Skip to content
Book a demoStart free
Connectors

Vitally connector

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

Vitally connector pricing, tier and credits on kaivo.io

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

Sync your Vitally customer success data into BigQuery with Kaivo to analyse account health and engagement.

CategoryCustomer Service
AuthenticationAPI key
SetupSelf-service

Getting started with the Vitally connector

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

Field Description
Secret Token
Your Vitally API secret token, used as the username for Basic Auth.

| | Basic Auth Header |

Optional password for Basic Auth. Leave empty if your secret token is the only credential required.

|

When you set up the connector, you provide:

Field Description
Data Center
The Vitally data center hosting your account.

| | Custom Subdomain |

Your Vitally subdomain, found in the URL you use to log in (https://{subdomain}.vitally.io). For example, enter mycompany for mycompany.rest.vitally.io. Required for the US data center; leave empty for EU.

| | Status |

Account status to filter the synced accounts.

|

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

accounts (110 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_executive_id STRING
churned_at STRING
created_at STRING
csm_id STRING
external_id STRING
health_score FLOAT64
id STRING
last_inbound_message_timestamp STRING
last_outbound_message_timestamp STRING
mrr FLOAT64
name STRING
next_renewal_date STRING
nps_detractor_count FLOAT64
nps_passive_count FLOAT64
nps_promoter_count FLOAT64
traits__bottom_avg_csat_1 FLOAT64
traits__bottom_avg_csat_2 FLOAT64
traits__bottom_avg_csat_3 FLOAT64
traits__bottom_staff_1 STRING
traits__bottom_staff_2 STRING
traits__bottom_staff_3 STRING
traits__csat_change_pct FLOAT64
traits__current_activated_pct FLOAT64
traits__current_csat_score FLOAT64
traits__current_logins_cnt FLOAT64
traits__current_messages_cnt FLOAT64
traits__current_new_cases_cnt FLOAT64
traits__current_passives_detractors FLOAT64
traits__current_period_cases_cnt FLOAT64
traits__current_period_nps FLOAT64
traits__current_promoters FLOAT64
traits__firm_id FLOAT64
traits__hspot_annual_contract_value FLOAT64
traits__hspot_appointments_per_100_cases FLOAT64
traits__hspot_automations_per_100_cases FLOAT64
traits__hspot_cancellation_date FLOAT64
traits__hspot_checklist_items_per_100_cases FLOAT64
traits__hspot_city STRING
traits__hspot_contract_start_date FLOAT64
traits__hspot_contracted_case_threshold FLOAT64
traits__hspot_current_google_reviews FLOAT64
traits__hspot_days_from_kickoff_to_fully_implemented__slack_roundedx FLOAT64
traits__hspot_documents_per_100_cases FLOAT64
traits__hspot_escalation STRING
traits__hspot_firm_id FLOAT64
traits__hspot_firm_success_manager STRING
traits__hspot_hs_csm_sentiment STRING
traits__hspot_hubspot_owner_id STRING
traits__hspot_implementation_manager STRING
traits__hspot_implementation_stage STRING
traits__hspot_last_payment FLOAT64
traits__hspot_messages_per_100_cases FLOAT64
traits__hspot_notice_of_termination_date FLOAT64
traits__hspot_of_cases FLOAT64
traits__hspot_practice_area STRING
traits__hspot_scorecard__activation STRING
traits__hspot_scorecard__activation_percentage STRING
traits__hspot_scorecard__growth STRING
traits__hspot_scorecard_last_updated FLOAT64
traits__hspot_sentiment_notes STRING
traits__hspot_size_category STRING
traits__hspot_starting_google_reviews FLOAT64
traits__hspot_state STRING
traits__hspot_status STRING
traits__hspot_termination_date FLOAT64
traits__hspot_treatments_per_100_cases FLOAT64
traits__last_nps_1 FLOAT64
traits__last_nps_2 FLOAT64
traits__last_nps_3 FLOAT64
traits__logins_change_pct FLOAT64
traits__message_change_pct FLOAT64
traits__new_cases_change_pct FLOAT64
traits__nps_change_pct FLOAT64
traits__passives_change_pct FLOAT64
traits__period_cases_change_pct FLOAT64
traits__period_month FLOAT64
traits__period_year STRING
traits__previous_activated_pct FLOAT64
traits__previous_csat_score FLOAT64
traits__previous_logins_cnt FLOAT64
traits__previous_messages_cnt FLOAT64
traits__previous_new_cases_cnt FLOAT64
traits__previous_passives_detractors FLOAT64
traits__previous_period_cases_cnt FLOAT64
traits__previous_period_nps FLOAT64
traits__previous_promoters FLOAT64
traits__promoters_change_pct FLOAT64
traits__top_avg_csat_1 FLOAT64
traits__top_avg_csat_2 FLOAT64
traits__top_avg_csat_3 FLOAT64
traits__top_staff_1 STRING
traits__top_staff_2 STRING
traits__top_staff_3 STRING
traits__unhappy_client_1 STRING
traits__unhappy_client_2 STRING
traits__unhappy_client_3 STRING
traits__vitally_custom_adoption_champions FLOAT64
traits__vitally_custom_executive_sponsors FLOAT64
traits__vitally_custom_forecast STRING
traits__vitally_custom_forecast_notes STRING
traits__vitally_custom_implementation_project_status STRING
traits__vitally_custom_implementation_stage STRING
traits__vitally_custom_last_account_review_reminder FLOAT64
traits__vitally_custom_next_steps STRING
traits__vitally_custom_renewal_contacts FLOAT64
traits__vitally_custom_renewal_stage STRING
updated_at STRING
users_count FLOAT64
_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.
assigned_at STRING
created_at STRING
id STRING
key_role__created_at STRING
key_role__id STRING
key_role__label STRING
vitally_user__email STRING
vitally_user__id STRING
vitally_user__license_status STRING
vitally_user__name 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
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: accounts__traits__hspot_practice_areas

Section titled “Subtable: accounts__traits__hspot_practice_areas”
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.
admins (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
id STRING
license_status STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
source STRING
status STRING
subject STRING
traits__zendesk_status STRING
traits__zendesk_type STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: conversations__traits__zendesk_tags

Section titled “Subtable: conversations__traits__zendesk_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.
notes (127 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account__account_executive_id STRING
account__churned_at STRING
account__created_at STRING
account__csm_id STRING
account__external_id STRING
account__health_score FLOAT64
account__id STRING
account__last_inbound_message_timestamp STRING
account__last_outbound_message_timestamp STRING
account__mrr FLOAT64
account__name STRING
account__next_renewal_date STRING
account__nps_detractor_count FLOAT64
account__nps_passive_count FLOAT64
account__nps_promoter_count FLOAT64
account__traits__bottom_avg_csat_1 FLOAT64
account__traits__bottom_avg_csat_2 FLOAT64
account__traits__bottom_avg_csat_3 FLOAT64
account__traits__bottom_staff_1 STRING
account__traits__bottom_staff_2 STRING
account__traits__bottom_staff_3 STRING
account__traits__csat_change_pct FLOAT64
account__traits__current_activated_pct FLOAT64
account__traits__current_csat_score FLOAT64
account__traits__current_logins_cnt FLOAT64
account__traits__current_messages_cnt FLOAT64
account__traits__current_new_cases_cnt FLOAT64
account__traits__current_passives_detractors FLOAT64
account__traits__current_period_cases_cnt FLOAT64
account__traits__current_period_nps FLOAT64
account__traits__current_promoters FLOAT64
account__traits__firm_id FLOAT64
account__traits__hspot_annual_contract_value FLOAT64
account__traits__hspot_appointments_per_100_cases FLOAT64
account__traits__hspot_automations_per_100_cases FLOAT64
account__traits__hspot_cancellation_date FLOAT64
account__traits__hspot_checklist_items_per_100_cases FLOAT64
account__traits__hspot_city STRING
account__traits__hspot_contract_start_date FLOAT64
account__traits__hspot_contracted_case_threshold FLOAT64
account__traits__hspot_current_google_reviews FLOAT64
account__traits__hspot_days_from_kickoff_to_fully_implemented__slack_roundedx FLOAT64
account__traits__hspot_documents_per_100_cases FLOAT64
account__traits__hspot_escalation STRING
account__traits__hspot_firm_id FLOAT64
account__traits__hspot_firm_success_manager STRING
account__traits__hspot_hs_csm_sentiment STRING
account__traits__hspot_hubspot_owner_id STRING
account__traits__hspot_implementation_manager STRING
account__traits__hspot_implementation_stage STRING
account__traits__hspot_last_payment FLOAT64
account__traits__hspot_messages_per_100_cases FLOAT64
account__traits__hspot_notice_of_termination_date FLOAT64
account__traits__hspot_of_cases FLOAT64
account__traits__hspot_practice_area STRING
account__traits__hspot_scorecard__activation STRING
account__traits__hspot_scorecard__activation_percentage STRING
account__traits__hspot_scorecard__growth STRING
account__traits__hspot_scorecard_last_updated FLOAT64
account__traits__hspot_sentiment_notes STRING
account__traits__hspot_size_category STRING
account__traits__hspot_starting_google_reviews FLOAT64
account__traits__hspot_state STRING
account__traits__hspot_status STRING
account__traits__hspot_termination_date FLOAT64
account__traits__hspot_treatments_per_100_cases FLOAT64
account__traits__last_nps_1 FLOAT64
account__traits__last_nps_2 FLOAT64
account__traits__last_nps_3 FLOAT64
account__traits__logins_change_pct FLOAT64
account__traits__message_change_pct FLOAT64
account__traits__new_cases_change_pct FLOAT64
account__traits__nps_change_pct FLOAT64
account__traits__passives_change_pct FLOAT64
account__traits__period_cases_change_pct FLOAT64
account__traits__period_month FLOAT64
account__traits__period_year STRING
account__traits__previous_activated_pct FLOAT64
account__traits__previous_csat_score FLOAT64
account__traits__previous_logins_cnt FLOAT64
account__traits__previous_messages_cnt FLOAT64
account__traits__previous_new_cases_cnt FLOAT64
account__traits__previous_passives_detractors FLOAT64
account__traits__previous_period_cases_cnt FLOAT64
account__traits__previous_period_nps FLOAT64
account__traits__previous_promoters FLOAT64
account__traits__promoters_change_pct FLOAT64
account__traits__top_avg_csat_1 FLOAT64
account__traits__top_avg_csat_2 FLOAT64
account__traits__top_avg_csat_3 FLOAT64
account__traits__top_staff_1 STRING
account__traits__top_staff_2 STRING
account__traits__top_staff_3 STRING
account__traits__unhappy_client_1 STRING
account__traits__unhappy_client_2 STRING
account__traits__unhappy_client_3 STRING
account__traits__vitally_custom_adoption_champions FLOAT64
account__traits__vitally_custom_executive_sponsors FLOAT64
account__traits__vitally_custom_forecast STRING
account__traits__vitally_custom_forecast_notes STRING
account__traits__vitally_custom_implementation_project_status STRING
account__traits__vitally_custom_implementation_stage STRING
account__traits__vitally_custom_last_account_review_reminder FLOAT64
account__traits__vitally_custom_next_steps STRING
account__traits__vitally_custom_renewal_contacts FLOAT64
account__traits__vitally_custom_renewal_stage STRING
account__updated_at STRING
account__users_count FLOAT64
account_id STRING
author__email STRING
author__id STRING
author__license_status STRING
author__name STRING
author_id STRING
category__created_at STRING
category__id STRING
category__name STRING
category__updated_at STRING
category_id STRING
created_at STRING
id STRING
note STRING
note_date STRING
subject STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: notes__account__traits__hspot_practice_areas

Section titled “Subtable: notes__account__traits__hspot_practice_areas”
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.
tasks (128 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account__account_executive_id STRING
account__churned_at STRING
account__created_at STRING
account__csm_id STRING
account__external_id STRING
account__health_score FLOAT64
account__id STRING
account__last_inbound_message_timestamp STRING
account__last_outbound_message_timestamp STRING
account__mrr FLOAT64
account__name STRING
account__next_renewal_date STRING
account__nps_detractor_count FLOAT64
account__nps_passive_count FLOAT64
account__nps_promoter_count FLOAT64
account__traits__bottom_avg_csat_1 FLOAT64
account__traits__bottom_avg_csat_2 FLOAT64
account__traits__bottom_avg_csat_3 FLOAT64
account__traits__bottom_staff_1 STRING
account__traits__bottom_staff_2 STRING
account__traits__bottom_staff_3 STRING
account__traits__csat_change_pct FLOAT64
account__traits__current_activated_pct FLOAT64
account__traits__current_csat_score FLOAT64
account__traits__current_logins_cnt FLOAT64
account__traits__current_messages_cnt FLOAT64
account__traits__current_new_cases_cnt FLOAT64
account__traits__current_passives_detractors FLOAT64
account__traits__current_period_cases_cnt FLOAT64
account__traits__current_period_nps FLOAT64
account__traits__current_promoters FLOAT64
account__traits__firm_id FLOAT64
account__traits__hspot_annual_contract_value FLOAT64
account__traits__hspot_appointments_per_100_cases FLOAT64
account__traits__hspot_automations_per_100_cases FLOAT64
account__traits__hspot_cancellation_date FLOAT64
account__traits__hspot_checklist_items_per_100_cases FLOAT64
account__traits__hspot_city STRING
account__traits__hspot_contract_start_date FLOAT64
account__traits__hspot_contracted_case_threshold FLOAT64
account__traits__hspot_current_google_reviews FLOAT64
account__traits__hspot_days_from_kickoff_to_fully_implemented__slack_roundedx FLOAT64
account__traits__hspot_documents_per_100_cases FLOAT64
account__traits__hspot_escalation STRING
account__traits__hspot_firm_id FLOAT64
account__traits__hspot_firm_success_manager STRING
account__traits__hspot_hs_csm_sentiment STRING
account__traits__hspot_hubspot_owner_id STRING
account__traits__hspot_implementation_manager STRING
account__traits__hspot_implementation_stage STRING
account__traits__hspot_last_payment FLOAT64
account__traits__hspot_messages_per_100_cases FLOAT64
account__traits__hspot_notice_of_termination_date FLOAT64
account__traits__hspot_of_cases FLOAT64
account__traits__hspot_practice_area STRING
account__traits__hspot_scorecard__activation STRING
account__traits__hspot_scorecard__activation_percentage STRING
account__traits__hspot_scorecard__growth STRING
account__traits__hspot_scorecard_last_updated FLOAT64
account__traits__hspot_sentiment_notes STRING
account__traits__hspot_size_category STRING
account__traits__hspot_starting_google_reviews FLOAT64
account__traits__hspot_state STRING
account__traits__hspot_status STRING
account__traits__hspot_termination_date FLOAT64
account__traits__hspot_treatments_per_100_cases FLOAT64
account__traits__last_nps_1 FLOAT64
account__traits__last_nps_2 FLOAT64
account__traits__last_nps_3 FLOAT64
account__traits__logins_change_pct FLOAT64
account__traits__message_change_pct FLOAT64
account__traits__new_cases_change_pct FLOAT64
account__traits__nps_change_pct FLOAT64
account__traits__passives_change_pct FLOAT64
account__traits__period_cases_change_pct FLOAT64
account__traits__period_month FLOAT64
account__traits__period_year STRING
account__traits__previous_activated_pct FLOAT64
account__traits__previous_csat_score FLOAT64
account__traits__previous_logins_cnt FLOAT64
account__traits__previous_messages_cnt FLOAT64
account__traits__previous_new_cases_cnt FLOAT64
account__traits__previous_passives_detractors FLOAT64
account__traits__previous_period_cases_cnt FLOAT64
account__traits__previous_period_nps FLOAT64
account__traits__previous_promoters FLOAT64
account__traits__promoters_change_pct FLOAT64
account__traits__top_avg_csat_1 FLOAT64
account__traits__top_avg_csat_2 FLOAT64
account__traits__top_avg_csat_3 FLOAT64
account__traits__top_staff_1 STRING
account__traits__top_staff_2 STRING
account__traits__top_staff_3 STRING
account__traits__unhappy_client_1 STRING
account__traits__unhappy_client_2 STRING
account__traits__unhappy_client_3 STRING
account__traits__vitally_custom_adoption_champions FLOAT64
account__traits__vitally_custom_executive_sponsors FLOAT64
account__traits__vitally_custom_forecast STRING
account__traits__vitally_custom_forecast_notes STRING
account__traits__vitally_custom_implementation_project_status STRING
account__traits__vitally_custom_implementation_stage STRING
account__traits__vitally_custom_last_account_review_reminder FLOAT64
account__traits__vitally_custom_next_steps STRING
account__traits__vitally_custom_renewal_contacts FLOAT64
account__traits__vitally_custom_renewal_stage STRING
account__updated_at STRING
account__users_count FLOAT64
account_id STRING
assigned_to__email STRING
assigned_to__id STRING
assigned_to__license_status STRING
assigned_to__name STRING
assigned_to_id STRING
completed_at STRING
completed_by__email STRING
completed_by__id STRING
completed_by__license_status STRING
completed_by__name STRING
completed_by_id STRING
created_at STRING
due_date STRING
id STRING
name STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: tasks__account__traits__hspot_practice_areas

Section titled “Subtable: tasks__account__traits__hspot_practice_areas”
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.
account_id STRING
actual_start_date STRING
archived_at STRING
created_at STRING
duration_in_days FLOAT64
id STRING
name STRING
owned_by_vitally_user_id STRING
project_category_id STRING
project_status_id STRING
target_completion_date 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.
users (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
email STRING
external_id STRING
first_known STRING
id STRING
join_date STRING
last_inbound_message_timestamp STRING
last_outbound_message_timestamp STRING
name STRING
traits__hspot_email STRING
traits__hspot_executive_sponsorx STRING
traits__hspot_firstname STRING
traits__hspot_jobtitle STRING
traits__hspot_lastname STRING
traits__hspot_phone STRING
traits__vitally_custom_adoption_champion BOOL
traits__vitally_custom_executive_sponsor BOOL
traits__vitally_custom_renewal_contact BOOL
unsubscribed_from_conversations BOOL
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.
account_executive_id STRING
churned_at STRING
created_at STRING
csm_id STRING
external_id STRING
health_score FLOAT64
id STRING
last_inbound_message_timestamp STRING
last_outbound_message_timestamp STRING
mrr FLOAT64
name STRING
next_renewal_date STRING
nps_detractor_count FLOAT64
nps_passive_count FLOAT64
nps_promoter_count FLOAT64
traits__bottom_avg_csat_1 FLOAT64
traits__bottom_avg_csat_2 FLOAT64
traits__bottom_avg_csat_3 FLOAT64
traits__bottom_staff_1 STRING
traits__bottom_staff_2 STRING
traits__bottom_staff_3 STRING
traits__csat_change_pct FLOAT64
traits__current_activated_pct FLOAT64
traits__current_csat_score FLOAT64
traits__current_logins_cnt FLOAT64
traits__current_messages_cnt FLOAT64
traits__current_new_cases_cnt FLOAT64
traits__current_passives_detractors FLOAT64
traits__current_period_cases_cnt FLOAT64
traits__current_period_nps FLOAT64
traits__current_promoters FLOAT64
traits__firm_id FLOAT64
traits__hspot_annual_contract_value FLOAT64
traits__hspot_appointments_per_100_cases FLOAT64
traits__hspot_automations_per_100_cases FLOAT64
traits__hspot_cancellation_date FLOAT64
traits__hspot_checklist_items_per_100_cases FLOAT64
traits__hspot_city STRING
traits__hspot_contract_start_date FLOAT64
traits__hspot_contracted_case_threshold FLOAT64
traits__hspot_current_google_reviews FLOAT64
traits__hspot_days_from_kickoff_to_fully_implemented__slack_roundedx FLOAT64
traits__hspot_documents_per_100_cases FLOAT64
traits__hspot_escalation STRING
traits__hspot_firm_id FLOAT64
traits__hspot_firm_success_manager STRING
traits__hspot_hs_csm_sentiment STRING
traits__hspot_hubspot_owner_id STRING
traits__hspot_implementation_manager STRING
traits__hspot_implementation_stage STRING
traits__hspot_last_payment FLOAT64
traits__hspot_messages_per_100_cases FLOAT64
traits__hspot_notice_of_termination_date FLOAT64
traits__hspot_of_cases FLOAT64
traits__hspot_practice_area STRING
traits__hspot_scorecard__activation STRING
traits__hspot_scorecard__activation_percentage STRING
traits__hspot_scorecard__growth STRING
traits__hspot_scorecard_last_updated FLOAT64
traits__hspot_sentiment_notes STRING
traits__hspot_size_category STRING
traits__hspot_starting_google_reviews FLOAT64
traits__hspot_state STRING
traits__hspot_status STRING
traits__hspot_termination_date FLOAT64
traits__hspot_treatments_per_100_cases FLOAT64
traits__last_nps_1 FLOAT64
traits__last_nps_2 FLOAT64
traits__last_nps_3 FLOAT64
traits__logins_change_pct FLOAT64
traits__message_change_pct FLOAT64
traits__new_cases_change_pct FLOAT64
traits__nps_change_pct FLOAT64
traits__passives_change_pct FLOAT64
traits__period_cases_change_pct FLOAT64
traits__period_month FLOAT64
traits__period_year STRING
traits__previous_activated_pct FLOAT64
traits__previous_csat_score FLOAT64
traits__previous_logins_cnt FLOAT64
traits__previous_messages_cnt FLOAT64
traits__previous_new_cases_cnt FLOAT64
traits__previous_passives_detractors FLOAT64
traits__previous_period_cases_cnt FLOAT64
traits__previous_period_nps FLOAT64
traits__previous_promoters FLOAT64
traits__promoters_change_pct FLOAT64
traits__top_avg_csat_1 FLOAT64
traits__top_avg_csat_2 FLOAT64
traits__top_avg_csat_3 FLOAT64
traits__top_staff_1 STRING
traits__top_staff_2 STRING
traits__top_staff_3 STRING
traits__unhappy_client_1 STRING
traits__unhappy_client_2 STRING
traits__unhappy_client_3 STRING
traits__vitally_custom_adoption_champions FLOAT64
traits__vitally_custom_executive_sponsors FLOAT64
traits__vitally_custom_forecast STRING
traits__vitally_custom_forecast_notes STRING
traits__vitally_custom_implementation_project_status STRING
traits__vitally_custom_implementation_stage STRING
traits__vitally_custom_last_account_review_reminder FLOAT64
traits__vitally_custom_next_steps STRING
traits__vitally_custom_renewal_contacts FLOAT64
traits__vitally_custom_renewal_stage STRING
updated_at STRING
users_count FLOAT64
_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
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: users__accounts__traits__hspot_practice_areas

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

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

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

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

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

Use accounts and notes to monitor health and activity across accounts.

Join conversations and tasks with accounts to see how you work each one.

Use users to understand engagement within your accounts.

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

  • HubSpot: Sync HubSpot to BigQuery.
  • Dixa: Sync Dixa to BigQuery.
  • Freshservice: Sync Freshservice to BigQuery.
  • Genesys: Sync Genesys to BigQuery.
  • Gorgias: Sync Gorgias to BigQuery.
  • giosg: Sync giosg to BigQuery.