ActiveCampaign (v1) | Stitch Documentation

ActiveCampaign extraction is supported by Stitch
This integration is powered by Singer's ActiveCampaign tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Stitch support.

ActiveCampaign integration summary

Stitch’s ActiveCampaign integration replicates data using the ActiveCampaign v3 API. Refer to the Schema section for a list of objects available for replication.

ActiveCampaign feature snapshot

A high-level look at Stitch's ActiveCampaign (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on February 8, 2022	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-activecampaign
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting ActiveCampaign

Step 1: Retrieve your ActiveCampaign API URL and token

Login to your ActiveCampaign account.
Go to the My Settings page.
Click on the Developer tab.
Copy your API URL and API token and keep them readily available for the next step.

Step 2: Add ActiveCampaign as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the ActiveCampaign icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch ActiveCampaign” would create a schema called stitch_activecampaign in the destination. Note: Schema names cannot be changed after you save the integration.
In the API Token field, paste the token you copied from step 1.
In the API Url field, paste the URL you copied from step 1.

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your ActiveCampaign integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond ActiveCampaign’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 4: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

ActiveCampaign integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For ActiveCampaign integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up ActiveCampaign, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

ActiveCampaign table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

This is the latest version of the ActiveCampaign integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

account_contacts

The account_contacts table contains information about contacts in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation account_contacts schema on GitHub ActiveCampaign API method

account_contacts table foreign keys

Join account_contacts with	on
accounts	account_contacts.account = accounts.id
deals	account_contacts.account = deals.account account_contacts.contact = deals.contact
contact_emails	account_contacts.account = contact_emails.account account_contacts.contact = contact_emails.contact
email_activities	account_contacts.account = email_activities.account account_contacts.contact = email_activities.contact
account_custom_field_values	account_contacts.account = account_custom_field_values.account_id
contacts	account_contacts.contact = contacts.id
forms	account_contacts.contact = forms.contacts
bounce_logs	account_contacts.contact = bounce_logs.contact
contact_data	account_contacts.contact = contact_data.contact
contact_lists	account_contacts.contact = contact_lists.contact
contact_tags	account_contacts.contact = contact_tags.contact
contact_conversions	account_contacts.contact = contact_conversions.contact
contact_automations	account_contacts.contact = contact_automations.contact
contact_custom_field_values	account_contacts.contact = contact_custom_field_values.contact
contact_deals	account_contacts.contact = contact_deals.contact

account_contacts table schema

account

INTEGER

contact

INTEGER

created_timestamp

DATE-TIME

INTEGER

job_title

STRING

updated_timestamp

DATE-TIME

account_custom_field_values

The account_custom_field_values table contains information about your account custom fields’ values in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation account_custom_field_values schema on GitHub ActiveCampaign API method

account_custom_field_values table foreign keys

Join account_custom_field_values with	on
account_custom_fields	account_custom_field_values.custom_field_id = account_custom_fields.id
accounts	account_custom_field_values.account_id = accounts.id
deals	account_custom_field_values.account_id = deals.account
contact_emails	account_custom_field_values.account_id = contact_emails.account
email_activities	account_custom_field_values.account_id = email_activities.account
account_contacts	account_custom_field_values.account_id = account_contacts.account

account_custom_field_values table schema

account_custom_field_metum_id

INTEGER

account_id

INTEGER

created_timestamp

DATE-TIME

custom_field_id

INTEGER

field_value

STRING

INTEGER

updated_timestamp

DATE-TIME

account_custom_fields

The account_custom_fields table contains information about account custom fields in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation account_custom_fields schema on GitHub ActiveCampaign API method

account_custom_fields table foreign keys

Join account_custom_fields with	on
account_custom_field_values	account_custom_fields.id = account_custom_field_values.custom_field_id

account_custom_fields table schema

created_timestamp

DATE-TIME

display_order

INTEGER

field_default

STRING

field_default_currency

STRING

field_label

STRING

field_options

ARRAY

field_type

STRING

hide_field_flag

BOOLEAN

INTEGER

is_form_visible

BOOLEAN

is_required

BOOLEAN

known_field_id

INTEGER

personalization

STRING

updated_timestamp

DATE-TIME

accounts

The accounts table contains information about accounts in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation accounts schema on GitHub ActiveCampaign API method

accounts table foreign keys

Join accounts with	on
deals	accounts.id = deals.account
contact_emails	accounts.id = contact_emails.account
email_activities	accounts.id = email_activities.account
account_contacts	accounts.id = account_contacts.account
account_custom_field_values	accounts.id = account_custom_field_values.account_id

accounts table schema

account_url

STRING

contact_count

INTEGER

created_timestamp

DATE-TIME

deal_count

INTEGER

name

STRING

updated_timestamp

DATE-TIME

activities

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	tstamp
Useful links	activities schema on GitHub

activities table foreign keys

Join activities with	on
users	activities.userid = users.id
forms	activities.userid = forms.userid
lists	activities.userid = lists.userid
messages	activities.userid = messages.userid
saved_responses	activities.userid = saved_responses.last_sent_user_id
tasks	activities.userid = tasks.user
templates	activities.userid = templates.userid
campaign_lists	activities.userid = campaign_lists.userid
configs	activities.userid = configs.userid
contact_emails	activities.userid = contact_emails.userid
deal_activities	activities.userid = deal_activities.userid
deal_group_users	activities.userid = deal_group_users.user
email_activities	activities.userid = email_activities.userid
sms	activities.userid = sms.userid
automations	activities.userid = automations.userid
calendars	activities.userid = calendars.userid
campaigns	activities.userid = campaigns.userid

activities table schema

INTEGER

json_data

STRING

permission

STRING

reference

OBJECT

Click to expand reference

INTEGER

type

STRING

reference_action

STRING

reference_id

INTEGER

reference_model_name

STRING

reference_type

STRING

subscriberid

INTEGER

tstamp

DATE-TIME

user

INTEGER

userid

INTEGER

addresses

The addresses table contains information about addresses in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

addresses schema on GitHub

ActiveCampaign API method

addresses table foreign keys

Join addresses with	on
campaigns	addresses.id = campaigns.addressid
forms	addresses.id = forms.addressid

addresses table schema

address1

STRING

address2

STRING

allgroup

INTEGER

city

STRING

company_name

STRING

country

STRING

district

STRING

INTEGER

is_default

BOOLEAN

state

STRING

zip

STRING

automation_blocks

Replication Method

Key-based Incremental

Primary Key

Useful links

automation_blocks schema on GitHub

automation_blocks table foreign keys

Join automation_blocks with	on
automations	automation_blocks.automation = automations.id
deal_activities	automation_blocks.automation = deal_activities.automation
goals	automation_blocks.automation = goals.automation
site_messages	automation_blocks.automation = site_messages.automation
sms	automation_blocks.automation = sms.automation
campaigns	automation_blocks.automation = campaigns.automation
contact_automations	automation_blocks.automation = contact_automations.automation

automation_blocks table schema

automation

INTEGER

cdate

DATE-TIME

deleted

INTEGER

mdate

DATE-TIME

ordernum

INTEGER

params

OBJECT

ARRAY

parent

INTEGER

automations

The automations table contains information about automations in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation automations schema on GitHub ActiveCampaign API method

automations table foreign keys

Join automations with	on
users	automations.userid = users.id
forms	automations.userid = forms.userid
lists	automations.userid = lists.userid
messages	automations.userid = messages.userid
saved_responses	automations.userid = saved_responses.last_sent_user_id
tasks	automations.userid = tasks.user
templates	automations.userid = templates.userid
activities	automations.userid = activities.userid
campaign_lists	automations.userid = campaign_lists.userid
configs	automations.userid = configs.userid
contact_emails	automations.userid = contact_emails.userid
deal_activities	automations.userid = deal_activities.userid automations.id = deal_activities.automation
deal_group_users	automations.userid = deal_group_users.user
email_activities	automations.userid = email_activities.userid
sms	automations.userid = sms.userid automations.id = sms.automation
calendars	automations.userid = calendars.userid
campaigns	automations.userid = campaigns.userid automations.id = campaigns.automation
goals	automations.id = goals.automation
site_messages	automations.id = site_messages.automation
automation_blocks	automations.id = automation_blocks.automation
contact_automations	automations.id = contact_automations.automation

automations table schema

cdate

DATE-TIME

defaultscreenshot

STRING

entered

INTEGER

exited

INTEGER

hidden

INTEGER

mdate

DATE-TIME

name

STRING

screenshot

STRING

status

INTEGER

userid

INTEGER

bounce_logs

Replication Method

Key-based Incremental

Replication Key

updated_timestamp

Useful links

bounce_logs schema on GitHub

bounce_logs table foreign keys

Join bounce_logs with	on
campaigns	bounce_logs.campaignid = campaigns.id
campaign_links	bounce_logs.campaignid = campaign_links.campaignid bounce_logs.messageid = campaign_links.messageid
campaign_lists	bounce_logs.campaignid = campaign_lists.campaignid
campaign_messages	bounce_logs.campaignid = campaign_messages.campaignid bounce_logs.messageid = campaign_messages.messageid
contact_lists	bounce_logs.campaignid = contact_lists.campaign bounce_logs.contact = contact_lists.contact bounce_logs.messageid = contact_lists.message
contacts	bounce_logs.contact = contacts.id
deals	bounce_logs.contact = deals.contact
forms	bounce_logs.contact = forms.contacts
contact_data	bounce_logs.contact = contact_data.contact
contact_emails	bounce_logs.contact = contact_emails.contact bounce_logs.messageid = contact_emails.messageid
contact_tags	bounce_logs.contact = contact_tags.contact
contact_conversions	bounce_logs.contact = contact_conversions.contact
email_activities	bounce_logs.contact = email_activities.contact
account_contacts	bounce_logs.contact = account_contacts.contact
contact_automations	bounce_logs.contact = contact_automations.contact
contact_custom_field_values	bounce_logs.contact = contact_custom_field_values.contact
contact_deals	bounce_logs.contact = contact_deals.contact
messages	bounce_logs.messageid = messages.id

