Skip to content
Book a demoStart free
Connectors

Humanitix connector

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

Humanitix connector pricing, tier and credits on kaivo.io

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

Sync your Humanitix event data into BigQuery with Kaivo to analyse ticket sales, attendees, and event revenue.

CategoryOther
AuthenticationAPI key
SetupSelf-service

Getting started with the Humanitix connector

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

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

events (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_id STRING
banner_image__url STRING
classification__type STRING
classification__category STRING
created_at STRING
currency STRING
end_date STRING
event_location__type STRING
event_location__address STRING
event_location__map_url STRING
event_location__place_id STRING
event_location__venue_name STRING
location STRING
marked_as_sold_out BOOL
name STRING
organiser_id STRING
payment_options__refund_settings__refund_policy STRING
pricing__maximum_price FLOAT64
pricing__minimum_price FLOAT64
public BOOL
published BOOL
slug STRING
start_date STRING
suspend_sales BOOL
timezone STRING
total_capacity FLOAT64
updated_at STRING
user_id 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.
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
deleted BOOL
disabled BOOL
end_date STRING
start_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__event_location__address_components

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

Subtable: events__event_location__address_components__types

Section titled “Subtable: events__event_location__address_components__types”
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 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.
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.
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
deleted BOOL
disabled BOOL
is_donation BOOL
name STRING
price FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
orders (75 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
business_purpose BOOL
client_donation FLOAT64
completed_at STRING
created_at STRING
currency STRING
email STRING
event_date_id STRING
event_id STRING
financial_status STRING
first_name STRING
incomplete_at STRING
last_name STRING
location STRING
manual_order BOOL
mobile STRING
notes STRING
order_name STRING
organiser_mail_list_opt_in BOOL
payment_gateway STRING
payment_type STRING
purchase_totals__absorbed_fee FLOAT64
purchase_totals__amex_fee FLOAT64
purchase_totals__booking_fee FLOAT64
purchase_totals__booking_taxes FLOAT64
purchase_totals__client_donation FLOAT64
purchase_totals__credit FLOAT64
purchase_totals__dgr_donation FLOAT64
purchase_totals__discounts FLOAT64
purchase_totals__donation FLOAT64
purchase_totals__fees_included BOOL
purchase_totals__gift_card_credit FLOAT64
purchase_totals__gross_sales FLOAT64
purchase_totals__humanitix_fee FLOAT64
purchase_totals__net_client_donation FLOAT64
purchase_totals__net_sales FLOAT64
purchase_totals__passed_on_fee FLOAT64
purchase_totals__passed_on_taxes FLOAT64
purchase_totals__rebates FLOAT64
purchase_totals__refunds FLOAT64
purchase_totals__subtotal FLOAT64
purchase_totals__taxes FLOAT64
purchase_totals__total FLOAT64
purchase_totals__total_taxes FLOAT64
purchase_totals__zip_fee FLOAT64
sales_channel STRING
status STRING
tip_fees BOOL
totals__absorbed_fee FLOAT64
totals__amex_fee FLOAT64
totals__booking_fee FLOAT64
totals__booking_taxes FLOAT64
totals__client_donation FLOAT64
totals__credit FLOAT64
totals__dgr_donation FLOAT64
totals__discounts FLOAT64
totals__donation FLOAT64
totals__fees_included BOOL
totals__gift_card_credit FLOAT64
totals__gross_sales FLOAT64
totals__humanitix_fee FLOAT64
totals__net_client_donation FLOAT64
totals__net_sales FLOAT64
totals__passed_on_fee FLOAT64
totals__passed_on_taxes FLOAT64
totals__rebates FLOAT64
totals__refunds FLOAT64
totals__subtotal FLOAT64
totals__taxes FLOAT64
totals__total FLOAT64
totals__total_taxes FLOAT64
totals__zip_fee 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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
created_at STRING
location STRING
name STRING
updated_at STRING
user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tickets (294 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_id STRING
absorbed_fee FLOAT64
created_at STRING
currency STRING
dgr_donation FLOAT64
discount FLOAT64
event_date_id STRING
event_id STRING
fee FLOAT64
first_name STRING
is_donation BOOL
last_name STRING
location STRING
net_price FLOAT64
number FLOAT64
order_id STRING
order_name STRING
passed_on_fee FLOAT64
price FLOAT64
qr_code_data___id STRING
qr_code_data__event_id STRING
sales_channel STRING
status STRING
taxes FLOAT64
ticket_type_id STRING
ticket_type_name STRING
total FLOAT64
totals_v2__credit__gift_card FLOAT64
totals_v2__credit__store FLOAT64
totals_v2__credit__voucher FLOAT64
totals_v2__custom_sales_tax__absorb FLOAT64
totals_v2__custom_sales_tax__pass_on FLOAT64
totals_v2__custom_sales_tax__total FLOAT64
totals_v2__dgr_donation FLOAT64
totals_v2__discount FLOAT64
totals_v2__earnings FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__fixed_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__percent_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__afterpay_fee__total_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__fixed_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__percent_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__amex_fee__total_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__fixed_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__percent_fee__total__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__absorb__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__pass_on__tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__total__after_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__total__before_tax FLOAT64
totals_v2__fees__additional_fee__zip_fee__total_fee__total__tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__humanitix_fee__fixed_fee__total__tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__absorb__tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__total__after_tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__total__before_tax FLOAT64
totals_v2__fees__humanitix_fee__percent_fee__total__tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__absorb__tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__pass_on__tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__total__after_tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__total__before_tax FLOAT64
totals_v2__fees__humanitix_fee__total_fee__total__tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__payment_fee__fixed_fee__total__tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__absorb__tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__total__after_tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__total__before_tax FLOAT64
totals_v2__fees__payment_fee__percent_fee__total__tax FLOAT64
totals_v2__fees__payment_fee__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__payment_fee__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__payment_fee__total_fee__absorb__tax FLOAT64
totals_v2__fees__payment_fee__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__payment_fee__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__payment_fee__total_fee__pass_on__tax FLOAT64
totals_v2__fees__payment_fee__total_fee__total__after_tax FLOAT64
totals_v2__fees__payment_fee__total_fee__total__before_tax FLOAT64
totals_v2__fees__payment_fee__total_fee__total__tax FLOAT64
totals_v2__fees__rebate__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__rebate__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__rebate__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__rebate__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__rebate__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__rebate__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__rebate__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__rebate__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__rebate__fixed_fee__total__tax FLOAT64
totals_v2__fees__rebate__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__rebate__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__rebate__percent_fee__absorb__tax FLOAT64
totals_v2__fees__rebate__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__rebate__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__rebate__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__rebate__percent_fee__total__after_tax FLOAT64
totals_v2__fees__rebate__percent_fee__total__before_tax FLOAT64
totals_v2__fees__rebate__percent_fee__total__tax FLOAT64
totals_v2__fees__rebate__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__rebate__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__rebate__total_fee__absorb__tax FLOAT64
totals_v2__fees__rebate__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__rebate__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__rebate__total_fee__pass_on__tax FLOAT64
totals_v2__fees__rebate__total_fee__total__after_tax FLOAT64
totals_v2__fees__rebate__total_fee__total__before_tax FLOAT64
totals_v2__fees__rebate__total_fee__total__tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__fixed_fee__total__tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__absorb__tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__total__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__total__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__percent_fee__total__tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__absorb__tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__pass_on__tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__total__after_tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__total__before_tax FLOAT64
totals_v2__fees__total_fee_revenue__total_fee__total__tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__total_fees__fixed_fee__total__tax FLOAT64
totals_v2__fees__total_fees__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__total_fees__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__total_fees__percent_fee__absorb__tax FLOAT64
totals_v2__fees__total_fees__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__total_fees__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__total_fees__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__total_fees__percent_fee__total__after_tax FLOAT64
totals_v2__fees__total_fees__percent_fee__total__before_tax FLOAT64
totals_v2__fees__total_fees__percent_fee__total__tax FLOAT64
totals_v2__fees__total_fees__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__total_fees__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__total_fees__total_fee__absorb__tax FLOAT64
totals_v2__fees__total_fees__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__total_fees__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__total_fees__total_fee__pass_on__tax FLOAT64
totals_v2__fees__total_fees__total_fee__total__after_tax FLOAT64
totals_v2__fees__total_fees__total_fee__total__before_tax FLOAT64
totals_v2__fees__total_fees__total_fee__total__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__absorb__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__absorb__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__absorb__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__pass_on__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__pass_on__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__pass_on__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__total__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__total__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__fixed_fee__total__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__absorb__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__absorb__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__absorb__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__pass_on__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__pass_on__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__pass_on__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__total__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__total__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__percent_fee__total__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__absorb__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__absorb__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__absorb__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__pass_on__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__pass_on__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__pass_on__tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__total__after_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__total__before_tax FLOAT64
totals_v2__fees__uncapped_humanitix_fee__total_fee__total__tax FLOAT64
totals_v2__gross_sales FLOAT64
totals_v2__item_taxes FLOAT64
totals_v2__net_sales FLOAT64
totals_v2__payout FLOAT64
totals_v2__referral FLOAT64
totals_v2__refunds FLOAT64
totals_v2__sub_total__after_tax FLOAT64
totals_v2__sub_total__before_tax FLOAT64
totals_v2__sub_total__tax FLOAT64
totals_v2__total FLOAT64
totals_v2__total_organiser_taxes FLOAT64
totals_v2__total_taxes 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 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.

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

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

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

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

Use orders and tickets to track sales and revenue by event over time.

Join events with tickets to measure turnout.

Use tags to compare performance across event types.

Use Humanitix data in your AI and BI tools

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

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