Skip to content
Book a demoStart free
Connectors

Appcues connector

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

Appcues connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Appcues 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 marketing and sales data instead of moving it.

Sync your Appcues onboarding and in-app content into BigQuery with Kaivo to see which flows and guides reach your users.

CategoryMarketing & Sales, Tech
AuthenticationUsername and password
SetupSelf-service

Getting started with the Appcues connector

Section titled “Getting started with the Appcues connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Appcues 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.

Connect with your Appcues login. You provide:

Field Description
Password

When you set up the connector, you provide:

Field Description
Username
Account ID
Account ID of Appcues found in account settings page (https://studio.appcues.com/settings/account)

| | Start Date |

Any data before this date will not be fetched.

|

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

banners (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_id STRING
app_id STRING
contains_localized_blocks BOOL
created_at FLOAT64
created_by STRING
frequency STRING
id STRING
locked_for_localization BOOL
name STRING
platform STRING
preview_url STRING
published BOOL
state STRING
tags__c141e1ae_993c_4869_8f77_4aa314fdb468 BOOL
theme STRING
updated_at FLOAT64
updated_by STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
content__type STRING
content__node_id STRING
content__props__block_type STRING
content__props__id STRING
content__props__is STRING
content__props__style__align_items STRING
content__props__style__background_color STRING
content__props__style__border_radius STRING
content__props__style__box_sizing STRING
content__props__style__color STRING
content__props__style__display STRING
content__props__style__flex_direction STRING
content__props__style__font_family STRING
content__props__style__left FLOAT64
content__props__style__margin_bottom STRING
content__props__style__margin_left STRING
content__props__style__margin_right STRING
content__props__style__margin_top STRING
content__props__style__padding_bottom STRING
content__props__style__padding_left STRING
content__props__style__padding_right STRING
content__props__style__padding_top STRING
content__props__style__pointer_events STRING
content__props__style__position STRING
content__props__style__right FLOAT64
content__props__style__will_change STRING
content__props__style__z_index FLOAT64
content_type STRING
created_at FLOAT64
created_by STRING
id STRING
index FLOAT64
updated_at FLOAT64
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
on STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: banners__steps__actions__dismiss_button

Section titled “Subtable: banners__steps__actions__dismiss_button”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
on STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: banners__steps__content__props__children

Section titled “Subtable: banners__steps__content__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
node_id STRING
props__block_type STRING
props__is STRING
props__style__align_items STRING
props__style__display STRING
props__style__flex_direction STRING
props__style__justify_content STRING
props__style__margin_left STRING
props__style__margin_right STRING
props__style__width STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: banners__steps__content__props__children__props__children

Section titled “Subtable: banners__steps__content__props__children__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
type STRING
node_id STRING
props__aria_label STRING
props__block_type STRING
props__data_ignore BOOL
props__id STRING
props__is STRING
props__style__align_self STRING
props__style__background STRING
props__style__border STRING
props__style__color STRING
props__style__cursor STRING
props__style__height STRING
props__style__margin FLOAT64
props__style__margin_right STRING
props__style__margin_top STRING
props__style__padding FLOAT64
props__style__position STRING
props__style__right STRING
props__style__top STRING
props__style__width STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: banners__steps__content__props__children__props__children__props__children

Section titled “Subtable: banners__steps__content__props__children__props__children__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
node_id STRING
props__fill STRING
props__height STRING
props__is STRING
props__style__margin FLOAT64
props__style__text_align STRING
props__view_box STRING
props__width STRING
props__xmlns STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: banners__steps__content__props__children__props__children__props__children__props__children

Section titled “Subtable: banners__steps__content__props__children__props__children__props__children__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
node_id STRING
props__d STRING
props__fill STRING
props__is STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: banners__steps__content__props__children__props__children__props__children__props__children__props__children

Section titled “Subtable: banners__steps__content__props__children__props__children__props__children__props__children__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__duration FLOAT64
config__fill STRING
config__placement STRING
config__pointer_events STRING
config__root_display STRING
config__sticky BOOL
config__target__selector STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: banners__steps__traits__config__keyframes

Section titled “Subtable: banners__steps__traits__config__keyframes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
opacity FLOAT64
padding_bottom STRING
padding_top STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__strategy STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
checklists (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_id STRING
checklist_id STRING
completion_flow_id STRING
created_at FLOAT64
created_by STRING
id STRING
internal_name STRING
intro_flow_id STRING
is_dismissable BOOL
is_sequential BOOL
items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__id STRING
items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__index FLOAT64
items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__label STRING
items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__id STRING
items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__index FLOAT64
items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__label STRING
open_behavior STRING
state STRING
styles__type STRING
styles__beacon_background_color STRING
styles__beacon_horizontal_offset FLOAT64
styles__beacon_icon STRING
styles__beacon_text_color STRING
styles__beacon_vertical_offset FLOAT64
styles__completion_icon STRING
styles__font STRING
styles__header_icon STRING
styles__position STRING
styles__primary_color STRING
styles__success_color STRING
styles__success_image_code STRING
text_tokens__beacon_text STRING
text_tokens__completion_dismiss_text STRING
text_tokens__completion_text STRING
text_tokens__completion_title STRING
text_tokens__description_text STRING
text_tokens__dismiss_cancel_text STRING
text_tokens__dismiss_confirm_text STRING
text_tokens__dismiss_prompt_text STRING
text_tokens__dismiss_text STRING
text_tokens__header_text STRING
title STRING
updated_at FLOAT64
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__action

Section titled “Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__action”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__actions

Section titled “Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__actions”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attributes__action_type STRING
attributes__params__flow_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__conditions__and

Section titled “Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__conditions__and”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
content__content STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__depends_on

Section titled “Subtable: checklists__items___6288639f_2bf4_41ec_82dc_4a158efaf7a7__depends_on”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__action

Section titled “Subtable: checklists__items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__action”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__conditions__and

Section titled “Subtable: checklists__items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__conditions__and”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
properties__operator STRING
properties__property STRING
properties__value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__depends_on

Section titled “Subtable: checklists__items__c1d275b5_3ee4_4ce9_a4f6_3fb385f1328b__depends_on”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__rule__conditions__and

Section titled “Subtable: checklists__rule__conditions__and”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: checklists__rule__conditions__and__or

Section titled “Subtable: checklists__rule__conditions__and__or”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
url__operator STRING
url__value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
flows (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
created_by STRING
frequency STRING
id STRING
name STRING
published BOOL
tags___44dffa27_aee8_4076_b080_06508ed80196 BOOL
tags__b831cc07_7155_4d43_a4e2_6ff8cf60b968 BOOL
updated_at STRING
updated_by STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
launchpads (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_id STRING
app_id STRING
contains_localized_blocks BOOL
created_at FLOAT64
created_by STRING
frequency STRING
id STRING
locked_for_localization BOOL
name STRING
platform STRING
published BOOL
state STRING
updated_at FLOAT64
updated_by STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
content__version STRING
content__type STRING
content__node_id STRING
content__props__id STRING
content__props__is STRING
content__props__style___container_background STRING
content__props__style___container_border_radius STRING
content__props__style___container_shadow STRING
content__props__style___flows_list_block_background_hover STRING
content__props__style___flows_list_block_color STRING
content__props__style___flows_list_block_item_radius STRING
content__props__style___flows_list_block_marker_color STRING
content__props__style___flows_list_block_radius STRING
content__props__style___flows_list_block_shadow STRING
content__props__style___font_family STRING
content__props__style___header_background STRING
content__props__style___header_color STRING
content__props__style___launcher_block_background STRING
content__props__style___launcher_block_background_active STRING
content__props__style___launcher_block_background_hover STRING
content__props__style___launcher_block_color STRING
content__props__style___link_block_background_hover STRING
content__props__style___link_block_color STRING
content__props__style___link_block_icon_background STRING
content__props__style___link_block_icon_background_hover STRING
content__props__style___link_block_icon_color STRING
content__props__style___link_block_item_radius STRING
content__props__style___link_block_marker_color STRING
content__props__style___link_block_radius STRING
content__props__style___link_block_shadow STRING
content__props__style___primary_color STRING
content__props__style___search_results_block_background_color STRING
content__props__style___search_results_block_background_color_active STRING
content__props__style___search_results_block_background_color_hover STRING
content__props__style___search_results_block_color STRING
content__props__style___search_results_block_content_wrapper_background_color STRING
content__props__style___search_results_block_outline_color STRING
content__props__style___search_results_block_radius STRING
content__props__style___search_results_block_shadow STRING
content__props__style___secondary_color STRING
content__props__style___text_field_block_input_border_color STRING
content__props__style__color STRING
content__props__style__display STRING
content__props__style__flex_direction STRING
content__props__style__font_family STRING
content__props__style__position STRING
content__props__style__width STRING
content__props__style__z_index FLOAT64
content_type STRING
created_at FLOAT64
created_by STRING
id STRING
index FLOAT64
updated_at FLOAT64
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__appcues_flows_list_83ab2fbc_6178_4115_840b_b62c9335922d

Section titled “Subtable: launchpads__steps__actions__appcues_flows_list_83ab2fbc_6178_4115_840b_b62c9335922d”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__interaction_data__block_type STRING
config__interaction_type STRING
map_event_to_config__detail_id STRING
on STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__launchpad_button

Section titled “Subtable: launchpads__steps__actions__launchpad_button”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__target__selector STRING
config__toggle_group_id STRING
on STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__launchpad_button__config__actions

Section titled “Subtable: launchpads__steps__actions__launchpad_button__config__actions”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__interaction_type STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__launchpad_button__config__animations

Section titled “Subtable: launchpads__steps__actions__launchpad_button__config__animations”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
duration FLOAT64
fill STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__launchpad_button__config__animations__keyframes

Section titled “Subtable: launchpads__steps__actions__launchpad_button__config__animations__keyframes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
animation_timing_function STRING
bottom STRING
offset FLOAT64
opacity FLOAT64
right STRING
transform STRING
transform_origin STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__launchpad_close_button

Section titled “Subtable: launchpads__steps__actions__launchpad_close_button”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__target__selector STRING
config__toggle_group_id STRING
on STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__launchpad_close_button__config__animations

Section titled “Subtable: launchpads__steps__actions__launchpad_close_button__config__animations”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
duration FLOAT64
fill STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__actions__launchpad_close_button__config__animations__keyframes

Section titled “Subtable: launchpads__steps__actions__launchpad_close_button__config__animations__keyframes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
animation_timing_function STRING
offset FLOAT64
opacity FLOAT64
transform STRING
transform_origin STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__content__props__children

Section titled “Subtable: launchpads__steps__content__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
node_id STRING
props__data_ignore BOOL
props__id STRING
props__is STRING
props__style__background STRING
props__style__border_radius STRING
props__style__bottom FLOAT64
props__style__box_shadow STRING
props__style__left STRING
props__style__margin_bottom STRING
props__style__max_height STRING
props__style__opacity STRING
props__style__overflow_x STRING
props__style__position STRING
props__style__right FLOAT64
props__style__transform STRING
props__style__visibility STRING
props__style__width STRING
props__style__z_index STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__content__props__children__props__children

Section titled “Subtable: launchpads__steps__content__props__children__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
node_id STRING
props__active_color STRING
props__add_buttons STRING
props__block_type STRING
props__data_ignore BOOL
props__draggable BOOL
props__hover_color STRING
props__is STRING
props__style__align_items STRING
props__style__background STRING
props__style__background_color STRING
props__style__border_bottom STRING
props__style__box_sizing STRING
props__style__color STRING
props__style__display STRING
props__style__flex_direction STRING
props__style__font_size STRING
props__style__gap STRING
props__style__height STRING
props__style__justify_content STRING
props__style__margin_bottom STRING
props__style__margin_top STRING
props__style__padding STRING
props__style__position STRING
props__style__top STRING
props__style__transition STRING
props__style__z_index STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__content__props__children__props__children__props__children

Section titled “Subtable: launchpads__steps__content__props__children__props__children__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
type STRING
node_id STRING
props__block_type STRING
props__droppable BOOL
props__href STRING
props__id STRING
props__is STRING
props__style__align_items STRING
props__style__background STRING
props__style__border STRING
props__style__color STRING
props__style__cursor STRING
props__style__display STRING
props__style__flex FLOAT64
props__style__flex_direction STRING
props__style__font_size STRING
props__style__font_weight STRING
props__style__margin STRING
props__style__padding STRING
props__style__text_decoration STRING
props__style__width STRING
props__target STRING
props__title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__content__props__children__props__children__props__children__props__children

Section titled “Subtable: launchpads__steps__content__props__children__props__children__props__children__props__children”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__placement_unit STRING
config__strategy STRING
config__target__selector STRING
config__unset_opposite_direction BOOL
config__x_offset FLOAT64
config__x_position STRING
config__y_offset FLOAT64
config__y_position STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__traits__config__on_launchpad_close

Section titled “Subtable: launchpads__steps__traits__config__on_launchpad_close”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
config__animation__duration FLOAT64
config__animation__fill STRING
config__animation__id STRING
config__target__selector STRING
config__toggle_group_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: launchpads__steps__traits__config__on_launchpad_close__config__animation__keyframes

Section titled “Subtable: launchpads__steps__traits__config__on_launchpad_close__config__animation__keyframes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
animation_timing_function STRING
offset FLOAT64
opacity FLOAT64
transform STRING
transform_origin STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pins (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_id STRING
app_id STRING
contains_localized_blocks BOOL
created_at FLOAT64
created_by STRING
frequency STRING
id STRING
locked_for_localization BOOL
name STRING
platform STRING
preview_url STRING
published BOOL
state STRING
tags__c141e1ae_993c_4869_8f77_4aa314fdb468 BOOL
theme STRING
updated_at FLOAT64
updated_by STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
segments (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
created_by STRING
id STRING
name STRING
updated_at STRING
updated_by STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
created_by STRING
id STRING
name STRING
updated_at STRING
updated_by STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Appcues 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 Appcues?

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

It depends on how much history is in your Appcues 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 Appcues’s schema changes?

Section titled “What happens when Appcues’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 Appcues, 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 Appcues 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 Appcues connector in Kaivo and all of its synced data is deleted with it.

Track flows, checklists, and launchpads to document the in-app experiences you run.

Use segments to see which user groups each flow and banner targets.

Join flows and pins with tags to understand how your in-app messaging is organised.

Bring Appcues content into BigQuery to report on it next to your product usage data.

Once Appcues 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 Appcues 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 Appcues connector pricing and plan details.