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:

  • For tables using Key-based Incremental Replication, data equal to or newer than this date will be replicated to your destination.
  • For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your destination.

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

Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

List all accounts

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

id
INTEGER

The account ID.

Reference:

updated_timestamp
DATE-TIME

The time the account was last updated.

account_url
STRING

contact_count
INTEGER

created_timestamp
DATE-TIME

deal_count
INTEGER

name
STRING


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

List all associations

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


account_custom_fields

Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

List all custom fields

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

id
INTEGER

The custom field ID.

Reference:

updated_timestamp
DATE-TIME

The time the custom field was last updated.

created_timestamp
DATE-TIME

display_order
INTEGER

field_default
STRING

field_default_currency
STRING

field_label
STRING

field_options
ARRAY

value
STRING

account_custom_fields (table), field_options (attribute)

field_type
STRING

hide_field_flag
BOOLEAN

is_form_visible
BOOLEAN

is_required
BOOLEAN

known_field_id
INTEGER

personalization
STRING


account_custom_field_values

Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

List all custom field values

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

id
INTEGER

The custom field value ID.

updated_timestamp
DATE-TIME

The time the custom field value was last updated.

account_custom_field_metum_id
INTEGER

account_id
INTEGER

The account ID.

Reference:

created_timestamp
DATE-TIME

custom_field_id
INTEGER

The custom field ID.

Reference:

field_value
STRING


Replication Method :

Key-based Incremental

Replication Key :

tstamp

Primary Key :

id

API endpoint :

id
INTEGER

The activity ID.

tstamp
DATE-TIME

The activity timestamp.

json_data
STRING

permission
STRING

reference
OBJECT

id
INTEGER

type
STRING

activities (table), reference (attribute)

reference_action
STRING

reference_id
INTEGER

reference_model_name
STRING

reference_type
STRING

subscriberid
INTEGER

user
INTEGER

userid
INTEGER

The user ID.

Reference:


Replication Method :

Full Table

Primary Key :

id

API endpoint :

List all addresses

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

id
INTEGER

The address ID.

Reference:

address1
STRING

address2
STRING

allgroup
INTEGER

city
STRING

company_name
STRING

country
STRING

district
STRING

is_default
BOOLEAN

state
STRING

zip
STRING


Replication Method :

Key-based Incremental

Replication Key :

mdate

Primary Key :

id

API endpoint :

List all automations

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


automation_blocks

Replication Method :

Key-based Incremental

Replication Key :
Primary Key :

id

API endpoint :

id
INTEGER

The automation block ID.

mdate
DATE-TIME

The date the block was last modified.

automation
INTEGER

The automation ID.

Reference:

cdate
DATE-TIME

deleted
INTEGER

ordernum
INTEGER

params
ARRAY, OBJECT

parent
INTEGER


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

None

API endpoint :

id
INTEGER

The bounce log ID.

updated_timestamp
DATE-TIME

The time the bounce log was last updated.

bounce
INTEGER

bounceid
INTEGER

campaign
INTEGER

campaignid
INTEGER

The campaign ID.

Reference:

code
INTEGER

codeid
INTEGER

contact
INTEGER

The contact ID.

Reference:

created_by
INTEGER

created_timestamp
DATE-TIME

email
STRING

error
STRING

message
INTEGER

messageid
INTEGER

The message ID.

Reference:

source
STRING

subscriberid
INTEGER

tstamp
DATE-TIME

updated_by
INTEGER


Replication Method :

Full Table

Primary Key :

id

API endpoint :

List all brandings

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

id
INTEGER

The branding resource ID.

admin_template_css
STRING

admin_template_httm
STRING

copyright
INTEGER

favicon
STRING

footer_html_value
STRING

footer_text_value
STRING

group_id
STRING

header_html_value
STRING

header_text_value
STRING

help
INTEGER

license
INTEGER

public_template_css
STRING

public_template_httm
STRING

site_logo
STRING

site_logo_small
STRING

site_name
STRING

version
INTEGER


Replication Method :

Key-based Incremental

Replication Key :

mdate

Primary Key :

id

API endpoint :

List all calendar feeds

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


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

List all campaigns

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

id
INTEGER

The campaign ID.

Reference:

updated_timestamp
DATE-TIME

The time the campaign was last updated.

activerss_interval
STRING

activerss_items
INTEGER

activerss_url
STRING

addressid
INTEGER

The address ID.

Reference:

analytics_campaign_name
STRING

automation
INTEGER

The automation ID.

Reference:

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

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

