ActiveCampaign

ActiveCampaign is a SaaS platform for small-to-mid-sized businesses. It offers marketing and sales automation.

For more information about the API, see ActiveCampaign v3 API.

See the Schema section for a list of objects available for replication.

Présentation générale de ce connecteur, y compris des liens utiles et les fonctions supportées.

Caractéristique/Fonctionnalité	Détails du support
Projets Qlik Talend Data Integration supportés	Projets de réplication uniquement. Les projets de pipeline de données ne sont pas supportés.
Méthodes de mise à jour de la cible	Tâches de réplication : Appliquer les modifications Stocker les modifications Tâches de dépôt temporaire de données dans un lac de données : Change Data Capture (CDC)
Gestion des métadonnées	La génération manuelle de métadonnées n'est pas nécessaire.
Évolution du schéma	Seule l'opération Modifier le type de données de la colonne est supportée.
Réplication de colonnes LOB (NCLOB, CLOB et BLOB)	Non supporté.
Opération CDC planifiée	Requis. C'est ainsi que la cible est mise à jour en fonction des modifications apportées à la source. Pour les tâches de réplication, consultez Planification de tâches . Pour les tâches de dépôt temporaire dans un lac, consultez Planification de CDC pour les tâches de dépôt temporaire dans un lac.
Notifications	Partiellement supporté Définition de notifications en cas de modifications du fonctionnement
Monitoring	CDC uniquement, car Chargement complet n'est pas pertinent pour ce connecteur. Surveillance d'une tâche de données individuelle
Désimbrication automatique des charges utiles des colonnes JSON	Non supporté. Les charges utiles des colonnes JSON des jeux de données sources ne sont pas automatiquement désimbriquées sur la cible.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assurez-vous que le compte que vous utilisez dispose d'un accès en lecture sur les tables à récupérer.

To retrieve your API URL and token:

Log into your ActiveCampaign account.
Go to the My Settings page.
Click the Developer tab.
Copy the API URL and API token.

Creating the connection

Pour plus d'informations, consultez Connexion à des applications SaaS.

Complétez les propriétés de connexion requises.
Fournissez un nom pour la connexion dans Nom de la connexion.
Sélectionnez Ouvrir les métadonnées de connexion pour définir les métadonnées de la connexion lors de sa création.
Cliquez sur Créer.

Connection settings
Setting	Description
Data gateway	Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation. Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune. Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données.
Start Date	Saisissez la date, au format `MM/DD/YYYY`, à partir de laquelle les données doivent être répliquées de votre source vers votre cible.
API Token	API token.
API URL	API URL.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

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

account_contacts

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

name

STRING

updated_timestamp

DATE-TIME

activities

Replication Method

CDC

Primary Key

Replication Key

tstamp

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

INTEGER

json_data

STRING

permission

STRING

reference

OBJECT

This is a nested data structure:

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

Useful links

ActiveCampaign documentation

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

INTEGER

is_default

BOOLEAN

state

STRING

zip

STRING

automation_blocks

Replication Method

CDC

Primary Key

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

mdate

DATE-TIME

ordernum

INTEGER

params

OBJECT

ARRAY

parent

INTEGER

automations

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

Replication Method	CDC
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation 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

mdate

DATE-TIME

name

STRING

screenshot

STRING

status

INTEGER

userid

INTEGER

bounce_logs

Replication Method

CDC

Replication Key

updated_timestamp

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

INTEGER

message

INTEGER

messageid

INTEGER

source

STRING

subscriberid

INTEGER

tstamp

DATE-TIME

updated_by

INTEGER

updated_timestamp

DATE-TIME

brandings

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

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

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	CDC
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation 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

INTEGER

mdate

DATE-TIME

notification

INTEGER

title

STRING

token

STRING

type

STRING

userid

INTEGER

campaign_links

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation ActiveCampaign API method

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

campaign

INTEGER

campaignid

INTEGER

created_by

INTEGER

created_timestamp

DATE-TIME

INTEGER

link

STRING

linkclicks

INTEGER

message

STRING

messageid

INTEGER

name

STRING

ref

STRING

tracked

INTEGER

uniquelinkclicks

INTEGER

updated_by

INTEGER

updated_timestamp

DATE-TIME

campaign_lists

Replication Method

Full Table

Primary Key

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

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

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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

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

CDC

Primary Key

Replication Key

updated_timestamp

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

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

CDC

Useful links

ActiveCampaign documentation

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

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

CDC

Primary Key

Replication Key

cdate

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

modifier

STRING

trigger_type

STRING

value

INTEGER

contact_custom_field_options

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

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

isdefault

INTEGER

label

STRING

orderid

INTEGER

udate

DATE-TIME

value

STRING

contact_custom_field_rels

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

ActiveCampaign API method

cdate

DATE-TIME

dorder

INTEGER

field

INTEGER

relid

INTEGER

contact_custom_field_values

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

Replication Method	CDC
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation 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

owner

