Skip to content
Book a demoStart free
Connectors

Pendo connector

Set up the Pendo connector in Kaivo: authentication, configuration, the 6 BigQuery tables it syncs, and answers to common questions.

Pendo connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Pendo data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your customer support data instead of moving it.

Sync your Pendo product analytics into BigQuery with Kaivo to analyse feature usage, guides, and accounts alongside the rest of your data.

CategoryCustomer Service, Tech
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Pendo account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
Your Pendo integration key. You can generate one in Pendo under Settings → Integrations → Integration Keys.

|

Kaivo syncs 6 tables from Pendo into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

Account Metadata (116 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
agent__id__dirty BOOL Flag indicating if the data is dirty or not.
agent__id__display_name STRING Display name of the ID.
agent__id__element_format STRING Format of the element.
agent__id__element_type STRING Type of the element.
agent__id__type STRING Type of the ID.
agent__id__is_calculated BOOL Flag indicating if the ID is calculated or not.
agent__id__is_deleted BOOL Flag indicating if the ID is deleted or not.
agent__id__is_hidden BOOL Flag indicating if the ID is hidden or not.
agent__id__is_per_app BOOL Flag indicating if the ID is specific to an app or not.
agent__id__is_promoted BOOL Flag indicating if the ID is promoted or not.
agent__id__never_index BOOL Flag indicating if the ID should never be indexed.
agent__name__dirty BOOL Flag indicating if the data is dirty or not.
agent__name__display_name STRING Display name of the agent’s name.
agent__name__element_format STRING Format of the element.
agent__name__element_type STRING Type of the element.
agent__name__type STRING Type of the agent’s name.
agent__name__is_calculated BOOL Flag indicating if the agent’s name is calculated or not.
agent__name__is_deleted BOOL Flag indicating if the agent’s name is deleted or not.
agent__name__is_hidden BOOL Flag indicating if the agent’s name is hidden or not.
agent__name__is_per_app BOOL Flag indicating if the agent’s name is specific to an app or not.
agent__name__is_promoted BOOL Flag indicating if the agent’s name is promoted or not.
agent__name__never_index BOOL Flag indicating if the agent’s name should never be indexed.
agent__name__sample STRING Sample data for the agent’s name.
agent__size__dirty BOOL Flag indicating if the data is dirty or not.
agent__size__display_name STRING Display name of the agent’s size.
agent__size__element_format STRING Format of the element.
agent__size__element_type STRING Type of the element.
agent__size__type STRING Type of the agent’s size.
agent__size__is_calculated BOOL Flag indicating if the agent’s size is calculated or not.
agent__size__is_deleted BOOL Flag indicating if the agent’s size is deleted or not.
agent__size__is_hidden BOOL Flag indicating if the agent’s size is hidden or not.
agent__size__is_per_app BOOL Flag indicating if the agent’s size is specific to an app or not.
agent__size__is_promoted BOOL Flag indicating if the agent’s size is promoted or not.
agent__size__never_index BOOL Flag indicating if the agent’s size should never be indexed.
agent__size__sample STRING Sample data for the agent’s size.
agent__tier__dirty BOOL Flag indicating if the data is dirty or not.
agent__tier__display_name STRING Display name of the agent’s tier.
agent__tier__element_format STRING Format of the element.
agent__tier__element_type STRING Type of the element.
agent__tier__type STRING Type of the agent’s tier.
agent__tier__is_calculated BOOL Flag indicating if the agent’s tier is calculated or not.
agent__tier__is_deleted BOOL Flag indicating if the agent’s tier is deleted or not.
agent__tier__is_hidden BOOL Flag indicating if the agent’s tier is hidden or not.
agent__tier__is_per_app BOOL Flag indicating if the agent’s tier is specific to an app or not.
agent__tier__is_promoted BOOL Flag indicating if the agent’s tier is promoted or not.
agent__tier__never_index BOOL Flag indicating if the agent’s tier should never be indexed.
agent__tier__sample STRING Sample data for the agent’s tier.
agent__timezone__dirty BOOL Flag indicating if the data is dirty or not.
agent__timezone__display_name STRING Display name of the agent’s timezone.
agent__timezone__element_format STRING Format of the element.
agent__timezone__element_type STRING Type of the element.
agent__timezone__type STRING Type of the agent’s timezone.
agent__timezone__is_calculated BOOL Flag indicating if the agent’s timezone is calculated or not.
agent__timezone__is_deleted BOOL Flag indicating if the agent’s timezone is deleted or not.
agent__timezone__is_hidden BOOL Flag indicating if the agent’s timezone is hidden or not.
agent__timezone__is_per_app BOOL Flag indicating if the agent’s timezone is specific to an app or not.
agent__timezone__is_promoted BOOL Flag indicating if the agent’s timezone is promoted or not.
agent__timezone__never_index BOOL Flag indicating if the agent’s timezone should never be indexed.
agent__timezone__sample STRING Sample data for the agent’s timezone.
auto__firstvisit__dirty BOOL Flag indicating if the data is dirty or not.
auto__firstvisit__display_name STRING Display name of the first visit.
auto__firstvisit__element_format STRING Format of the element.
auto__firstvisit__element_type STRING Type of the element.
auto__firstvisit__type STRING Type of the first visit.
auto__firstvisit__is_calculated BOOL Flag indicating if the first visit is calculated or not.
auto__firstvisit__is_deleted BOOL Flag indicating if the first visit is deleted or not.
auto__firstvisit__is_hidden BOOL Flag indicating if the first visit is hidden or not.
auto__firstvisit__is_per_app BOOL Flag indicating if the first visit is specific to an app or not.
auto__firstvisit__is_promoted BOOL Flag indicating if the first visit is promoted or not.
auto__firstvisit__never_index BOOL Flag indicating if the first visit should never be indexed.
auto__id__dirty BOOL Flag indicating if the data is dirty or not.
auto__id__display_name STRING Display name of the auto ID.
auto__id__element_format STRING Format of the element.
auto__id__element_type STRING Type of the element.
auto__id__type STRING Type of the auto ID.
auto__id__is_calculated BOOL Flag indicating if the auto ID is calculated or not.
auto__id__is_deleted BOOL Flag indicating if the auto ID is deleted or not.
auto__id__is_hidden BOOL Flag indicating if the auto ID is hidden or not.
auto__id__is_per_app BOOL Flag indicating if the auto ID is specific to an app or not.
auto__id__is_promoted BOOL Flag indicating if the auto ID is promoted or not.
auto__id__never_index BOOL Flag indicating if the auto ID should never be indexed.
auto__lastvisit__dirty BOOL Flag indicating if the data is dirty or not.
auto__lastvisit__display_name STRING Display name of the last visit.
auto__lastvisit__element_format STRING Format of the element.
auto__lastvisit__element_type STRING Type of the element.
auto__lastvisit__type STRING Type of the last visit.
auto__lastvisit__is_calculated BOOL Flag indicating if the last visit is calculated or not.
auto__lastvisit__is_deleted BOOL Flag indicating if the last visit is deleted or not.
auto__lastvisit__is_hidden BOOL Flag indicating if the last visit is hidden or not.
auto__lastvisit__is_per_app BOOL Flag indicating if the last visit is specific to an app or not.
auto__lastvisit__is_promoted BOOL Flag indicating if the last visit is promoted or not.
auto__lastvisit__never_index BOOL Flag indicating if the last visit should never be indexed.
pendo__blacklistguides__dirty BOOL Flag indicating if the data is dirty or not.
pendo__blacklistguides__display_name STRING Display name of the blacklisted guides.
pendo__blacklistguides__element_format STRING Format of the element.
pendo__blacklistguides__element_type STRING Type of the element.
pendo__blacklistguides__type STRING Type of the blacklisted guides.
pendo__blacklistguides__is_calculated BOOL Flag indicating if the blacklisted guides are calculated or not.
pendo__blacklistguides__is_deleted BOOL Flag indicating if the blacklisted guides are deleted or not.
pendo__blacklistguides__is_hidden BOOL Flag indicating if the blacklisted guides are hidden or not.
pendo__blacklistguides__is_per_app BOOL Flag indicating if the blacklisted guides are specific to an app or not.
pendo__blacklistguides__is_promoted BOOL Flag indicating if the blacklisted guides are promoted or not.
pendo__blacklistguides__never_index BOOL Flag indicating if the blacklisted guides should never be indexed.
pendo__donotprocess__dirty BOOL Flag indicating if the data is dirty or not.
pendo__donotprocess__display_name STRING Display name of the data not to process.
pendo__donotprocess__element_format STRING Format of the element.
pendo__donotprocess__element_type STRING Type of the element.
pendo__donotprocess__type STRING Type of the data not to process.
pendo__donotprocess__is_calculated BOOL Flag indicating if the data not to process is calculated or not.
pendo__donotprocess__is_deleted BOOL Flag indicating if the data not to process is deleted or not.
pendo__donotprocess__is_hidden BOOL Flag indicating if the data not to process is hidden or not.
pendo__donotprocess__is_per_app BOOL Flag indicating if the data not to process is specific to an app or not.
pendo__donotprocess__is_promoted BOOL Flag indicating if the data not to process is promoted or not.
pendo__donotprocess__never_index BOOL Flag indicating if the data not to process should never be indexed.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Feature (65 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_id INT64 The unique identifier of the application to which the feature belongs.
app_wide BOOL Indicates whether the feature is applicable across the entire application.
color STRING The color associated with the feature for visual identification.
created_at INT64 The timestamp when the feature was created.
created_by_user__deleted_at INT64 Timestamp when the user was deleted.
created_by_user__first STRING The first name of the user.
created_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
created_by_user__id STRING The unique identifier of the user.
created_by_user__last STRING The last name of the user.
created_by_user__last_login INT64 Timestamp of the user’s last login.
created_by_user__role INT64 The role of the user.
created_by_user__user_type STRING The type of user.
created_by_user__username STRING The username of the user.
created_designer_version STRING The version of the designer tool used during feature creation.
daily_merge_first INT64 Timestamp of the first daily merge process for the feature.
daily_rollup_first INT64 Timestamp of the first daily rollup process for the feature.
dirty BOOL Indicates if the feature is marked as ‘dirty’ for updates.
element_initial_tag STRING The initial tag associated with the feature element.
element_selection_type STRING Type of selection method used for elements.
group__type STRING The type of the group.
group__color STRING Color assigned to the group.
group__created_at INT64 Timestamp of group creation.
group__created_by_user__deleted_at INT64 Timestamp when the user was deleted.
group__created_by_user__first STRING The first name of the user.
group__created_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
group__created_by_user__id STRING The unique identifier of the user.
group__created_by_user__last STRING The last name of the user.
group__created_by_user__last_login INT64 Timestamp of the user’s last login.
group__created_by_user__role INT64 The role of the user.
group__created_by_user__user_type STRING The type of user.
group__created_by_user__username STRING The username of the user.
group__description STRING Description of the group.
group__id STRING The unique identifier of the group.
group__last_updated_at INT64 Timestamp of the last group update.
group__last_updated_by_user__first STRING The first name of the user.
group__last_updated_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
group__last_updated_by_user__id STRING The unique identifier of the user.
group__last_updated_by_user__last STRING The last name of the user.
group__last_updated_by_user__last_login INT64 Timestamp of the user’s last login.
group__last_updated_by_user__role INT64 The role of the user.
group__last_updated_by_user__user_type STRING The type of user.
group__last_updated_by_user__username STRING The username of the user.
group__length INT64 The number of items in the group.
group__name STRING The name of the group.
id STRING The unique identifier of the feature.
is_core_event BOOL Indicates if the feature is a core event.
kind STRING The kind of feature.
last_updated_at INT64 Timestamp of the last feature update.
last_updated_by_user__deleted_at INT64 Timestamp when the user was deleted.
last_updated_by_user__first STRING The first name of the user.
last_updated_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
last_updated_by_user__id STRING The unique identifier of the user.
last_updated_by_user__last STRING The last name of the user.
last_updated_by_user__last_login INT64 Timestamp of the user’s last login.
last_updated_by_user__role INT64 The role of the user.
last_updated_by_user__user_type STRING The type of user.
last_updated_by_user__username STRING The username of the user.
name STRING The name of the feature.
page_id STRING The unique identifier of the page associated with the feature.
root_version_id STRING The unique identifier of the root version of the feature.
stable_version_id STRING The unique identifier of the stable version of the feature.
suggested_match STRING Indicates if there is a suggested match for the feature.
valid_through INT64 The timestamp until which the feature is valid.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • Feature__created_by_user__visitor_ids (4 columns)
  • Feature__element_path_rules (4 columns)
  • Feature__event_property_configurations (10 columns)
  • Feature__group__created_by_user__visitor_ids (4 columns)
  • Feature__group__items (4 columns)
  • Feature__group__last_updated_by_user__visitor_ids (4 columns)
  • Feature__last_updated_by_user__visitor_ids (4 columns)
Guide (85 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_id INT64 The unique identifier of the application associated with the guide data.
attributes__type STRING Type of guide.
attributes__activation JSON Information related to guide activation.
attributes__badge JSON Badge details associated with the guide.
attributes__capping__max_impressions INT64 Maximum number of times the guide is allowed to be displayed.
attributes__capping__max_session_impressions INT64 Maximum number of times the guide can be displayed in a single session.
attributes__dates__en_us STRING
attributes__dates__es STRING
attributes__dates__ja STRING
attributes__device__type STRING Type of device the guide is optimized for.
attributes__dom__is_only_show_once BOOL Indicates if the guide should be shown only once.
attributes__dom__show_guide_only_on_element_click BOOL Specifies if the guide is triggered by clicking on an element.
attributes__element_selection_type STRING Type of selection for guide elements.
attributes__email BOOL Configuration details for email notifications related to the guide.
attributes__is_announcement BOOL Indicates if the guide is an announcement.
attributes__notification_bubble__background_color STRING
attributes__notification_bubble__color STRING
attributes__notification_bubble__font_family STRING
attributes__notification_bubble__font_weight INT64
attributes__override_auto_throttling BOOL Flag to override automatic throttle settings.
attributes__priority INT64 Priority level of the guide.
attributes__resource_center__home_view_id STRING
attributes__resource_center__integration_name STRING
attributes__resource_center__integration_provider STRING
attributes__resource_center__is_module BOOL
attributes__resource_center__is_top_level BOOL
attributes__resource_center__module_id STRING
attributes__resource_center__origin_id STRING
attributes__shared_service_version STRING Version of the shared service used by the guide.
authored_language STRING Language in which the guide is authored.
conversion__attribution_window INT64 Time window for attributing conversions to the guide.
conversion__item_id STRING Identifier of the item associated with the conversion.
conversion__item_type STRING Type of item that triggers the conversion.
created_at INT64 Timestamp indicating when the guide was created.
created_by_user__deleted_at INT64
created_by_user__first STRING
created_by_user__has_logged_in BOOL
created_by_user__id STRING
created_by_user__last STRING
created_by_user__last_login INT64
created_by_user__role INT64
created_by_user__user_type STRING
created_by_user__username STRING
current_first_eligible_to_be_seen_at INT64 Timestamp for the first eligibility of the guide to be shown.
description STRING Description of the guide.
editor_type STRING Type of editor used to create the guide.
email_configuration__email_metadata_property_name STRING
email_configuration__subject STRING
email_state STRING State of email notifications for the guide.
experiment__end_time INT64
experiment__group_size INT64
experiment__notification_duration INT64
experiment__start_time INT64
id STRING Unique identifier of the guide.
is_module BOOL Indicates if the guide is a module.
is_multi_step BOOL Flag to indicate if the guide has multiple steps.
is_top_level BOOL Specifies if the guide is at the top level.
is_training BOOL Indicates if the guide is for training purposes.
kind STRING Type or category of the guide.
last_updated_at INT64 Timestamp indicating the last update time for the guide.
last_updated_by_user__deleted_at INT64
last_updated_by_user__first STRING
last_updated_by_user__has_logged_in BOOL
last_updated_by_user__id STRING
last_updated_by_user__last STRING
last_updated_by_user__last_login INT64
last_updated_by_user__role INT64
last_updated_by_user__user_type STRING
last_updated_by_user__username STRING
launch_method STRING Method used to launch the guide.
min_agent_version STRING Minimum agent version required for guide compatibility.
name STRING Name of the guide.
origin_id STRING Original identifier of the guide.
published_at INT64 Timestamp indicating when the guide was published.
published_ever BOOL Indicates if the guide has ever been published.
recurrence INT64 Recurrence settings for the guide.
recurrence_eligibility_window INT64 Time window for recurrence eligibility.
reset_at INT64 Timestamp indicating when the guide is reset.
resource_center_id STRING Identifier of the resource center associated with the guide.
root_version_id STRING Identifier of the root version of the guide.
shows_after INT64 Time duration after which the guide is displayed.
stable_version_id STRING Identifier of the stable version of the guide.
state STRING Current state of the guide.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • Guide__app_ids (4 columns)
  • Guide__attributes__resource_center__children (4 columns)
  • Guide__audience (11 columns)
  • Guide__audience_ui_hint__filters (16 columns)
  • Guide__children (4 columns)
  • Guide__created_by_user__visitor_ids (4 columns)
  • Guide__last_updated_by_user__visitor_ids (4 columns)
  • Guide__polls (11 columns)
  • Guide__polls__numeric_responses (4 columns)
  • Guide__steps (65 columns)
  • Guide__steps__poll_ids (4 columns)
Page (62 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_id INT64 The ID of the Pendo application to which the page belongs.
color STRING The color associated with the page.
created_at INT64 The date and time when the page was created.
created_by_user__deleted_at INT64 The date and time when the user was deleted.
created_by_user__first STRING The first name of the user.
created_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
created_by_user__id STRING The unique ID of the user.
created_by_user__last STRING The last name of the user.
created_by_user__last_login INT64 The date and time of the user’s last login.
created_by_user__role INT64 The role of the user.
created_by_user__user_type STRING The type of user.
created_by_user__username STRING The username of the user.
daily_merge_first INT64 Placeholder for daily merge information.
daily_rollup_first INT64 Placeholder for daily rollup information.
dirty BOOL Flag indicating if the page data is dirty or needs updating.
group__type STRING The type of the group.
group__color STRING The color associated with the group.
group__created_at INT64 The date and time when the group was created.
group__created_by_user__deleted_at INT64 The date and time when the user was deleted.
group__created_by_user__first STRING The first name of the user.
group__created_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
group__created_by_user__id STRING The unique ID of the user.
group__created_by_user__last STRING The last name of the user.
group__created_by_user__last_login INT64 The date and time of the user’s last login.
group__created_by_user__role INT64 The role of the user.
group__created_by_user__user_type STRING The type of user.
group__created_by_user__username STRING The username of the user.
group__description STRING The description of the group.
group__id STRING The unique ID of the group.
group__last_updated_at INT64 The date and time of the last update to the group.
group__last_updated_by_user__first STRING The first name of the user.
group__last_updated_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
group__last_updated_by_user__id STRING The unique ID of the user.
group__last_updated_by_user__last STRING The last name of the user.
group__last_updated_by_user__last_login INT64 The date and time of the user’s last login.
group__last_updated_by_user__role INT64 The role of the user.
group__last_updated_by_user__user_type STRING The type of user.
group__last_updated_by_user__username STRING The username of the user.
group__length INT64 The length of the group.
group__name STRING The name of the group.
id STRING The unique ID of the page.
is_auto_tagged BOOL Flag indicating if the page is automatically tagged.
is_core_event BOOL Flag indicating if the page is a core event.
kind STRING The kind of page data.
last_updated_at INT64 The date and time of the last update to the page.
last_updated_by_user__deleted_at INT64 The date and time when the user was deleted.
last_updated_by_user__first STRING The first name of the user.
last_updated_by_user__has_logged_in BOOL Flag indicating if the user has logged in.
last_updated_by_user__id STRING The unique ID of the user.
last_updated_by_user__last STRING The last name of the user.
last_updated_by_user__last_login INT64 The date and time of the user’s last login.
last_updated_by_user__role INT64 The role of the user.
last_updated_by_user__user_type STRING The type of user.
last_updated_by_user__username STRING The username of the user.
name STRING The name of the page.
root_version_id STRING The ID of the root version of the page.
rulesjson STRING The JSON representation of rules associated with the page.
stable_version_id STRING The ID of the stable version of the page.
suggested_name STRING The suggested name for the page.
valid_through INT64 The date until which the page data is valid.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • Page__created_by_user__visitor_ids (4 columns)
  • Page__group__created_by_user__visitor_ids (4 columns)
  • Page__group__items (4 columns)
  • Page__group__last_updated_by_user__visitor_ids (4 columns)
  • Page__last_updated_by_user__visitor_ids (4 columns)
  • Page__rules (6 columns)
Report (82 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING The type or category of the report data.
created_at INT64 Timestamp when the report was created
created_by_user__deleted_at INT64
created_by_user__first STRING
created_by_user__has_logged_in BOOL
created_by_user__id STRING
created_by_user__last STRING
created_by_user__last_login INT64
created_by_user__role INT64
created_by_user__user_type STRING
created_by_user__username STRING
definition__type STRING
definition__attribute STRING
definition__config__across_apps BOOL
definition__config__app_id STRING
definition__config__collapse_dups BOOL
definition__config__features BOOL
definition__config__max_interval INT64
definition__config__max_length INT64
definition__config__omit_pages BOOL
definition__config__page_id STRING
definition__config__predecessors BOOL
definition__config__segment_id STRING
definition__config__selected_account__class_name STRING
definition__config__selected_account__id STRING
definition__config__selected_account__text STRING
definition__config__track_events BOOL
definition__config__unique_visitors BOOL
definition__date_ranges__primary_date_range__type STRING
definition__date_ranges__secondary_date_range JSON
definition__date_ranges__use_secondary_date_range BOOL
definition__generator STRING
definition__graph_type STRING
definition__is_comparing_segments BOOL
definition__is_comparing_sources BOOL
definition__kind STRING
definition__minimum INT64
definition__multi_source_type STRING
definition__period STRING
definition__single_source__id STRING
definition__single_source__kind STRING
definition__single_source_type STRING
definition__table_type STRING
definition__time_series__type STRING
definition__time_series__end STRING
definition__time_series__primary_time_series__count INT64
definition__time_series__primary_time_series__first INT64
definition__time_series__primary_time_series__period STRING
definition__time_series__secondary_time_series JSON
definition__time_series__start STRING
id STRING Unique ID of the report
kind STRING Kind of the report
last_run_at INT64 Timestamp of the last run of the report
last_success_run_at INT64 Timestamp of the last successful run of the report
last_success_run_obj STRING The object containing information about the last successful run.
last_updated_at INT64 Timestamp of the last update of the report
last_updated_by_user__deleted_at INT64
last_updated_by_user__first STRING
last_updated_by_user__has_logged_in BOOL
last_updated_by_user__id STRING
last_updated_by_user__last STRING
last_updated_by_user__last_login INT64
last_updated_by_user__role INT64
last_updated_by_user__user_type STRING
last_updated_by_user__username STRING
level STRING The level at which the report data is generated or accessed.
name STRING Name of the report
owned_by_user__first STRING
owned_by_user__has_logged_in BOOL
owned_by_user__id STRING
owned_by_user__last STRING
owned_by_user__role INT64
owned_by_user__user_type STRING
owned_by_user__username STRING
root_version_id STRING The identifier for the root version of the report.
scope STRING The scope or range of data to include in the report.
share STRING Information about sharing settings or permissions for the report.
shared BOOL Flag indicating whether the report is shared with others.
stable_version_id STRING The identifier for the stable version of the report.
target STRING The target or audience for which the report is intended.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • Report__aggregation__fields (6 columns)
  • Report__aggregation__pipeline (31 columns)
  • Report__aggregation__pipeline__fork (3 columns)
  • Report__aggregation__pipeline__fork__list (7 columns)
  • Report__aggregation__pipeline__fork__list__group__fields (4 columns)
  • Report__aggregation__pipeline__fork__list__group__group (4 columns)
  • Report__aggregation__pipeline__group__fields (12 columns)
  • Report__aggregation__pipeline__group__group (4 columns)
  • Report__aggregation__pipeline__merge__fields (4 columns)
  • Report__aggregation__pipeline__merge__pipeline (25 columns)
  • Report__aggregation__pipeline__merge__pipeline__group__fields (4 columns)
  • Report__aggregation__pipeline__merge__pipeline__group__group (4 columns)
  • Report__aggregation__pipeline__merge__pipeline__join__fields (4 columns)
  • Report__aggregation__pipeline__merge__pipeline__spawn (3 columns)
  • Report__aggregation__pipeline__merge__pipeline__spawn__list (9 columns)
  • Report__aggregation__pipeline__merge__pipeline__spawn__list__group__fields (5 columns)
  • Report__aggregation__pipeline__merge__pipeline__spawn__list__group__group (4 columns)
  • Report__aggregation__pipeline__merge__pipeline__switch__response__response (5 columns)
  • Report__aggregation__pipeline__source__single_events__event_class (4 columns)
  • Report__created_by_user__visitor_ids (4 columns)
  • Report__definition__config__columns (17 columns)
  • Report__definition__config__columns__primary_keys (4 columns)
  • Report__definition__config__filters (4 columns)
  • Report__definition__config__segments (4 columns)
  • Report__definition__history (4 columns)
  • Report__definition__segments (4 columns)
  • Report__definition__sources__alls (4 columns)
  • Report__last_updated_by_user__visitor_ids (4 columns)
Visitor Metadata (298 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
agent__age__dirty BOOL
agent__age__display_name STRING
agent__age__element_format STRING
agent__age__element_type STRING
agent__age__type STRING
agent__age__is_calculated BOOL
agent__age__is_deleted BOOL
agent__age__is_hidden BOOL
agent__age__is_per_app BOOL
agent__age__is_promoted BOOL
agent__age__never_index BOOL
agent__age__sample STRING
agent__country__dirty BOOL
agent__country__display_name STRING
agent__country__element_format STRING
agent__country__element_type STRING
agent__country__type STRING
agent__country__is_calculated BOOL
agent__country__is_deleted BOOL
agent__country__is_hidden BOOL
agent__country__is_per_app BOOL
agent__country__is_promoted BOOL
agent__country__never_index BOOL
agent__country__sample STRING
agent__displayname__dirty BOOL
agent__displayname__display_name STRING
agent__displayname__element_format STRING
agent__displayname__element_type STRING
agent__displayname__type STRING
agent__displayname__is_calculated BOOL
agent__displayname__is_deleted BOOL
agent__displayname__is_hidden BOOL
agent__displayname__is_per_app BOOL
agent__displayname__is_promoted BOOL
agent__displayname__never_index BOOL
agent__displayname__sample STRING
agent__email__dirty BOOL
agent__email__display_name STRING
agent__email__element_format STRING
agent__email__element_type STRING
agent__email__type STRING
agent__email__is_calculated BOOL
agent__email__is_deleted BOOL
agent__email__is_hidden BOOL
agent__email__is_per_app BOOL
agent__email__is_promoted BOOL
agent__email__never_index BOOL
agent__email__sample STRING
agent__firstname__dirty BOOL
agent__firstname__display_name STRING
agent__firstname__element_format STRING
agent__firstname__element_type STRING
agent__firstname__type STRING
agent__firstname__is_calculated BOOL
agent__firstname__is_deleted BOOL
agent__firstname__is_hidden BOOL
agent__firstname__is_per_app BOOL
agent__firstname__is_promoted BOOL
agent__firstname__never_index BOOL
agent__firstname__sample STRING
agent__gender__dirty BOOL
agent__gender__display_name STRING
agent__gender__element_format STRING
agent__gender__element_type STRING
agent__gender__type STRING
agent__gender__is_calculated BOOL
agent__gender__is_deleted BOOL
agent__gender__is_hidden BOOL
agent__gender__is_per_app BOOL
agent__gender__is_promoted BOOL
agent__gender__never_index BOOL
agent__gender__sample STRING
agent__language__dirty BOOL
agent__language__display_name STRING
agent__language__element_format STRING
agent__language__element_type STRING
agent__language__type STRING
agent__language__is_calculated BOOL
agent__language__is_deleted BOOL
agent__language__is_hidden BOOL
agent__language__is_per_app BOOL
agent__language__is_promoted BOOL
agent__language__never_index BOOL
agent__language__sample STRING
agent__loccomplete__dirty BOOL
agent__loccomplete__display_name STRING
agent__loccomplete__element_format STRING
agent__loccomplete__element_type STRING
agent__loccomplete__type STRING
agent__loccomplete__is_calculated BOOL
agent__loccomplete__is_deleted BOOL
agent__loccomplete__is_hidden BOOL
agent__loccomplete__is_per_app BOOL
agent__loccomplete__is_promoted BOOL
agent__loccomplete__never_index BOOL
agent__loccomplete__sample STRING
agent__name__dirty BOOL
agent__name__display_name STRING
agent__name__element_format STRING
agent__name__element_type STRING
agent__name__type STRING
agent__name__is_calculated BOOL
agent__name__is_deleted BOOL
agent__name__is_hidden BOOL
agent__name__is_per_app BOOL
agent__name__is_promoted BOOL
agent__name__never_index BOOL
agent__name__sample STRING
agent__role__dirty BOOL
agent__role__display_name STRING
agent__role__element_format STRING
agent__role__element_type STRING
agent__role__type STRING
agent__role__is_calculated BOOL
agent__role__is_deleted BOOL
agent__role__is_hidden BOOL
agent__role__is_per_app BOOL
agent__role__is_promoted BOOL
agent__role__never_index BOOL
agent__role__sample STRING
agent__tags__dirty BOOL
agent__tags__display_name STRING
agent__tags__element_format STRING
agent__tags__element_type STRING
agent__tags__type STRING
agent__tags__is_calculated BOOL
agent__tags__is_deleted BOOL
agent__tags__is_hidden BOOL
agent__tags__is_per_app BOOL
agent__tags__is_promoted BOOL
agent__tags__never_index BOOL
auto__accountid__dirty BOOL
auto__accountid__display_name STRING
auto__accountid__element_format STRING
auto__accountid__element_type STRING
auto__accountid__type STRING
auto__accountid__is_calculated BOOL
auto__accountid__is_deleted BOOL
auto__accountid__is_hidden BOOL
auto__accountid__is_per_app BOOL
auto__accountid__is_promoted BOOL
auto__accountid__never_index BOOL
auto__accountids__dirty BOOL
auto__accountids__display_name STRING
auto__accountids__element_format STRING
auto__accountids__element_type STRING
auto__accountids__type STRING
auto__accountids__is_calculated BOOL
auto__accountids__is_deleted BOOL
auto__accountids__is_hidden BOOL
auto__accountids__is_per_app BOOL
auto__accountids__is_promoted BOOL
auto__accountids__never_index BOOL
auto__firstvisit__dirty BOOL
auto__firstvisit__display_name STRING
auto__firstvisit__element_format STRING
auto__firstvisit__element_type STRING
auto__firstvisit__type STRING
auto__firstvisit__is_calculated BOOL
auto__firstvisit__is_deleted BOOL
auto__firstvisit__is_hidden BOOL
auto__firstvisit__is_per_app BOOL
auto__firstvisit__is_promoted BOOL
auto__firstvisit__never_index BOOL
auto__id__dirty BOOL
auto__id__display_name STRING
auto__id__element_format STRING
auto__id__element_type STRING
auto__id__type STRING
auto__id__is_calculated BOOL
auto__id__is_deleted BOOL
auto__id__is_hidden BOOL
auto__id__is_per_app BOOL
auto__id__is_promoted BOOL
auto__id__never_index BOOL
auto__lastbrowsername__dirty BOOL
auto__lastbrowsername__display_name STRING
auto__lastbrowsername__element_format STRING
auto__lastbrowsername__element_type STRING
auto__lastbrowsername__type STRING
auto__lastbrowsername__is_calculated BOOL
auto__lastbrowsername__is_deleted BOOL
auto__lastbrowsername__is_hidden BOOL
auto__lastbrowsername__is_per_app BOOL
auto__lastbrowsername__is_promoted BOOL
auto__lastbrowsername__never_index BOOL
auto__lastbrowserversion__dirty BOOL
auto__lastbrowserversion__display_name STRING
auto__lastbrowserversion__element_format STRING
auto__lastbrowserversion__element_type STRING
auto__lastbrowserversion__type STRING
auto__lastbrowserversion__is_calculated BOOL
auto__lastbrowserversion__is_deleted BOOL
auto__lastbrowserversion__is_hidden BOOL
auto__lastbrowserversion__is_per_app BOOL
auto__lastbrowserversion__is_promoted BOOL
auto__lastbrowserversion__never_index BOOL
auto__lastoperatingsystem__dirty BOOL
auto__lastoperatingsystem__display_name STRING
auto__lastoperatingsystem__element_format STRING
auto__lastoperatingsystem__element_type STRING
auto__lastoperatingsystem__type STRING
auto__lastoperatingsystem__is_calculated BOOL
auto__lastoperatingsystem__is_deleted BOOL
auto__lastoperatingsystem__is_hidden BOOL
auto__lastoperatingsystem__is_per_app BOOL
auto__lastoperatingsystem__is_promoted BOOL
auto__lastoperatingsystem__never_index BOOL
auto__lastservername__dirty BOOL
auto__lastservername__display_name STRING
auto__lastservername__element_format STRING
auto__lastservername__element_type STRING
auto__lastservername__type STRING
auto__lastservername__is_calculated BOOL
auto__lastservername__is_deleted BOOL
auto__lastservername__is_hidden BOOL
auto__lastservername__is_per_app BOOL
auto__lastservername__is_promoted BOOL
auto__lastservername__never_index BOOL
auto__lastvisit__dirty BOOL
auto__lastvisit__display_name STRING
auto__lastvisit__element_format STRING
auto__lastvisit__element_type STRING
auto__lastvisit__type STRING
auto__lastvisit__is_calculated BOOL
auto__lastvisit__is_deleted BOOL
auto__lastvisit__is_hidden BOOL
auto__lastvisit__is_per_app BOOL
auto__lastvisit__is_promoted BOOL
auto__lastvisit__never_index BOOL
custom__practicumtest__dirty BOOL
custom__practicumtest__display_name STRING
custom__practicumtest__element_format STRING
custom__practicumtest__element_type STRING
custom__practicumtest__type STRING
custom__practicumtest__is_calculated BOOL
custom__practicumtest__is_deleted BOOL
custom__practicumtest__is_hidden BOOL
custom__practicumtest__is_per_app BOOL
custom__practicumtest__is_promoted BOOL
custom__practicumtest__never_index BOOL
custom__rmlsurveytest__dirty BOOL
custom__rmlsurveytest__display_name STRING
custom__rmlsurveytest__element_format STRING
custom__rmlsurveytest__element_type STRING
custom__rmlsurveytest__type STRING
custom__rmlsurveytest__is_calculated BOOL
custom__rmlsurveytest__is_deleted BOOL
custom__rmlsurveytest__is_hidden BOOL
custom__rmlsurveytest__is_per_app BOOL
custom__rmlsurveytest__is_promoted BOOL
custom__rmlsurveytest__never_index BOOL
custom__special__dirty BOOL
custom__special__display_name STRING
custom__special__element_format STRING
custom__special__element_type STRING
custom__special__type STRING
custom__special__is_calculated BOOL
custom__special__is_deleted BOOL
custom__special__is_hidden BOOL
custom__special__is_per_app BOOL
custom__special__is_promoted BOOL
custom__special__never_index BOOL
pendo__blacklistguides__dirty BOOL
pendo__blacklistguides__display_name STRING
pendo__blacklistguides__element_format STRING
pendo__blacklistguides__element_type STRING
pendo__blacklistguides__type STRING
pendo__blacklistguides__is_calculated BOOL
pendo__blacklistguides__is_deleted BOOL
pendo__blacklistguides__is_hidden BOOL
pendo__blacklistguides__is_per_app BOOL
pendo__blacklistguides__is_promoted BOOL
pendo__blacklistguides__never_index BOOL
pendo__designerenabled__dirty BOOL
pendo__designerenabled__display_name STRING
pendo__designerenabled__element_format STRING
pendo__designerenabled__element_type STRING
pendo__designerenabled__type STRING
pendo__designerenabled__is_calculated BOOL
pendo__designerenabled__is_deleted BOOL
pendo__designerenabled__is_hidden BOOL
pendo__designerenabled__is_per_app BOOL
pendo__designerenabled__is_promoted BOOL
pendo__designerenabled__never_index BOOL
pendo__donotprocess__dirty BOOL
pendo__donotprocess__display_name STRING
pendo__donotprocess__element_format STRING
pendo__donotprocess__element_type STRING
pendo__donotprocess__type STRING
pendo__donotprocess__is_calculated BOOL
pendo__donotprocess__is_deleted BOOL
pendo__donotprocess__is_hidden BOOL
pendo__donotprocess__is_per_app BOOL
pendo__donotprocess__is_promoted BOOL
pendo__donotprocess__never_index BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • Visitor Metadata__agent__tags__sample (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Pendo supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Pendo?

Section titled “How long does the initial sync take for Pendo?”

It depends on how much history is in your Pendo account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Pendo’s schema changes?

Section titled “What happens when Pendo’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Pendo, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Pendo instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Pendo connector in Kaivo and all of its synced data is deleted with it.

Use Feature and Page data to see which parts of your product get used.

Bring Guide data into BigQuery to measure how in-app guidance lands.

Join Account Metadata with usage to spot accounts at risk or ready to expand.

Connect Pendo usage with your billing data to link product use to revenue.

Once Pendo data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Pendo data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Pendo connector pricing and plan details.

  • HubSpot: Sync HubSpot to BigQuery.
  • Adform: Sync Adform to BigQuery.
  • Amplitude: Sync Amplitude to BigQuery.
  • Auth0: Sync Auth0 to BigQuery.
  • Convex: Sync Convex to BigQuery.
  • Dixa: Sync Dixa to BigQuery.