The segment ID.

Reference:

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

updates
INTEGER

user
INTEGER

userid
INTEGER

The user ID.

Reference:

waitpreview
INTEGER

willrecur
INTEGER


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

Retrieve links associated to campaign

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


Replication Method :

Full Table

Primary Key :

id

API endpoint :


campaign_messages

Replication Method :

Full Table

Primary Key :

id

API endpoint :

id
INTEGER

The campaign message ID.

campaign
INTEGER

campaignid
INTEGER

The campaign ID.

Reference:

forwards
INTEGER

hardbounces
INTEGER

initial_split_percentage
NUMBER

linkclicks
INTEGER

message
INTEGER

messageid
INTEGER

The message ID.

Reference:

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


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

id
INTEGER

The configuration ID.

updated_timestamp
DATE-TIME

The time the configuration was last updated.

cdate
DATE-TIME

created_by
INTEGER

created_timestamp
DATE-TIME

item
STRING

keyname
STRING

owner
INTEGER

section
STRING

udate
DATE-TIME

updated_by
INTEGER

userid
INTEGER

The user ID.

Reference:

val
STRING


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

List, search, and filter contacts

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

id
INTEGER

The contact ID.

Reference:

updated_timestamp
DATE-TIME

The time the contact was last updated.

account_contacts
ARRAY

value
INTEGER

contacts (table), account_contacts (attribute)

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

ip
STRING

last_name
STRING

organization
INTEGER

orgid
INTEGER

phone
STRING

rating_tstamp
STRING

score_values
ARRAY

value
INTEGER

contacts (table), score_values (attribute)

segmentio_id
STRING

sentcnt
INTEGER

socialdata_lastcheck
DATE-TIME

ua
STRING

udate
DATE-TIME

updated_by
INTEGER

updated_utc_timestamp
DATE-TIME


contact_automations

Replication Method :

Key-based Incremental

Replication Key :
Primary Key :

None

API endpoint :

List all automations a contact is in

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

id
INTEGER

The contact automation ID.

lastdate
DATE-TIME

The date the automation was last updated.

adddate
DATE-TIME

automation
INTEGER

The automation ID.

Reference:

batchid
STRING

complete_value
INTEGER

completed
INTEGER

completed_elements
INTEGER

contact
INTEGER

The contact ID.

Reference:

lastblock
INTEGER

lastlogid
INTEGER

remdate
DATE-TIME

seriesid
INTEGER

startid
INTEGER

status
INTEGER

timespan
INTEGER

total_elements
INTEGER


contact_conversions

Replication Method :

Key-based Incremental

Replication Key :

cdate

Primary Key :

id

API endpoint :

id
INTEGER

The contact conversion ID.

cdate
DATE-TIME

The date the contact conversion was created.

contact
INTEGER

The contact ID.

Reference:

conversion
INTEGER

The conversion ID.

Reference:

conversion_trigger
INTEGER

conversiontrigger
INTEGER

The conversion trigger ID.

Reference:

converted_by
INTEGER

converted_by_id
INTEGER

converted_by_type
STRING

currency
STRING

dynamic
INTEGER

modifier
STRING

trigger_type
STRING

value
INTEGER


contact_custom_fields

Replication Method :

Full Table

Primary Key :

id

API endpoint :

List all custom fields

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

id
INTEGER

The contact custom field ID.

cdate
DATE-TIME

cols
INTEGER

defval
STRING

descript
STRING

isrequired
INTEGER

ordernum
INTEGER

perstag
STRING

rows
INTEGER

service
STRING

show_in_list
INTEGER

title
STRING

type
STRING

udate
DATE-TIME

visible
INTEGER


contact_custom_field_options

Replication Method :

Full Table

Primary Key :

id

API endpoint :

List all custom fields

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

id
INTEGER

The contact custom field option ID.

cdate
DATE-TIME

field
INTEGER

isdefault
INTEGER

label
STRING

orderid
INTEGER

The order ID.

Reference:

udate
DATE-TIME

value
STRING


contact_custom_field_rels

Replication Method :

Full Table

Primary Key :

id

API endpoint :

List all custom fields

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

id
INTEGER

The contact custom field relationship ID.

cdate
DATE-TIME

dorder
INTEGER

field
INTEGER

relid
INTEGER


contact_custom_field_values

Replication Method :

Key-based Incremental

Replication Key :

udate

Primary Key :

id

API endpoint :

List all custom field values

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

id
INTEGER

The contact custom field value ID.