INTEGER

udate

DATE-TIME

updated_by

INTEGER

value

STRING

contact_custom_fields

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

ActiveCampaign API method

cdate

DATE-TIME

cols

INTEGER

defval

STRING

descript

STRING

INTEGER

isrequired

INTEGER

ordernum

INTEGER

perstag

STRING

rows

INTEGER

service

STRING

show_in_list

INTEGER

title

STRING

type

STRING

udate

DATE-TIME

visible

INTEGER

contact_data

Replication Method

CDC

Primary Key

Replication Key

tstamp

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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

role

STRING

updated_by

INTEGER

updated_timestamp

DATE-TIME

contact_emails

Replication Method

CDC

Primary Key

Replication Key

sdate

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

STRING

message

INTEGER

messageheader

STRING

messageid

INTEGER

sdate

DATE-TIME

seriesid

INTEGER

source

STRING

subscriberid

INTEGER

user

INTEGER

userid

INTEGER

contact_lists

Replication Method

CDC

Primary Key

Replication Key

updated_timestamp

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

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

CDC

Primary Key

Replication Key

updated_timestamp

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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

INTEGER

STRING

last_name

STRING

organization

INTEGER

orgid

INTEGER

phone

STRING

rating_tstamp

STRING

score_values

ARRAY

segmentio_id

STRING

sentcnt

INTEGER

socialdata_lastcheck

DATE-TIME

STRING

udate

DATE-TIME

updated_by

INTEGER

updated_timestamp

DATE-TIME

updated_utc_timestamp

DATE-TIME

conversion_triggers

Replication Method

CDC

Primary Key

Replication Key

udate

Join conversion_triggers with

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

modifier

STRING

retroactive

INTEGER

trigger_type

STRING

udate

DATE-TIME

value

STRING

conversions

Replication Method

CDC

Primary Key

Replication Key

udate

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

limit

INTEGER

name

STRING

udate

DATE-TIME

value

INTEGER

deal_activities

Replication Method

CDC

Primary Key

Replication Key

cdate

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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

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

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

user

INTEGER

deal_groups

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

Replication Method	CDC
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation 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

order

INTEGER

title

STRING

udate

DATE-TIME

width

INTEGER

deals

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

Replication Method	CDC
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	tstamp
Useful links	ActiveCampaign documentation 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

INTEGER

total_orders

INTEGER

total_products

INTEGER

total_revenue

NUMBER

tstamp

DATE-TIME

ecommerce_order_activities

Replication Method

CDC

Primary Key

Replication Key

updated_date

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

INTEGER

logo_url

STRING

order

INTEGER

order_number

STRING

order_url

STRING

orderid

INTEGER

shipping_amount

NUMBER

shipping_method

STRING

source

INTEGER

state

INTEGER

store_name

STRING

tax_amount

NUMBER

total_price

NUMBER

total_products

INTEGER

updated_date

DATE-TIME

ecommerce_order_products

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

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

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	CDC
Primary Key	id
Replication Key	updated_date
Useful links	ActiveCampaign documentation 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

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

CDC

Primary Key

Replication Key

tstamp

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

INTEGER

message

STRING

message_html

STRING

reference

OBJECT

This is a nested data structure:

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	CDC
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation 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

This is a nested data structure: ARRAY, which is also a nested data structure.

actions

email: STRING
list: INTEGER
type: STRING

address

INTEGER

addressid

INTEGER

aid

INTEGER

body

STRING

button

STRING

cdate

DATE-TIME

cfields

OBJECT

This is a nested data structure: ARRAY, which is also a nested data structure.

cfields

class: STRING
default_text: STRING
header: STRING
html: STRING
required: BOOLEAN
type: STRING

contacts

INTEGER

deals

INTEGER

defaultscreenshot

STRING

entries

INTEGER

layout

STRING

name

STRING

options

OBJECT

This is a nested data structure:

blank_overwrite: BOOLEAN
confaction: STRING
confform: STRING
optin_created: BOOLEAN
optin_id: INTEGER
sendoptin: BOOLEAN

parentformid

INTEGER

recent

ARRAY

style

OBJECT

This is a nested data structure: OBJECT, which is also a nested data structure.

style

ac_branding: BOOLEAN
background: STRING
border: OBJECT, which is also a nested data structure:
- color: STRING
- radius: INTEGER
- style: STRING
- width: INTEGER
button: OBJECT, which is also a nested data structure:
- background: STRING
- border: OBJECT, which is also a nested data structure:
  - color: STRING
  - radius: INTEGER
  - style: STRING
  - width: INTEGER
fontcolor: STRING
padding: STRING
dark: BOOLEAN
fontcolor: STRING
layout: STRING
width: STRING

submit

STRING

submitdata

OBJECT

This is a nested data structure:

type: STRING

thanks

STRING

title

STRING

udate

DATE-TIME

url

STRING

userid

INTEGER

goals

Replication Method

Full Table

Primary Key

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