bounce_logs table schema

bounce

INTEGER

bounceid

INTEGER

campaign

INTEGER

campaignid

INTEGER

code

INTEGER

codeid

INTEGER

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

email

STRING

error

STRING

INTEGER

message

INTEGER

messageid

INTEGER

source

STRING

subscriberid

INTEGER

tstamp

DATE-TIME

updated_by

INTEGER

updated_timestamp

DATE-TIME

brandings

The brandings table contains information about existing branding resources in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

brandings schema on GitHub

ActiveCampaign API method

brandings table schema

admin_template_css

STRING

admin_template_htm

STRING

copyright

INTEGER

favicon

STRING

footer_html_value

STRING

footer_text_value

STRING

groupid

STRING

header_html_value

STRING

header_text_value

STRING

help

INTEGER

license

INTEGER

public_template_css

STRING

public_template_htm

STRING

site_logo

STRING

site_logo_small

STRING

site_name

STRING

version

INTEGER

calendars

The calendars table contains information about calendar feeds in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation calendars schema on GitHub ActiveCampaign API method

calendars table foreign keys

Join calendars with	on
users	calendars.userid = users.id
forms	calendars.userid = forms.userid
lists	calendars.userid = lists.userid
messages	calendars.userid = messages.userid
saved_responses	calendars.userid = saved_responses.last_sent_user_id
tasks	calendars.userid = tasks.user
templates	calendars.userid = templates.userid
activities	calendars.userid = activities.userid
campaign_lists	calendars.userid = campaign_lists.userid
configs	calendars.userid = configs.userid
contact_emails	calendars.userid = contact_emails.userid
deal_activities	calendars.userid = deal_activities.userid
deal_group_users	calendars.userid = deal_group_users.user
email_activities	calendars.userid = email_activities.userid
sms	calendars.userid = sms.userid
automations	calendars.userid = automations.userid
campaigns	calendars.userid = campaigns.userid

calendars table schema

cdate

DATE-TIME

INTEGER

mdate

DATE-TIME

notification

INTEGER

title

STRING

token

STRING

type

STRING

userid

INTEGER

campaign_links

The campaign_links table contains information about the links attached to your campaigns in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation campaign_links schema on GitHub ActiveCampaign API method

campaign_links table foreign keys

Join campaign_links with	on
campaigns	campaign_links.campaignid = campaigns.id
bounce_logs	campaign_links.campaignid = bounce_logs.campaignid campaign_links.messageid = bounce_logs.messageid
campaign_lists	campaign_links.campaignid = campaign_lists.campaignid
campaign_messages	campaign_links.campaignid = campaign_messages.campaignid campaign_links.messageid = campaign_messages.messageid
contact_lists	campaign_links.campaignid = contact_lists.campaign campaign_links.messageid = contact_lists.message
messages	campaign_links.messageid = messages.id
contact_emails	campaign_links.messageid = contact_emails.messageid

campaign_links table schema

campaign

INTEGER

campaignid

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

INTEGER

link

STRING

linkclicks

INTEGER

message

STRING

messageid

INTEGER

name

STRING

ref

STRING

tracked

INTEGER

uniquelinkclicks

INTEGER

updated_by

INTEGER

updated_timestamp

DATE-TIME

campaign_lists

Replication Method

Full Table

Primary Key

Useful links

campaign_lists schema on GitHub

campaign_lists table foreign keys

Join campaign_lists with	on
campaigns	campaign_lists.campaignid = campaigns.id campaign_lists.userid = campaigns.userid
campaign_links	campaign_lists.campaignid = campaign_links.campaignid
bounce_logs	campaign_lists.campaignid = bounce_logs.campaignid
campaign_messages	campaign_lists.campaignid = campaign_messages.campaignid
contact_lists	campaign_lists.campaignid = contact_lists.campaign campaign_lists.listid = contact_lists.list
users	campaign_lists.userid = users.id
forms	campaign_lists.userid = forms.userid
lists	campaign_lists.userid = lists.userid campaign_lists.listid = lists.id
messages	campaign_lists.userid = messages.userid
saved_responses	campaign_lists.userid = saved_responses.last_sent_user_id
tasks	campaign_lists.userid = tasks.user
templates	campaign_lists.userid = templates.userid
activities	campaign_lists.userid = activities.userid
configs	campaign_lists.userid = configs.userid
contact_emails	campaign_lists.userid = contact_emails.userid
deal_activities	campaign_lists.userid = deal_activities.userid
deal_group_users	campaign_lists.userid = deal_group_users.user
email_activities	campaign_lists.userid = email_activities.userid
sms	campaign_lists.userid = sms.userid
automations	campaign_lists.userid = automations.userid
calendars	campaign_lists.userid = calendars.userid
webhooks	campaign_lists.listid = webhooks.listid

campaign_lists table schema

campaign

INTEGER

campaignid

INTEGER

cdate

DATE-TIME

INTEGER

list

INTEGER

list_amt

INTEGER

listid

INTEGER

name

STRING

udate

DATE-TIME

user

INTEGER

userid

INTEGER

campaign_messages

Replication Method

Full Table

Primary Key

Useful links

campaign_messages schema on GitHub

campaign_messages table foreign keys

Join campaign_messages with	on
campaigns	campaign_messages.campaignid = campaigns.id
campaign_links	campaign_messages.campaignid = campaign_links.campaignid campaign_messages.messageid = campaign_links.messageid
bounce_logs	campaign_messages.campaignid = bounce_logs.campaignid campaign_messages.messageid = bounce_logs.messageid
campaign_lists	campaign_messages.campaignid = campaign_lists.campaignid
contact_lists	campaign_messages.campaignid = contact_lists.campaign campaign_messages.messageid = contact_lists.message
messages	campaign_messages.messageid = messages.id
contact_emails	campaign_messages.messageid = contact_emails.messageid

campaign_messages table schema

campaign

INTEGER

campaignid

INTEGER

forwards

INTEGER

hardbounces

INTEGER

initial_split_percentage

NUMBER

linkclicks

INTEGER

message

INTEGER

messageid

INTEGER

opens

INTEGER

percentage

NUMBER

replies

INTEGER

screenshot

STRING

send_amt

INTEGER

socialshares

INTEGER

softbounces

INTEGER

sourcesize

INTEGER

spamcheck_max

INTEGER

spamcheck_score

INTEGER

subject

STRING

subscriberclicks

INTEGER

total_amt

INTEGER

uniqueforwards

INTEGER

uniquelinkclicks

INTEGER

uniqueopens

INTEGER

uniquereplies

INTEGER

unsubreasons

INTEGER

unsubscribes

INTEGER

updates

INTEGER

campaigns

The campaigns table contains information about your campaigns in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation campaigns schema on GitHub ActiveCampaign API method

campaigns table foreign keys

Join campaigns with	on
addresses	campaigns.addressid = addresses.id
forms	campaigns.addressid = forms.addressid campaigns.userid = forms.userid
campaign_links	campaigns.id = campaign_links.campaignid
bounce_logs	campaigns.id = bounce_logs.campaignid
campaign_lists	campaigns.id = campaign_lists.campaignid campaigns.userid = campaign_lists.userid
campaign_messages	campaigns.id = campaign_messages.campaignid
contact_lists	campaigns.id = contact_lists.campaign
users	campaigns.userid = users.id
lists	campaigns.userid = lists.userid
messages	campaigns.userid = messages.userid
saved_responses	campaigns.userid = saved_responses.last_sent_user_id
tasks	campaigns.userid = tasks.user
templates	campaigns.userid = templates.userid
activities	campaigns.userid = activities.userid
configs	campaigns.userid = configs.userid
contact_emails	campaigns.userid = contact_emails.userid
deal_activities	campaigns.userid = deal_activities.userid campaigns.automation = deal_activities.automation
deal_group_users	campaigns.userid = deal_group_users.user
email_activities	campaigns.userid = email_activities.userid
sms	campaigns.userid = sms.userid campaigns.automation = sms.automation
automations	campaigns.userid = automations.userid campaigns.automation = automations.id
calendars	campaigns.userid = calendars.userid
goals	campaigns.automation = goals.automation
site_messages	campaigns.automation = site_messages.automation
automation_blocks	campaigns.automation = automation_blocks.automation
contact_automations	campaigns.automation = contact_automations.automation
segments	campaigns.segmentid = segments.id

campaigns table schema

activerss_interval

STRING

activerss_items

INTEGER

activerss_url

STRING

addressid

INTEGER

analytics_campaign_name

STRING

automation

INTEGER

basemessageid

INTEGER

basetemplateid

STRING

bounceid

INTEGER

cdate

DATE-TIME

created_timestamp

DATE-TIME

deletestamp

DATE-TIME

embed_images

INTEGER

facebook

INTEGER

formid

INTEGER

forwards

INTEGER

hardbounces

INTEGER

htmlunsub

INTEGER

htmlunsubdata

STRING

INTEGER

ip4

STRING

laststep

STRING

ldate

DATE-TIME

linkclicks

INTEGER

mail_cleanup

INTEGER

mail_send

INTEGER

mail_transfer

INTEGER

mailer_log_file

INTEGER

managetext

INTEGER

mdate

DATE-TIME

name

STRING

opens

INTEGER

public

INTEGER

realcid

INTEGER

recurring

STRING

reminder_field

STRING

reminder_format

STRING