udate
DATE-TIME

The custom field value’s udate.

cdate
DATE-TIME

contact
INTEGER

The contact ID.

Reference:

created_by
INTEGER

field
INTEGER

owner
INTEGER

updated_by
INTEGER

value
STRING


Replication Method :

Key-based Incremental

Replication Key :

tstamp

Primary Key :

id

API endpoint :

id
INTEGER

The contact datapoint ID.

tstamp
DATE-TIME

The time the contact data timestamp.

contact
INTEGER

The contact ID.

Reference:

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

tw_id
INTEGER

updated_by
INTEGER

updated_timestamp
DATE-TIME


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

List all secondary contacts

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


Replication Method :

Key-based Incremental

Replication Key :

sdate

Primary Key :

id

API endpoint :


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

id
INTEGER

The contact list ID.

updated_timestamp
DATE-TIME

The time the contact list was last updated.

automation
INTEGER

autosync_log
INTEGER

campaign
INTEGER

The campaign ID.

Reference:

contact
INTEGER

The contact ID.

Reference:

created_by
INTEGER

created_timestamp
DATE-TIME

first_name
STRING

form
INTEGER

The form ID.

Reference:

ip4_last
INTEGER

ip_4sub
INTEGER

ip_4unsub
INTEGER

last_name
STRING

list
INTEGER

The list ID.

Reference:

message
INTEGER

The message ID.

Reference:

responder
INTEGER

sdate
DATE-TIME

seriesid
INTEGER

sourceid
INTEGER

status
INTEGER

sync
INTEGER

udate
DATE-TIME

unsubreason
STRING

unsubscribe_automation
INTEGER

updated_by
INTEGER


Replication Method :

Key-based Incremental

Replication Key :

updated_timestamp

Primary Key :

id

API endpoint :

id
INTEGER

The contact tag ID.

updated_timestamp
DATE-TIME

The time the contact tag was last updated.

cdate
DATE-TIME

contact
INTEGER

The contact ID.

Reference:

created_by
INTEGER

created_timestamp
DATE-TIME

tag
INTEGER

The tag ID.

Reference:

updated_by
INTEGER


Replication Method :

Key-based Incremental

Replication Key :

udate

Primary Key :

id

API endpoint :

id
INTEGER

The conversion ID.

Reference:

udate
DATE-TIME

The date the conversion was last updated.

cdate
DATE-TIME

currency
STRING

enforcelimit
INTEGER

limit
INTEGER

name
STRING

value
INTEGER


conversion_triggers

API endpoint :

id
INTEGER

The conversion trigger ID.

Reference:

udate
DATE-TIME

The date the conversion trigger was last updated.

automation_block
INTEGER

cdate
DATE-TIME

conversion
INTEGER

The conversion ID.

Reference:

dynamic
INTEGER

modifier
STRING

retroactive
INTEGER

trigger_type
STRING

value
STRING


Replication Method :

Key-based Incremental

Replication Key :

mdate

Primary Key :

id

API endpoint :

List all deals

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

id
INTEGER

The deal ID.

Reference:

mdate
DATE-TIME

The deal mdate.

account
INTEGER

The account ID.

Reference:

activitycount
INTEGER

cdate
DATE-TIME

contact
INTEGER

The contact ID.

Reference:

currency
STRING

customer_account
INTEGER

description
STRING

edate
DATE-TIME

group
INTEGER

The pipeline ID.

Reference:

hash
STRING

is_disabled
BOOLEAN

next_task
INTEGER

nextdate
STRING

nextdealid
INTEGER

nexttaskid
INTEGER

organization
INTEGER

owner
INTEGER

percent
NUMBER

stage
INTEGER

The stage ID.

Reference:

status
INTEGER

title
STRING

value
NUMBER

win_probability
NUMBER

win_probability_mdate
DATE-TIME


Replication Method :

Key-based Incremental

Replication Key :

cdate

Primary Key :

id

API endpoint :

id
INTEGER

The deal activity ID.

cdate
DATE-TIME

The date the deal activity was created.

automation
INTEGER

The automation ID.

Reference:

d_id
INTEGER

d_stageid
INTEGER

data_action
STRING

data_id
INTEGER

data_oldval
STRING

data_type
STRING

deal
INTEGER

The deal ID.

Reference:

deleted
INTEGER

is_addtask
INTEGER

seriesid
INTEGER

sortdate
DATE-TIME

stage
INTEGER

The stage ID.

Reference:

user
INTEGER

userid
INTEGER

The user ID.