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

  1. Login to your ActiveCampaign account.
  2. Go to the My Settings page.
  3. Click on the Developer tab.
  4. 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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the ActiveCampaign icon.

  4. 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.

  5. In the API Token field, paste the token you copied from step 1.
  6. 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

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:

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

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. 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.

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.


ActiveCampaign table reference

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

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

INTEGER

contact

INTEGER

created_timestamp

DATE-TIME

id

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

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_metum_id

INTEGER

account_id

INTEGER

created_timestamp

DATE-TIME

custom_field_id

INTEGER

field_value

STRING

id

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

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

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

id

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

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

account_url

STRING

contact_count

INTEGER

created_timestamp

DATE-TIME

deal_count

INTEGER

id

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

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

id

INTEGER

json_data

STRING

permission

STRING

reference

OBJECT

id

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

id

Useful links

ActiveCampaign documentation

addresses schema on GitHub

ActiveCampaign API method

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

address1

STRING

address2

STRING

allgroup

INTEGER

city

STRING

company_name

STRING

country

STRING

district

STRING

id

INTEGER

is_default

BOOLEAN

state

STRING

zip

STRING

automation_blocks

Replication Method

Key-based Incremental

Primary Key

id

Useful links

automation_blocks schema on GitHub

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

INTEGER

cdate

DATE-TIME

deleted

INTEGER

id

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

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

cdate

DATE-TIME

defaultscreenshot

STRING

entered

INTEGER

exited

INTEGER

hidden

INTEGER

id

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

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

INTEGER

bounceid

INTEGER

campaign

INTEGER

campaignid

INTEGER

code

INTEGER

codeid

INTEGER

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

email

STRING

error

STRING

id

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

id

Useful links

ActiveCampaign documentation

brandings schema on GitHub

ActiveCampaign API method

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

id

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

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

cdate

DATE-TIME

id

INTEGER

mdate

DATE-TIME

notification

INTEGER

title

STRING

token

STRING

type

STRING

userid

INTEGER

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_lists

Replication Method

Full Table

Primary Key

id

Useful links

campaign_lists schema on GitHub

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

INTEGER

campaignid

INTEGER

cdate

DATE-TIME

id

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

id

Useful links

campaign_messages schema on GitHub

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

INTEGER

campaignid

INTEGER

forwards

INTEGER

hardbounces

INTEGER

id

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

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

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

id

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

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

cdate

DATE-TIME

created_by

INTEGER

created_timestamp

DATE-TIME

id

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

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

adddate

DATE-TIME

automation

INTEGER

batchid

STRING

complete_value

INTEGER

completed

INTEGER

completed_elements

INTEGER

contact

INTEGER

id

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

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

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

id

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

id

Useful links

ActiveCampaign documentation

contact_custom_field_options schema on GitHub

ActiveCampaign API method

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

cdate

DATE-TIME

field

INTEGER

id

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

id

Useful links

ActiveCampaign documentation

contact_custom_field_rels schema on GitHub

ActiveCampaign API method

cdate

DATE-TIME

dorder

INTEGER

field

INTEGER

id

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

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

cdate

DATE-TIME

contact

INTEGER

created_by

INTEGER

field

INTEGER

id

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

id

Useful links

ActiveCampaign documentation

contact_custom_fields schema on GitHub

ActiveCampaign API method

cdate

DATE-TIME

cols

INTEGER

defval

STRING

descript

STRING

id

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

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

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

id

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

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

cdate

DATE-TIME

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

deal

INTEGER

id

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

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

account

INTEGER

contact

INTEGER

d_id

INTEGER

deal

INTEGER

id

INTEGER

ip

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

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

automation

INTEGER

autosync_log

INTEGER

campaign

INTEGER

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

first_name

STRING

form

INTEGER

id

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

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

cdate

DATE-TIME

contact

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

id

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

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

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

id

INTEGER

ip

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

ua

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

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

automation_block

INTEGER

cdate

DATE-TIME

conversion

INTEGER

dynamic

INTEGER

id

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

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

cdate

DATE-TIME

currency

STRING

enforcelimit

INTEGER

id

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

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

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

id

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

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

created_timestamp

DATE-TIME

custom_field_id

INTEGER

deal_custom_field_metum_id

INTEGER

deal_id

INTEGER

field_value

STRING

id

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

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

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

id

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

id

Useful links

deal_group_users schema on GitHub

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

cdate

DATE-TIME

deal_group

INTEGER

id

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

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

allgroups

STRING

allusers

STRING

autoassign

STRING

cdate

DATE-TIME

currency

STRING

id

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

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

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

id

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

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

account

INTEGER

activitycount

INTEGER

cdate

DATE-TIME

contact

INTEGER

currency

STRING

customer_account

INTEGER

description

STRING

edate

DATE-TIME

group