reminder_last_cron_run

STRING

reminder_offset

INTEGER

reminder_offset_sign

STRING

reminder_offset_type

STRING

reminder_type

STRING

replies

INTEGER

replysys

INTEGER

responder_existing

INTEGER

responder_offset

INTEGER

responder_type

STRING

schedule

INTEGER

scheduleddate

STRING

sdate

DATE-TIME

segmentid

INTEGER

send_amt

INTEGER

sendid

INTEGER

seriesid

INTEGER

socialshares

INTEGER

softbounces

INTEGER

source

STRING

split_content

INTEGER

split_offset

INTEGER

split_offset_type

STRING

split_type

STRING

split_winner_awaiting

INTEGER

split_winner_messageid

INTEGER

status

INTEGER

subscriberclicks

INTEGER

survey

STRING

textunsub

INTEGER

textunsubdata

STRING

threadid

INTEGER

total_amt

INTEGER

tracklinks

STRING

tracklinksanalytics

INTEGER

trackreads

INTEGER

trackreadsanalytics

INTEGER

tweet

INTEGER

type

STRING

uniqueforwards

INTEGER

uniquelinkclicks

INTEGER

uniqueopens

INTEGER

uniquereplies

INTEGER

unsubreasons

INTEGER

unsubscribes

INTEGER

updated_timestamp

DATE-TIME

updates

INTEGER

user

INTEGER

userid

INTEGER

waitpreview

INTEGER

willrecur

INTEGER

configs

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	configs schema on GitHub

configs table foreign keys

Join configs with	on
users	configs.userid = users.id
forms	configs.userid = forms.userid
lists	configs.userid = lists.userid
messages	configs.userid = messages.userid
saved_responses	configs.userid = saved_responses.last_sent_user_id
tasks	configs.userid = tasks.user
templates	configs.userid = templates.userid
activities	configs.userid = activities.userid
campaign_lists	configs.userid = campaign_lists.userid
contact_emails	configs.userid = contact_emails.userid
deal_activities	configs.userid = deal_activities.userid
deal_group_users	configs.userid = deal_group_users.user
email_activities	configs.userid = email_activities.userid
sms	configs.userid = sms.userid
automations	configs.userid = automations.userid
calendars	configs.userid = calendars.userid
campaigns	configs.userid = campaigns.userid

configs table schema

cdate

DATE-TIME

created_by

INTEGER

created_timestamp

DATE-TIME

INTEGER

item

STRING

keyname

STRING

owner

INTEGER

section

STRING

udate

DATE-TIME

updated_by

INTEGER

updated_timestamp

DATE-TIME

userid

INTEGER

val

STRING

contact_automations

The contact_automations table contains information about automations in your ActiveCampaign account that you can add contacts to.

Replication Method

Key-based Incremental

Useful links

ActiveCampaign documentation

contact_automations schema on GitHub

ActiveCampaign API method

contact_automations table foreign keys

Join contact_automations with	on
contacts	contact_automations.contact = contacts.id
deals	contact_automations.contact = deals.contact
forms	contact_automations.contact = forms.contacts
bounce_logs	contact_automations.contact = bounce_logs.contact
contact_data	contact_automations.contact = contact_data.contact
contact_emails	contact_automations.contact = contact_emails.contact
contact_lists	contact_automations.contact = contact_lists.contact
contact_tags	contact_automations.contact = contact_tags.contact
contact_conversions	contact_automations.contact = contact_conversions.contact
email_activities	contact_automations.contact = email_activities.contact
account_contacts	contact_automations.contact = account_contacts.contact
contact_custom_field_values	contact_automations.contact = contact_custom_field_values.contact
contact_deals	contact_automations.contact = contact_deals.contact
automations	contact_automations.automation = automations.id
deal_activities	contact_automations.automation = deal_activities.automation
goals	contact_automations.automation = goals.automation
site_messages	contact_automations.automation = site_messages.automation
sms	contact_automations.automation = sms.automation
automation_blocks	contact_automations.automation = automation_blocks.automation
campaigns	contact_automations.automation = campaigns.automation

contact_automations table schema

adddate

DATE-TIME

automation

INTEGER

batchid

STRING

complete_value

INTEGER

completed

INTEGER

completed_elements

INTEGER

contact

INTEGER

lastblock

INTEGER

lastdate

DATE-TIME

lastlogid

INTEGER

remdate

DATE-TIME

seriesid

INTEGER

startid

INTEGER

status

INTEGER

timespan

INTEGER

total_elements

INTEGER

contact_conversions

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	cdate
Useful links	contact_conversions schema on GitHub

contact_conversions table foreign keys

Join contact_conversions with	on
contacts	contact_conversions.contact = contacts.id
deals	contact_conversions.contact = deals.contact
forms	contact_conversions.contact = forms.contacts
bounce_logs	contact_conversions.contact = bounce_logs.contact
contact_data	contact_conversions.contact = contact_data.contact
contact_emails	contact_conversions.contact = contact_emails.contact
contact_lists	contact_conversions.contact = contact_lists.contact
contact_tags	contact_conversions.contact = contact_tags.contact
email_activities	contact_conversions.contact = email_activities.contact
account_contacts	contact_conversions.contact = account_contacts.contact
contact_automations	contact_conversions.contact = contact_automations.contact
contact_custom_field_values	contact_conversions.contact = contact_custom_field_values.contact
contact_deals	contact_conversions.contact = contact_deals.contact
conversions	contact_conversions.conversion = conversions.id
conversion_triggers	contact_conversions.conversion = conversion_triggers.conversion contact_conversions.conversiontrigger = conversion_triggers.id

contact_conversions table schema

cdate

DATE-TIME

contact

INTEGER

conversion

INTEGER

conversion_trigger

INTEGER

conversiontrigger

INTEGER

converted_by

INTEGER

converted_by_id

INTEGER

converted_by_type

STRING

currency

STRING

dynamic

INTEGER

modifier

STRING

trigger_type

STRING

value

INTEGER

contact_custom_field_options

The contact_custom_field_options table contains information about custom field options for your contacts in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

contact_custom_field_options schema on GitHub

ActiveCampaign API method

contact_custom_field_options table foreign keys

Join contact_custom_field_options with	on
ecommerce_orders	contact_custom_field_options.orderid = ecommerce_orders.id
ecommerce_order_products	contact_custom_field_options.orderid = ecommerce_order_products.orderid
ecommerce_order_activities	contact_custom_field_options.orderid = ecommerce_order_activities.orderid
deal_stages	contact_custom_field_options.orderid = deal_stages.order

contact_custom_field_options table schema

cdate

DATE-TIME

field

INTEGER

isdefault

INTEGER

label

STRING

orderid

INTEGER

udate

DATE-TIME

value

STRING

contact_custom_field_rels

The contact_custom_field_rels table contains information about custom field relationships for your contacts in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

contact_custom_field_rels schema on GitHub

ActiveCampaign API method

contact_custom_field_rels table schema

cdate

DATE-TIME

dorder

INTEGER

field

INTEGER

relid

INTEGER

contact_custom_field_values

The contact_custom_field_values table contains information about custom field values for your contacts in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation contact_custom_field_values schema on GitHub ActiveCampaign API method

contact_custom_field_values table foreign keys

Join contact_custom_field_values with	on
contacts	contact_custom_field_values.contact = contacts.id
deals	contact_custom_field_values.contact = deals.contact
forms	contact_custom_field_values.contact = forms.contacts
bounce_logs	contact_custom_field_values.contact = bounce_logs.contact
contact_data	contact_custom_field_values.contact = contact_data.contact
contact_emails	contact_custom_field_values.contact = contact_emails.contact
contact_lists	contact_custom_field_values.contact = contact_lists.contact
contact_tags	contact_custom_field_values.contact = contact_tags.contact
contact_conversions	contact_custom_field_values.contact = contact_conversions.contact
email_activities	contact_custom_field_values.contact = email_activities.contact
account_contacts	contact_custom_field_values.contact = account_contacts.contact
contact_automations	contact_custom_field_values.contact = contact_automations.contact
contact_deals	contact_custom_field_values.contact = contact_deals.contact

contact_custom_field_values table schema

cdate

DATE-TIME

contact

INTEGER

created_by

INTEGER

field

INTEGER

owner

INTEGER

udate

DATE-TIME

updated_by

INTEGER

value

STRING

contact_custom_fields

The contact_custom_fields table contains information about custom fields for your contacts in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

contact_custom_fields schema on GitHub

ActiveCampaign API method

contact_custom_fields table schema

cdate

DATE-TIME

cols

INTEGER

defval

STRING

descript

STRING

INTEGER

isrequired

INTEGER

ordernum

INTEGER

perstag

STRING

rows

INTEGER

service

STRING

show_in_list

INTEGER

title

STRING

type

STRING

udate

DATE-TIME

visible

INTEGER

contact_data

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	tstamp
Useful links	contact_data schema on GitHub

contact_data table foreign keys

Join contact_data with	on
contacts	contact_data.contact = contacts.id
deals	contact_data.contact = deals.contact
forms	contact_data.contact = forms.contacts
bounce_logs	contact_data.contact = bounce_logs.contact
contact_emails	contact_data.contact = contact_emails.contact
contact_lists	contact_data.contact = contact_lists.contact
contact_tags	contact_data.contact = contact_tags.contact
contact_conversions	contact_data.contact = contact_conversions.contact
email_activities	contact_data.contact = email_activities.contact
account_contacts	contact_data.contact = account_contacts.contact
contact_automations	contact_data.contact = contact_automations.contact
contact_custom_field_values	contact_data.contact = contact_custom_field_values.contact
contact_deals	contact_data.contact = contact_deals.contact

contact_data table schema

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

fb_id

INTEGER

