Skip to content
Book a demoStart free
Connectors

HighLevel connector

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

HighLevel connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your HighLevel 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 CRM data instead of moving it.

Sync your HighLevel CRM data into BigQuery with Kaivo to report on pipeline, contacts, and revenue in one place.

CategoryCRM, Marketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the HighLevel connector

Section titled “Getting started with the HighLevel connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your HighLevel 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
The location-level API key for the same sub-account, found under Settings → API Key in High Level.

|

When you set up the connector, you provide:

Field Description
Location ID
The ID of the High Level sub-account (location) to sync. Find it under Settings → Business Profile of the sub-account, or in the URL while you have that sub-account open.

| | Start Date |

Any data before this date will not be fetched.

|

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

Contact Search (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
address STRING
assigned_to STRING
city STRING
company_name STRING
country STRING
date_added STRING
date_updated STRING
dnd BOOL
email STRING
first_name_lower_case STRING
id STRING
last_name_lower_case STRING
location_id STRING
phone STRING
postal_code STRING
source STRING
state STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Contact Search__additional_emails (4 columns)
  • Contact Search__additional_phones (4 columns)
  • Contact Search__custom_fields (5 columns)
  • Contact Search__followers (4 columns)
  • Contact Search__opportunities (8 columns)
  • Contact Search__search_after (4 columns)
  • Contact Search__tags (4 columns)
Contacts (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
address1 STRING
assigned_to STRING
city STRING
contact_name STRING
country STRING
date_added STRING
date_updated STRING
dnd BOOL
dnd_settings__email__code STRING
dnd_settings__email__message STRING
dnd_settings__email__status STRING
email STRING
first_name STRING
first_name_raw STRING
id STRING
last_name STRING
last_name_raw STRING
location_id STRING
phone STRING
postal_code STRING
profile_photo STRING
source STRING
state STRING
timezone STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Contacts__additional_emails (4 columns)
  • Contacts__attributions (17 columns)
  • Contacts__custom_fields (5 columns)
  • Contacts__followers (4 columns)
  • Contacts__tags (4 columns)
Custom Fields (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
data_type STRING
date_added STRING
document_type STRING
field_key STRING
id STRING
is_allowed_custom_option BOOL
is_multi_file_allowed BOOL
location_id STRING
max_file_limit FLOAT64
model STRING
name STRING
parent_id STRING
placeholder STRING
position FLOAT64
standard BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Custom Fields__picklist_options (4 columns)
Form Submissions (76 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
contact_id STRING
created_at STRING
email STRING
form_id STRING
id STRING
name STRING
others___7rq_pmp_ve17cq_vho69_a_dn STRING
others__lm_kf_xx_b_wn_wa4_xkp_ig33w STRING
others__timezone STRING
others__am_fingerprint STRING
others__am_id STRING
others__contact_id STRING
others__email STRING
others__event_data__version STRING
others__event_data__type STRING
others__event_data__ad_source STRING
others__event_data__campaign STRING
others__event_data__document_url STRING
others__event_data__domain STRING
others__event_data__fb_event_id STRING
others__event_data__fbc STRING
others__event_data__fbp STRING
others__event_data__ga_client_id STRING
others__event_data__keyword STRING
others__event_data__medium STRING
others__event_data__medium_id STRING
others__event_data__page__title STRING
others__event_data__page__url STRING
others__event_data__page_visit_type STRING
others__event_data__parent_id STRING
others__event_data__parent_name STRING
others__event_data__referrer STRING
others__event_data__source STRING
others__event_data__timestamp FLOAT64
others__event_data__url_params___fs STRING
others__event_data__url_params___gl STRING
others__event_data__url_params__ad_id STRING
others__event_data__url_params__adset_id STRING
others__event_data__url_params__am_id STRING
others__event_data__url_params__el STRING
others__event_data__url_params__fbclid STRING
others__event_data__url_params__gad_source STRING
others__event_data__url_params__gbraid STRING
others__event_data__url_params__gclid STRING
others__event_data__url_params__gtm_debug STRING
others__event_data__url_params__he STRING
others__event_data__url_params__inf_contact_key STRING
others__event_data__url_params__mcp_token STRING
others__event_data__url_params__placement STRING
others__event_data__url_params__site_source_name STRING
others__event_data__url_params__utm_campaign STRING
others__event_data__url_params__utm_content STRING
others__event_data__url_params__utm_id STRING
others__event_data__url_params__utm_medium STRING
others__event_data__url_params__utm_source STRING
others__event_data__url_params__utm_term STRING
others__first_name STRING
others__form_id STRING
others__full_name STRING
others__funne_event_data__domain_name STRING
others__funne_event_data__event_type STRING
others__funne_event_data__funnel_id STRING
others__funne_event_data__funnel_step_id STRING
others__funne_event_data__page_id STRING
others__funne_event_data__page_url STRING
others__ip STRING
others__last_name STRING
others__location_id STRING
others__phone STRING
others__session_fingerprint STRING
others__session_id STRING
others__signature_hash STRING
others__submission_id STRING
others__terms_and_conditions STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Form Submissions__others__event_data__contact_session_ids__ids (4 columns)
  • Form Submissions__others__fields_ori_sequance (4 columns)
Invoices (92 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
alt_id STRING
alt_type STRING
amount_due FLOAT64
amount_paid FLOAT64
automatic_taxes_calculated BOOL
automatic_taxes_enabled BOOL
business_details__address__address_line1 STRING
business_details__address__city STRING
business_details__address__country_code STRING
business_details__address__postal_code STRING
business_details__address__state STRING
business_details__logo_url STRING
business_details__name STRING
business_details__phone_no STRING
business_details__website STRING
contact_details__address__address_line1 STRING
contact_details__address__city STRING
contact_details__address__country_code STRING
contact_details__address__postal_code STRING
contact_details__address__state STRING
contact_details__company_name STRING
contact_details__email STRING
contact_details__id STRING
contact_details__name STRING
contact_details__phone_no STRING
created_at STRING
currency STRING
discount__type STRING
discount__value FLOAT64
due_date STRING
invoice_number STRING
invoice_total FLOAT64
issue_date STRING
last_paid_at STRING
last_visited_at STRING
live_mode BOOL
manual_status_transitions__paid BOOL
manual_status_transitions__sent BOOL
meta__auto_payment__error__type STRING
meta__auto_payment__error__decline_code STRING
meta__auto_payment__error__message STRING
meta__auto_payment__error__request_id STRING
meta__auto_payment__error__status_code FLOAT64
meta__auto_payment__retry FLOAT64
meta__auto_payment__success BOOL
meta__auto_payment__task_req__create_time__nanos FLOAT64
meta__auto_payment__task_req__create_time__seconds STRING
meta__auto_payment__task_req__dispatch_count FLOAT64
meta__auto_payment__task_req__dispatch_deadline__nanos FLOAT64
meta__auto_payment__task_req__dispatch_deadline__seconds STRING
meta__auto_payment__task_req__http_request__body STRING
meta__auto_payment__task_req__http_request__headers__version STRING
meta__auto_payment__task_req__http_request__headers__authorization STRING
meta__auto_payment__task_req__http_request__headers__content_type STRING
meta__auto_payment__task_req__http_request__headers__user_agent STRING
meta__auto_payment__task_req__http_request__headers__channel STRING
meta__auto_payment__task_req__http_request__headers__source STRING
meta__auto_payment__task_req__http_request__headers__source_id STRING
meta__auto_payment__task_req__http_request__http_method STRING
meta__auto_payment__task_req__http_request__url STRING
meta__auto_payment__task_req__message_type STRING
meta__auto_payment__task_req__name STRING
meta__auto_payment__task_req__payload_type STRING
meta__auto_payment__task_req__response_count FLOAT64
meta__auto_payment__task_req__schedule_time__nanos FLOAT64
meta__auto_payment__task_req__schedule_time__seconds STRING
meta__auto_payment__task_req__view STRING
meta__child_task_id STRING
meta__next_child_task__execute_at STRING
meta__next_child_task__id STRING
meta__parent_task__id STRING
name STRING
payment_schedule__type STRING
reminders_configuration__reminder_settings__default_email_template_id STRING
schedule_id STRING
schedule_type STRING
sent_at STRING
sent_by STRING
sent_from__from_email STRING
sent_from__from_name STRING
source STRING
status STRING
terms_notes STRING
title STRING
total FLOAT64
total_summary__discount FLOAT64
total_summary__sub_total FLOAT64
updated_at STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Invoices__business_details__custom_values (4 columns)
  • Invoices__contact_details__additional_emails (4 columns)
  • Invoices__contact_details__custom_fields (16 columns)
  • Invoices__invoice_items (14 columns)
  • Invoices__invoice_items__taxes (4 columns)
  • Invoices__payment_schedule__schedules (8 columns)
  • Invoices__reminders_configuration__reminder_settings__reminders (14 columns)
  • Invoices__sent_to__email (4 columns)
  • Invoices__sent_to__email_bcc (4 columns)
  • Invoices__sent_to__email_cc (4 columns)
  • Invoices__sent_to__phone_no (4 columns)
  • Invoices__tips_received (4 columns)
Opportunities (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assigned_to STRING
contact__company_name STRING
contact__email STRING
contact__id STRING
contact__name STRING
contact__phone STRING
contact_id STRING
created_at STRING
id STRING
index_version FLOAT64
last_stage_change_at STRING
last_status_change_at STRING
location_id STRING
monetary_value FLOAT64
name STRING
pipeline_id STRING
pipeline_stage_id STRING
pipeline_stage_u_id STRING
source STRING
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Opportunities__attributions (16 columns)
  • Opportunities__custom_fields (4 columns)
  • Opportunities__followers (4 columns)
  • Opportunities__relations (14 columns)
  • Opportunities__relations__tags (4 columns)
Order (93 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
alt_id STRING
alt_type STRING
amount FLOAT64
amount_summary__discount FLOAT64
amount_summary__shipping FLOAT64
amount_summary__subtotal FLOAT64
amount_summary__tax FLOAT64
automatic_taxes_calculated BOOL
contact_id STRING
contact_snapshot__type STRING
contact_snapshot__attribution_source__ad_id STRING
contact_snapshot__attribution_source__campaign STRING
contact_snapshot__attribution_source__fbc STRING
contact_snapshot__attribution_source__fbclid STRING
contact_snapshot__attribution_source__fbp STRING
contact_snapshot__attribution_source__ga_client_id STRING
contact_snapshot__attribution_source__ip STRING
contact_snapshot__attribution_source__medium STRING
contact_snapshot__attribution_source__medium_id STRING
contact_snapshot__attribution_source__referrer STRING
contact_snapshot__attribution_source__session_source STRING
contact_snapshot__attribution_source__url STRING
contact_snapshot__attribution_source__user_agent STRING
contact_snapshot__attribution_source__utm_content STRING
contact_snapshot__attribution_source__utm_medium STRING
contact_snapshot__attribution_source__utm_source STRING
contact_snapshot__attribution_source__utm_term STRING
contact_snapshot__country STRING
contact_snapshot__created_by__channel STRING
contact_snapshot__created_by__source STRING
contact_snapshot__created_by__source_id STRING
contact_snapshot__created_by__timestamp STRING
contact_snapshot__date_added STRING
contact_snapshot__date_updated STRING
contact_snapshot__dnd BOOL
contact_snapshot__email STRING
contact_snapshot__email_lower_case STRING
contact_snapshot__fingerprint STRING
contact_snapshot__first_name STRING
contact_snapshot__first_name_lower_case STRING
contact_snapshot__full_name_lower_case STRING
contact_snapshot__id STRING
contact_snapshot__internal_source__type STRING
contact_snapshot__internal_source__id STRING
contact_snapshot__last_attribution_source__ad_id STRING
contact_snapshot__last_attribution_source__campaign STRING
contact_snapshot__last_attribution_source__fbc STRING
contact_snapshot__last_attribution_source__fbclid STRING
contact_snapshot__last_attribution_source__fbp STRING
contact_snapshot__last_attribution_source__ga_client_id STRING
contact_snapshot__last_attribution_source__ip STRING
contact_snapshot__last_attribution_source__medium STRING
contact_snapshot__last_attribution_source__medium_id STRING
contact_snapshot__last_attribution_source__referrer STRING
contact_snapshot__last_attribution_source__session_source STRING
contact_snapshot__last_attribution_source__url STRING
contact_snapshot__last_attribution_source__user_agent STRING
contact_snapshot__last_attribution_source__utm_content STRING
contact_snapshot__last_attribution_source__utm_medium STRING
contact_snapshot__last_attribution_source__utm_source STRING
contact_snapshot__last_attribution_source__utm_term STRING
contact_snapshot__last_name STRING
contact_snapshot__last_name_lower_case STRING
contact_snapshot__location_id STRING
contact_snapshot__phone STRING
contact_snapshot__source STRING
contact_snapshot__stripe_customer_id STRING
contact_snapshot__timezone STRING
contact_snapshot__unsubscribe_email BOOL
created_at STRING
currency STRING
email STRING
fingerprint STRING
fulfillment_status STRING
live_mode BOOL
mark_as_test BOOL
payment_status STRING
product_name STRING
source__type STRING
source__id STRING
source__meta__domain STRING
source__meta__page_id STRING
source__meta__page_url STRING
source__meta__step_id STRING
source__name STRING
source__sub_type STRING
status STRING
trace_id STRING
tracking_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Order__contact_snapshot__additional_emails (4 columns)
  • Order__contact_snapshot__additional_phones (4 columns)
  • Order__contact_snapshot__custom_fields (5 columns)
  • Order__contact_snapshot__tags (4 columns)
  • Order__items (108 columns)
  • Order__items__price__membership_offers (5 columns)
  • Order__items__price__paypal__metadata__links (7 columns)
  • Order__items__price__variant_option_ids (4 columns)
  • Order__items__product__collection_ids (4 columns)
  • Order__items__product__medias (4 columns)
  • Order__items__product__taxes (4 columns)
  • Order__items__product__variants (4 columns)
  • Order__tax_summary (4 columns)
Orders (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
alt_id STRING
alt_type STRING
amount FLOAT64
contact_email STRING
contact_id STRING
contact_name STRING
coupon_code STRING
created_at STRING
currency STRING
discount FLOAT64
fulfillment_status STRING
live_mode BOOL
onetime_products FLOAT64
payment_status STRING
recurring_products FLOAT64
source_id STRING
source_meta__affiliate_manager__fingerprint STRING
source_meta__affiliate_manager__id STRING
source_meta__domain STRING
source_meta__page_id STRING
source_meta__page_url STRING
source_meta__step_id STRING
source_name STRING
source_sub_type STRING
source_type STRING
status STRING
subtotal FLOAT64
total_products FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Payments (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
alt_id STRING
alt_type STRING
amount FLOAT64
contact_email STRING
contact_id STRING
contact_name STRING
coupon_code STRING
created_at STRING
currency STRING
discount FLOAT64
fulfillment_status STRING
live_mode BOOL
onetime_products FLOAT64
payment_status STRING
recurring_products FLOAT64
source_id STRING
source_meta__affiliate_manager__fingerprint STRING
source_meta__affiliate_manager__id STRING
source_meta__domain STRING
source_meta__page_id STRING
source_meta__page_url STRING
source_meta__step_id STRING
source_name STRING
source_sub_type STRING
source_type STRING
status STRING
subtotal FLOAT64
total_products FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Pipelines (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_added STRING
date_updated STRING
id STRING
name STRING
origin_id STRING
show_in_funnel BOOL
show_in_pie_chart BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Pipelines__stages (9 columns)
Subscriptions (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
alt_id STRING
alt_type STRING
amount FLOAT64
contact_email STRING
contact_id STRING
contact_name STRING
contact_phone STRING
created_at STRING
currency STRING
entity_id STRING
entity_source_id STRING
entity_source_meta__affiliate_manager__fingerprint STRING
entity_source_meta__affiliate_manager__id STRING
entity_source_meta__domain STRING
entity_source_meta__page_id STRING
entity_source_meta__page_url STRING
entity_source_meta__step_id STRING
entity_source_name STRING
entity_source_sub_type STRING
entity_source_type STRING
entity_type STRING
ip_address STRING
live_mode BOOL
payment_provider_connected_account STRING
payment_provider_type STRING
status STRING
subscription_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Transactions (238 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
alt_id STRING
alt_type STRING
amount FLOAT64
amount_refunded FLOAT64
charge_id STRING
charge_snapshot__description STRING
charge_snapshot__metadata__alt_id STRING
charge_snapshot__metadata__alt_type STRING
charge_snapshot__metadata__contact_id STRING
charge_snapshot__metadata__invoice_id STRING
charge_snapshot__metadata__invoice_number STRING
charge_snapshot__metadata__location_id STRING
charge_snapshot__metadata__order_id STRING
charge_snapshot__metadata__payment_recorded_by STRING
charge_snapshot__metadata__payment_schedule_ids STRING
charge_snapshot__metadata__transaction_id STRING
charge_snapshot__metadata__verify_minimum_value_to_pay STRING
charge_snapshot__avs_response STRING
charge_snapshot__amount FLOAT64
charge_snapshot__amount_capturable FLOAT64
charge_snapshot__amount_received FLOAT64
charge_snapshot__application STRING
charge_snapshot__auth_amount FLOAT64
charge_snapshot__auth_code STRING
charge_snapshot__authorization_indicator STRING
charge_snapshot__automatic_payment_methods__allow_redirects STRING
charge_snapshot__automatic_payment_methods__enabled BOOL
charge_snapshot__bill_to__address STRING
charge_snapshot__bill_to__city STRING
charge_snapshot__bill_to__company STRING
charge_snapshot__bill_to__country STRING
charge_snapshot__bill_to__first_name STRING
charge_snapshot__bill_to__last_name STRING
charge_snapshot__bill_to__phone_number STRING
charge_snapshot__bill_to__state STRING
charge_snapshot__bill_to__zip STRING
charge_snapshot__billing_info__failed_payments_count FLOAT64
charge_snapshot__billing_info__final_payment_time STRING
charge_snapshot__billing_info__last_payment__amount__currency_code STRING
charge_snapshot__billing_info__last_payment__amount__value STRING
charge_snapshot__billing_info__last_payment__time STRING
charge_snapshot__billing_info__next_billing_time STRING
charge_snapshot__billing_info__outstanding_balance__currency_code STRING
charge_snapshot__billing_info__outstanding_balance__value STRING
charge_snapshot__capture_method STRING
charge_snapshot__card__type STRING
charge_snapshot__card__last4 STRING
charge_snapshot__card_code_response STRING
charge_snapshot__charges__has_more BOOL
charge_snapshot__charges__object STRING
charge_snapshot__charges__total_count FLOAT64
charge_snapshot__charges__url STRING
charge_snapshot__client_sdk_response__facilitator_access_token STRING
charge_snapshot__client_sdk_response__order_id STRING
charge_snapshot__client_sdk_response__payer_id STRING
charge_snapshot__client_sdk_response__subscription_id STRING
charge_snapshot__client_secret STRING
charge_snapshot__confirmation_method STRING
charge_snapshot__create_time STRING
charge_snapshot__created FLOAT64
charge_snapshot__currency STRING
charge_snapshot__customer JSON
charge_snapshot__customer_ip STRING
charge_snapshot__id STRING
charge_snapshot__invoice STRING
charge_snapshot__last_payment_error__type STRING
charge_snapshot__last_payment_error__charge STRING
charge_snapshot__last_payment_error__code STRING
charge_snapshot__last_payment_error__decline_code STRING
charge_snapshot__last_payment_error__doc_url STRING
charge_snapshot__last_payment_error__message STRING
charge_snapshot__last_payment_error__param STRING
charge_snapshot__last_payment_error__payment_method__type STRING
charge_snapshot__last_payment_error__payment_method__allow_redisplay STRING
charge_snapshot__last_payment_error__payment_method__billing_details__address__city STRING
charge_snapshot__last_payment_error__payment_method__billing_details__address__country STRING
charge_snapshot__last_payment_error__payment_method__billing_details__address__line1 STRING
charge_snapshot__last_payment_error__payment_method__billing_details__address__line2 STRING
charge_snapshot__last_payment_error__payment_method__billing_details__address__postal_code STRING
charge_snapshot__last_payment_error__payment_method__billing_details__address__state STRING
charge_snapshot__last_payment_error__payment_method__billing_details__name STRING
charge_snapshot__last_payment_error__payment_method__card__brand STRING
charge_snapshot__last_payment_error__payment_method__card__checks__address_line1_check STRING
charge_snapshot__last_payment_error__payment_method__card__checks__address_postal_code_check STRING
charge_snapshot__last_payment_error__payment_method__card__checks__cvc_check STRING
charge_snapshot__last_payment_error__payment_method__card__country STRING
charge_snapshot__last_payment_error__payment_method__card__display_brand STRING
charge_snapshot__last_payment_error__payment_method__card__exp_month FLOAT64
charge_snapshot__last_payment_error__payment_method__card__exp_year FLOAT64
charge_snapshot__last_payment_error__payment_method__card__fingerprint STRING
charge_snapshot__last_payment_error__payment_method__card__funding STRING
charge_snapshot__last_payment_error__payment_method__card__last4 STRING
charge_snapshot__last_payment_error__payment_method__card__three_d_secure_usage__supported BOOL
charge_snapshot__last_payment_error__payment_method__card__wallet__type STRING
charge_snapshot__last_payment_error__payment_method__card__wallet__apple_pay__type STRING
charge_snapshot__last_payment_error__payment_method__card__wallet__dynamic_last4 STRING
charge_snapshot__last_payment_error__payment_method__created FLOAT64
charge_snapshot__last_payment_error__payment_method__customer STRING
charge_snapshot__last_payment_error__payment_method__id STRING
charge_snapshot__last_payment_error__payment_method__livemode BOOL
charge_snapshot__last_payment_error__payment_method__object STRING
charge_snapshot__latest_charge STRING
charge_snapshot__livemode BOOL
charge_snapshot__market_type STRING
charge_snapshot__mode STRING
charge_snapshot__notes STRING
charge_snapshot__object STRING
charge_snapshot__order__description STRING
charge_snapshot__order__discount_amount FLOAT64
charge_snapshot__order__invoice_number STRING
charge_snapshot__order__tax_is_after_discount BOOL
charge_snapshot__payer__address__country_code STRING
charge_snapshot__payer__email_address STRING
charge_snapshot__payer__name__given_name STRING
charge_snapshot__payer__name__prefix STRING
charge_snapshot__payer__name__surname STRING
charge_snapshot__payer__payer_id STRING
charge_snapshot__payer__phone__phone_number__national_number STRING
charge_snapshot__payment__credit_card__card_number STRING
charge_snapshot__payment__credit_card__card_type STRING
charge_snapshot__payment__credit_card__expiration_date STRING
charge_snapshot__payment_method__type STRING
charge_snapshot__payment_method__allow_redisplay STRING
charge_snapshot__payment_method__billing_details__address__city STRING
charge_snapshot__payment_method__billing_details__address__country STRING
charge_snapshot__payment_method__billing_details__address__line1 STRING
charge_snapshot__payment_method__billing_details__address__line2 STRING
charge_snapshot__payment_method__billing_details__address__postal_code STRING
charge_snapshot__payment_method__billing_details__address__state STRING
charge_snapshot__payment_method__billing_details__email STRING
charge_snapshot__payment_method__billing_details__name STRING
charge_snapshot__payment_method__card__brand STRING
charge_snapshot__payment_method__card__checks__address_line1_check STRING
charge_snapshot__payment_method__card__checks__address_postal_code_check STRING
charge_snapshot__payment_method__card__checks__cvc_check STRING
charge_snapshot__payment_method__card__country STRING
charge_snapshot__payment_method__card__display_brand STRING
charge_snapshot__payment_method__card__exp_month FLOAT64
charge_snapshot__payment_method__card__exp_year FLOAT64
charge_snapshot__payment_method__card__fingerprint STRING
charge_snapshot__payment_method__card__funding STRING
charge_snapshot__payment_method__card__last4 STRING
charge_snapshot__payment_method__card__three_d_secure_usage__supported BOOL
charge_snapshot__payment_method__card__wallet__type STRING
charge_snapshot__payment_method__card__wallet__apple_pay__type STRING
charge_snapshot__payment_method__card__wallet__dynamic_last4 STRING
charge_snapshot__payment_method__created FLOAT64
charge_snapshot__payment_method__customer STRING
charge_snapshot__payment_method__id STRING
charge_snapshot__payment_method__livemode BOOL
charge_snapshot__payment_method__object STRING
charge_snapshot__payment_method_configuration_details__id STRING
charge_snapshot__payment_method_configuration_details__parent STRING
charge_snapshot__payment_method_options__card__request_three_d_secure STRING
charge_snapshot__payment_method_options__us_bank_account__verification_method STRING
charge_snapshot__payment_source__paypal__account_id STRING
charge_snapshot__payment_source__paypal__account_status STRING
charge_snapshot__payment_source__paypal__address__country_code STRING
charge_snapshot__payment_source__paypal__business_name STRING
charge_snapshot__payment_source__paypal__email_address STRING
charge_snapshot__payment_source__paypal__name__given_name STRING
charge_snapshot__payment_source__paypal__name__prefix STRING
charge_snapshot__payment_source__paypal__name__surname STRING
charge_snapshot__payment_source__paypal__phone_number__national_number STRING
charge_snapshot__plan_id STRING
charge_snapshot__plan_overridden BOOL
charge_snapshot__product STRING
charge_snapshot__profile__customer_payment_profile_id STRING
charge_snapshot__profile__customer_profile_id STRING
charge_snapshot__quantity STRING
charge_snapshot__recurring_billing BOOL
charge_snapshot__response_code FLOAT64
charge_snapshot__response_reason_code FLOAT64
charge_snapshot__response_reason_description STRING
charge_snapshot__settle_amount FLOAT64
charge_snapshot__setup_future_usage STRING
charge_snapshot__shipping__address__city STRING
charge_snapshot__shipping__address__country STRING
charge_snapshot__shipping__address__line1 STRING
charge_snapshot__shipping__address__postal_code STRING
charge_snapshot__shipping__address__state STRING
charge_snapshot__shipping__name STRING
charge_snapshot__shipping_amount__currency_code STRING
charge_snapshot__shipping_amount__value STRING
charge_snapshot__start_time STRING
charge_snapshot__status STRING
charge_snapshot__status_update_time STRING
charge_snapshot__submit_time_local STRING
charge_snapshot__submit_time_utc STRING
charge_snapshot__subscriber__email_address STRING
charge_snapshot__subscriber__name__given_name STRING
charge_snapshot__subscriber__name__surname STRING
charge_snapshot__subscriber__payer_id STRING
charge_snapshot__subscriber__shipping_address__address__address_line_1 STRING
charge_snapshot__subscriber__shipping_address__address__admin_area_1 STRING
charge_snapshot__subscriber__shipping_address__address__admin_area_2 STRING
charge_snapshot__subscriber__shipping_address__address__country_code STRING
charge_snapshot__subscriber__shipping_address__address__postal_code STRING
charge_snapshot__subscriber__shipping_address__name__full_name STRING
charge_snapshot__tax_exempt BOOL
charge_snapshot__trans_id STRING
charge_snapshot__transaction_status STRING
charge_snapshot__transaction_type STRING
charge_snapshot__update_time STRING
contact_email STRING
contact_id STRING
contact_name STRING
created_at STRING
currency STRING
entity_id STRING
entity_source_id STRING
entity_source_meta__description STRING
entity_source_meta__affiliate_manager__fingerprint STRING
entity_source_meta__affiliate_manager__id STRING
entity_source_meta__domain STRING
entity_source_meta__invoice_number STRING
entity_source_meta__page_id STRING
entity_source_meta__page_url STRING
entity_source_meta__payment_recorded_by STRING
entity_source_meta__payment_schedule_ids STRING
entity_source_meta__step_id STRING
entity_source_meta__verify_minimum_value_to_pay BOOL
entity_source_name STRING
entity_source_sub_type STRING
entity_source_type STRING
entity_type STRING
ip_address STRING
live_mode BOOL
payment_method__card__brand STRING
payment_method__card__last4 STRING
payment_provider_connected_account STRING
payment_provider_type STRING
status STRING
subscription_id STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • Transactions__charge_snapshot__billing_info__cycle_executions (9 columns)
  • Transactions__charge_snapshot__charges__data (90 columns)
  • Transactions__charge_snapshot__charges__data__refunds__data (4 columns)
  • Transactions__charge_snapshot__last_payment_error__payment_method__card__networks__available (4 columns)
  • Transactions__charge_snapshot__line_items__line_item (21 columns)
  • Transactions__charge_snapshot__links (6 columns)
  • Transactions__charge_snapshot__payment_method__card__networks__available (4 columns)
  • Transactions__charge_snapshot__payment_method_options__us_bank_account__financial_connections__permissions (4 columns)
  • Transactions__charge_snapshot__payment_method_options__us_bank_account__financial_connections__prefetch (4 columns)
  • Transactions__charge_snapshot__payment_method_types (4 columns)
  • Transactions__charge_snapshot__purchase_units (11 columns)
  • Transactions__charge_snapshot__purchase_units__payments__captures (17 columns)
  • Transactions__charge_snapshot__purchase_units__payments__captures__links (6 columns)
  • Transactions__charge_snapshot__purchase_units__payments__captures__seller_protection__dispute_categories (4 columns)

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

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

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

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

Use Opportunities and Pipelines to track pipeline value and conversion over time.

Join Invoices, Payments, and Subscriptions to track revenue and recurring billing.

Use Form Submissions and Contacts to see which sources bring leads.

Use HighLevel data in your AI and BI tools

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

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