Skip to content
Book a demoStart free
Connectors

Chameleon connector

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

Chameleon connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Chameleon 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 Chameleon in-product experience data into BigQuery with Kaivo to see which tours, tooltips, and surveys reach your users.

CategoryMarketing & Sales, Tech
AuthenticationAPI key
SetupSelf-service

Getting started with the Chameleon connector

Section titled “Getting started with the Chameleon connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Chameleon 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 Chameleon API Secret (not the client-side Account Token), found in your dashboard under Settings → Tokens.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

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

changes (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
experience_id STRING
id STRING
kind STRING
model_id STRING
model_type STRING
object__id STRING
object__kind STRING
object__path STRING
object__path_index STRING
object__selection_id STRING
object__selector JSON
object__step_id STRING
object__tag STRING
object__text STRING
path STRING
user__created_at STRING
user__email STRING
user__id STRING
user__name STRING
user__updated_at 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.

Subtable: changes__object__completed_unpublish_count

Section titled “Subtable: changes__object__completed_unpublish_count”
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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__completed_unpublish_user_id

Section titled “Subtable: changes__object__completed_unpublish_user_id”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__display_animation

Section titled “Subtable: changes__object__display_animation”
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: changes__object__first_published_at

Section titled “Subtable: changes__object__first_published_at”
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 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.

Subtable: changes__object__published_at_count

Section titled “Subtable: changes__object__published_at_count”
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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__published_completed_unpublish_count

Section titled “Subtable: changes__object__published_completed_unpublish_count”
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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__published_run_at

Section titled “Subtable: changes__object__published_run_at”
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: changes__object__published_run_at_count

Section titled “Subtable: changes__object__published_run_at_count”
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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__published_segment_ids

Section titled “Subtable: changes__object__published_segment_ids”
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: changes__object__published_segment_ids__list

Section titled “Subtable: changes__object__published_segment_ids__list”
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: changes__object__published_updated_at

Section titled “Subtable: changes__object__published_updated_at”
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: changes__object__published_user_id

Section titled “Subtable: changes__object__published_user_id”
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: changes__object__recurrence_frequency

Section titled “Subtable: changes__object__recurrence_frequency”
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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__recurrence_kind

Section titled “Subtable: changes__object__recurrence_kind”
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: changes__object__secondary_trigger

Section titled “Subtable: changes__object__secondary_trigger”
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: changes__object__secondary_trigger_position

Section titled “Subtable: changes__object__secondary_trigger_position”
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 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.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__segment_ids__list

Section titled “Subtable: changes__object__segment_ids__list”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__object__style_relative_offset_x

Section titled “Subtable: changes__object__style_relative_offset_x”
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: changes__object__style_trigger_offset_x

Section titled “Subtable: changes__object__style_trigger_offset_x”
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: changes__object__style_trigger_offset_y

Section titled “Subtable: changes__object__style_trigger_offset_y”
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: changes__object__style_trigger_scale_width

Section titled “Subtable: changes__object__style_trigger_scale_width”
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: changes__object__trigger_element_attachment_id

Section titled “Subtable: changes__object__trigger_element_attachment_id”
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: changes__object__trigger_secondary_type

Section titled “Subtable: changes__object__trigger_secondary_type”
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.

Subtable: changes__object__width_with_units

Section titled “Subtable: changes__object__width_with_units”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: changes__options__trigger_element_attachment_url

Section titled “Subtable: changes__options__trigger_element_attachment_url”
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.
helpbars (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
inline_position STRING
key_meta BOOL
key_uid STRING
oids__search_groups__actions STRING
oids__search_groups__default STRING
oids__search_groups__experiences STRING
oids__search_groups__pinned STRING
placeholder STRING
style_color_background STRING
style_color_text STRING
style_trigger_offset_x STRING
style_trigger_offset_y STRING
style_widget_background_color STRING
style_widget_border_color STRING
style_widget_border_radius STRING
style_widget_icon_color STRING
style_widget_offset_x STRING
style_widget_offset_y STRING
style_widget_text_color STRING
title_recent STRING
trigger_position STRING
updated_at STRING
widget_attachment_size STRING
widget_icon_uid STRING
widget_position STRING
widget_screen_position STRING
widget_text 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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: helpbars__widget_css_syntax_errors

Section titled “Subtable: helpbars__widget_css_syntax_errors”
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.
launchers (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
icon_size STRING
id STRING
list_type STRING
name STRING
position_type STRING
screen_position STRING
segments_op STRING
stats__displayed_count FLOAT64
stats__started_count FLOAT64
title STRING
trigger STRING
trigger_text STRING
trigger_type STRING
updated_at 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.
description STRING
created_at STRING
hide BOOL
id STRING
kind STRING
title 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.
id STRING
match_type 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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
segments (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
name STRING
updated_at 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.
created_at STRING
id STRING
kind STRING
op STRING
prop STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
survey_responses (145 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
button_id STRING
button_order FLOAT64
button_text STRING
comment_step_input_text STRING
created_at STRING
finished_at STRING
href STRING
id STRING
input_text STRING
profile__created_at STRING
profile__id STRING
profile__options__account_type STRING
profile__options__active_connections FLOAT64
profile__options__clearbit_company_category_industry STRING
profile__options__clearbit_company_category_industry_group STRING
profile__options__clearbit_company_category_naics_code FLOAT64
profile__options__clearbit_company_category_sector STRING
profile__options__clearbit_company_category_sic_code FLOAT64
profile__options__clearbit_company_category_sub_industry STRING
profile__options__clearbit_company_crunchbase_handle STRING
profile__options__clearbit_company_description STRING
profile__options__clearbit_company_domain STRING
profile__options__clearbit_company_email_provider BOOL
profile__options__clearbit_company_facebook_handle STRING
profile__options__clearbit_company_founded_year FLOAT64
profile__options__clearbit_company_geo_city STRING
profile__options__clearbit_company_geo_country STRING
profile__options__clearbit_company_geo_country_code STRING
profile__options__clearbit_company_geo_lat FLOAT64
profile__options__clearbit_company_geo_lng FLOAT64
profile__options__clearbit_company_geo_postal_code STRING
profile__options__clearbit_company_geo_state STRING
profile__options__clearbit_company_geo_state_code STRING
profile__options__clearbit_company_geo_street_name STRING
profile__options__clearbit_company_geo_street_number STRING
profile__options__clearbit_company_indexed_at STRING
profile__options__clearbit_company_legal_name STRING
profile__options__clearbit_company_linkedin_handle STRING
profile__options__clearbit_company_location STRING
profile__options__clearbit_company_logo STRING
profile__options__clearbit_company_metrics_alexa_global_rank FLOAT64
profile__options__clearbit_company_metrics_alexa_us_rank FLOAT64
profile__options__clearbit_company_metrics_employees FLOAT64
profile__options__clearbit_company_metrics_employees_range STRING
profile__options__clearbit_company_metrics_estimated_annual_revenue STRING
profile__options__clearbit_company_metrics_raised FLOAT64
profile__options__clearbit_company_name STRING
profile__options__clearbit_company_phone STRING
profile__options__clearbit_company_time_zone STRING
profile__options__clearbit_company_twitter_followers FLOAT64
profile__options__clearbit_company_twitter_following FLOAT64
profile__options__clearbit_company_twitter_handle STRING
profile__options__clearbit_company_type STRING
profile__options__clearbit_company_utc_offset FLOAT64
profile__options__clearbit_person_employment_domain STRING
profile__options__clearbit_person_employment_name STRING
profile__options__clearbit_person_employment_role STRING
profile__options__clearbit_person_employment_seniority STRING
profile__options__clearbit_person_employment_title STRING
profile__options__clearbit_person_fuzzy BOOL
profile__options__clearbit_person_geo_city STRING
profile__options__clearbit_person_geo_country STRING
profile__options__clearbit_person_geo_country_code STRING
profile__options__clearbit_person_geo_lat FLOAT64
profile__options__clearbit_person_geo_lng FLOAT64
profile__options__clearbit_person_geo_state STRING
profile__options__clearbit_person_geo_state_code STRING
profile__options__clearbit_person_indexed_at STRING
profile__options__clearbit_person_linkedin_handle STRING
profile__options__clearbit_person_location STRING
profile__options__clearbit_person_name_family_name STRING
profile__options__clearbit_person_name_full_name STRING
profile__options__clearbit_person_name_given_name STRING
profile__options__clearbit_person_time_zone STRING
profile__options__clearbit_person_utc_offset FLOAT64
profile__options__clearbit_reveal_company_category_industry STRING
profile__options__clearbit_reveal_company_category_industry_group STRING
profile__options__clearbit_reveal_company_category_naics_code FLOAT64
profile__options__clearbit_reveal_company_category_sector STRING
profile__options__clearbit_reveal_company_category_sic_code FLOAT64
profile__options__clearbit_reveal_company_category_sub_industry STRING
profile__options__clearbit_reveal_company_crunchbase_handle STRING
profile__options__clearbit_reveal_company_description STRING
profile__options__clearbit_reveal_company_domain STRING
profile__options__clearbit_reveal_company_email_provider BOOL
profile__options__clearbit_reveal_company_facebook_handle STRING
profile__options__clearbit_reveal_company_founded_year FLOAT64
profile__options__clearbit_reveal_company_geo_city STRING
profile__options__clearbit_reveal_company_geo_country STRING
profile__options__clearbit_reveal_company_geo_country_code STRING
profile__options__clearbit_reveal_company_geo_lat FLOAT64
profile__options__clearbit_reveal_company_geo_lng FLOAT64
profile__options__clearbit_reveal_company_geo_postal_code STRING
profile__options__clearbit_reveal_company_geo_state STRING
profile__options__clearbit_reveal_company_geo_state_code STRING
profile__options__clearbit_reveal_company_geo_street_name STRING
profile__options__clearbit_reveal_company_geo_street_number STRING
profile__options__clearbit_reveal_company_geo_sub_premise STRING
profile__options__clearbit_reveal_company_indexed_at STRING
profile__options__clearbit_reveal_company_legal_name STRING
profile__options__clearbit_reveal_company_linkedin_handle STRING
profile__options__clearbit_reveal_company_location STRING
profile__options__clearbit_reveal_company_logo STRING
profile__options__clearbit_reveal_company_metrics_alexa_global_rank FLOAT64
profile__options__clearbit_reveal_company_metrics_alexa_us_rank FLOAT64
profile__options__clearbit_reveal_company_metrics_annual_revenue FLOAT64
profile__options__clearbit_reveal_company_metrics_employees FLOAT64
profile__options__clearbit_reveal_company_metrics_employees_range STRING
profile__options__clearbit_reveal_company_metrics_estimated_annual_revenue STRING
profile__options__clearbit_reveal_company_metrics_raised FLOAT64
profile__options__clearbit_reveal_company_name STRING
profile__options__clearbit_reveal_company_phone STRING
profile__options__clearbit_reveal_company_time_zone STRING
profile__options__clearbit_reveal_company_twitter_followers FLOAT64
profile__options__clearbit_reveal_company_twitter_following FLOAT64
profile__options__clearbit_reveal_company_twitter_handle STRING
profile__options__clearbit_reveal_company_type STRING
profile__options__clearbit_reveal_company_utc_offset FLOAT64
profile__options__clearbit_reveal_confidence_score STRING
profile__options__clearbit_reveal_fuzzy BOOL
profile__options__clearbit_reveal_geo_ip_city STRING
profile__options__clearbit_reveal_geo_ip_country STRING
profile__options__clearbit_reveal_geo_ip_country_code STRING
profile__options__clearbit_reveal_geo_ip_state STRING
profile__options__clearbit_reveal_geo_ip_state_code STRING
profile__options__clearbit_reveal_role STRING
profile__options__clearbit_reveal_seniority STRING
profile__options__current_workspace_id STRING
profile__options__days_since_customer FLOAT64
profile__options__email STRING
profile__options__first_close_date STRING
profile__options__first_sync_success STRING
profile__options__icp_score_category STRING
profile__options__is_corporate BOOL
profile__options__provider STRING
profile__options__salesforce_contact__email STRING
profile__options__trial_end_date STRING
profile__options__workspace_id STRING
profile__uid STRING
profile__updated_at STRING
profile_id STRING
survey_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: survey_responses__comment_step_buttons_selected

Section titled “Subtable: survey_responses__comment_step_buttons_selected”
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: survey_responses__comment_step_buttons_selected2

Section titled “Subtable: survey_responses__comment_step_buttons_selected2”
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: survey_responses__comment_step_dropdown_items

Section titled “Subtable: survey_responses__comment_step_dropdown_items”
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: survey_responses__comment_step_dropdown_items2

Section titled “Subtable: survey_responses__comment_step_dropdown_items2”
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: survey_responses__dropdown_items

Section titled “Subtable: survey_responses__dropdown_items”
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: survey_responses__profile__options__chameleon_launchers_started

Section titled “Subtable: survey_responses__profile__options__chameleon_launchers_started”
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: survey_responses__profile__options__clearbit_company_domain_aliases

Section titled “Subtable: survey_responses__profile__options__clearbit_company_domain_aliases”
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: survey_responses__profile__options__clearbit_company_site_email_addresses

Section titled “Subtable: survey_responses__profile__options__clearbit_company_site_email_addresses”
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: survey_responses__profile__options__clearbit_company_site_phone_numbers

Section titled “Subtable: survey_responses__profile__options__clearbit_company_site_phone_numbers”
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: survey_responses__profile__options__clearbit_company_tags

Section titled “Subtable: survey_responses__profile__options__clearbit_company_tags”
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: survey_responses__profile__options__clearbit_company_tech

Section titled “Subtable: survey_responses__profile__options__clearbit_company_tech”
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: survey_responses__profile__options__clearbit_reveal_company_domain_aliases

Section titled “Subtable: survey_responses__profile__options__clearbit_reveal_company_domain_aliases”
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: survey_responses__profile__options__clearbit_reveal_company_site_email_addresses

Section titled “Subtable: survey_responses__profile__options__clearbit_reveal_company_site_email_addresses”
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: survey_responses__profile__options__clearbit_reveal_company_site_phone_numbers

Section titled “Subtable: survey_responses__profile__options__clearbit_reveal_company_site_phone_numbers”
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: survey_responses__profile__options__clearbit_reveal_company_tags

Section titled “Subtable: survey_responses__profile__options__clearbit_reveal_company_tags”
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: survey_responses__profile__options__clearbit_reveal_company_tech

Section titled “Subtable: survey_responses__profile__options__clearbit_reveal_company_tech”
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: survey_responses__profile__options__providers

Section titled “Subtable: survey_responses__profile__options__providers”
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.
surveys (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
name STRING
position FLOAT64
published_at STRING
rate_unlimit_at STRING
segment_id STRING
segments_op STRING
stats__completed_count FLOAT64
stats__exited_count FLOAT64
stats__last_completed_at STRING
stats__last_exited_at STRING
stats__last_started_at STRING
stats__started_count FLOAT64
updated_at 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.
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 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.
tooltips (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
name STRING
position FLOAT64
published_at STRING
updated_at 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.
tours (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
experiment_range STRING
id STRING
name STRING
position FLOAT64
segments_op STRING
stats__completed_count FLOAT64
stats__exited_count FLOAT64
stats__started_count FLOAT64
style STRING
updated_at 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 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.
url_groups (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
name STRING
short_name STRING
style_short_name_color STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
urls (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
domain STRING
enabled STRING
host STRING
id STRING
updated_at 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 Chameleon 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 Chameleon?

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

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

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

Use tours, tooltips, and launchers to document the in-app guidance you run.

Join surveys with survey_responses to measure in-app feedback.

Use segments to see which user groups each experience targets.

Use Chameleon data in your AI and BI tools

Section titled “Use Chameleon data in your AI and BI tools”

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