fb_name

STRING

ga_campaign_content

STRING

ga_campaign_customsegment

STRING

ga_campaign_medium

STRING

ga_campaign_name

STRING

ga_campaign_source

STRING

ga_campaign_term

STRING

ga_first_visit

STRING

ga_times_visited

INTEGER

geo_area

STRING

geo_city

STRING

geo_country

STRING

geo_country2

STRING

geo_ip4

STRING

geo_lat

STRING

geo_lon

STRING

geo_state

STRING

geo_tstamp

DATE-TIME

geo_tz

STRING

geo_tz_offset

STRING

geo_zip

STRING

INTEGER

tstamp

DATE-TIME

tw_id

INTEGER

updated_by

INTEGER

updated_timestamp

DATE-TIME

contact_deals

The contact_deals contains information about secondary contacts associated with a deal in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation contact_deals schema on GitHub ActiveCampaign API method

contact_deals table foreign keys

Join contact_deals with	on
deals	contact_deals.deal = deals.id contact_deals.contact = deals.contact
deal_custom_field_values	contact_deals.deal = deal_custom_field_values.deal_id
forms	contact_deals.deal = forms.deals contact_deals.contact = forms.contacts
deal_activities	contact_deals.deal = deal_activities.deal
email_activities	contact_deals.deal = email_activities.deal contact_deals.contact = email_activities.contact
contact_emails	contact_deals.deal = contact_emails.deal contact_deals.contact = contact_emails.contact
contacts	contact_deals.contact = contacts.id
bounce_logs	contact_deals.contact = bounce_logs.contact
contact_data	contact_deals.contact = contact_data.contact
contact_lists	contact_deals.contact = contact_lists.contact
contact_tags	contact_deals.contact = contact_tags.contact
contact_conversions	contact_deals.contact = contact_conversions.contact
account_contacts	contact_deals.contact = account_contacts.contact
contact_automations	contact_deals.contact = contact_automations.contact
contact_custom_field_values	contact_deals.contact = contact_custom_field_values.contact

contact_deals table schema

cdate

DATE-TIME

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

deal

INTEGER

role

STRING

updated_by

INTEGER

updated_timestamp

DATE-TIME

contact_emails

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	sdate
Useful links	contact_emails schema on GitHub

contact_emails table foreign keys

Join contact_emails with	on
deals	contact_emails.deal = deals.id contact_emails.account = deals.account contact_emails.contact = deals.contact
deal_custom_field_values	contact_emails.deal = deal_custom_field_values.deal_id
contact_deals	contact_emails.deal = contact_deals.deal contact_emails.contact = contact_deals.contact
forms	contact_emails.deal = forms.deals contact_emails.contact = forms.contacts contact_emails.userid = forms.userid
deal_activities	contact_emails.deal = deal_activities.deal contact_emails.userid = deal_activities.userid
email_activities	contact_emails.deal = email_activities.deal contact_emails.account = email_activities.account contact_emails.contact = email_activities.contact contact_emails.userid = email_activities.userid
accounts	contact_emails.account = accounts.id
account_contacts	contact_emails.account = account_contacts.account contact_emails.contact = account_contacts.contact
account_custom_field_values	contact_emails.account = account_custom_field_values.account_id
contacts	contact_emails.contact = contacts.id
bounce_logs	contact_emails.contact = bounce_logs.contact contact_emails.messageid = bounce_logs.messageid
contact_data	contact_emails.contact = contact_data.contact
contact_lists	contact_emails.contact = contact_lists.contact contact_emails.messageid = contact_lists.message
contact_tags	contact_emails.contact = contact_tags.contact
contact_conversions	contact_emails.contact = contact_conversions.contact
contact_automations	contact_emails.contact = contact_automations.contact
contact_custom_field_values	contact_emails.contact = contact_custom_field_values.contact
users	contact_emails.userid = users.id
lists	contact_emails.userid = lists.userid
messages	contact_emails.userid = messages.userid contact_emails.messageid = messages.id
saved_responses	contact_emails.userid = saved_responses.last_sent_user_id
tasks	contact_emails.userid = tasks.user
templates	contact_emails.userid = templates.userid
activities	contact_emails.userid = activities.userid
campaign_lists	contact_emails.userid = campaign_lists.userid
configs	contact_emails.userid = configs.userid
deal_group_users	contact_emails.userid = deal_group_users.user
sms	contact_emails.userid = sms.userid
automations	contact_emails.userid = automations.userid
calendars	contact_emails.userid = calendars.userid
campaigns	contact_emails.userid = campaigns.userid
campaign_messages	contact_emails.messageid = campaign_messages.messageid
campaign_links	contact_emails.messageid = campaign_links.messageid

contact_emails table schema

account

INTEGER

contact

INTEGER

d_id

INTEGER

deal

INTEGER

STRING

message

INTEGER

messageheader

STRING

messageid

INTEGER

sdate

DATE-TIME

seriesid

INTEGER

source

STRING

subscriberid

INTEGER

user

INTEGER

userid

INTEGER

contact_lists

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	contact_lists schema on GitHub

contact_lists table foreign keys

Join contact_lists with	on
campaigns	contact_lists.campaign = campaigns.id
campaign_links	contact_lists.campaign = campaign_links.campaignid contact_lists.message = campaign_links.messageid
bounce_logs	contact_lists.campaign = bounce_logs.campaignid contact_lists.contact = bounce_logs.contact contact_lists.message = bounce_logs.messageid
campaign_lists	contact_lists.campaign = campaign_lists.campaignid contact_lists.list = campaign_lists.listid
campaign_messages	contact_lists.campaign = campaign_messages.campaignid contact_lists.message = campaign_messages.messageid
contacts	contact_lists.contact = contacts.id
deals	contact_lists.contact = deals.contact
forms	contact_lists.contact = forms.contacts contact_lists.form = forms.id
contact_data	contact_lists.contact = contact_data.contact
contact_emails	contact_lists.contact = contact_emails.contact contact_lists.message = contact_emails.messageid
contact_tags	contact_lists.contact = contact_tags.contact
contact_conversions	contact_lists.contact = contact_conversions.contact
email_activities	contact_lists.contact = email_activities.contact
account_contacts	contact_lists.contact = account_contacts.contact
contact_automations	contact_lists.contact = contact_automations.contact
contact_custom_field_values	contact_lists.contact = contact_custom_field_values.contact
contact_deals	contact_lists.contact = contact_deals.contact
lists	contact_lists.list = lists.id
webhooks	contact_lists.list = webhooks.listid
messages	contact_lists.message = messages.id

contact_lists table schema

automation

INTEGER

autosync_log

INTEGER

campaign

INTEGER

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

first_name

STRING

form

INTEGER

ip4_last

INTEGER

ip_4sub

INTEGER

ip_4unsub

INTEGER

last_name

STRING

list

INTEGER

message

INTEGER

responder

INTEGER

sdate

DATE-TIME

seriesid

INTEGER

sourceid

INTEGER

status

INTEGER

sync

INTEGER

udate

DATE-TIME

unsubreason

STRING

unsubscribe_automation

INTEGER

updated_by

INTEGER

updated_timestamp

DATE-TIME

contact_tags

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	contact_tags schema on GitHub

contact_tags table foreign keys

Join contact_tags with	on
contacts	contact_tags.contact = contacts.id
deals	contact_tags.contact = deals.contact
forms	contact_tags.contact = forms.contacts
bounce_logs	contact_tags.contact = bounce_logs.contact
contact_data	contact_tags.contact = contact_data.contact
contact_emails	contact_tags.contact = contact_emails.contact
contact_lists	contact_tags.contact = contact_lists.contact
contact_conversions	contact_tags.contact = contact_conversions.contact
email_activities	contact_tags.contact = email_activities.contact
account_contacts	contact_tags.contact = account_contacts.contact
contact_automations	contact_tags.contact = contact_automations.contact
contact_custom_field_values	contact_tags.contact = contact_custom_field_values.contact
contact_deals	contact_tags.contact = contact_deals.contact
tags	contact_tags.tag = tags.id

contact_tags table schema

cdate

DATE-TIME

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

INTEGER

tag

INTEGER

updated_by

INTEGER

updated_timestamp

DATE-TIME

contacts

The contacts table contains information about the people that you market or sell to in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation contacts schema on GitHub ActiveCampaign API method

contacts table foreign keys

Join contacts with	on
deals	contacts.id = deals.contact
forms	contacts.id = forms.contacts
bounce_logs	contacts.id = bounce_logs.contact
contact_data	contacts.id = contact_data.contact
contact_emails	contacts.id = contact_emails.contact
contact_lists	contacts.id = contact_lists.contact
contact_tags	contacts.id = contact_tags.contact
contact_conversions	contacts.id = contact_conversions.contact
email_activities	contacts.id = email_activities.contact
account_contacts	contacts.id = account_contacts.contact
contact_automations	contacts.id = contact_automations.contact
contact_custom_field_values	contacts.id = contact_custom_field_values.contact
contact_deals	contacts.id = contact_deals.contact

contacts table schema

account_contacts

ARRAY

adate

DATE-TIME

anonymized

INTEGER

bounced_date

STRING

bounced_hard

INTEGER

bounced_soft

INTEGER

cdate

DATE-TIME

created_by

INTEGER

created_timestamp

DATE-TIME

created_utc_timestamp

DATE-TIME

deleted

INTEGER

deleted_at

DATE-TIME

edate

DATE-TIME

email

STRING

email_domain

STRING

email_empty

BOOLEAN

email_local

STRING

first_name

STRING

gravatar

INTEGER

hash

STRING

INTEGER

STRING

last_name

STRING

organization

INTEGER

orgid

INTEGER

phone

STRING

rating_tstamp

STRING

