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.ioKaivo 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.
What is the Pendo connector
Section titled “What is the Pendo connector”Sync your Pendo product analytics into BigQuery with Kaivo to analyse feature usage, guides, and accounts alongside the rest of your data.
| Category | Customer Service, Tech |
|---|---|
| Authentication | API key |
| Setup | Self-service |
Getting started with the Pendo connector
Section titled “Getting started with the Pendo connector”- Sign up for Kaivo and create a workspace.
- Connect your Pendo account.
- Choose which tables to sync.
- Wait for the initial sync to finish.
- Query your data in BigQuery or your favourite AI or BI tool.
Authenticating Pendo
Section titled “Authenticating Pendo”Authenticate with your API Key.
| Field | Description |
|---|---|
| API Key | |
| Your Pendo integration key. You can generate one in Pendo under Settings → Integrations → Integration Keys. |
|
Tables and columns synced from Pendo
Section titled “Tables and columns synced from Pendo”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”Repeating fields are split into their own tables, listed here with their column counts.
Visitor Metadata__agent__tags__sample(4 columns)
How the Pendo sync works
Section titled “How the Pendo sync works”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.
Frequently asked questions
Section titled “Frequently asked questions”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.
Can I sync only some tables or columns?
Section titled “Can I sync only some tables or columns?”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.
Common use cases for Pendo data
Section titled “Common use cases for Pendo data”Feature adoption
Section titled “Feature adoption”Use Feature and Page data to see which parts of your product get used.
Guide performance
Section titled “Guide performance”Bring Guide data into BigQuery to measure how in-app guidance lands.
Account health
Section titled “Account health”Join Account Metadata with usage to spot accounts at risk or ready to expand.
Combine with revenue
Section titled “Combine with revenue”Connect Pendo usage with your billing data to link product use to revenue.
Use Pendo data in your AI and BI tools
Section titled “Use Pendo data in your AI and BI tools”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.
Claude
Section titled “Claude”Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →
Power BI
Section titled “Power BI”Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →
Data Studio
Section titled “Data Studio”Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →
Tableau
Section titled “Tableau”The premium analytics standard, with native BigQuery integration. Setup guide →
Google Sheets
Section titled “Google Sheets”Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →
Connect via Power Query’s BigQuery connector. Setup guide →
Metabase
Section titled “Metabase”Open-source BI tool with strong BigQuery support. Setup guide →
See our pricing page for Pendo connector pricing and plan details.