Skip to content
Book a demoStart free
Connectors

Eventzilla connector

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

Eventzilla connector pricing, tier and credits on kaivo.io

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

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

CategoryOther
AuthenticationAPI key
SetupSelf-service

Getting started with the Eventzilla connector

Section titled “Getting started with the Eventzilla connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Eventzilla 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
API key to use. Generate it by creating a new application within your Eventzilla account settings under Settings > App Management.

|

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

attendees (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bar_code STRING
buyer_first_name STRING
buyer_last_name STRING
email STRING
event_date STRING
event_id FLOAT64
first_name STRING
id FLOAT64
is_attended STRING
last_name STRING
payment_type STRING
refno STRING
ticket_type STRING
transaction_amount FLOAT64
transaction_date STRING
transaction_status 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.
categories (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
category STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
bgimage_url STRING
categories STRING
currency STRING
dateid FLOAT64
description_html STRING
end_date STRING
end_time STRING
id FLOAT64
invite_code STRING
language STRING
logo_url STRING
show_remaining BOOL
start_date STRING
start_time STRING
status STRING
tickets_sold FLOAT64
tickets_total FLOAT64
time_zone STRING
timezone_code STRING
title STRING
twitter_hashtag STRING
url STRING
utc_offset STRING
venue STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tickets (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
additional_instructions STRING
allow_partial_payment BOOL
boxoffice_only BOOL
group_discount FLOAT64
group_percentage FLOAT64
group_price FLOAT64
id FLOAT64
is_visible BOOL
limit_maximum FLOAT64
limit_minimum FLOAT64
partial_payment_amount FLOAT64
partial_payment_frequency STRING
partial_payment_installments FLOAT64
price FLOAT64
quantity_total FLOAT64
sales_end_date STRING
sales_end_time STRING
sales_start_date STRING
sales_start_time STRING
ticket_type STRING
title STRING
unlock_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transactions (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
buyer_first_name STRING
buyer_last_name STRING
checkout_id FLOAT64
comments STRING
email STRING
event_date STRING
event_id FLOAT64
eventzilla_fee FLOAT64
payment_type STRING
promo_code STRING
refno STRING
tickets_in_transaction FLOAT64
title STRING
transaction_amount FLOAT64
transaction_date STRING
transaction_discount FLOAT64
transaction_status STRING
transaction_tax FLOAT64
user_id FLOAT64
_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.
address_country STRING
address_line1 STRING
address_line2 STRING
address_locality STRING
address_region STRING
avatar_url STRING
company STRING
email STRING
facebook_id STRING
first_name STRING
id FLOAT64
last_name STRING
last_seen STRING
phone_primary STRING
timezone STRING
twitter_id STRING
user_type STRING
username STRING
website STRING
zip_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

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

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

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

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

Join events with attendees to measure turnout.

Use categories to compare performance across event types.

Use Eventzilla data in your AI and BI tools

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

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