score_values

ARRAY

segmentio_id

STRING

sentcnt

INTEGER

socialdata_lastcheck

DATE-TIME

STRING

udate

DATE-TIME

updated_by

INTEGER

updated_timestamp

DATE-TIME

updated_utc_timestamp

DATE-TIME

conversion_triggers

Replication Method
Primary Key	id
Replication Key	udate
Useful links	conversion_triggers schema on GitHub

conversion_triggers table foreign keys

Join conversion_triggers with

conversions

conversion_triggers.conversion = conversions.id

contact_conversions

conversion_triggers.conversion = contact_conversions.conversion

conversion_triggers.id = contact_conversions.conversiontrigger

conversion_triggers table schema

automation_block

INTEGER

cdate

DATE-TIME

conversion

INTEGER

dynamic

INTEGER

modifier

STRING

retroactive

INTEGER

trigger_type

STRING

udate

DATE-TIME

value

STRING

conversions

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	udate
Useful links	conversions schema on GitHub

conversions table foreign keys

Join conversions with	on
contact_conversions	conversions.id = contact_conversions.conversion
conversion_triggers	conversions.id = conversion_triggers.conversion

conversions table schema

cdate

DATE-TIME

currency

STRING

enforcelimit

INTEGER

limit

INTEGER

name

STRING

udate

DATE-TIME

value

INTEGER

deal_activities

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	cdate
Useful links	deal_activities schema on GitHub

deal_activities table foreign keys

Join deal_activities with	on
deals	deal_activities.deal = deals.id deal_activities.stage = deals.stage
deal_custom_field_values	deal_activities.deal = deal_custom_field_values.deal_id
contact_deals	deal_activities.deal = contact_deals.deal
forms	deal_activities.deal = forms.deals deal_activities.userid = forms.userid
email_activities	deal_activities.deal = email_activities.deal deal_activities.userid = email_activities.userid
contact_emails	deal_activities.deal = contact_emails.deal deal_activities.userid = contact_emails.userid
deal_stages	deal_activities.stage = deal_stages.id
deal_groups	deal_activities.stage = deal_groups.stages
users	deal_activities.userid = users.id
lists	deal_activities.userid = lists.userid
messages	deal_activities.userid = messages.userid
saved_responses	deal_activities.userid = saved_responses.last_sent_user_id
tasks	deal_activities.userid = tasks.user
templates	deal_activities.userid = templates.userid
activities	deal_activities.userid = activities.userid
campaign_lists	deal_activities.userid = campaign_lists.userid
configs	deal_activities.userid = configs.userid
deal_group_users	deal_activities.userid = deal_group_users.user
sms	deal_activities.userid = sms.userid deal_activities.automation = sms.automation
automations	deal_activities.userid = automations.userid deal_activities.automation = automations.id
calendars	deal_activities.userid = calendars.userid
campaigns	deal_activities.userid = campaigns.userid deal_activities.automation = campaigns.automation
goals	deal_activities.automation = goals.automation
site_messages	deal_activities.automation = site_messages.automation
automation_blocks	deal_activities.automation = automation_blocks.automation
contact_automations	deal_activities.automation = contact_automations.automation

deal_activities table schema

automation

INTEGER

cdate

DATE-TIME

d_id

INTEGER

d_stageid

INTEGER

data_action

STRING

data_id

INTEGER

data_oldval

STRING

data_type

STRING

deal

INTEGER

deleted

INTEGER

is_addtask

INTEGER

seriesid

INTEGER

sortdate

DATE-TIME

stage

INTEGER

user

INTEGER

userid

INTEGER

deal_custom_field_values

The deal_custom_field_values table contains information about custom field values for deals in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation deal_custom_field_values schema on GitHub ActiveCampaign API method

deal_custom_field_values table foreign keys

Join deal_custom_field_values with	on
deal_custom_fields	deal_custom_field_values.custom_field_id = deal_custom_fields.id
deals	deal_custom_field_values.deal_id = deals.id
contact_deals	deal_custom_field_values.deal_id = contact_deals.deal
forms	deal_custom_field_values.deal_id = forms.deals
deal_activities	deal_custom_field_values.deal_id = deal_activities.deal
email_activities	deal_custom_field_values.deal_id = email_activities.deal
contact_emails	deal_custom_field_values.deal_id = contact_emails.deal

deal_custom_field_values table schema

created_timestamp

DATE-TIME

custom_field_id

INTEGER

deal_custom_field_metum_id

INTEGER

deal_id

INTEGER

field_value

STRING

INTEGER

updated_timestamp

DATE-TIME

deal_custom_fields

The deal_custom_fields table contains information about custom fields for deals in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation deal_custom_fields schema on GitHub ActiveCampaign API method

deal_custom_fields table foreign keys

Join deal_custom_fields with	on
deal_custom_field_values	deal_custom_fields.id = deal_custom_field_values.custom_field_id

deal_custom_fields table schema

created_timestamp

DATE-TIME

display_order

INTEGER

field_default

STRING

field_default_currency

STRING

field_label

STRING

field_options

ARRAY

field_type

STRING

hide_field_flag

BOOLEAN

INTEGER

is_form_visible

BOOLEAN

is_required

BOOLEAN

known_field_id

INTEGER

personalization

STRING

updated_timestamp

DATE-TIME

deal_group_users

Replication Method

Full Table

Primary Key

Useful links

deal_group_users schema on GitHub

deal_group_users table foreign keys

Join deal_group_users with	on
deal_groups	deal_group_users.deal_group = deal_groups.id
deals	deal_group_users.deal_group = deals.group
deal_stages	deal_group_users.deal_group = deal_stages.group
users	deal_group_users.user = users.id
forms	deal_group_users.user = forms.userid
lists	deal_group_users.user = lists.userid
messages	deal_group_users.user = messages.userid
saved_responses	deal_group_users.user = saved_responses.last_sent_user_id
tasks	deal_group_users.user = tasks.user
templates	deal_group_users.user = templates.userid
activities	deal_group_users.user = activities.userid
campaign_lists	deal_group_users.user = campaign_lists.userid
configs	deal_group_users.user = configs.userid
contact_emails	deal_group_users.user = contact_emails.userid
deal_activities	deal_group_users.user = deal_activities.userid
email_activities	deal_group_users.user = email_activities.userid
sms	deal_group_users.user = sms.userid
automations	deal_group_users.user = automations.userid
calendars	deal_group_users.user = calendars.userid
campaigns	deal_group_users.user = campaigns.userid

deal_group_users table schema

cdate

DATE-TIME

deal_group

INTEGER

user

INTEGER

deal_groups

The deal_groups table contains information about deal pipelines in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation deal_groups schema on GitHub ActiveCampaign API method

deal_groups table foreign keys

Join deal_groups with	on
deal_stages	deal_groups.stages = deal_stages.id deal_groups.id = deal_stages.group
deals	deal_groups.stages = deals.stage deal_groups.id = deals.group
deal_activities	deal_groups.stages = deal_activities.stage
deal_group_users	deal_groups.id = deal_group_users.deal_group

deal_groups table schema

allgroups

STRING

allusers

STRING

autoassign

STRING

cdate

DATE-TIME

currency

STRING

INTEGER

stages

ARRAY

title

STRING

udate

DATE-TIME

deal_stages

The deal_stages table contains information about grouped deals within a pipeline in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation deal_stages schema on GitHub ActiveCampaign API method

deal_stages table foreign keys

Join deal_stages with	on
deals	deal_stages.id = deals.stage deal_stages.group = deals.group
deal_groups	deal_stages.id = deal_groups.stages deal_stages.group = deal_groups.id
deal_activities	deal_stages.id = deal_activities.stage
deal_group_users	deal_stages.group = deal_group_users.deal_group
ecommerce_orders	deal_stages.order = ecommerce_orders.id
ecommerce_order_products	deal_stages.order = ecommerce_order_products.orderid
ecommerce_order_activities	deal_stages.order = ecommerce_order_activities.orderid
contact_custom_field_options	deal_stages.order = contact_custom_field_options.orderid

deal_stages table schema

card_region1

STRING

card_region2

STRING

card_region3

STRING

card_region4

STRING

card_region5

STRING

cdate

DATE-TIME

color

STRING

deal_order

STRING

group

INTEGER

order

INTEGER

title

STRING

udate

DATE-TIME

width

INTEGER

deals

The deals table contains information about deals in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation deals schema on GitHub ActiveCampaign API method

deals table foreign keys

Join deals with	on
deal_custom_field_values	deals.id = deal_custom_field_values.deal_id
contact_deals	deals.id = contact_deals.deal deals.contact = contact_deals.contact
forms	deals.id = forms.deals deals.contact = forms.contacts
deal_activities	deals.id = deal_activities.deal deals.stage = deal_activities.stage
email_activities	deals.id = email_activities.deal deals.account = email_activities.account deals.contact = email_activities.contact
contact_emails	deals.id = contact_emails.deal deals.account = contact_emails.account deals.contact = contact_emails.contact
deal_stages	deals.stage = deal_stages.id deals.group = deal_stages.group
deal_groups	deals.stage = deal_groups.stages deals.group = deal_groups.id
deal_group_users	deals.group = deal_group_users.deal_group
accounts	deals.account = accounts.id
account_contacts	deals.account = account_contacts.account deals.contact = account_contacts.contact
account_custom_field_values	deals.account = account_custom_field_values.account_id
contacts	deals.contact = contacts.id
bounce_logs	deals.contact = bounce_logs.contact
contact_data	deals.contact = contact_data.contact
contact_lists	deals.contact = contact_lists.contact
contact_tags	deals.contact = contact_tags.contact
contact_conversions	deals.contact = contact_conversions.contact
contact_automations	deals.contact = contact_automations.contact
contact_custom_field_values	deals.contact = contact_custom_field_values.contact

