Skip to content
Book a demoStart free
Connectors

Iterable connector

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

Iterable connector pricing, tier and credits on kaivo.io

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

Sync your Iterable campaigns, messages, and user events into BigQuery with Kaivo to analyse cross-channel marketing alongside the rest of your data.

CategoryMarketing & Sales, Surveys & Email
AuthenticationAPI key
SetupSelf-service

Getting started with the Iterable connector

Section titled “Getting started with the Iterable connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Iterable account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
Your Iterable API Key.

|

When you set up the connector, you provide:

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

|

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

campaigns (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier of the campaign
created_at INT64 The timestamp when the campaign was created
updated_at INT64 The timestamp when the campaign was last updated
start_at INT64 The timestamp when the campaign will start
ended_at INT64 The timestamp when the campaign ended
name STRING The name of the campaign
template_id INT64 The ID of the template used for the campaign
message_medium STRING The medium used to deliver the campaign message (e.g., email, SMS)
created_by_user_id STRING The ID of the user who created the campaign
updated_by_user_id STRING The ID of the user who last updated the campaign
campaign_state STRING The current state of the campaign (e.g., draft, active, paused)
send_size FLOAT64 The size of the audience targeted by the campaign
recurring_campaign_id FLOAT64 If the campaign is recurring, the ID of the parent recurring campaign
workflow_id FLOAT64 The ID of the workflow associated with the campaign
type STRING The type of campaign (e.g., one-time, recurring)
_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 INT64
_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 INT64
_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.
channels (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64 The unique identifier of the channel.
name STRING The name or title of the channel.
channel_type STRING The type of channel, such as email, SMS, or push notification.
message_medium STRING The medium used to deliver messages through this channel, such as text, image, or video.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
itbl_internal__document_created_at TIMESTAMP Timestamp when the related document was created
itbl_internal__document_updated_at TIMESTAMP Timestamp when the related document was last updated
_type STRING Type of the event data
created_at TIMESTAMP Timestamp when the event was created
email STRING Email address related to the event
user_id STRING User ID associated with the event
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_users (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING The email address of the user.
list_id INT64 The unique identifier of the list to which the user belongs.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lists (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier of the list.
name STRING The name or title of the list.
created_at INT64 The date and time when the list was created.
list_type STRING The type or category of the list.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
message_types (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64 The unique identifier for the message type.
name STRING The display name for the message type.
channel_id FLOAT64 The unique identifier for the channel the message belongs to.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
metadata (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING The name of the metadata
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (71 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
country STRING Country name.
first_order_date TIMESTAMP Date and time of the first order.
email_acquired_date TIMESTAMP Date and time when the email was acquired.
email_segment_status STRING Status of the email segment.
admin_graphql_api_id STRING Admin GraphQL API ID.
id STRING User ID.
most_recent_email_list STRING Most recent email list the user is part of.
most_recent_email_segment STRING Most recent email segment the user is part of.
aov FLOAT64 Average order value.
first_campaign STRING First campaign the user interacted with.
third_most_recent_order_date TIMESTAMP Date and time of the third most recent order.
first_purchase_date TIMESTAMP Date and time of the first purchase made by the user.
first_medium STRING First medium through which the user interacted.
default_address__first_name STRING First name of the user associated with the address.
default_address__city STRING City name.
default_address__name STRING Full name associated with the address.
default_address__zip STRING Postal code or ZIP code.
default_address__country STRING Country name of the address.
default_address__address2 STRING Address line 2.
default_address__company STRING Company name associated with the address.
default_address__country_code STRING Country code of the address.
default_address__id STRING Unique identifier for the address.
default_address__last_name STRING Last name of the user associated with the address.
default_address__address1 STRING Address line 1.
default_address__default BOOL Indicates if this is the default address.
default_address__province STRING Province or state of the address.
default_address__province_code STRING Province or state code of the address.
default_address__country_name STRING Full name of the country.
default_address__phone STRING Contact phone number.
accepts_marketing BOOL Indicates whether the user has consented to receive marketing communications.
second_most_recent_order_date TIMESTAMP Date and time of the second most recent order.
state STRING State name.
most_recent_campaign STRING Most recent campaign the user interacted with.
zip STRING Postal code or ZIP code.
total_spent FLOAT64 Total amount spent by the user.
most_recent_order_date TIMESTAMP Date and time of the most recent order.
last_order_id STRING ID of the user’s last order.
tax_exempt BOOL Indicates if the user is tax exempt.
most_recent_source STRING Most recent source of user interaction.
twelve_month_ltr INT64 Lifetime total revenue for the past twelve months.
verified_email BOOL Indicates if the user’s email address is verified.
most_recent_medium STRING Most recent medium of user interaction.
orders_count INT64 Total number of orders made by the user.
first_name STRING User’s first name.
last_interaction_ts TIMESTAMP Date and time of the last interaction with the user.
bought_sas BOOL Indicates if the user has purchased a specific product or service.
last_name STRING User’s last name.
last_order_name STRING Name of the user’s last order.
second_order_date TIMESTAMP Date and time of the second order.
has_account BOOL Indicates if the user has an account.
city STRING City name.
itbl_internal__email_domain STRING Domain of the user’s email address.
itbl_internal__document_updated_at TIMESTAMP Date and time when the document was last updated.
itbl_internal__document_created_at TIMESTAMP Date and time when the document was created.
has_reminder BOOL Indicates if the user has set a reminder.
third_order_date TIMESTAMP Date and time of the third order.
first_source STRING First source of user interaction.
first_name STRING User’s first name.
email STRING User’s email address.
profile_updated_at TIMESTAMP Date and time when the profile was last updated.
signup_date TIMESTAMP Date and time when the user signed up.
address1 STRING Primary address line of the user.
last_name STRING User’s last name.
ltr INT64 Lifetime total revenue.
user_id STRING User’s unique identifier.
shopify_created_at TIMESTAMP Date and time when the user was created in Shopify.
signup_source STRING Source through which the user signed up.
total_orders INT64 Total number of orders made by the user.
shopify_updated_at TIMESTAMP Date and time when the user was last updated in Shopify.
_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.
first_name STRING First name of the user associated with the address.
city STRING City name.
name STRING Full name associated with the address.
zip STRING Postal code or ZIP code.
country STRING Country name of the address.
address1 STRING Address line 1.
address2 STRING Address line 2.
company STRING Company name associated with the address.
country_code STRING Country code of the address.
default BOOL Indicates if this is the default address.
id STRING Unique identifier for the address.
last_name STRING Last name of the user associated with the address.
province STRING Province or state of the address.
province_code STRING Province or state code of the address.
country_name STRING Full name of the country.
phone STRING Contact phone number.
_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 IDs of the email lists associated with the user.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: users__second_most_recent_order_cards

Section titled “Subtable: users__second_most_recent_order_cards”
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 Details of the second most recent order cards.
_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 IDs of the channels from which the user unsubscribed.
_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 Details of the most recent order cards.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: users__subscribed_message_type_ids

Section titled “Subtable: users__subscribed_message_type_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON IDs of the message types the user is subscribed to.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: users__unsubscribed_message_type_ids

Section titled “Subtable: users__unsubscribed_message_type_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON IDs of the message types from which the user unsubscribed.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: users__third_most_recent_order_cards

Section titled “Subtable: users__third_most_recent_order_cards”
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 Details of the third most recent order cards.
_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 Business lines associated with the user.
_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 Details of the second order cards.
_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 Details of the third order cards.
_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 Details of the first order cards.
_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 Iterable 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 Iterable?

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

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

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

Track sends, opens, clicks, and conversions by campaign and channel.

Analyse user events to see how engagement changes over time.

Report on subscribes and unsubscribes to monitor list growth and churn.

Join Iterable engagement with revenue in BigQuery to connect campaigns to sales.

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