name

STRING

seriesid

INTEGER

groups

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

ActiveCampaign API method

descript

STRING

INTEGER

optinconfirm

INTEGER

p_admin

INTEGER

pg_automation_manage

INTEGER

pg_contact_actions

INTEGER

pg_contact_add

INTEGER

pg_contact_approve

INTEGER

pg_contact_delete

INTEGER

pg_contact_edit

INTEGER

pg_contact_export

INTEGER

pg_contact_fields

INTEGER

pg_contact_filters

INTEGER

pg_contact_import

INTEGER

pg_contact_merge

INTEGER

pg_contact_sync

INTEGER

pg_deal

INTEGER

pg_deal_delete

INTEGER

pg_deal_group_add

INTEGER

pg_deal_group_delete

INTEGER

pg_deal_group_edit

INTEGER

pg_deal_reassign

INTEGER

pg_form_edit

INTEGER

pg_group_add

INTEGER

pg_group_delete

INTEGER

pg_group_edit

INTEGER

pg_list_add

INTEGER

pg_list_bounce

INTEGER

pg_list_delete

INTEGER

pg_list_edit

INTEGER

pg_list_emailaccount

INTEGER

pg_list_headers

INTEGER

pg_message_add

INTEGER

pg_message_delete

INTEGER

pg_message_edit

INTEGER

pg_message_send

INTEGER

pg_personalization_add

INTEGER

pg_personalization_delete

INTEGER

pg_personalization_edit

INTEGER

pg_reports_campaign

INTEGER

pg_reports_list

INTEGER

pg_reports_trend

INTEGER

pg_reports_user

INTEGER

pg_saved_responses_manage

INTEGER

pg_startup_gettingstarted

INTEGER

pg_startup_reports

INTEGER

pg_template_add

INTEGER

pg_template_delete

INTEGER

pg_template_edit

INTEGER

pg_user_add

INTEGER

pg_user_delete

INTEGER

pg_user_edit

INTEGER

req_approval

INTEGER

req_approval1st

INTEGER

req_approval_notify

INTEGER

sdate

DATE-TIME

socialdata

INTEGER

title

STRING

unsubscribelink

INTEGER

lists

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

Replication Method	CDC
Primary Key	id
Replication Key	updated_timestamp
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign documentation 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

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	CDC
Primary Key	id
Replication Key	mdate
Useful links	ActiveCampaign API method

cdate

DATE-TIME

descript

STRING

INTEGER

mdate

DATE-TIME

name

STRING

reltype

STRING

status

INTEGER

segments

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

ActiveCampaign API method

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

created_by

INTEGER

created_timestamp

DATE-TIME

hidden

INTEGER

logic

STRING

name

STRING

seriesid

INTEGER

updated_by

INTEGER

updated_timestamp

DATE-TIME

site_messages

Replication Method

CDC

Primary Key

Replication Key

ldate

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

ldate

DATE-TIME

name

STRING

template

OBJECT

This is a nested data structure:

detailed: OBJECT, which is also a nested data structure.
initial: OBJECT, which is also a nested data structure.

sms

Replication Method

CDC

Primary Key

Replication Key

ldate

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

ldate

DATE-TIME

msg

STRING

replies

INTEGER

sdate

DATE-TIME

sent

INTEGER

seriesid

INTEGER

tf_day

STRING

tf_hr_from

INTEGER

tf_hr_to

INTEGER

tstamp

DATE-TIME

uniquereplies

INTEGER

unsubscribes

INTEGER

user

INTEGER

userid

INTEGER

task_types

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

ActiveCampaign API method

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

cdate

DATE-TIME

defduration

INTEGER

status

INTEGER

title

STRING

udate

DATE-TIME

tasks

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

Replication Method	CDC
Primary Key	id
Replication Key	udate
Useful links	ActiveCampaign documentation 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

INTEGER

note

STRING

owner

OBJECT

This is a nested data structure:

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	CDC
Primary Key	id
Replication Key	mdate
Useful links	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

importnum

INTEGER

mdate

DATE-TIME

modified

INTEGER

name

STRING

preview_content

STRING

screenshot

STRING

subject

STRING

used

INTEGER

userid

INTEGER

waitpreview

INTEGER

users

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

Replication Method

Full Table

Primary Key

Useful links

ActiveCampaign documentation

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

INTEGER

last_name

STRING

local_zoneid

STRING

mfa_enabled

INTEGER

password_updated_utc_timestamp

DATE-TIME

phone

STRING

signature

STRING

udate

DATE-TIME

username

STRING

webhooks

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

Replication Method

Full Table

Primary Key

Useful links

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

INTEGER

listid

INTEGER

name

STRING

sources

ARRAY

url

STRING

Cette page vous a-t-elle aidé ?

Si vous rencontrez des problèmes sur cette page ou dans son contenu – une faute de frappe, une étape manquante ou une erreur technique – faites-le-nous savoir.

Laissez vos commentaires ici