deals table schema

account

INTEGER

activitycount

INTEGER

cdate

DATE-TIME

contact

INTEGER

currency

STRING

customer_account

INTEGER

description

STRING

edate

DATE-TIME

group

INTEGER

hash

STRING

INTEGER

is_disabled

BOOLEAN

mdate

DATE-TIME

next_task

INTEGER

nextdate

STRING

nextdealid

INTEGER

nexttaskid

INTEGER

organization

INTEGER

owner

INTEGER

percent

NUMBER

stage

INTEGER

status

INTEGER

title

STRING

value

NUMBER

win_probability

NUMBER

win_probability_mdate

DATE-TIME

ecommerce_connections

The ecommerce_connections table contains information about accounts within your ActiveCampaign account that are linked to an external e-commerce service.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation ecommerce_connections schema on GitHub ActiveCampaign API method

ecommerce_connections table foreign keys

Join ecommerce_connections with	on
ecommerce_customers	ecommerce_connections.id = ecommerce_customers.connectionid
ecommerce_orders	ecommerce_connections.id = ecommerce_orders.connectionid
ecommerce_order_products	ecommerce_connections.id = ecommerce_order_products.connectionid
ecommerce_order_activities	ecommerce_connections.id = ecommerce_order_activities.connectionid

ecommerce_connections table schema

cdate

DATE-TIME

externalid

STRING

INTEGER

is_internal

INTEGER

last_sync

DATE-TIME

link_url

STRING

logo_url

STRING

name

STRING

service

STRING

status

INTEGER

sync_status

INTEGER

udate

DATE-TIME

ecommerce_customers

The ecommerce_customers table contains the aggregated e-commerce data from customers in your ActiveCampaign account who are using an external e-commerce service.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	tstamp
Useful links	ActiveCampaign documentation ecommerce_customers schema on GitHub ActiveCampaign API method

ecommerce_customers table foreign keys

Join ecommerce_customers with	on
ecommerce_connections	ecommerce_customers.connectionid = ecommerce_connections.id
ecommerce_orders	ecommerce_customers.connectionid = ecommerce_orders.connectionid ecommerce_customers.id = ecommerce_orders.customer
ecommerce_order_products	ecommerce_customers.connectionid = ecommerce_order_products.connectionid
ecommerce_order_activities	ecommerce_customers.connectionid = ecommerce_order_activities.connectionid ecommerce_customers.id = ecommerce_order_activities.customerid

ecommerce_customers table schema

avg_product_category

STRING

avg_revenue_per_order

NUMBER

connection

INTEGER

connectionid

INTEGER

email

STRING

externalid

STRING

INTEGER

total_orders

INTEGER

total_products

INTEGER

total_revenue

NUMBER

tstamp

DATE-TIME

ecommerce_order_activities

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_date
Useful links	ecommerce_order_activities schema on GitHub

ecommerce_order_activities table foreign keys

Join ecommerce_order_activities with	on
ecommerce_connections	ecommerce_order_activities.connectionid = ecommerce_connections.id
ecommerce_customers	ecommerce_order_activities.connectionid = ecommerce_customers.connectionid ecommerce_order_activities.customerid = ecommerce_customers.id
ecommerce_orders	ecommerce_order_activities.connectionid = ecommerce_orders.connectionid ecommerce_order_activities.customerid = ecommerce_orders.customer ecommerce_order_activities.orderid = ecommerce_orders.id
ecommerce_order_products	ecommerce_order_activities.connectionid = ecommerce_order_products.connectionid ecommerce_order_activities.orderid = ecommerce_order_products.orderid
contact_custom_field_options	ecommerce_order_activities.orderid = contact_custom_field_options.orderid
deal_stages	ecommerce_order_activities.orderid = deal_stages.order

ecommerce_order_activities table schema

abandoned_date

DATE-TIME

connection

INTEGER

connectionid

INTEGER

created_date

DATE-TIME

currency

STRING

customerid

INTEGER

discount_amount

NUMBER

email

STRING

external_created_date

DATE-TIME

external_updated_date

DATE-TIME

externalcheckoutid

STRING

externalid

STRING

INTEGER

logo_url

STRING

order

INTEGER

order_number

STRING

order_url

STRING

orderid

INTEGER

shipping_amount

NUMBER

shipping_method

STRING

source

INTEGER

state

INTEGER

store_name

STRING

tax_amount

NUMBER

total_price

NUMBER

total_products

INTEGER

updated_date

DATE-TIME

ecommerce_order_products

The ecommerce_order_products table contains lists of products for e-commerce orders in your ActiveCampaign account that come from external services. This is a child table of ecommerce_order_products.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

ecommerce_order_products schema on GitHub

ActiveCampaign API method

ecommerce_order_products table foreign keys

Join ecommerce_order_products with	on
ecommerce_connections	ecommerce_order_products.connectionid = ecommerce_connections.id
ecommerce_customers	ecommerce_order_products.connectionid = ecommerce_customers.connectionid
ecommerce_orders	ecommerce_order_products.connectionid = ecommerce_orders.connectionid ecommerce_order_products.orderid = ecommerce_orders.id
ecommerce_order_activities	ecommerce_order_products.connectionid = ecommerce_order_activities.connectionid ecommerce_order_products.orderid = ecommerce_order_activities.orderid
contact_custom_field_options	ecommerce_order_products.orderid = contact_custom_field_options.orderid
deal_stages	ecommerce_order_products.orderid = deal_stages.order

ecommerce_order_products table schema

category

STRING

connectionid

INTEGER

created_date

DATE-TIME

description

STRING

ecom_order

INTEGER

externalid

STRING

INTEGER

image_url

STRING

name

STRING

orderid

INTEGER

price

NUMBER

product_url

STRING

quantity

INTEGER

sku

STRING

tstamp

DATE-TIME

updated_date

DATE-TIME

ecommerce_orders

The ecommerce_orders table contains information about your ActiveCampaign account’s customer orders using an external e-commerce service.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_date
Useful links	ActiveCampaign documentation ecommerce_orders schema on GitHub ActiveCampaign API method

ecommerce_orders table foreign keys

Join ecommerce_orders with	on
ecommerce_connections	ecommerce_orders.connectionid = ecommerce_connections.id
ecommerce_customers	ecommerce_orders.connectionid = ecommerce_customers.connectionid ecommerce_orders.customer = ecommerce_customers.id
ecommerce_order_products	ecommerce_orders.connectionid = ecommerce_order_products.connectionid ecommerce_orders.id = ecommerce_order_products.orderid
ecommerce_order_activities	ecommerce_orders.connectionid = ecommerce_order_activities.connectionid ecommerce_orders.customer = ecommerce_order_activities.customerid ecommerce_orders.id = ecommerce_order_activities.orderid
contact_custom_field_options	ecommerce_orders.id = contact_custom_field_options.orderid
deal_stages	ecommerce_orders.id = deal_stages.order

ecommerce_orders table schema

connection

INTEGER

connectionid

INTEGER

created_date

DATE-TIME

currency

STRING

customer

INTEGER

discount_amount

NUMBER

email

STRING

external_created_date

DATE-TIME

external_updated_date

DATE-TIME

externalid

STRING

INTEGER

order_date

DATE-TIME

order_products

ARRAY

order_url

STRING

shipping_amount

NUMBER

shipping_method

STRING

source

INTEGER

state

INTEGER

tax_amount

NUMBER

total_price

NUMBER

total_products

INTEGER

tstamp

DATE-TIME

updated_date

DATE-TIME

email_activities

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	tstamp
Useful links	email_activities schema on GitHub

email_activities table foreign keys

Join email_activities with	on
deals	email_activities.deal = deals.id email_activities.account = deals.account email_activities.contact = deals.contact
deal_custom_field_values	email_activities.deal = deal_custom_field_values.deal_id
contact_deals	email_activities.deal = contact_deals.deal email_activities.contact = contact_deals.contact
forms	email_activities.deal = forms.deals email_activities.contact = forms.contacts email_activities.userid = forms.userid
deal_activities	email_activities.deal = deal_activities.deal email_activities.userid = deal_activities.userid
contact_emails	email_activities.deal = contact_emails.deal email_activities.account = contact_emails.account email_activities.contact = contact_emails.contact email_activities.userid = contact_emails.userid
accounts	email_activities.account = accounts.id
account_contacts	email_activities.account = account_contacts.account email_activities.contact = account_contacts.contact
account_custom_field_values	email_activities.account = account_custom_field_values.account_id
contacts	email_activities.contact = contacts.id
bounce_logs	email_activities.contact = bounce_logs.contact
contact_data	email_activities.contact = contact_data.contact
contact_lists	email_activities.contact = contact_lists.contact
contact_tags	email_activities.contact = contact_tags.contact
contact_conversions	email_activities.contact = contact_conversions.contact
contact_automations	email_activities.contact = contact_automations.contact
contact_custom_field_values	email_activities.contact = contact_custom_field_values.contact
users	email_activities.userid = users.id
lists	email_activities.userid = lists.userid
messages	email_activities.userid = messages.userid
saved_responses	email_activities.userid = saved_responses.last_sent_user_id
tasks	email_activities.userid = tasks.user
templates	email_activities.userid = templates.userid
activities	email_activities.userid = activities.userid
campaign_lists	email_activities.userid = campaign_lists.userid
configs	email_activities.userid = configs.userid
deal_group_users	email_activities.userid = deal_group_users.user
sms	email_activities.userid = sms.userid
automations	email_activities.userid = automations.userid
calendars	email_activities.userid = calendars.userid
campaigns	email_activities.userid = campaigns.userid

email_activities table schema

account

INTEGER

