This integration is powered by Singer's ActiveCampaign tap and certified by Stitch. Check out and contribute to the repo on GitHub.
For support, contact Stitch support.
ActiveCampaign integration summary
Stitch’s ActiveCampaign integration replicates data using the ActiveCampaign v3 API. Refer to the Schema section for a list of objects available for replication.
ActiveCampaign feature snapshot
A high-level look at Stitch's ActiveCampaign (v1) integration, including release status, useful links, and the features supported in Stitch.
STITCH | |||
Release status |
Released on February 8, 2022 |
Supported by | |
Stitch plan |
Standard |
API availability |
Available |
Singer GitHub repository | |||
REPLICATION SETTINGS | |||
Anchor Scheduling |
Supported |
Advanced Scheduling |
Supported |
Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
DATA SELECTION | |||
Table selection |
Supported |
Column selection |
Supported |
Select all |
Supported |
||
TRANSPARENCY | |||
Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting ActiveCampaign
Step 1: Retrieve your ActiveCampaign API URL and token
- Login to your ActiveCampaign account.
- Go to the My Settings page.
- Click on the Developer tab.
- Copy your API URL and API token and keep them readily available for the next step.
Step 2: Add ActiveCampaign as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the ActiveCampaign icon.
-
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch ActiveCampaign” would create a schema called
stitch_activecampaign
in the destination. Note: Schema names cannot be changed after you save the integration. - In the API Token field, paste the token you copied from step 1.
- In the API Url field, paste the URL you copied from step 1.
Step 3: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your ActiveCampaign integration. This means that:
- 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:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Set objects to replicate
The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For ActiveCampaign integrations, you can select:
-
Individual tables and columns
-
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’s Tables to Replicate tab, locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
-
Click the Tables to Replicate tab.
- In the list of tables, click the box next to the Table Names column.
-
In the menu that displays, click Track all Tables and Fields:
- Click the Finalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up ActiveCampaign, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
ActiveCampaign table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
This is the latest version of the ActiveCampaign integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs
> customers
), while case is maintained in PostgreSQL destinations (CusTomERs
> CusTomERs
). Refer to the Loading Guide for your destination for more info.
accounts
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The accounts
table contains information about accounts in your ActiveCampaign account.
id
The account ID. Reference: |
updated_timestamp
The time the account was last updated. |
account_url
|
contact_count
|
created_timestamp
|
deal_count
|
name
|
account_contacts
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The account_contacts
table contains information about contacts in your ActiveCampaign account.
id
The account contact ID. |
updated_timestamp
The time the contact was last updated. |
account
The account ID. Reference: |
contact
The contact ID. Reference:
|
created_timestamp
|
job_title
|
account_custom_fields
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The account_custom_fields
table contains information about account custom fields in your ActiveCampaign account.
id
The custom field ID. Reference: |
updated_timestamp
The time the custom field was last updated. |
created_timestamp
|
display_order
|
field_default
|
field_default_currency
|
field_label
|
field_options
|
field_type
|
hide_field_flag
|
is_form_visible
|
is_required
|
known_field_id
|
personalization
|
account_custom_field_values
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The account_custom_field_values
table contains information about your account custom fields’ values in your ActiveCampaign account.
id
The custom field value ID. |
updated_timestamp
The time the custom field value was last updated. |
account_custom_field_metum_id
|
account_id
The account ID. Reference: |
created_timestamp
|
custom_field_id
The custom field ID. Reference: |
field_value
|
activities
Replication Method : |
Key-based Incremental |
Replication Key |
tstamp |
Primary Key |
id |
API endpoint : |
id
The activity ID. |
tstamp
The activity timestamp. |
json_data
|
permission
|
reference
|
reference_action
|
reference_id
|
reference_model_name
|
reference_type
|
subscriberid
|
user
|
userid
The user ID. Reference:
|
addresses
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
The addresses
table contains information about addresses in your ActiveCampaign account.
id
The address ID. Reference: |
address1
|
address2
|
allgroup
|
city
|
company_name
|
country
|
district
|
is_default
|
state
|
zip
|
automations
Replication Method : |
Key-based Incremental |
Replication Key |
mdate |
Primary Key |
id |
API endpoint : |
The automations
table contains information about automations in your ActiveCampaign account.
id
The automation ID. Reference: |
mdate
The date the automation was last modified. |
cdate
|
defaultscreenshot
|
entered
|
exited
|
hidden
|
name
|
screenshot
|
status
|
userid
The user ID. Reference:
|
automation_blocks
Replication Method : |
Key-based Incremental |
Replication Key |
|
Primary Key |
id |
API endpoint : |
id
The automation block ID. |
mdate
The date the block was last modified. |
automation
The automation ID. Reference: |
cdate
|
deleted
|
ordernum
|
params
|
parent
|
bounce_logs
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
None |
API endpoint : |
id
The bounce log ID. |
updated_timestamp
The time the bounce log was last updated. |
bounce
|
bounceid
|
campaign
|
campaignid
The campaign ID. Reference: |
code
|
codeid
|
contact
The contact ID. Reference:
|
created_by
|
created_timestamp
|
email
|
error
|
message
|
messageid
The message ID. Reference: |
source
|
subscriberid
|
tstamp
|
updated_by
|
brandings
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
The brandings
table contains information about existing branding resources in your ActiveCampaign account.
id
The branding resource ID. |
admin_template_css
|
admin_template_httm
|
copyright
|
favicon
|
footer_html_value
|
footer_text_value
|
group_id
|
header_html_value
|
header_text_value
|
help
|
license
|
public_template_css
|
public_template_httm
|
site_logo
|
site_logo_small
|
site_name
|
version
|
calendars
Replication Method : |
Key-based Incremental |
Replication Key |
mdate |
Primary Key |
id |
API endpoint : |
The calendars
table contains information about calendar feeds in your ActiveCampaign account.
id
The calendar feed ID. |
mdate
The date the calendar feed was last modified. |
cdate
|
notification
|
title
|
token
|
type
|
userid
The user ID. Reference:
|
campaigns
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The campaigns
table contains information about your campaigns in your ActiveCampaign account.
id
The campaign ID. Reference: |
updated_timestamp
The time the campaign was last updated. |
activerss_interval
|
activerss_items
|
activerss_url
|
addressid
The address ID. Reference: |
analytics_campaign_name
|
automation
The automation ID. Reference: |
basemessageid
|
basetemplateid
|
bounceid
|
cdate
|
created_timestamp
|
deletestamp
|
embed_images
|
facebook
|
formid
|
forwards
|
hardbounces
|
htmlunsub
|
htmlunsubdata
|
ip4
|
laststep
|
ldate
|
linkclicks
|
mail_cleanup
|
mail_send
|
mail_transfer
|
mailer_log_file
|
managetext
|
mdate
|
name
|
opens
|
public
|
realcid
|
recurring
|
reminder_field
|
reminder_format
|
reminder_last_cron_run
|
reminder_offset
|
reminder_offset_sign
|
reminder_offset_type
|
reminder_type
|
replies
|
replysys
|
responder_existing
|
responder_offset
|
responder_type
|
schedule
|
scheduleddate
|
sdate
|
segmentid
The segment ID. Reference: |
send_amt
|
sendid
|
seriesid
|
socialshares
|
softbounces
|
source
|
split_content
|
split_offset
|
split_offset_type
|
split_type
|
split_winner_awaiting
|
split_winner_messageid
|
status
|
subscriberclicks
|
survey
|
textunsub
|
textunsubdata
|
threadid
|
total_amt
|
tracklinks
|
tracklinksanalytics
|
trackreads
|
trackreadsanalytics
|
tweet
|
type
|
uniqueforwards
|
uniquelinkclicks
|
uniqueopens
|
uniquereplies
|
unsubreasons
|
unsubscribes
|
updates
|
user
|
userid
The user ID. Reference:
|
waitpreview
|
willrecur
|
campaign_links
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The campaign_links
table contains information about the links attached to your campaigns in your ActiveCampaign account.
id
The campaign link ID. |
updated_timestamp
The time the campaign link was last updated. |
campaign
|
campaignid
The campaign ID. Reference: |
created_by
|
created_timestamp
|
link
|
linkclicks
|
message
|
messageid
The message ID. Reference: |
name
|
ref
|
tracked
|
uniquelinkclicks
|
updated_by
|
campaign_lists
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
id
The campaign list ID. |
campaign
|
campaignid
The campaign ID. Reference: |
cdate
|
list
|
list_amt
|
listid
The list ID. Reference: |
name
|
udate
|
user
|
userid
The user ID. Reference:
|
campaign_messages
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
id
The campaign message ID. |
campaign
|
campaignid
The campaign ID. Reference: |
forwards
|
hardbounces
|
initial_split_percentage
|
linkclicks
|
message
|
messageid
The message ID. Reference: |
opens
|
percentage
|
replies
|
screenshot
|
send_amt
|
socialshares
|
softbounces
|
sourcesize
|
spamcheck_max
|
spamcheck_score
|
subject
|
subscriberclicks
|
total_amt
|
uniqueforwards
|
uniquelinkclicks
|
uniqueopens
|
uniquereplies
|
unsubreasons
|
unsubscribes
|
updates
|
configs
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
id
The configuration ID. |
updated_timestamp
The time the configuration was last updated. |
cdate
|
created_by
|
created_timestamp
|
item
|
keyname
|
owner
|
section
|
udate
|
updated_by
|
userid
The user ID. Reference:
|
val
|
contacts
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The contacts
table contains information about the people that you market or sell to in your ActiveCampaign account.
id
The contact ID. Reference:
|
updated_timestamp
The time the contact was last updated. |
account_contacts
|
adate
|
anonymized
|
bounced_date
|
bounced_hard
|
bounced_soft
|
cdate
|
created_by
|
created_timestamp
|
created_utc_timestamp
|
deleted
|
deleted_at
|
edate
|
email
|
email_domain
|
email_empty
|
email_local
|
first_name
|
gravatar
|
hash
|
ip
|
last_name
|
organization
|
orgid
|
phone
|
rating_tstamp
|
score_values
|
segmentio_id
|
sentcnt
|
socialdata_lastcheck
|
ua
|
udate
|
updated_by
|
updated_utc_timestamp
|
contact_automations
Replication Method : |
Key-based Incremental |
Replication Key |
|
Primary Key |
None |
API endpoint : |
The contact_automations
table contains information about automations in your ActiveCampaign account that you can add contacts to.
id
The contact automation ID. |
lastdate
The date the automation was last updated. |
adddate
|
automation
The automation ID. Reference: |
batchid
|
complete_value
|
completed
|
completed_elements
|
contact
The contact ID. Reference:
|
lastblock
|
lastlogid
|
remdate
|
seriesid
|
startid
|
status
|
timespan
|
total_elements
|
contact_conversions
Replication Method : |
Key-based Incremental |
Replication Key |
cdate |
Primary Key |
id |
API endpoint : |
id
The contact conversion ID. |
cdate
The date the contact conversion was created. |
contact
The contact ID. Reference:
|
conversion
The conversion ID. Reference: |
conversion_trigger
|
conversiontrigger
The conversion trigger ID. Reference: |
converted_by
|
converted_by_id
|
converted_by_type
|
currency
|
dynamic
|
modifier
|
trigger_type
|
value
|
contact_custom_fields
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
The contact_custom_fields
table contains information about custom fields for your contacts in your ActiveCampaign account.
id
The contact custom field ID. |
cdate
|
cols
|
defval
|
descript
|
isrequired
|
ordernum
|
perstag
|
rows
|
service
|
show_in_list
|
title
|
type
|
udate
|
visible
|
contact_custom_field_options
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
The contact_custom_field_options
table contains information about custom field options for your contacts in your ActiveCampaign account.
id
The contact custom field option ID. |
cdate
|
field
|
isdefault
|
label
|
orderid
The order ID. Reference: |
udate
|
value
|
contact_custom_field_rels
Replication Method : |
Full Table |
Primary Key |
id |
API endpoint : |
The contact_custom_field_rels
table contains information about custom field relationships for your contacts in your ActiveCampaign account.
id
The contact custom field relationship ID. |
cdate
|
dorder
|
field
|
relid
|
contact_custom_field_values
Replication Method : |
Key-based Incremental |
Replication Key |
udate |
Primary Key |
id |
API endpoint : |
The contact_custom_field_values
table contains information about custom field values for your contacts in your ActiveCampaign account.
id
The contact custom field value ID. |
udate
The custom field value’s udate. |
cdate
|
contact
The contact ID. Reference:
|
created_by
|
field
|
owner
|
updated_by
|
value
|
contact_data
Replication Method : |
Key-based Incremental |
Replication Key |
tstamp |
Primary Key |
id |
API endpoint : |
id
The contact datapoint ID. |
tstamp
The time the contact data timestamp. |
contact
The contact ID. Reference:
|
created_by
|
created_timestamp
|
fb_id
|
fb_name
|
ga_campaign_content
|
ga_campaign_customsegment
|
ga_campaign_medium
|
ga_campaign_name
|
ga_campaign_source
|
ga_campaign_term
|
ga_first_visit
|
ga_times_visited
|
geo_area
|
geo_city
|
geo_country
|
geo_country2
|
geo_ip4
|
geo_lat
|
geo_lon
|
geo_state
|
geo_tstamp
|
geo_tz
|
geo_tz_offset
|
geo_zip
|
tw_id
|
updated_by
|
updated_timestamp
|
contact_deals
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
The contact_deals
contains information about secondary contacts associated with a deal in your ActiveCampaign account.
id
The secondary contact ID. |
updated_timestamp
The time the secondary contact was last updated. |
cdate
|
contact
The contact ID. Reference:
|
created_by
|
created_timestamp
|
deal
The deal ID. Reference: |
role
|
updated_by
|
contact_emails
Replication Method : |
Key-based Incremental |
Replication Key |
sdate |
Primary Key |
id |
API endpoint : |
contact_lists
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
id
The contact list ID. |
updated_timestamp
The time the contact list was last updated. |
automation
|
autosync_log
|
campaign
The campaign ID. Reference: |
contact
The contact ID. Reference:
|
created_by
|
created_timestamp
|
first_name
|
form
The form ID. Reference: |
ip4_last
|
ip_4sub
|
ip_4unsub
|
last_name
|
list
The list ID. Reference: |
message
The message ID. Reference: |
responder
|
sdate
|
seriesid
|
sourceid
|
status
|
sync
|
udate
|
unsubreason
|
unsubscribe_automation
|
updated_by
|
contact_tags
Replication Method : |
Key-based Incremental |
Replication Key |
updated_timestamp |
Primary Key |
id |
API endpoint : |
conversions
Replication Method : |
Key-based Incremental |
Replication Key |
udate |
Primary Key |
id |
API endpoint : |
id
The conversion ID. Reference: |
udate
The date the conversion was last updated. |
cdate
|
currency
|
enforcelimit
|
limit
|
name
|
value
|
conversion_triggers
API endpoint : |
id
The conversion trigger ID. Reference: |
udate
The date the conversion trigger was last updated. |
automation_block
|
cdate
|
conversion
The conversion ID. Reference: |
dynamic
|
modifier
|
retroactive
|
trigger_type
|
value
|
Replication Method : |
Key-based Incremental |
Replication Key |
mdate |
Primary Key |
id |
API endpoint : |
The deals
table contains information about deals in your ActiveCampaign account.
id
The deal ID. Reference: |
mdate
The deal mdate. |
account
The account ID. Reference: |
activitycount
|
cdate
|
contact
The contact ID. Reference:
|
currency
|
customer_account
|
description
|
edate
|
group
The pipeline ID. Reference: |
hash
|
is_disabled
|
next_task
|
nextdate
|
nextdealid
|
nexttaskid
|
organization
|
owner
|
percent
|
stage
The stage ID. Reference: |
status
|
title
|
value
|
win_probability
|
win_probability_mdate
|
deal_activities
Replication Method : |
Key-based Incremental |
Replication Key |
cdate |
Primary Key |
id |
API endpoint : |
id
The deal activity ID. |
cdate
The date the deal activity was created. |
automation
The automation ID. Reference: |
d_id
|
d_stageid
|
data_action
|
data_id
|
data_oldval
|
data_type
|
deal
The deal ID. Reference: |
deleted
|
is_addtask
|
seriesid
|
sortdate
|
stage
The stage ID. Reference: |
user
|
userid
The user ID. |