INTEGER

hash

STRING

id

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

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

cdate

DATE-TIME

externalid

STRING

id

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

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

avg_product_category

STRING

avg_revenue_per_order

NUMBER

connection

INTEGER

connectionid

INTEGER

email

STRING

externalid

STRING

id

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

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

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

id

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

id

Useful links

ActiveCampaign documentation

ecommerce_order_products schema on GitHub

ActiveCampaign API method

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

category

STRING

connectionid

INTEGER

created_date

DATE-TIME

description

STRING

ecom_order

INTEGER

externalid

STRING

id

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

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

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

id

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

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

account

INTEGER

cc_address

STRING

contact

INTEGER

d_id

INTEGER

deal

INTEGER

from_address

STRING

from_name

STRING

id

INTEGER

message

STRING

message_html

STRING

reference

OBJECT

id

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

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

action

STRING

actiondata

OBJECT

actions

ARRAY

email

STRING

list

INTEGER

type

STRING

address

INTEGER

addressid

INTEGER

aid

INTEGER

body

STRING

button

STRING

cdate

DATE-TIME

cfields

OBJECT

ARRAY

class

STRING

default_text

STRING

header

STRING

html

STRING

required

BOOLEAN

type

STRING

contacts

INTEGER

deals

INTEGER

defaultscreenshot

STRING

entries

INTEGER

id

INTEGER

layout

STRING

name

STRING

options

OBJECT

blank_overwrite

BOOLEAN

confaction

STRING

confform

STRING

optin_created

BOOLEAN

optin_id

INTEGER

sendoptin

BOOLEAN

parentformid

INTEGER

recent

ARRAY

style

OBJECT

ac_branding

BOOLEAN

background

STRING

border

OBJECT

color

STRING

radius

INTEGER

style

STRING

width

INTEGER

button

OBJECT

background

STRING

border

OBJECT

color

STRING

radius

INTEGER

style

STRING

width

INTEGER

fontcolor

STRING

padding

STRING

dark

BOOLEAN

fontcolor

STRING

layout

STRING

width

INTEGER

submit

STRING

submitdata

OBJECT

thanks

STRING

title

STRING

udate

DATE-TIME

url

STRING

userid

INTEGER

goals

Replication Method

Full Table

Primary Key

id

Useful links

goals schema on GitHub

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

automation

INTEGER

automation_block

INTEGER

blockid

INTEGER

cdate

DATE-TIME

dirty_stats

INTEGER

id

INTEGER

name

STRING

seriesid

INTEGER

groups

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

Replication Method

Full Table

Primary Key

id

Useful links

ActiveCampaign documentation

groups schema on GitHub

ActiveCampaign API method

descript

STRING

id

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

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

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

id

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

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

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

id

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

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

body

STRING

cdate

DATE-TIME

id

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

cdate

DATE-TIME

descript

STRING

id

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

id

Useful links

ActiveCampaign documentation

segments schema on GitHub

ActiveCampaign API method

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

created_by

INTEGER

created_timestamp

DATE-TIME

hidden

INTEGER

id

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

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

automation

INTEGER

id

INTEGER

ldate

DATE-TIME

name

STRING

template

OBJECT

detailed

OBJECT

initial

OBJECT

sms

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

ldate

Useful links

sms schema on GitHub

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

automation

INTEGER

failed

INTEGER

id

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

tags

The tags table contains information about labels that you can apply to contacts in your ActiveCampaign account.

Replication Method

Full Table

Primary Key

id

Useful links

tags schema on GitHub

ActiveCampaign API method

Join tags with on
contact_tags
tags.id = contact_tags.tag

cdate

DATE-TIME

created_by

INTEGER

created_timestamp

DATE-TIME

description

STRING

id

INTEGER

tag

STRING

tag_type

STRING

updated_by

INTEGER

updated_timestamp

DATE-TIME

task_types

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

Replication Method

Full Table

Primary Key

id

Useful links

ActiveCampaign documentation

task_types schema on GitHub

ActiveCampaign API method

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

cdate

DATE-TIME

defduration

INTEGER

id

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

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

assignee

INTEGER

automation

INTEGER

cdate

DATE-TIME

deal_tasktype

INTEGER

done_automation

INTEGER

duedate

DATE-TIME

edate

DATE-TIME

id

INTEGER

note

STRING

owner

OBJECT

id

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

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

categoryid

INTEGER

content

STRING

ed_instanceid

INTEGER

ed_version

INTEGER

hidden

INTEGER

id

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

id

Useful links

ActiveCampaign documentation

users schema on GitHub

ActiveCampaign API method

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

cdate

DATE-TIME

email

STRING

first_name

STRING

id

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

id

Useful links

webhooks schema on GitHub

ActiveCampaign API method

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

cdate

DATE-TIME

events

ARRAY

id

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.