cc_address

STRING

contact

INTEGER

d_id

INTEGER

deal

INTEGER

from_address

STRING

from_name

STRING

INTEGER

message

STRING

message_html

STRING

reference

OBJECT

Click to expand reference

INTEGER

type

STRING

relid

INTEGER

reltype

STRING

subject

STRING

subscriberid

INTEGER

to_address

STRING

tstamp

DATE-TIME

user

INTEGER

userid

INTEGER

forms

The forms table contains information about forms in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation forms schema on GitHub ActiveCampaign API method

forms table foreign keys

Join forms with	on
addresses	forms.addressid = addresses.id
campaigns	forms.addressid = campaigns.addressid forms.userid = campaigns.userid
deals	forms.deals = deals.id forms.contacts = deals.contact
deal_custom_field_values	forms.deals = deal_custom_field_values.deal_id
contact_deals	forms.deals = contact_deals.deal forms.contacts = contact_deals.contact
deal_activities	forms.deals = deal_activities.deal forms.userid = deal_activities.userid
email_activities	forms.deals = email_activities.deal forms.contacts = email_activities.contact forms.userid = email_activities.userid
contact_emails	forms.deals = contact_emails.deal forms.contacts = contact_emails.contact forms.userid = contact_emails.userid
contacts	forms.contacts = contacts.id
bounce_logs	forms.contacts = bounce_logs.contact
contact_data	forms.contacts = contact_data.contact
contact_lists	forms.contacts = contact_lists.contact forms.id = contact_lists.form
contact_tags	forms.contacts = contact_tags.contact
contact_conversions	forms.contacts = contact_conversions.contact
account_contacts	forms.contacts = account_contacts.contact
contact_automations	forms.contacts = contact_automations.contact
contact_custom_field_values	forms.contacts = contact_custom_field_values.contact
users	forms.userid = users.id
lists	forms.userid = lists.userid
messages	forms.userid = messages.userid
saved_responses	forms.userid = saved_responses.last_sent_user_id
tasks	forms.userid = tasks.user
templates	forms.userid = templates.userid
activities	forms.userid = activities.userid
campaign_lists	forms.userid = campaign_lists.userid
configs	forms.userid = configs.userid
deal_group_users	forms.userid = deal_group_users.user
sms	forms.userid = sms.userid
automations	forms.userid = automations.userid
calendars	forms.userid = calendars.userid

forms table schema

action

STRING

actiondata

OBJECT

Click to expand actiondata

actions

ARRAY

Click to expand actions

email

STRING

list

INTEGER

type

STRING

address

INTEGER

addressid

INTEGER

aid

INTEGER

body

STRING

button

STRING

cdate

DATE-TIME

cfields

OBJECT

ARRAY

Click to expand cfields

class

STRING

default_text

STRING

header

STRING

html

STRING

required

BOOLEAN

type

STRING

contacts

INTEGER

deals

INTEGER

defaultscreenshot

STRING

entries

INTEGER

layout

STRING

name

STRING

options

OBJECT

Click to expand options

blank_overwrite

BOOLEAN

confaction

STRING

confform

STRING

optin_created

BOOLEAN

optin_id

INTEGER

sendoptin

BOOLEAN

parentformid

INTEGER

recent

ARRAY

Click to expand recent

style

OBJECT

Click to expand style

ac_branding

BOOLEAN

background

STRING

border

OBJECT

Click to expand border

color

STRING

radius

INTEGER

style

STRING

width

INTEGER

button

OBJECT

Click to expand button

background

STRING

border

OBJECT

Click to expand border

color

STRING

radius

INTEGER

style

STRING

width

INTEGER

fontcolor

STRING

padding

STRING

dark

BOOLEAN

fontcolor

STRING

layout

STRING

width

INTEGER

submit

STRING

submitdata

OBJECT

Click to expand submitdata

url

STRING

thanks

STRING

title

STRING

udate

DATE-TIME

url

STRING

userid

INTEGER

goals

Replication Method

Full Table

Primary Key

Useful links

goals schema on GitHub

goals table foreign keys

Join goals with	on
automations	goals.automation = automations.id
deal_activities	goals.automation = deal_activities.automation
site_messages	goals.automation = site_messages.automation
sms	goals.automation = sms.automation
automation_blocks	goals.automation = automation_blocks.automation
campaigns	goals.automation = campaigns.automation
contact_automations	goals.automation = contact_automations.automation

goals table schema

automation

INTEGER

automation_block

INTEGER

blockid

INTEGER

cdate

DATE-TIME

dirty_stats

INTEGER

name

STRING

seriesid

INTEGER

groups

The groups table contains information about user groups in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

groups schema on GitHub

ActiveCampaign API method

groups table schema

descript

STRING

INTEGER

optinconfirm

INTEGER

p_admin

INTEGER

pg_automation_manage

INTEGER

pg_contact_actions

INTEGER

pg_contact_add

INTEGER

pg_contact_approve

INTEGER

pg_contact_delete

INTEGER

pg_contact_edit

INTEGER

pg_contact_export

INTEGER

pg_contact_fields

INTEGER

pg_contact_filters

INTEGER

pg_contact_import

INTEGER

pg_contact_merge

INTEGER

pg_contact_sync

INTEGER

pg_deal

INTEGER

pg_deal_delete

INTEGER

pg_deal_group_add

INTEGER

pg_deal_group_delete

INTEGER

pg_deal_group_edit

INTEGER

pg_deal_reassign

INTEGER

pg_form_edit

INTEGER

pg_group_add

INTEGER

pg_group_delete

INTEGER

pg_group_edit

INTEGER

pg_list_add

INTEGER

pg_list_bounce

INTEGER

pg_list_delete

INTEGER

pg_list_edit

INTEGER

pg_list_emailaccount

INTEGER

pg_list_headers

INTEGER

pg_message_add

INTEGER

pg_message_delete

INTEGER

pg_message_edit

INTEGER

pg_message_send

INTEGER

pg_personalization_add

INTEGER

pg_personalization_delete

INTEGER

pg_personalization_edit

INTEGER

pg_reports_campaign

INTEGER

pg_reports_list

INTEGER

pg_reports_trend

INTEGER

pg_reports_user

INTEGER

pg_saved_responses_manage

INTEGER

pg_startup_gettingstarted

INTEGER

pg_startup_reports

INTEGER

pg_template_add

INTEGER

pg_template_delete

INTEGER

pg_template_edit

INTEGER

pg_user_add

INTEGER

pg_user_delete

INTEGER

pg_user_edit

INTEGER

req_approval

INTEGER

req_approval1st

INTEGER

req_approval_notify

INTEGER

sdate

DATE-TIME

socialdata

INTEGER

title

STRING

unsubscribelink

INTEGER

lists

The lists table contains information about groups of contacts that campaigns can be sent to in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation lists schema on GitHub ActiveCampaign API method

lists table foreign keys

Join lists with	on
users	lists.userid = users.id
forms	lists.userid = forms.userid
messages	lists.userid = messages.userid
saved_responses	lists.userid = saved_responses.last_sent_user_id
tasks	lists.userid = tasks.user
templates	lists.userid = templates.userid
activities	lists.userid = activities.userid
campaign_lists	lists.userid = campaign_lists.userid lists.id = campaign_lists.listid
configs	lists.userid = configs.userid
contact_emails	lists.userid = contact_emails.userid
deal_activities	lists.userid = deal_activities.userid
deal_group_users	lists.userid = deal_group_users.user
email_activities	lists.userid = email_activities.userid
sms	lists.userid = sms.userid
automations	lists.userid = automations.userid
calendars	lists.userid = calendars.userid
campaigns	lists.userid = campaigns.userid
webhooks	lists.id = webhooks.listid
contact_lists	lists.id = contact_lists.list

lists table schema

analytics_domains

STRING

analytics_source

STRING

analytics_ua

STRING

carboncopy

STRING

cdate

DATE-TIME

created_by

INTEGER

created_timestamp

DATE-TIME

deletestamp

STRING

facebook_session

STRING

fulladdress

STRING

get_unsubscribe_reason

INTEGER

name

STRING

optinmessageid

INTEGER

optinoptout

INTEGER

optoutconf

INTEGER

p_embed_image

INTEGER

p_use_analytics_link

INTEGER

p_use_analytics_read

INTEGER

p_use_captcha

INTEGER

p_use_facebook

INTEGER

p_use_tracking

INTEGER

p_use_twitter

INTEGER

private

INTEGER

require_name

INTEGER

send_last_broadcast

INTEGER

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

DATE-TIME

unsubscription_notify

STRING

updated_by

INTEGER

updated_timestamp

DATE-TIME

user

INTEGER

userid

INTEGER

messages

The messages table contains information about messages for campaigns in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation messages schema on GitHub ActiveCampaign API method

messages table foreign keys

Join messages with	on
users	messages.userid = users.id
forms	messages.userid = forms.userid
lists	messages.userid = lists.userid
saved_responses	messages.userid = saved_responses.last_sent_user_id
tasks	messages.userid = tasks.user
templates	messages.userid = templates.userid
activities	messages.userid = activities.userid
campaign_lists	messages.userid = campaign_lists.userid
configs	messages.userid = configs.userid
contact_emails	messages.userid = contact_emails.userid messages.id = contact_emails.messageid
deal_activities	messages.userid = deal_activities.userid
deal_group_users	messages.userid = deal_group_users.user
email_activities	messages.userid = email_activities.userid
sms	messages.userid = sms.userid
automations	messages.userid = automations.userid
calendars	messages.userid = calendars.userid
campaigns	messages.userid = campaigns.userid
bounce_logs	messages.id = bounce_logs.messageid
campaign_messages	messages.id = campaign_messages.messageid
contact_lists	messages.id = contact_lists.message
campaign_links	messages.id = campaign_links.messageid

