Skip to content
Book a demoStart free
Connectors

ActiveCampaign connector

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

ActiveCampaign connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your ActiveCampaign 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 ActiveCampaign contacts, campaigns, and deals into BigQuery with Kaivo to measure email performance and pipeline alongside your marketing data.

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

Getting started with the ActiveCampaign connector

Section titled “Getting started with the ActiveCampaign connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your ActiveCampaign 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 ActiveCampaign API key. Find it under Settings → Developer → API Access.

|

When you set up the connector, you provide:

Field Description
Account Username
Your ActiveCampaign account name (the subdomain of your account URL, e.g. mycompany from mycompany.activehosted.com).

|

Tables and columns synced from ActiveCampaign

Section titled “Tables and columns synced from ActiveCampaign”

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

campaigns (94 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
activerss_interval STRING
activerss_items STRING
activerss_url STRING
addressid STRING
analytics_campaign_name STRING
automation STRING
basemessageid STRING
basetemplateid STRING
bounceid STRING
cdate STRING
deletestamp STRING
embed_images STRING
facebook STRING
formid STRING
forwards STRING
hardbounces STRING
htmlunsub STRING
htmlunsubdata STRING
id STRING
ip4 STRING
laststep STRING
ldate STRING
linkclicks STRING
links__automation STRING
links__campaign_lists STRING
links__campaign_message STRING
links__campaign_messages STRING
links__links STRING
links__user STRING
mail_cleanup STRING
mail_send STRING
mail_transfer STRING
mailer_log_file STRING
managetext STRING
mdate STRING
name STRING
opens STRING
public STRING
realcid STRING
recurring STRING
reminder_field STRING
reminder_format STRING
reminder_last_cron_run STRING
reminder_offset STRING
reminder_offset_sign STRING
reminder_offset_type STRING
reminder_type STRING
replies STRING
replysys STRING
responder_existing STRING
responder_offset STRING
responder_type STRING
schedule STRING
scheduleddate STRING
sdate STRING
segmentid STRING
send_amt STRING
sendid STRING
seriesid STRING
socialshares STRING
softbounces STRING
source STRING
split_content STRING
split_offset STRING
split_offset_type STRING
split_type STRING
split_winner_awaiting STRING
split_winner_messageid STRING
status STRING
subscriberclicks STRING
survey STRING
textunsub STRING
textunsubdata STRING
threadid STRING
total_amt STRING
tracklinks STRING
tracklinksanalytics STRING
trackreads STRING
trackreadsanalytics STRING
tweet STRING
uniqueforwards STRING
uniquelinkclicks STRING
uniqueopens STRING
uniquereplies STRING
unsubreasons STRING
unsubscribes STRING
updates STRING
user STRING
userid STRING
waitpreview STRING
willrecur STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (56 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
adate STRING
anonymized STRING
bounced_date STRING
bounced_hard STRING
bounced_soft STRING
cdate STRING
created_by STRING
created_timestamp STRING
created_utc_timestamp STRING
deleted STRING
deleted_at STRING
edate STRING
email STRING
email_domain STRING
email_empty BOOL
email_local STRING
first_name STRING
gravatar STRING
hash STRING
id STRING
ip STRING
last_name STRING
links__account_contacts STRING
links__automation_entry_counts STRING
links__bounce_logs STRING
links__contact_automations STRING
links__contact_data STRING
links__contact_deals STRING
links__contact_goals STRING
links__contact_lists STRING
links__contact_logs STRING
links__contact_tags STRING
links__deals STRING
links__field_values STRING
links__geo_ips STRING
links__notes STRING
links__organization STRING
links__plus_append STRING
links__score_values STRING
links__tracking_logs STRING
mpp_tracking STRING
organization JSON
orgid STRING
orgname STRING
phone STRING
rating_tstamp STRING
segmentio_id STRING
sentcnt STRING
socialdata_lastcheck STRING
ua STRING
udate STRING
updated_by STRING
updated_timestamp STRING
updated_utc_timestamp STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
deals (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account STRING
activitycount STRING
cdate STRING
contact STRING
currency STRING
customer_account STRING
description STRING
edate STRING
group STRING
hash STRING
id STRING
is_disabled BOOL
links__account STRING
links__contact STRING
links__contact_deals STRING
links__customer_account STRING
links__deal_activities STRING
links__deal_custom_field_data STRING
links__group STRING
links__next_task STRING
links__notes STRING
links__organization STRING
links__owner STRING
links__score_values STRING
links__stage STRING
links__tasks STRING
mdate STRING
next_task STRING
nextdate STRING
nextdealid STRING
nexttaskid STRING
organization STRING
owner STRING
percent STRING
stage STRING
status STRING
title STRING
value STRING
win_probability INT64
win_probability_mdate STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
forms (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action STRING
address STRING
addressid STRING
aid STRING
body STRING
button STRING
cdate STRING
contacts INT64
deals INT64
defaultscreenshot STRING
entries STRING
id STRING
layout STRING
links__address STRING
name STRING
options__blanks_overwrite BOOL
options__confaction STRING
options__confform STRING
options__optin_created BOOL
options__optin_id INT64
options__sendoptin BOOL
parentformid STRING
style__ac_branding BOOL
style__background STRING
style__border__color STRING
style__border__radius INT64
style__border__style STRING
style__border__width INT64
style__button__background STRING
style__button__border__color STRING
style__button__border__radius INT64
style__button__border__style STRING
style__button__border__width INT64
style__button__fontcolor STRING
style__button__padding INT64
style__dark BOOL
style__fontcolor STRING
style__layout STRING
style__width INT64
submit STRING
submitdata__url STRING
thanks STRING
title STRING
udate STRING
url STRING
userid 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.
type STRING
email STRING
list 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.
type STRING
class STRING
header 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.
lists (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
analytics_domains STRING
analytics_source STRING
analytics_ua STRING
carboncopy STRING
cdate STRING
deletestamp STRING
facebook_session STRING
fulladdress STRING
get_unsubscribe_reason STRING
id STRING
links__address_lists STRING
links__contact_goal_lists STRING
links__user STRING
name STRING
optinmessageid STRING
optinoptout STRING
optoutconf STRING
p_embed_image STRING
p_use_analytics_link STRING
p_use_analytics_read STRING
p_use_captcha STRING
p_use_facebook STRING
p_use_tracking STRING
p_use_twitter STRING
private STRING
require_name STRING
send_last_broadcast STRING
sender_addr1 STRING
sender_addr2 STRING
sender_city STRING
sender_country STRING
sender_name STRING
sender_phone STRING
sender_reminder STRING
sender_state STRING
sender_url STRING
sender_zip STRING
stringid STRING
subscription_notify STRING
to_name STRING
twitter_token STRING
twitter_token_secret STRING
udate STRING
unsubscription_notify STRING
user STRING
userid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
segments (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
hidden STRING
id STRING
logic STRING
name STRING
seriesid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

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

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

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

Track campaigns against contacts and lists to see open and engagement trends over time.

Use lists and segments to monitor how your audience grows and which segments convert.

Bring deals into BigQuery to report on pipeline value and win rates next to your campaign activity.

Join contacts with deals to connect email engagement to revenue.

Use ActiveCampaign data in your AI and BI tools

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

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