messages table schema

cdate

DATE-TIME

charset

STRING

ed_instanceid

INTEGER

ed_version

INTEGER

encoding

STRING

format

STRING

fromemail

STRING

fromname

STRING

hidden

INTEGER

html

STRING

htmlfetch

STRING

INTEGER

mdate

DATE-TIME

name

STRING

preheader_text

STRING

preview_data

STRING

preview_mime

STRING

priority

INTEGER

reply2

STRING

subject

STRING

text

STRING

textfetch

STRING

user

INTEGER

userid

INTEGER

saved_responses

The saved_responses table contains information about email response templates in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation saved_responses schema on GitHub ActiveCampaign API method

saved_responses table foreign keys

Join saved_responses with	on
users	saved_responses.last_sent_user_id = users.id
forms	saved_responses.last_sent_user_id = forms.userid
lists	saved_responses.last_sent_user_id = lists.userid
messages	saved_responses.last_sent_user_id = messages.userid
tasks	saved_responses.last_sent_user_id = tasks.user
templates	saved_responses.last_sent_user_id = templates.userid
activities	saved_responses.last_sent_user_id = activities.userid
campaign_lists	saved_responses.last_sent_user_id = campaign_lists.userid
configs	saved_responses.last_sent_user_id = configs.userid
contact_emails	saved_responses.last_sent_user_id = contact_emails.userid
deal_activities	saved_responses.last_sent_user_id = deal_activities.userid
deal_group_users	saved_responses.last_sent_user_id = deal_group_users.user
email_activities	saved_responses.last_sent_user_id = email_activities.userid
sms	saved_responses.last_sent_user_id = sms.userid
automations	saved_responses.last_sent_user_id = automations.userid
calendars	saved_responses.last_sent_user_id = calendars.userid
campaigns	saved_responses.last_sent_user_id = campaigns.userid

saved_responses table schema

body

STRING

cdate

DATE-TIME

INTEGER

last_sent_user_id

INTEGER

ldate

DATE-TIME

mdate

DATE-TIME

subject

STRING

title

STRING

scores

The scores table contains information about prioritization scores on leads in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	mdate
Useful links	scores schema on GitHub ActiveCampaign API method

scores table schema

cdate

DATE-TIME

descript

STRING

INTEGER

mdate

DATE-TIME

name

STRING

reltype

STRING

status

INTEGER

segments

The segments table contains information about targeted groups of contacts that meet specified criteria in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

segments schema on GitHub

ActiveCampaign API method

segments table foreign keys

Join segments with	on
campaigns	segments.id = campaigns.segmentid

segments table schema

created_by

INTEGER

created_timestamp

DATE-TIME

hidden

INTEGER

logic

STRING

name

STRING

seriesid

INTEGER

updated_by

INTEGER

updated_timestamp

DATE-TIME

site_messages

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	ldate
Useful links	site_messages schema on GitHub

site_messages table foreign keys

Join site_messages with	on
automations	site_messages.automation = automations.id
deal_activities	site_messages.automation = deal_activities.automation
goals	site_messages.automation = goals.automation
sms	site_messages.automation = sms.automation
automation_blocks	site_messages.automation = automation_blocks.automation
campaigns	site_messages.automation = campaigns.automation
contact_automations	site_messages.automation = contact_automations.automation

site_messages table schema

automation

INTEGER

ldate

DATE-TIME

name

STRING

template

OBJECT

Click to expand template

detailed

OBJECT

initial

OBJECT

sms

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	ldate
Useful links	sms schema on GitHub

sms table foreign keys

Join sms with	on
users	sms.userid = users.id
forms	sms.userid = forms.userid
lists	sms.userid = lists.userid
messages	sms.userid = messages.userid
saved_responses	sms.userid = saved_responses.last_sent_user_id
tasks	sms.userid = tasks.user
templates	sms.userid = templates.userid
activities	sms.userid = activities.userid
campaign_lists	sms.userid = campaign_lists.userid
configs	sms.userid = configs.userid
contact_emails	sms.userid = contact_emails.userid
deal_activities	sms.userid = deal_activities.userid sms.automation = deal_activities.automation
deal_group_users	sms.userid = deal_group_users.user
email_activities	sms.userid = email_activities.userid
automations	sms.userid = automations.userid sms.automation = automations.id
calendars	sms.userid = calendars.userid
campaigns	sms.userid = campaigns.userid sms.automation = campaigns.automation
goals	sms.automation = goals.automation
site_messages	sms.automation = site_messages.automation
automation_blocks	sms.automation = automation_blocks.automation
contact_automations	sms.automation = contact_automations.automation

sms table schema

automation

INTEGER

failed

INTEGER

ldate

DATE-TIME

msg

STRING

replies

INTEGER

sdate

DATE-TIME

sent

INTEGER

seriesid

INTEGER

tf_day

STRING

tf_hr_from

INTEGER

tf_hr_to

INTEGER

tstamp

DATE-TIME

uniquereplies

INTEGER

unsubscribes

INTEGER

user

INTEGER

userid

INTEGER

task_types

The task_types table contains information about task types in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

task_types schema on GitHub

ActiveCampaign API method

task_types table foreign keys

Join task_types with	on
tasks	task_types.id = tasks.deal_tasktype

task_types table schema

cdate

DATE-TIME

defduration

INTEGER

status

INTEGER

title

STRING

udate

DATE-TIME

tasks

The tasks table contains information about tasks to do in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation tasks schema on GitHub ActiveCampaign API method

tasks table foreign keys

Join tasks with	on
users	tasks.user = users.id
forms	tasks.user = forms.userid
lists	tasks.user = lists.userid
messages	tasks.user = messages.userid
saved_responses	tasks.user = saved_responses.last_sent_user_id
templates	tasks.user = templates.userid
activities	tasks.user = activities.userid
campaign_lists	tasks.user = campaign_lists.userid
configs	tasks.user = configs.userid
contact_emails	tasks.user = contact_emails.userid
deal_activities	tasks.user = deal_activities.userid
deal_group_users	tasks.user = deal_group_users.user
email_activities	tasks.user = email_activities.userid
sms	tasks.user = sms.userid
automations	tasks.user = automations.userid
calendars	tasks.user = calendars.userid
campaigns	tasks.user = campaigns.userid
task_types	tasks.deal_tasktype = task_types.id

tasks table schema

assignee

INTEGER

automation

INTEGER

cdate

DATE-TIME

deal_tasktype

INTEGER

done_automation

INTEGER

duedate

DATE-TIME

edate

DATE-TIME

INTEGER

note

STRING

owner

OBJECT

Click to expand owner

INTEGER

type

STRING

relid

INTEGER

reltype

STRING

status

INTEGER

title

STRING

udate

DATE-TIME

user

INTEGER

templates

The templates table contains information about templates used for campaign emails in your ActiveCampaign account.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	mdate
Useful links	templates schema on GitHub ActiveCampaign API method

templates table foreign keys

Join templates with	on
users	templates.userid = users.id
forms	templates.userid = forms.userid
lists	templates.userid = lists.userid
messages	templates.userid = messages.userid
saved_responses	templates.userid = saved_responses.last_sent_user_id
tasks	templates.userid = tasks.user
activities	templates.userid = activities.userid
campaign_lists	templates.userid = campaign_lists.userid
configs	templates.userid = configs.userid
contact_emails	templates.userid = contact_emails.userid
deal_activities	templates.userid = deal_activities.userid
deal_group_users	templates.userid = deal_group_users.user
email_activities	templates.userid = email_activities.userid
sms	templates.userid = sms.userid
automations	templates.userid = automations.userid
calendars	templates.userid = calendars.userid
campaigns	templates.userid = campaigns.userid

templates table schema

categoryid

INTEGER

content

STRING

ed_instanceid

INTEGER

ed_version

INTEGER

hidden

INTEGER

importnum

INTEGER

mdate

DATE-TIME

modified

INTEGER

name

STRING

preview_content

STRING

screenshot

STRING

subject

STRING

used

INTEGER

userid

INTEGER

waitpreview

INTEGER

users

The users table contains information about users who can login to your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

users schema on GitHub

ActiveCampaign API method

users table foreign keys

Join users with	on
forms	users.id = forms.userid
lists	users.id = lists.userid
messages	users.id = messages.userid
saved_responses	users.id = saved_responses.last_sent_user_id
tasks	users.id = tasks.user
templates	users.id = templates.userid
activities	users.id = activities.userid
campaign_lists	users.id = campaign_lists.userid
configs	users.id = configs.userid
contact_emails	users.id = contact_emails.userid
deal_activities	users.id = deal_activities.userid
deal_group_users	users.id = deal_group_users.user
email_activities	users.id = email_activities.userid
sms	users.id = sms.userid
automations	users.id = automations.userid
calendars	users.id = calendars.userid
campaigns	users.id = campaigns.userid

users table schema

cdate

DATE-TIME

email

STRING

first_name

STRING

INTEGER

last_name

STRING

local_zoneid

STRING

mfa_enabled

INTEGER

password_updated_utc_timestamp

DATE-TIME

phone

STRING

signature

STRING

udate

DATE-TIME

username

STRING

webhooks

The webhooks table contains information about real-time updates about your contact and campaign activity in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

Useful links

webhooks schema on GitHub

ActiveCampaign API method

webhooks table foreign keys

Join webhooks with	on
lists	webhooks.listid = lists.id
campaign_lists	webhooks.listid = campaign_lists.listid
contact_lists	webhooks.listid = contact_lists.list

webhooks table schema

cdate

DATE-TIME

events

ARRAY

INTEGER

listid

INTEGER

name

STRING

sources

ARRAY

url

STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues