# 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](https://developers.activecampaign.com/reference#overview).

See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#Schema) section for a list of objects available for replication.

## Preparing for authentication

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

Information noteMake sure that the account you use has read access to the tables you want to fetch.

To retrieve your API URL and token:

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

## Creating the connection

For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).

1. Fill in the required connection properties.

2. Provide a name for the connection in Connection name.

3. Select Open connection metadata to define metadata for the connection when it has been created.

4. Click Create.

Connection settings

| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.<br><br>Information note<br><br>This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.<br><br>For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| API Token | API token. |
| API URL | API URL. |

## Schema

Information note

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

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](https://developers.activecampaign.com/reference#account-contacts)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-associations-1 "Opens in new tab: ActiveCampaign API method") |

account\_contacts table foreign keys

| Join account\_contacts with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#accounts) | ```<br>account_contacts.account = accounts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>account_contacts.account = deals.account<br>```<br><br>```<br>account_contacts.contact = deals.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>account_contacts.account = contact_emails.account<br>```<br><br>```<br>account_contacts.contact = contact_emails.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>account_contacts.account = email_activities.account<br>```<br><br>```<br>account_contacts.contact = email_activities.contact<br>``` |
| [account_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-custom-field-values) | ```<br>account_contacts.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>account_contacts.contact = contacts.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>account_contacts.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>account_contacts.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>account_contacts.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>account_contacts.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>account_contacts.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>account_contacts.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>account_contacts.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>account_contacts.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>account_contacts.contact = contact_deals.contact<br>``` |

account\_contacts table schema

| **account**<br><br><br>INTEGER |
| --- |
| **contact**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **job\_title**<br><br><br>STRING |
| **updated\_timestamp**<br><br><br>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](https://developers.activecampaign.com/reference#custom-account-field-values)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-custom-field-values-2 "Opens in new tab: ActiveCampaign API method") |

account\_custom\_field\_values table foreign keys

| Join account\_custom\_field\_values with | on |
| --- | --- |
| [account_custom_fields](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-custom-fields) | ```<br>account_custom_field_values.custom_field_id = account_custom_fields.id<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#accounts) | ```<br>account_custom_field_values.account_id = accounts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>account_custom_field_values.account_id = deals.account<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>account_custom_field_values.account_id = contact_emails.account<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>account_custom_field_values.account_id = email_activities.account<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>account_custom_field_values.account_id = account_contacts.account<br>``` |

account\_custom\_field\_values table schema

| **account\_custom\_field\_metum\_id**<br><br><br>INTEGER |
| --- |
| **account\_id**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **custom\_field\_id**<br><br><br>INTEGER |
| **field\_value**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>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](https://developers.activecampaign.com/reference#custom-account-fields-1)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-custom-fields "Opens in new tab: ActiveCampaign API method") |

account\_custom\_fields table foreign keys

| Join account\_custom\_fields with | on |
| --- | --- |
| [account_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-custom-field-values) | ```<br>account_custom_fields.id = account_custom_field_values.custom_field_id<br>``` |

account\_custom\_fields table schema

| **created\_timestamp**<br><br><br>DATE-TIME |
| --- |
| **display\_order**<br><br><br>INTEGER |
| **field\_default**<br><br><br>STRING |
| **field\_default\_currency**<br><br><br>STRING |
| **field\_label**<br><br><br>STRING |
| **field\_options**<br><br>ARRAY |
| **field\_type**<br><br><br>STRING |
| **hide\_field\_flag**<br><br><br>BOOLEAN |
| **id**<br><br><br>INTEGER |
| **is\_form\_visible**<br><br><br>BOOLEAN |
| **is\_required**<br><br><br>BOOLEAN |
| **known\_field\_id**<br><br><br>INTEGER |
| **personalization**<br><br><br>STRING |
| **updated\_timestamp**<br><br><br>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](https://developers.activecampaign.com/reference#accounts)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-accounts "Opens in new tab: ActiveCampaign API method") |

accounts table foreign keys

| Join accounts with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>accounts.id = deals.account<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>accounts.id = contact_emails.account<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>accounts.id = email_activities.account<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>accounts.id = account_contacts.account<br>``` |
| [account_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-custom-field-values) | ```<br>accounts.id = account_custom_field_values.account_id<br>``` |

accounts table schema

| **account\_url**<br><br><br>STRING |
| --- |
| **contact\_count**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **deal\_count**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### activities

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | tstamp |

activities table foreign keys

| Join activities with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>activities.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>activities.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>activities.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>activities.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>activities.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>activities.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>activities.userid = templates.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>activities.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>activities.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>activities.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>activities.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>activities.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>activities.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>activities.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>activities.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>activities.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>activities.userid = campaigns.userid<br>``` |

activities table schema

| **id**<br><br><br>INTEGER |
| --- |
| **json\_data**<br><br><br>STRING |
| **permission**<br><br><br>STRING |
| **reference**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li><b>id</b>: INTEGER</li><li><b>type</b>: STRING</li></ul> |
| **reference\_action**<br><br><br>STRING |
| **reference\_id**<br><br><br>INTEGER |
| **reference\_model\_name**<br><br><br>STRING |
| **reference\_type**<br><br><br>STRING |
| **subscriberid**<br><br><br>INTEGER |
| **tstamp**<br><br><br>DATE-TIME |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>INTEGER |

### addresses

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#address)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-addresses "Opens in new tab: ActiveCampaign API method") |

addresses table foreign keys

| Join addresses with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>addresses.id = campaigns.addressid<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>addresses.id = forms.addressid<br>``` |

addresses table schema

| **address1**<br><br><br>STRING |
| --- |
| **address2**<br><br><br>STRING |
| **allgroup**<br><br><br>INTEGER |
| **city**<br><br><br>STRING |
| **company\_name**<br><br><br>STRING |
| **country**<br><br><br>STRING |
| **district**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **is\_default**<br><br><br>BOOLEAN |
| **state**<br><br><br>STRING |
| **zip**<br><br><br>STRING |

### automation\_blocks

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |

automation\_blocks table foreign keys

| Join automation\_blocks with | on |
| --- | --- |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>automation_blocks.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>automation_blocks.automation = deal_activities.automation<br>``` |
| [goals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#goals) | ```<br>automation_blocks.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#site-messages) | ```<br>automation_blocks.automation = site_messages.automation<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>automation_blocks.automation = sms.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>automation_blocks.automation = campaigns.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>automation_blocks.automation = contact_automations.automation<br>``` |

automation\_blocks table schema

| **automation**<br><br><br>INTEGER |
| --- |
| **cdate**<br><br><br>DATE-TIME |
| **deleted**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **mdate**<br><br><br>DATE-TIME |
| **ordernum**<br><br><br>INTEGER |
| **params**<br><br>OBJECT<br><br>ARRAY |
| **parent**<br><br><br>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](https://developers.activecampaign.com/reference#automation)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-automations "Opens in new tab: ActiveCampaign API method") |

automations table foreign keys

| Join automations with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>automations.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>automations.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>automations.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>automations.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>automations.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>automations.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>automations.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>automations.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>automations.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>automations.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>automations.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>automations.userid = deal_activities.userid<br>```<br><br>```<br>automations.id = deal_activities.automation<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>automations.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>automations.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>automations.userid = sms.userid<br>```<br><br>```<br>automations.id = sms.automation<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>automations.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>automations.userid = campaigns.userid<br>```<br><br>```<br>automations.id = campaigns.automation<br>``` |
| [goals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#goals) | ```<br>automations.id = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#site-messages) | ```<br>automations.id = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automation-blocks) | ```<br>automations.id = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>automations.id = contact_automations.automation<br>``` |

automations table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **defaultscreenshot**<br><br><br>STRING |
| **entered**<br><br><br>INTEGER |
| **exited**<br><br><br>INTEGER |
| **hidden**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **mdate**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **screenshot**<br><br><br>STRING |
| **status**<br><br><br>INTEGER |
| **userid**<br><br><br>INTEGER |

### bounce\_logs

| **Replication Method** | CDC |
| --- | --- |
| **Replication Key** | updated\_timestamp |

bounce\_logs table foreign keys

| Join bounce\_logs with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>bounce_logs.campaignid = campaigns.id<br>``` |
| [campaign_links](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-links) | ```<br>bounce_logs.campaignid = campaign_links.campaignid<br>```<br><br>```<br>bounce_logs.messageid = campaign_links.messageid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>bounce_logs.campaignid = campaign_lists.campaignid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-messages) | ```<br>bounce_logs.campaignid = campaign_messages.campaignid<br>```<br><br>```<br>bounce_logs.messageid = campaign_messages.messageid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>bounce_logs.campaignid = contact_lists.campaign<br>```<br><br>```<br>bounce_logs.contact = contact_lists.contact<br>```<br><br>```<br>bounce_logs.messageid = contact_lists.message<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>bounce_logs.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>bounce_logs.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>bounce_logs.contact = forms.contacts<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>bounce_logs.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>bounce_logs.contact = contact_emails.contact<br>```<br><br>```<br>bounce_logs.messageid = contact_emails.messageid<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>bounce_logs.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>bounce_logs.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>bounce_logs.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>bounce_logs.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>bounce_logs.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>bounce_logs.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>bounce_logs.contact = contact_deals.contact<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>bounce_logs.messageid = messages.id<br>``` |

bounce\_logs table schema

| **bounce**<br><br><br>INTEGER |
| --- |
| **bounceid**<br><br><br>INTEGER |
| **campaign**<br><br><br>INTEGER |
| **campaignid**<br><br><br>INTEGER |
| **code**<br><br><br>INTEGER |
| **codeid**<br><br><br>INTEGER |
| **contact**<br><br><br>INTEGER |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **email**<br><br><br>STRING |
| **error**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **message**<br><br><br>INTEGER |
| **messageid**<br><br><br>INTEGER |
| **source**<br><br><br>STRING |
| **subscriberid**<br><br><br>INTEGER |
| **tstamp**<br><br><br>DATE-TIME |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### brandings

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#branding)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#brandings "Opens in new tab: ActiveCampaign API method") |

brandings table schema

| **admin\_template\_css**<br><br><br>STRING |
| --- |
| **admin\_template\_htm**<br><br><br>STRING |
| **copyright**<br><br><br>INTEGER |
| **favicon**<br><br><br>STRING |
| **footer\_html\_value**<br><br><br>STRING |
| **footer\_text\_value**<br><br><br>STRING |
| **groupid**<br><br><br>STRING |
| **header\_html\_value**<br><br><br>STRING |
| **header\_text\_value**<br><br><br>STRING |
| **help**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **license**<br><br><br>INTEGER |
| **public\_template\_css**<br><br><br>STRING |
| **public\_template\_htm**<br><br><br>STRING |
| **site\_logo**<br><br><br>STRING |
| **site\_logo\_small**<br><br><br>STRING |
| **site\_name**<br><br><br>STRING |
| **version**<br><br><br>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](https://developers.activecampaign.com/reference#calendar-feeds)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-calendar-feeds "Opens in new tab: ActiveCampaign API method") |

calendars table foreign keys

| Join calendars with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>calendars.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>calendars.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>calendars.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>calendars.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>calendars.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>calendars.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>calendars.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>calendars.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>calendars.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>calendars.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>calendars.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>calendars.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>calendars.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>calendars.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>calendars.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>calendars.userid = automations.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>calendars.userid = campaigns.userid<br>``` |

calendars table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **id**<br><br><br>INTEGER |
| **mdate**<br><br><br>DATE-TIME |
| **notification**<br><br><br>INTEGER |
| **title**<br><br><br>STRING |
| **token**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **userid**<br><br><br>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](https://developers.activecampaign.com/reference#test-1)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#retrieve-links-associated-campaign "Opens in new tab: ActiveCampaign API method") |

campaign\_links table foreign keys

| Join campaign\_links with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>campaign_links.campaignid = campaigns.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>campaign_links.campaignid = bounce_logs.campaignid<br>```<br><br>```<br>campaign_links.messageid = bounce_logs.messageid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>campaign_links.campaignid = campaign_lists.campaignid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-messages) | ```<br>campaign_links.campaignid = campaign_messages.campaignid<br>```<br><br>```<br>campaign_links.messageid = campaign_messages.messageid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>campaign_links.campaignid = contact_lists.campaign<br>```<br><br>```<br>campaign_links.messageid = contact_lists.message<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>campaign_links.messageid = messages.id<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>campaign_links.messageid = contact_emails.messageid<br>``` |

campaign\_links table schema

| **campaign**<br><br><br>INTEGER |
| --- |
| **campaignid**<br><br><br>INTEGER |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **link**<br><br><br>STRING |
| **linkclicks**<br><br><br>INTEGER |
| **message**<br><br><br>STRING |
| **messageid**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **ref**<br><br><br>STRING |
| **tracked**<br><br><br>INTEGER |
| **uniquelinkclicks**<br><br><br>INTEGER |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### campaign\_lists

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |

campaign\_lists table foreign keys

| Join campaign\_lists with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>campaign_lists.campaignid = campaigns.id<br>```<br><br>```<br>campaign_lists.userid = campaigns.userid<br>``` |
| [campaign_links](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-links) | ```<br>campaign_lists.campaignid = campaign_links.campaignid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>campaign_lists.campaignid = bounce_logs.campaignid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-messages) | ```<br>campaign_lists.campaignid = campaign_messages.campaignid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>campaign_lists.campaignid = contact_lists.campaign<br>```<br><br>```<br>campaign_lists.listid = contact_lists.list<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>campaign_lists.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>campaign_lists.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>campaign_lists.userid = lists.userid<br>```<br><br>```<br>campaign_lists.listid = lists.id<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>campaign_lists.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>campaign_lists.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>campaign_lists.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>campaign_lists.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>campaign_lists.userid = activities.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>campaign_lists.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>campaign_lists.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>campaign_lists.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>campaign_lists.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>campaign_lists.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>campaign_lists.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>campaign_lists.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>campaign_lists.userid = calendars.userid<br>``` |
| [webhooks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#webhooks) | ```<br>campaign_lists.listid = webhooks.listid<br>``` |

campaign\_lists table schema

| **campaign**<br><br><br>INTEGER |
| --- |
| **campaignid**<br><br><br>INTEGER |
| **cdate**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **list**<br><br><br>INTEGER |
| **list\_amt**<br><br><br>INTEGER |
| **listid**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>INTEGER |

### campaign\_messages

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |

campaign\_messages table foreign keys

| Join campaign\_messages with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>campaign_messages.campaignid = campaigns.id<br>``` |
| [campaign_links](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-links) | ```<br>campaign_messages.campaignid = campaign_links.campaignid<br>```<br><br>```<br>campaign_messages.messageid = campaign_links.messageid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>campaign_messages.campaignid = bounce_logs.campaignid<br>```<br><br>```<br>campaign_messages.messageid = bounce_logs.messageid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>campaign_messages.campaignid = campaign_lists.campaignid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>campaign_messages.campaignid = contact_lists.campaign<br>```<br><br>```<br>campaign_messages.messageid = contact_lists.message<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>campaign_messages.messageid = messages.id<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>campaign_messages.messageid = contact_emails.messageid<br>``` |

campaign\_messages table schema

| **campaign**<br><br><br>INTEGER |
| --- |
| **campaignid**<br><br><br>INTEGER |
| **forwards**<br><br><br>INTEGER |
| **hardbounces**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **initial\_split\_percentage**<br><br>NUMBER |
| **linkclicks**<br><br><br>INTEGER |
| **message**<br><br><br>INTEGER |
| **messageid**<br><br><br>INTEGER |
| **opens**<br><br><br>INTEGER |
| **percentage**<br><br>NUMBER |
| **replies**<br><br><br>INTEGER |
| **screenshot**<br><br><br>STRING |
| **send\_amt**<br><br><br>INTEGER |
| **socialshares**<br><br><br>INTEGER |
| **softbounces**<br><br><br>INTEGER |
| **sourcesize**<br><br><br>INTEGER |
| **spamcheck\_max**<br><br><br>INTEGER |
| **spamcheck\_score**<br><br><br>INTEGER |
| **subject**<br><br><br>STRING |
| **subscriberclicks**<br><br><br>INTEGER |
| **total\_amt**<br><br><br>INTEGER |
| **uniqueforwards**<br><br><br>INTEGER |
| **uniquelinkclicks**<br><br><br>INTEGER |
| **uniqueopens**<br><br><br>INTEGER |
| **uniquereplies**<br><br><br>INTEGER |
| **unsubreasons**<br><br><br>INTEGER |
| **unsubscribes**<br><br><br>INTEGER |
| **updates**<br><br><br>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](https://developers.activecampaign.com/reference#test-1)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-campaigns "Opens in new tab: ActiveCampaign API method") |

campaigns table foreign keys

| Join campaigns with | on |
| --- | --- |
| [addresses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#addresses) | ```<br>campaigns.addressid = addresses.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>campaigns.addressid = forms.addressid<br>```<br><br>```<br>campaigns.userid = forms.userid<br>``` |
| [campaign_links](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-links) | ```<br>campaigns.id = campaign_links.campaignid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>campaigns.id = bounce_logs.campaignid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>campaigns.id = campaign_lists.campaignid<br>```<br><br>```<br>campaigns.userid = campaign_lists.userid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-messages) | ```<br>campaigns.id = campaign_messages.campaignid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>campaigns.id = contact_lists.campaign<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>campaigns.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>campaigns.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>campaigns.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>campaigns.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>campaigns.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>campaigns.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>campaigns.userid = activities.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>campaigns.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>campaigns.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>campaigns.userid = deal_activities.userid<br>```<br><br>```<br>campaigns.automation = deal_activities.automation<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>campaigns.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>campaigns.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>campaigns.userid = sms.userid<br>```<br><br>```<br>campaigns.automation = sms.automation<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>campaigns.userid = automations.userid<br>```<br><br>```<br>campaigns.automation = automations.id<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>campaigns.userid = calendars.userid<br>``` |
| [goals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#goals) | ```<br>campaigns.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#site-messages) | ```<br>campaigns.automation = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automation-blocks) | ```<br>campaigns.automation = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>campaigns.automation = contact_automations.automation<br>``` |
| [segments](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#segments) | ```<br>campaigns.segmentid = segments.id<br>``` |

campaigns table schema

| **activerss\_interval**<br><br><br>STRING |
| --- |
| **activerss\_items**<br><br><br>INTEGER |
| **activerss\_url**<br><br><br>STRING |
| **addressid**<br><br><br>INTEGER |
| **analytics\_campaign\_name**<br><br><br>STRING |
| **automation**<br><br><br>INTEGER |
| **basemessageid**<br><br><br>INTEGER |
| **basetemplateid**<br><br><br>STRING |
| **bounceid**<br><br><br>INTEGER |
| **cdate**<br><br><br>DATE-TIME |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **deletestamp**<br><br><br>DATE-TIME |
| **embed\_images**<br><br><br>INTEGER |
| **facebook**<br><br><br>INTEGER |
| **formid**<br><br><br>INTEGER |
| **forwards**<br><br><br>INTEGER |
| **hardbounces**<br><br><br>INTEGER |
| **htmlunsub**<br><br><br>INTEGER |
| **htmlunsubdata**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **ip4**<br><br><br>STRING |
| **laststep**<br><br><br>STRING |
| **ldate**<br><br><br>DATE-TIME |
| **linkclicks**<br><br><br>INTEGER |
| **mail\_cleanup**<br><br><br>INTEGER |
| **mail\_send**<br><br><br>INTEGER |
| **mail\_transfer**<br><br><br>INTEGER |
| **mailer\_log\_file**<br><br><br>INTEGER |
| **managetext**<br><br><br>INTEGER |
| **mdate**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **opens**<br><br><br>INTEGER |
| **public**<br><br><br>INTEGER |
| **realcid**<br><br><br>INTEGER |
| **recurring**<br><br><br>STRING |
| **reminder\_field**<br><br><br>STRING |
| **reminder\_format**<br><br><br>STRING |
| **reminder\_last\_cron\_run**<br><br><br>STRING |
| **reminder\_offset**<br><br><br>INTEGER |
| **reminder\_offset\_sign**<br><br><br>STRING |
| **reminder\_offset\_type**<br><br><br>STRING |
| **reminder\_type**<br><br><br>STRING |
| **replies**<br><br><br>INTEGER |
| **replysys**<br><br><br>INTEGER |
| **responder\_existing**<br><br><br>INTEGER |
| **responder\_offset**<br><br><br>INTEGER |
| **responder\_type**<br><br><br>STRING |
| **schedule**<br><br><br>INTEGER |
| **scheduleddate**<br><br><br>STRING |
| **sdate**<br><br><br>DATE-TIME |
| **segmentid**<br><br><br>INTEGER |
| **send\_amt**<br><br><br>INTEGER |
| **sendid**<br><br><br>INTEGER |
| **seriesid**<br><br><br>INTEGER |
| **socialshares**<br><br><br>INTEGER |
| **softbounces**<br><br><br>INTEGER |
| **source**<br><br><br>STRING |
| **split\_content**<br><br><br>INTEGER |
| **split\_offset**<br><br><br>INTEGER |
| **split\_offset\_type**<br><br><br>STRING |
| **split\_type**<br><br><br>STRING |
| **split\_winner\_awaiting**<br><br><br>INTEGER |
| **split\_winner\_messageid**<br><br><br>INTEGER |
| **status**<br><br><br>INTEGER |
| **subscriberclicks**<br><br><br>INTEGER |
| **survey**<br><br><br>STRING |
| **textunsub**<br><br><br>INTEGER |
| **textunsubdata**<br><br><br>STRING |
| **threadid**<br><br><br>INTEGER |
| **total\_amt**<br><br><br>INTEGER |
| **tracklinks**<br><br><br>STRING |
| **tracklinksanalytics**<br><br><br>INTEGER |
| **trackreads**<br><br><br>INTEGER |
| **trackreadsanalytics**<br><br><br>INTEGER |
| **tweet**<br><br><br>INTEGER |
| **type**<br><br><br>STRING |
| **uniqueforwards**<br><br><br>INTEGER |
| **uniquelinkclicks**<br><br><br>INTEGER |
| **uniqueopens**<br><br><br>INTEGER |
| **uniquereplies**<br><br><br>INTEGER |
| **unsubreasons**<br><br><br>INTEGER |
| **unsubscribes**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |
| **updates**<br><br><br>INTEGER |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>INTEGER |
| **waitpreview**<br><br><br>INTEGER |
| **willrecur**<br><br><br>INTEGER |

### configs

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_timestamp |

configs table foreign keys

| Join configs with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>configs.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>configs.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>configs.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>configs.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>configs.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>configs.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>configs.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>configs.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>configs.userid = campaign_lists.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>configs.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>configs.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>configs.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>configs.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>configs.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>configs.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>configs.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>configs.userid = campaigns.userid<br>``` |

configs table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **item**<br><br><br>STRING |
| **keyname**<br><br><br>STRING |
| **owner**<br><br><br>INTEGER |
| **section**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |
| **userid**<br><br><br>INTEGER |
| **val**<br><br><br>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](https://developers.activecampaign.com/reference#automations)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-contact-automations "Opens in new tab: ActiveCampaign API method") |

contact\_automations table foreign keys

| Join contact\_automations with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_automations.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_automations.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_automations.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_automations.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contact_automations.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contact_automations.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contact_automations.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contact_automations.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contact_automations.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_automations.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_automations.contact = account_contacts.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contact_automations.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contact_automations.contact = contact_deals.contact<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>contact_automations.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>contact_automations.automation = deal_activities.automation<br>``` |
| [goals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#goals) | ```<br>contact_automations.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#site-messages) | ```<br>contact_automations.automation = site_messages.automation<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>contact_automations.automation = sms.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automation-blocks) | ```<br>contact_automations.automation = automation_blocks.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>contact_automations.automation = campaigns.automation<br>``` |

contact\_automations table schema

| **adddate**<br><br><br>DATE-TIME |
| --- |
| **automation**<br><br><br>INTEGER |
| **batchid**<br><br><br>STRING |
| **complete\_value**<br><br><br>INTEGER |
| **completed**<br><br><br>INTEGER |
| **completed\_elements**<br><br><br>INTEGER |
| **contact**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **lastblock**<br><br><br>INTEGER |
| **lastdate**<br><br><br>DATE-TIME |
| **lastlogid**<br><br><br>INTEGER |
| **remdate**<br><br><br>DATE-TIME |
| **seriesid**<br><br><br>INTEGER |
| **startid**<br><br><br>INTEGER |
| **status**<br><br><br>INTEGER |
| **timespan**<br><br><br>INTEGER |
| **total\_elements**<br><br><br>INTEGER |

### contact\_conversions

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | cdate |

contact\_conversions table foreign keys

| Join contact\_conversions with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_conversions.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_conversions.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_conversions.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_conversions.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contact_conversions.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contact_conversions.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contact_conversions.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contact_conversions.contact = contact_tags.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_conversions.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_conversions.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contact_conversions.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contact_conversions.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contact_conversions.contact = contact_deals.contact<br>``` |
| [conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#conversions) | ```<br>contact_conversions.conversion = conversions.id<br>``` |
| [conversion_triggers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#conversion-triggers) | ```<br>contact_conversions.conversion = conversion_triggers.conversion<br>```<br><br>```<br>contact_conversions.conversiontrigger = conversion_triggers.id<br>``` |

contact\_conversions table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **contact**<br><br><br>INTEGER |
| **conversion**<br><br><br>INTEGER |
| **conversion\_trigger**<br><br><br>INTEGER |
| **conversiontrigger**<br><br><br>INTEGER |
| **converted\_by**<br><br><br>INTEGER |
| **converted\_by\_id**<br><br><br>INTEGER |
| **converted\_by\_type**<br><br><br>STRING |
| **currency**<br><br><br>STRING |
| **dynamic**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **modifier**<br><br><br>STRING |
| **trigger\_type**<br><br><br>STRING |
| **value**<br><br><br>INTEGER |

### contact\_custom\_field\_options

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#fields)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#retrieve-fields-1 "Opens in new tab: ActiveCampaign API method") |

contact\_custom\_field\_options table foreign keys

| Join contact\_custom\_field\_options with | on |
| --- | --- |
| [ecommerce_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-orders) | ```<br>contact_custom_field_options.orderid = ecommerce_orders.id<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-products) | ```<br>contact_custom_field_options.orderid = ecommerce_order_products.orderid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-activities) | ```<br>contact_custom_field_options.orderid = ecommerce_order_activities.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>contact_custom_field_options.orderid = deal_stages.order<br>``` |

contact\_custom\_field\_options table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **field**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **isdefault**<br><br><br>INTEGER |
| **label**<br><br><br>STRING |
| **orderid**<br><br><br>INTEGER |
| **udate**<br><br><br>DATE-TIME |
| **value**<br><br><br>STRING |

### contact\_custom\_field\_rels

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#fields)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#retrieve-fields-1 "Opens in new tab: ActiveCampaign API method") |

contact\_custom\_field\_rels table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **dorder**<br><br><br>INTEGER |
| **field**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **relid**<br><br><br>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](https://developers.activecampaign.com/reference#fieldvalues)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-custom-field-values-1 "Opens in new tab: ActiveCampaign API method") |

contact\_custom\_field\_values table foreign keys

| Join contact\_custom\_field\_values with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_custom_field_values.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_custom_field_values.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_custom_field_values.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_custom_field_values.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contact_custom_field_values.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contact_custom_field_values.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contact_custom_field_values.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contact_custom_field_values.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contact_custom_field_values.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_custom_field_values.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_custom_field_values.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contact_custom_field_values.contact = contact_automations.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contact_custom_field_values.contact = contact_deals.contact<br>``` |

contact\_custom\_field\_values table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **contact**<br><br><br>INTEGER |
| **created\_by**<br><br><br>INTEGER |
| **field**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **owner**<br><br><br>INTEGER |
| **udate**<br><br><br>DATE-TIME |
| **updated\_by**<br><br><br>INTEGER |
| **value**<br><br><br>STRING |

### contact\_custom\_fields

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#fields)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#retrieve-fields-1 "Opens in new tab: ActiveCampaign API method") |

contact\_custom\_fields table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **cols**<br><br><br>INTEGER |
| **defval**<br><br><br>STRING |
| **descript**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **isrequired**<br><br><br>INTEGER |
| **ordernum**<br><br><br>INTEGER |
| **perstag**<br><br><br>STRING |
| **rows**<br><br><br>INTEGER |
| **service**<br><br><br>STRING |
| **show\_in\_list**<br><br><br>INTEGER |
| **title**<br><br><br>STRING |
| **type**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **visible**<br><br><br>INTEGER |

### contact\_data

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | tstamp |

contact\_data table foreign keys

| Join contact\_data with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_data.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_data.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_data.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_data.contact = bounce_logs.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contact_data.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contact_data.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contact_data.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contact_data.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_data.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_data.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contact_data.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contact_data.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contact_data.contact = contact_deals.contact<br>``` |

contact\_data table schema

| **contact**<br><br><br>INTEGER |
| --- |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **fb\_id**<br><br><br>INTEGER |
| **fb\_name**<br><br><br>STRING |
| **ga\_campaign\_content**<br><br><br>STRING |
| **ga\_campaign\_customsegment**<br><br><br>STRING |
| **ga\_campaign\_medium**<br><br><br>STRING |
| **ga\_campaign\_name**<br><br><br>STRING |
| **ga\_campaign\_source**<br><br><br>STRING |
| **ga\_campaign\_term**<br><br><br>STRING |
| **ga\_first\_visit**<br><br><br>STRING |
| **ga\_times\_visited**<br><br><br>INTEGER |
| **geo\_area**<br><br><br>STRING |
| **geo\_city**<br><br><br>STRING |
| **geo\_country**<br><br><br>STRING |
| **geo\_country2**<br><br><br>STRING |
| **geo\_ip4**<br><br><br>STRING |
| **geo\_lat**<br><br><br>STRING |
| **geo\_lon**<br><br><br>STRING |
| **geo\_state**<br><br><br>STRING |
| **geo\_tstamp**<br><br><br>DATE-TIME |
| **geo\_tz**<br><br><br>STRING |
| **geo\_tz\_offset**<br><br><br>STRING |
| **geo\_zip**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **tstamp**<br><br><br>DATE-TIME |
| **tw\_id**<br><br><br>INTEGER |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>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](https://developers.activecampaign.com/reference#secondary-contacts)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-secondary-contacts "Opens in new tab: ActiveCampaign API method") |

contact\_deals table foreign keys

| Join contact\_deals with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_deals.deal = deals.id<br>```<br><br>```<br>contact_deals.contact = deals.contact<br>``` |
| [deal_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-field-values) | ```<br>contact_deals.deal = deal_custom_field_values.deal_id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_deals.deal = forms.deals<br>```<br><br>```<br>contact_deals.contact = forms.contacts<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>contact_deals.deal = deal_activities.deal<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_deals.deal = email_activities.deal<br>```<br><br>```<br>contact_deals.contact = email_activities.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contact_deals.deal = contact_emails.deal<br>```<br><br>```<br>contact_deals.contact = contact_emails.contact<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_deals.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_deals.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contact_deals.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contact_deals.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contact_deals.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contact_deals.contact = contact_conversions.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_deals.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contact_deals.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contact_deals.contact = contact_custom_field_values.contact<br>``` |

contact\_deals table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **contact**<br><br><br>INTEGER |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **deal**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **role**<br><br><br>STRING |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### contact\_emails

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | sdate |

contact\_emails table foreign keys

| Join contact\_emails with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_emails.deal = deals.id<br>```<br><br>```<br>contact_emails.account = deals.account<br>```<br><br>```<br>contact_emails.contact = deals.contact<br>``` |
| [deal_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-field-values) | ```<br>contact_emails.deal = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contact_emails.deal = contact_deals.deal<br>```<br><br>```<br>contact_emails.contact = contact_deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_emails.deal = forms.deals<br>```<br><br>```<br>contact_emails.contact = forms.contacts<br>```<br><br>```<br>contact_emails.userid = forms.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>contact_emails.deal = deal_activities.deal<br>```<br><br>```<br>contact_emails.userid = deal_activities.userid<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_emails.deal = email_activities.deal<br>```<br><br>```<br>contact_emails.account = email_activities.account<br>```<br><br>```<br>contact_emails.contact = email_activities.contact<br>```<br><br>```<br>contact_emails.userid = email_activities.userid<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#accounts) | ```<br>contact_emails.account = accounts.id<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_emails.account = account_contacts.account<br>```<br><br>```<br>contact_emails.contact = account_contacts.contact<br>``` |
| [account_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-custom-field-values) | ```<br>contact_emails.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_emails.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_emails.contact = bounce_logs.contact<br>```<br><br>```<br>contact_emails.messageid = bounce_logs.messageid<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contact_emails.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contact_emails.contact = contact_lists.contact<br>```<br><br>```<br>contact_emails.messageid = contact_lists.message<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contact_emails.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contact_emails.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contact_emails.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contact_emails.contact = contact_custom_field_values.contact<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>contact_emails.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>contact_emails.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>contact_emails.userid = messages.userid<br>```<br><br>```<br>contact_emails.messageid = messages.id<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>contact_emails.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>contact_emails.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>contact_emails.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>contact_emails.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>contact_emails.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>contact_emails.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>contact_emails.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>contact_emails.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>contact_emails.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>contact_emails.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>contact_emails.userid = campaigns.userid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-messages) | ```<br>contact_emails.messageid = campaign_messages.messageid<br>``` |
| [campaign_links](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-links) | ```<br>contact_emails.messageid = campaign_links.messageid<br>``` |

contact\_emails table schema

| **account**<br><br><br>INTEGER |
| --- |
| **contact**<br><br><br>INTEGER |
| **d\_id**<br><br><br>INTEGER |
| **deal**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **ip**<br><br><br>STRING |
| **message**<br><br><br>INTEGER |
| **messageheader**<br><br><br>STRING |
| **messageid**<br><br><br>INTEGER |
| **sdate**<br><br><br>DATE-TIME |
| **seriesid**<br><br><br>INTEGER |
| **source**<br><br><br>STRING |
| **subscriberid**<br><br><br>INTEGER |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>INTEGER |

### contact\_lists

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_timestamp |

contact\_lists table foreign keys

| Join contact\_lists with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>contact_lists.campaign = campaigns.id<br>``` |
| [campaign_links](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-links) | ```<br>contact_lists.campaign = campaign_links.campaignid<br>```<br><br>```<br>contact_lists.message = campaign_links.messageid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_lists.campaign = bounce_logs.campaignid<br>```<br><br>```<br>contact_lists.contact = bounce_logs.contact<br>```<br><br>```<br>contact_lists.message = bounce_logs.messageid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>contact_lists.campaign = campaign_lists.campaignid<br>```<br><br>```<br>contact_lists.list = campaign_lists.listid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-messages) | ```<br>contact_lists.campaign = campaign_messages.campaignid<br>```<br><br>```<br>contact_lists.message = campaign_messages.messageid<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_lists.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_lists.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_lists.contact = forms.contacts<br>```<br><br>```<br>contact_lists.form = forms.id<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contact_lists.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contact_lists.contact = contact_emails.contact<br>```<br><br>```<br>contact_lists.message = contact_emails.messageid<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contact_lists.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contact_lists.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_lists.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_lists.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contact_lists.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contact_lists.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contact_lists.contact = contact_deals.contact<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>contact_lists.list = lists.id<br>``` |
| [webhooks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#webhooks) | ```<br>contact_lists.list = webhooks.listid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>contact_lists.message = messages.id<br>``` |

contact\_lists table schema

| **automation**<br><br><br>INTEGER |
| --- |
| **autosync\_log**<br><br><br>INTEGER |
| **campaign**<br><br><br>INTEGER |
| **contact**<br><br><br>INTEGER |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **first\_name**<br><br><br>STRING |
| **form**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **ip4\_last**<br><br><br>INTEGER |
| **ip\_4sub**<br><br><br>INTEGER |
| **ip\_4unsub**<br><br><br>INTEGER |
| **last\_name**<br><br><br>STRING |
| **list**<br><br><br>INTEGER |
| **message**<br><br><br>INTEGER |
| **responder**<br><br><br>INTEGER |
| **sdate**<br><br><br>DATE-TIME |
| **seriesid**<br><br><br>INTEGER |
| **sourceid**<br><br><br>INTEGER |
| **status**<br><br><br>INTEGER |
| **sync**<br><br><br>INTEGER |
| **udate**<br><br><br>DATE-TIME |
| **unsubreason**<br><br><br>STRING |
| **unsubscribe\_automation**<br><br><br>INTEGER |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### contact\_tags

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_timestamp |

contact\_tags table foreign keys

| Join contact\_tags with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>contact_tags.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contact_tags.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contact_tags.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contact_tags.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contact_tags.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contact_tags.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contact_tags.contact = contact_lists.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contact_tags.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contact_tags.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contact_tags.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contact_tags.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contact_tags.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contact_tags.contact = contact_deals.contact<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tags) | ```<br>contact_tags.tag = tags.id<br>``` |

contact\_tags table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **contact**<br><br><br>INTEGER |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **tag**<br><br><br>INTEGER |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>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](https://developers.activecampaign.com/reference#contact)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-contacts "Opens in new tab: ActiveCampaign API method") |

contacts table foreign keys

| Join contacts with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>contacts.id = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>contacts.id = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>contacts.id = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>contacts.id = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>contacts.id = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>contacts.id = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>contacts.id = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>contacts.id = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>contacts.id = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>contacts.id = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>contacts.id = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>contacts.id = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>contacts.id = contact_deals.contact<br>``` |

contacts table schema

| **account\_contacts**<br><br>ARRAY |
| --- |
| **adate**<br><br><br>DATE-TIME |
| **anonymized**<br><br><br>INTEGER |
| **bounced\_date**<br><br><br>STRING |
| **bounced\_hard**<br><br><br>INTEGER |
| **bounced\_soft**<br><br><br>INTEGER |
| **cdate**<br><br><br>DATE-TIME |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **created\_utc\_timestamp**<br><br><br>DATE-TIME |
| **deleted**<br><br><br>INTEGER |
| **deleted\_at**<br><br><br>DATE-TIME |
| **edate**<br><br><br>DATE-TIME |
| **email**<br><br><br>STRING |
| **email\_domain**<br><br><br>STRING |
| **email\_empty**<br><br><br>BOOLEAN |
| **email\_local**<br><br><br>STRING |
| **first\_name**<br><br><br>STRING |
| **gravatar**<br><br><br>INTEGER |
| **hash**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **ip**<br><br><br>STRING |
| **last\_name**<br><br><br>STRING |
| **organization**<br><br><br>INTEGER |
| **orgid**<br><br><br>INTEGER |
| **phone**<br><br><br>STRING |
| **rating\_tstamp**<br><br><br>STRING |
| **score\_values**<br><br>ARRAY |
| **segmentio\_id**<br><br><br>STRING |
| **sentcnt**<br><br><br>INTEGER |
| **socialdata\_lastcheck**<br><br><br>DATE-TIME |
| **ua**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |
| **updated\_utc\_timestamp**<br><br><br>DATE-TIME |

### conversion\_triggers

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | udate |

conversion\_triggers table foreign keys

| Join conversion\_triggers with | on |
| --- | --- |
| [conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#conversions) | ```<br>conversion_triggers.conversion = conversions.id<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>conversion_triggers.conversion = contact_conversions.conversion<br>```<br><br>```<br>conversion_triggers.id = contact_conversions.conversiontrigger<br>``` |

conversion\_triggers table schema

| **automation\_block**<br><br><br>INTEGER |
| --- |
| **cdate**<br><br><br>DATE-TIME |
| **conversion**<br><br><br>INTEGER |
| **dynamic**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **modifier**<br><br><br>STRING |
| **retroactive**<br><br><br>INTEGER |
| **trigger\_type**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **value**<br><br><br>STRING |

### conversions

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | udate |

conversions table foreign keys

| Join conversions with | on |
| --- | --- |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>conversions.id = contact_conversions.conversion<br>``` |
| [conversion_triggers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#conversion-triggers) | ```<br>conversions.id = conversion_triggers.conversion<br>``` |

conversions table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **currency**<br><br><br>STRING |
| **enforcelimit**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **limit**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **value**<br><br><br>INTEGER |

### deal\_activities

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | cdate |

deal\_activities table foreign keys

| Join deal\_activities with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>deal_activities.deal = deals.id<br>```<br><br>```<br>deal_activities.stage = deals.stage<br>``` |
| [deal_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-field-values) | ```<br>deal_activities.deal = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>deal_activities.deal = contact_deals.deal<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>deal_activities.deal = forms.deals<br>```<br><br>```<br>deal_activities.userid = forms.userid<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>deal_activities.deal = email_activities.deal<br>```<br><br>```<br>deal_activities.userid = email_activities.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>deal_activities.deal = contact_emails.deal<br>```<br><br>```<br>deal_activities.userid = contact_emails.userid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>deal_activities.stage = deal_stages.id<br>``` |
| [deal_groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-groups) | ```<br>deal_activities.stage = deal_groups.stages<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>deal_activities.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>deal_activities.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>deal_activities.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>deal_activities.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>deal_activities.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>deal_activities.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>deal_activities.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>deal_activities.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>deal_activities.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>deal_activities.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>deal_activities.userid = sms.userid<br>```<br><br>```<br>deal_activities.automation = sms.automation<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>deal_activities.userid = automations.userid<br>```<br><br>```<br>deal_activities.automation = automations.id<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>deal_activities.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>deal_activities.userid = campaigns.userid<br>```<br><br>```<br>deal_activities.automation = campaigns.automation<br>``` |
| [goals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#goals) | ```<br>deal_activities.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#site-messages) | ```<br>deal_activities.automation = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automation-blocks) | ```<br>deal_activities.automation = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>deal_activities.automation = contact_automations.automation<br>``` |

deal\_activities table schema

| **automation**<br><br><br>INTEGER |
| --- |
| **cdate**<br><br><br>DATE-TIME |
| **d\_id**<br><br><br>INTEGER |
| **d\_stageid**<br><br><br>INTEGER |
| **data\_action**<br><br><br>STRING |
| **data\_id**<br><br><br>INTEGER |
| **data\_oldval**<br><br><br>STRING |
| **data\_type**<br><br><br>STRING |
| **deal**<br><br><br>INTEGER |
| **deleted**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **is\_addtask**<br><br><br>INTEGER |
| **seriesid**<br><br><br>INTEGER |
| **sortdate**<br><br><br>DATE-TIME |
| **stage**<br><br><br>INTEGER |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>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](https://developers.activecampaign.com/reference#dealcustomfielddata)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-custom-field-values "Opens in new tab: ActiveCampaign API method") |

deal\_custom\_field\_values table foreign keys

| Join deal\_custom\_field\_values with | on |
| --- | --- |
| [deal_custom_fields](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-fields) | ```<br>deal_custom_field_values.custom_field_id = deal_custom_fields.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>deal_custom_field_values.deal_id = deals.id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>deal_custom_field_values.deal_id = contact_deals.deal<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>deal_custom_field_values.deal_id = forms.deals<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>deal_custom_field_values.deal_id = deal_activities.deal<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>deal_custom_field_values.deal_id = email_activities.deal<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>deal_custom_field_values.deal_id = contact_emails.deal<br>``` |

deal\_custom\_field\_values table schema

| **created\_timestamp**<br><br><br>DATE-TIME |
| --- |
| **custom\_field\_id**<br><br><br>INTEGER |
| **deal\_custom\_field\_metum\_id**<br><br><br>INTEGER |
| **deal\_id**<br><br><br>INTEGER |
| **field\_value**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>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](https://developers.activecampaign.com/reference#dealcustomfieldmeta)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#retrieve-all-dealcustomfielddata-resources "Opens in new tab: ActiveCampaign API method") |

deal\_custom\_fields table foreign keys

| Join deal\_custom\_fields with | on |
| --- | --- |
| [deal_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-field-values) | ```<br>deal_custom_fields.id = deal_custom_field_values.custom_field_id<br>``` |

deal\_custom\_fields table schema

| **created\_timestamp**<br><br><br>DATE-TIME |
| --- |
| **display\_order**<br><br><br>INTEGER |
| **field\_default**<br><br><br>STRING |
| **field\_default\_currency**<br><br><br>STRING |
| **field\_label**<br><br><br>STRING |
| **field\_options**<br><br>ARRAY |
| **field\_type**<br><br><br>STRING |
| **hide\_field\_flag**<br><br><br>BOOLEAN |
| **id**<br><br><br>INTEGER |
| **is\_form\_visible**<br><br><br>BOOLEAN |
| **is\_required**<br><br><br>BOOLEAN |
| **known\_field\_id**<br><br><br>INTEGER |
| **personalization**<br><br><br>STRING |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### deal\_group\_users

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |

deal\_group\_users table foreign keys

| Join deal\_group\_users with | on |
| --- | --- |
| [deal_groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-groups) | ```<br>deal_group_users.deal_group = deal_groups.id<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>deal_group_users.deal_group = deals.group<br>``` |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>deal_group_users.deal_group = deal_stages.group<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>deal_group_users.user = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>deal_group_users.user = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>deal_group_users.user = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>deal_group_users.user = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>deal_group_users.user = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>deal_group_users.user = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>deal_group_users.user = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>deal_group_users.user = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>deal_group_users.user = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>deal_group_users.user = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>deal_group_users.user = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>deal_group_users.user = deal_activities.userid<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>deal_group_users.user = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>deal_group_users.user = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>deal_group_users.user = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>deal_group_users.user = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>deal_group_users.user = campaigns.userid<br>``` |

deal\_group\_users table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **deal\_group**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **user**<br><br><br>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](https://developers.activecampaign.com/reference#pipelines)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-pipelines "Opens in new tab: ActiveCampaign API method") |

deal\_groups table foreign keys

| Join deal\_groups with | on |
| --- | --- |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>deal_groups.stages = deal_stages.id<br>```<br><br>```<br>deal_groups.id = deal_stages.group<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>deal_groups.stages = deals.stage<br>```<br><br>```<br>deal_groups.id = deals.group<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>deal_groups.stages = deal_activities.stage<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>deal_groups.id = deal_group_users.deal_group<br>``` |

deal\_groups table schema

| **allgroups**<br><br><br>STRING |
| --- |
| **allusers**<br><br><br>STRING |
| **autoassign**<br><br><br>STRING |
| **cdate**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **stages**<br><br>ARRAY |
| **title**<br><br><br>STRING |
| **udate**<br><br><br>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](https://developers.activecampaign.com/reference#deal-stages)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-deal-stages "Opens in new tab: ActiveCampaign API method") |

deal\_stages table foreign keys

| Join deal\_stages with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>deal_stages.id = deals.stage<br>```<br><br>```<br>deal_stages.group = deals.group<br>``` |
| [deal_groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-groups) | ```<br>deal_stages.id = deal_groups.stages<br>```<br><br>```<br>deal_stages.group = deal_groups.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>deal_stages.id = deal_activities.stage<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>deal_stages.group = deal_group_users.deal_group<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-orders) | ```<br>deal_stages.order = ecommerce_orders.id<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-products) | ```<br>deal_stages.order = ecommerce_order_products.orderid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-activities) | ```<br>deal_stages.order = ecommerce_order_activities.orderid<br>``` |
| [contact_custom_field_options](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-options) | ```<br>deal_stages.order = contact_custom_field_options.orderid<br>``` |

deal\_stages table schema

| **card\_region1**<br><br><br>STRING |
| --- |
| **card\_region2**<br><br><br>STRING |
| **card\_region3**<br><br><br>STRING |
| **card\_region4**<br><br><br>STRING |
| **card\_region5**<br><br><br>STRING |
| **cdate**<br><br><br>DATE-TIME |
| **color**<br><br><br>STRING |
| **deal\_order**<br><br><br>STRING |
| **group**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **order**<br><br><br>INTEGER |
| **title**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **width**<br><br><br>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](https://developers.activecampaign.com/reference#deal)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-deals "Opens in new tab: ActiveCampaign API method") |

deals table foreign keys

| Join deals with | on |
| --- | --- |
| [deal_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-field-values) | ```<br>deals.id = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>deals.id = contact_deals.deal<br>```<br><br>```<br>deals.contact = contact_deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>deals.id = forms.deals<br>```<br><br>```<br>deals.contact = forms.contacts<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>deals.id = deal_activities.deal<br>```<br><br>```<br>deals.stage = deal_activities.stage<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>deals.id = email_activities.deal<br>```<br><br>```<br>deals.account = email_activities.account<br>```<br><br>```<br>deals.contact = email_activities.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>deals.id = contact_emails.deal<br>```<br><br>```<br>deals.account = contact_emails.account<br>```<br><br>```<br>deals.contact = contact_emails.contact<br>``` |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>deals.stage = deal_stages.id<br>```<br><br>```<br>deals.group = deal_stages.group<br>``` |
| [deal_groups](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-groups) | ```<br>deals.stage = deal_groups.stages<br>```<br><br>```<br>deals.group = deal_groups.id<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>deals.group = deal_group_users.deal_group<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#accounts) | ```<br>deals.account = accounts.id<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>deals.account = account_contacts.account<br>```<br><br>```<br>deals.contact = account_contacts.contact<br>``` |
| [account_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-custom-field-values) | ```<br>deals.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>deals.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>deals.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>deals.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>deals.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>deals.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>deals.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>deals.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>deals.contact = contact_custom_field_values.contact<br>``` |

deals table schema

| **account**<br><br><br>INTEGER |
| --- |
| **activitycount**<br><br><br>INTEGER |
| **cdate**<br><br><br>DATE-TIME |
| **contact**<br><br><br>INTEGER |
| **currency**<br><br><br>STRING |
| **customer\_account**<br><br><br>INTEGER |
| **description**<br><br><br>STRING |
| **edate**<br><br><br>DATE-TIME |
| **group**<br><br><br>INTEGER |
| **hash**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **is\_disabled**<br><br><br>BOOLEAN |
| **mdate**<br><br><br>DATE-TIME |
| **next\_task**<br><br><br>INTEGER |
| **nextdate**<br><br><br>STRING |
| **nextdealid**<br><br><br>INTEGER |
| **nexttaskid**<br><br><br>INTEGER |
| **organization**<br><br><br>INTEGER |
| **owner**<br><br><br>INTEGER |
| **percent**<br><br>NUMBER |
| **stage**<br><br><br>INTEGER |
| **status**<br><br><br>INTEGER |
| **title**<br><br><br>STRING |
| **value**<br><br>NUMBER |
| **win\_probability**<br><br>NUMBER |
| **win\_probability\_mdate**<br><br><br>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](https://developers.activecampaign.com/reference#connections)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-connections "Opens in new tab: ActiveCampaign API method") |

ecommerce\_connections table foreign keys

| Join ecommerce\_connections with | on |
| --- | --- |
| [ecommerce_customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-customers) | ```<br>ecommerce_connections.id = ecommerce_customers.connectionid<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-orders) | ```<br>ecommerce_connections.id = ecommerce_orders.connectionid<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-products) | ```<br>ecommerce_connections.id = ecommerce_order_products.connectionid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-activities) | ```<br>ecommerce_connections.id = ecommerce_order_activities.connectionid<br>``` |

ecommerce\_connections table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **externalid**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **is\_internal**<br><br><br>INTEGER |
| **last\_sync**<br><br><br>DATE-TIME |
| **link\_url**<br><br><br>STRING |
| **logo\_url**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **service**<br><br><br>STRING |
| **status**<br><br><br>INTEGER |
| **sync\_status**<br><br><br>INTEGER |
| **udate**<br><br><br>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](https://developers.activecampaign.com/reference#customers)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-customers "Opens in new tab: ActiveCampaign API method") |

ecommerce\_customers table foreign keys

| Join ecommerce\_customers with | on |
| --- | --- |
| [ecommerce_connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-connections) | ```<br>ecommerce_customers.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-orders) | ```<br>ecommerce_customers.connectionid = ecommerce_orders.connectionid<br>```<br><br>```<br>ecommerce_customers.id = ecommerce_orders.customer<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-products) | ```<br>ecommerce_customers.connectionid = ecommerce_order_products.connectionid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-activities) | ```<br>ecommerce_customers.connectionid = ecommerce_order_activities.connectionid<br>```<br><br>```<br>ecommerce_customers.id = ecommerce_order_activities.customerid<br>``` |

ecommerce\_customers table schema

| **avg\_product\_category**<br><br><br>STRING |
| --- |
| **avg\_revenue\_per\_order**<br><br>NUMBER |
| **connection**<br><br><br>INTEGER |
| **connectionid**<br><br><br>INTEGER |
| **email**<br><br><br>STRING |
| **externalid**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **total\_orders**<br><br><br>INTEGER |
| **total\_products**<br><br><br>INTEGER |
| **total\_revenue**<br><br>NUMBER |
| **tstamp**<br><br><br>DATE-TIME |

### ecommerce\_order\_activities

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | updated\_date |

ecommerce\_order\_activities table foreign keys

| Join ecommerce\_order\_activities with | on |
| --- | --- |
| [ecommerce_connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-connections) | ```<br>ecommerce_order_activities.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-customers) | ```<br>ecommerce_order_activities.connectionid = ecommerce_customers.connectionid<br>```<br><br>```<br>ecommerce_order_activities.customerid = ecommerce_customers.id<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-orders) | ```<br>ecommerce_order_activities.connectionid = ecommerce_orders.connectionid<br>```<br><br>```<br>ecommerce_order_activities.customerid = ecommerce_orders.customer<br>```<br><br>```<br>ecommerce_order_activities.orderid = ecommerce_orders.id<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-products) | ```<br>ecommerce_order_activities.connectionid = ecommerce_order_products.connectionid<br>```<br><br>```<br>ecommerce_order_activities.orderid = ecommerce_order_products.orderid<br>``` |
| [contact_custom_field_options](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-options) | ```<br>ecommerce_order_activities.orderid = contact_custom_field_options.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>ecommerce_order_activities.orderid = deal_stages.order<br>``` |

ecommerce\_order\_activities table schema

| **abandoned\_date**<br><br><br>DATE-TIME |
| --- |
| **connection**<br><br><br>INTEGER |
| **connectionid**<br><br><br>INTEGER |
| **created\_date**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **customerid**<br><br><br>INTEGER |
| **discount\_amount**<br><br>NUMBER |
| **email**<br><br><br>STRING |
| **external\_created\_date**<br><br><br>DATE-TIME |
| **external\_updated\_date**<br><br><br>DATE-TIME |
| **externalcheckoutid**<br><br><br>STRING |
| **externalid**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **logo\_url**<br><br><br>STRING |
| **order**<br><br><br>INTEGER |
| **order\_number**<br><br><br>STRING |
| **order\_url**<br><br><br>STRING |
| **orderid**<br><br><br>INTEGER |
| **shipping\_amount**<br><br>NUMBER |
| **shipping\_method**<br><br><br>STRING |
| **source**<br><br><br>INTEGER |
| **state**<br><br><br>INTEGER |
| **store\_name**<br><br><br>STRING |
| **tax\_amount**<br><br>NUMBER |
| **total\_price**<br><br>NUMBER |
| **total\_products**<br><br><br>INTEGER |
| **updated\_date**<br><br><br>DATE-TIME |

### ecommerce\_order\_products

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#e-commerce-order-products)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-products-for-order "Opens in new tab: ActiveCampaign API method") |

ecommerce\_order\_products table foreign keys

| Join ecommerce\_order\_products with | on |
| --- | --- |
| [ecommerce_connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-connections) | ```<br>ecommerce_order_products.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-customers) | ```<br>ecommerce_order_products.connectionid = ecommerce_customers.connectionid<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-orders) | ```<br>ecommerce_order_products.connectionid = ecommerce_orders.connectionid<br>```<br><br>```<br>ecommerce_order_products.orderid = ecommerce_orders.id<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-activities) | ```<br>ecommerce_order_products.connectionid = ecommerce_order_activities.connectionid<br>```<br><br>```<br>ecommerce_order_products.orderid = ecommerce_order_activities.orderid<br>``` |
| [contact_custom_field_options](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-options) | ```<br>ecommerce_order_products.orderid = contact_custom_field_options.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>ecommerce_order_products.orderid = deal_stages.order<br>``` |

ecommerce\_order\_products table schema

| **category**<br><br><br>STRING |
| --- |
| **connectionid**<br><br><br>INTEGER |
| **created\_date**<br><br><br>DATE-TIME |
| **description**<br><br><br>STRING |
| **ecom\_order**<br><br><br>INTEGER |
| **externalid**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **image\_url**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **orderid**<br><br><br>INTEGER |
| **price**<br><br>NUMBER |
| **product\_url**<br><br><br>STRING |
| **quantity**<br><br><br>INTEGER |
| **sku**<br><br><br>STRING |
| **tstamp**<br><br><br>DATE-TIME |
| **updated\_date**<br><br><br>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](https://developers.activecampaign.com/reference#orders)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-orders "Opens in new tab: ActiveCampaign API method") |

ecommerce\_orders table foreign keys

| Join ecommerce\_orders with | on |
| --- | --- |
| [ecommerce_connections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-connections) | ```<br>ecommerce_orders.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-customers) | ```<br>ecommerce_orders.connectionid = ecommerce_customers.connectionid<br>```<br><br>```<br>ecommerce_orders.customer = ecommerce_customers.id<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-products) | ```<br>ecommerce_orders.connectionid = ecommerce_order_products.connectionid<br>```<br><br>```<br>ecommerce_orders.id = ecommerce_order_products.orderid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#ecommerce-order-activities) | ```<br>ecommerce_orders.connectionid = ecommerce_order_activities.connectionid<br>```<br><br>```<br>ecommerce_orders.customer = ecommerce_order_activities.customerid<br>```<br><br>```<br>ecommerce_orders.id = ecommerce_order_activities.orderid<br>``` |
| [contact_custom_field_options](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-options) | ```<br>ecommerce_orders.id = contact_custom_field_options.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-stages) | ```<br>ecommerce_orders.id = deal_stages.order<br>``` |

ecommerce\_orders table schema

| **connection**<br><br><br>INTEGER |
| --- |
| **connectionid**<br><br><br>INTEGER |
| **created\_date**<br><br><br>DATE-TIME |
| **currency**<br><br><br>STRING |
| **customer**<br><br><br>INTEGER |
| **discount\_amount**<br><br>NUMBER |
| **email**<br><br><br>STRING |
| **external\_created\_date**<br><br><br>DATE-TIME |
| **external\_updated\_date**<br><br><br>DATE-TIME |
| **externalid**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **order\_date**<br><br><br>DATE-TIME |
| **order\_products**<br><br>ARRAY |
| **order\_url**<br><br><br>STRING |
| **shipping\_amount**<br><br>NUMBER |
| **shipping\_method**<br><br><br>STRING |
| **source**<br><br><br>INTEGER |
| **state**<br><br><br>INTEGER |
| **tax\_amount**<br><br>NUMBER |
| **total\_price**<br><br>NUMBER |
| **total\_products**<br><br><br>INTEGER |
| **tstamp**<br><br><br>DATE-TIME |
| **updated\_date**<br><br><br>DATE-TIME |

### email\_activities

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | tstamp |

email\_activities table foreign keys

| Join email\_activities with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>email_activities.deal = deals.id<br>```<br><br>```<br>email_activities.account = deals.account<br>```<br><br>```<br>email_activities.contact = deals.contact<br>``` |
| [deal_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-field-values) | ```<br>email_activities.deal = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>email_activities.deal = contact_deals.deal<br>```<br><br>```<br>email_activities.contact = contact_deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>email_activities.deal = forms.deals<br>```<br><br>```<br>email_activities.contact = forms.contacts<br>```<br><br>```<br>email_activities.userid = forms.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>email_activities.deal = deal_activities.deal<br>```<br><br>```<br>email_activities.userid = deal_activities.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>email_activities.deal = contact_emails.deal<br>```<br><br>```<br>email_activities.account = contact_emails.account<br>```<br><br>```<br>email_activities.contact = contact_emails.contact<br>```<br><br>```<br>email_activities.userid = contact_emails.userid<br>``` |
| [accounts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#accounts) | ```<br>email_activities.account = accounts.id<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>email_activities.account = account_contacts.account<br>```<br><br>```<br>email_activities.contact = account_contacts.contact<br>``` |
| [account_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-custom-field-values) | ```<br>email_activities.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>email_activities.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>email_activities.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>email_activities.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>email_activities.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>email_activities.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>email_activities.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>email_activities.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>email_activities.contact = contact_custom_field_values.contact<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>email_activities.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>email_activities.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>email_activities.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>email_activities.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>email_activities.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>email_activities.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>email_activities.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>email_activities.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>email_activities.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>email_activities.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>email_activities.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>email_activities.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>email_activities.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>email_activities.userid = campaigns.userid<br>``` |

email\_activities table schema

| **account**<br><br><br>INTEGER |
| --- |
| **cc\_address**<br><br><br>STRING |
| **contact**<br><br><br>INTEGER |
| **d\_id**<br><br><br>INTEGER |
| **deal**<br><br><br>INTEGER |
| **from\_address**<br><br><br>STRING |
| **from\_name**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **message**<br><br><br>STRING |
| **message\_html**<br><br><br>STRING |
| **reference**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li><b>id</b>: INTEGER</li><li><b>type</b>: STRING</li></ul> |
| **relid**<br><br><br>INTEGER |
| **reltype**<br><br><br>STRING |
| **subject**<br><br><br>STRING |
| **subscriberid**<br><br><br>INTEGER |
| **to\_address**<br><br><br>STRING |
| **tstamp**<br><br><br>DATE-TIME |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>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](https://developers.activecampaign.com/reference#forms)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#forms-1 "Opens in new tab: ActiveCampaign API method") |

forms table foreign keys

| Join forms with | on |
| --- | --- |
| [addresses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#addresses) | ```<br>forms.addressid = addresses.id<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>forms.addressid = campaigns.addressid<br>```<br><br>```<br>forms.userid = campaigns.userid<br>``` |
| [deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deals) | ```<br>forms.deals = deals.id<br>```<br><br>```<br>forms.contacts = deals.contact<br>``` |
| [deal_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-custom-field-values) | ```<br>forms.deals = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-deals) | ```<br>forms.deals = contact_deals.deal<br>```<br><br>```<br>forms.contacts = contact_deals.contact<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>forms.deals = deal_activities.deal<br>```<br><br>```<br>forms.userid = deal_activities.userid<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>forms.deals = email_activities.deal<br>```<br><br>```<br>forms.contacts = email_activities.contact<br>```<br><br>```<br>forms.userid = email_activities.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>forms.deals = contact_emails.deal<br>```<br><br>```<br>forms.contacts = contact_emails.contact<br>```<br><br>```<br>forms.userid = contact_emails.userid<br>``` |
| [contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contacts) | ```<br>forms.contacts = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>forms.contacts = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-data) | ```<br>forms.contacts = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>forms.contacts = contact_lists.contact<br>```<br><br>```<br>forms.id = contact_lists.form<br>``` |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>forms.contacts = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-conversions) | ```<br>forms.contacts = contact_conversions.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#account-contacts) | ```<br>forms.contacts = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>forms.contacts = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-custom-field-values) | ```<br>forms.contacts = contact_custom_field_values.contact<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>forms.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>forms.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>forms.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>forms.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>forms.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>forms.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>forms.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>forms.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>forms.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>forms.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>forms.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>forms.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>forms.userid = calendars.userid<br>``` |

forms table schema

| **action**<br><br><br>STRING |
| --- |
| **actiondata**<br><br><br>OBJECT<br><br>This is a nested data structure: ARRAY, which is also a nested data structure.<br><br>**actions**<br><br><ul><li><b>email</b>: STRING</li><li><b>list</b>: INTEGER</li><li><b>type</b>: STRING</li></ul> |
| **address**<br><br><br>INTEGER |
| **addressid**<br><br><br>INTEGER |
| **aid**<br><br><br>INTEGER |
| **body**<br><br><br>STRING |
| **button**<br><br><br>STRING |
| **cdate**<br><br><br>DATE-TIME |
| **cfields**<br><br>OBJECT<br><br>This is a nested data structure: ARRAY, which is also a nested data structure.<br><br>**cfields**<br><br><ul><li><b>class</b>: STRING</li><li><b>default_text</b>: STRING</li><li><b>header</b>: STRING</li><li><b>html</b>: STRING</li><li><b>required</b>: BOOLEAN</li><li><b>type</b>: STRING</li></ul> |
| **contacts**<br><br><br>INTEGER |
| **deals**<br><br><br>INTEGER |
| **defaultscreenshot**<br><br><br>STRING |
| **entries**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **layout**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **options**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li><b>blank_overwrite</b>: BOOLEAN</li><li><b>confaction</b>: STRING</li><li><b>confform</b>: STRING</li><li><b>optin_created</b>: BOOLEAN</li><li><b>optin_id</b>: INTEGER</li><li><b>sendoptin</b>: BOOLEAN</li></ul> |
| **parentformid**<br><br><br>INTEGER |
| **recent**<br><br>ARRAY |
| **style**<br><br><br>OBJECT<br><br>This is a nested data structure: OBJECT, which is also a nested data structure.<br><br>**style**<br><br><ul><li><b>ac_branding</b>: BOOLEAN</li><li><b>background</b>: STRING</li><li><b>border</b>: OBJECT, which is also a nested data structure:                                        <ul><li><b>color</b>: STRING</li><li><b>radius</b>: INTEGER</li><li><b>style</b>: STRING</li><li><b>width</b>: INTEGER</li></ul></li><li><b>button</b>: OBJECT, which is also a nested data structure:                                    <ul><li><b>background</b>: STRING</li><li><b>border</b>: OBJECT, which is also a nested data structure:                                                <ul><li><b>color</b>: STRING</li><li><b>radius</b>: INTEGER</li><li><b>style</b>: STRING</li><li><b>width</b>: INTEGER</li></ul></li></ul></li><li><b>fontcolor</b>: STRING</li><li><b>padding</b>: STRING</li><li><b>dark</b>: BOOLEAN</li><li><b>fontcolor</b>: STRING</li><li><b>layout</b>: STRING</li><li><b>width</b>: STRING</li></ul> |
| **submit**<br><br><br>STRING |
| **submitdata**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br>**type**: STRING |
| **thanks**<br><br><br>STRING |
| **title**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **url**<br><br><br>STRING |
| **userid**<br><br><br>INTEGER |

### goals

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |

goals table foreign keys

| Join goals with | on |
| --- | --- |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>goals.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>goals.automation = deal_activities.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#site-messages) | ```<br>goals.automation = site_messages.automation<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>goals.automation = sms.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automation-blocks) | ```<br>goals.automation = automation_blocks.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>goals.automation = campaigns.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>goals.automation = contact_automations.automation<br>``` |

goals table schema

| **automation**<br><br><br>INTEGER |
| --- |
| **automation\_block**<br><br><br>INTEGER |
| **blockid**<br><br><br>INTEGER |
| **cdate**<br><br><br>DATE-TIME |
| **dirty\_stats**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **seriesid**<br><br><br>INTEGER |

### groups

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#groups)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-groups "Opens in new tab: ActiveCampaign API method") |

groups table schema

| **descript**<br><br><br>STRING |
| --- |
| **id**<br><br><br>INTEGER |
| **optinconfirm**<br><br><br>INTEGER |
| **p\_admin**<br><br><br>INTEGER |
| **pg\_automation\_manage**<br><br><br>INTEGER |
| **pg\_contact\_actions**<br><br><br>INTEGER |
| **pg\_contact\_add**<br><br><br>INTEGER |
| **pg\_contact\_approve**<br><br><br>INTEGER |
| **pg\_contact\_delete**<br><br><br>INTEGER |
| **pg\_contact\_edit**<br><br><br>INTEGER |
| **pg\_contact\_export**<br><br><br>INTEGER |
| **pg\_contact\_fields**<br><br><br>INTEGER |
| **pg\_contact\_filters**<br><br><br>INTEGER |
| **pg\_contact\_import**<br><br><br>INTEGER |
| **pg\_contact\_merge**<br><br><br>INTEGER |
| **pg\_contact\_sync**<br><br><br>INTEGER |
| **pg\_deal**<br><br><br>INTEGER |
| **pg\_deal\_delete**<br><br><br>INTEGER |
| **pg\_deal\_group\_add**<br><br><br>INTEGER |
| **pg\_deal\_group\_delete**<br><br><br>INTEGER |
| **pg\_deal\_group\_edit**<br><br><br>INTEGER |
| **pg\_deal\_reassign**<br><br><br>INTEGER |
| **pg\_form\_edit**<br><br><br>INTEGER |
| **pg\_group\_add**<br><br><br>INTEGER |
| **pg\_group\_delete**<br><br><br>INTEGER |
| **pg\_group\_edit**<br><br><br>INTEGER |
| **pg\_list\_add**<br><br><br>INTEGER |
| **pg\_list\_bounce**<br><br><br>INTEGER |
| **pg\_list\_delete**<br><br><br>INTEGER |
| **pg\_list\_edit**<br><br><br>INTEGER |
| **pg\_list\_emailaccount**<br><br><br>INTEGER |
| **pg\_list\_headers**<br><br><br>INTEGER |
| **pg\_message\_add**<br><br><br>INTEGER |
| **pg\_message\_delete**<br><br><br>INTEGER |
| **pg\_message\_edit**<br><br><br>INTEGER |
| **pg\_message\_send**<br><br><br>INTEGER |
| **pg\_personalization\_add**<br><br><br>INTEGER |
| **pg\_personalization\_delete**<br><br><br>INTEGER |
| **pg\_personalization\_edit**<br><br><br>INTEGER |
| **pg\_reports\_campaign**<br><br><br>INTEGER |
| **pg\_reports\_list**<br><br><br>INTEGER |
| **pg\_reports\_trend**<br><br><br>INTEGER |
| **pg\_reports\_user**<br><br><br>INTEGER |
| **pg\_saved\_responses\_manage**<br><br><br>INTEGER |
| **pg\_startup\_gettingstarted**<br><br><br>INTEGER |
| **pg\_startup\_reports**<br><br><br>INTEGER |
| **pg\_template\_add**<br><br><br>INTEGER |
| **pg\_template\_delete**<br><br><br>INTEGER |
| **pg\_template\_edit**<br><br><br>INTEGER |
| **pg\_user\_add**<br><br><br>INTEGER |
| **pg\_user\_delete**<br><br><br>INTEGER |
| **pg\_user\_edit**<br><br><br>INTEGER |
| **req\_approval**<br><br><br>INTEGER |
| **req\_approval1st**<br><br><br>INTEGER |
| **req\_approval\_notify**<br><br><br>INTEGER |
| **sdate**<br><br><br>DATE-TIME |
| **socialdata**<br><br><br>INTEGER |
| **title**<br><br><br>STRING |
| **unsubscribelink**<br><br><br>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](https://developers.activecampaign.com/reference#lists)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#retrieve-all-lists "Opens in new tab: ActiveCampaign API method") |

lists table foreign keys

| Join lists with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>lists.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>lists.userid = forms.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>lists.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>lists.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>lists.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>lists.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>lists.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>lists.userid = campaign_lists.userid<br>```<br><br>```<br>lists.id = campaign_lists.listid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>lists.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>lists.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>lists.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>lists.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>lists.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>lists.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>lists.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>lists.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>lists.userid = campaigns.userid<br>``` |
| [webhooks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#webhooks) | ```<br>lists.id = webhooks.listid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>lists.id = contact_lists.list<br>``` |

lists table schema

| **analytics\_domains**<br><br><br>STRING |
| --- |
| **analytics\_source**<br><br><br>STRING |
| **analytics\_ua**<br><br><br>STRING |
| **carboncopy**<br><br><br>STRING |
| **cdate**<br><br><br>DATE-TIME |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **deletestamp**<br><br><br>STRING |
| **facebook\_session**<br><br><br>STRING |
| **fulladdress**<br><br><br>STRING |
| **get\_unsubscribe\_reason**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **optinmessageid**<br><br><br>INTEGER |
| **optinoptout**<br><br><br>INTEGER |
| **optoutconf**<br><br><br>INTEGER |
| **p\_embed\_image**<br><br><br>INTEGER |
| **p\_use\_analytics\_link**<br><br><br>INTEGER |
| **p\_use\_analytics\_read**<br><br><br>INTEGER |
| **p\_use\_captcha**<br><br><br>INTEGER |
| **p\_use\_facebook**<br><br><br>INTEGER |
| **p\_use\_tracking**<br><br><br>INTEGER |
| **p\_use\_twitter**<br><br><br>INTEGER |
| **private**<br><br><br>INTEGER |
| **require\_name**<br><br><br>INTEGER |
| **send\_last\_broadcast**<br><br><br>INTEGER |
| **sender\_addr1**<br><br><br>STRING |
| **sender\_addr2**<br><br><br>STRING |
| **sender\_city**<br><br><br>STRING |
| **sender\_country**<br><br><br>STRING |
| **sender\_name**<br><br><br>STRING |
| **sender\_phone**<br><br><br>STRING |
| **sender\_reminder**<br><br><br>STRING |
| **sender\_state**<br><br><br>STRING |
| **sender\_url**<br><br><br>STRING |
| **sender\_zip**<br><br><br>STRING |
| **stringid**<br><br><br>STRING |
| **subscription\_notify**<br><br><br>STRING |
| **to\_name**<br><br><br>STRING |
| **twitter\_token**<br><br><br>STRING |
| **twitter\_token\_secret**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **unsubscription\_notify**<br><br><br>STRING |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>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](https://developers.activecampaign.com/reference#messages)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-messages "Opens in new tab: ActiveCampaign API method") |

messages table foreign keys

| Join messages with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>messages.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>messages.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>messages.userid = lists.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>messages.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>messages.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>messages.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>messages.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>messages.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>messages.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>messages.userid = contact_emails.userid<br>```<br><br>```<br>messages.id = contact_emails.messageid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>messages.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>messages.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>messages.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>messages.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>messages.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>messages.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>messages.userid = campaigns.userid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#bounce-logs) | ```<br>messages.id = bounce_logs.messageid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-messages) | ```<br>messages.id = campaign_messages.messageid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>messages.id = contact_lists.message<br>``` |
| [campaign_links](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-links) | ```<br>messages.id = campaign_links.messageid<br>``` |

messages table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **charset**<br><br><br>STRING |
| **ed\_instanceid**<br><br><br>INTEGER |
| **ed\_version**<br><br><br>INTEGER |
| **encoding**<br><br><br>STRING |
| **format**<br><br><br>STRING |
| **fromemail**<br><br><br>STRING |
| **fromname**<br><br><br>STRING |
| **hidden**<br><br><br>INTEGER |
| **html**<br><br><br>STRING |
| **htmlfetch**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **mdate**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **preheader\_text**<br><br><br>STRING |
| **preview\_data**<br><br><br>STRING |
| **preview\_mime**<br><br><br>STRING |
| **priority**<br><br><br>INTEGER |
| **reply2**<br><br><br>STRING |
| **subject**<br><br><br>STRING |
| **text**<br><br><br>STRING |
| **textfetch**<br><br><br>STRING |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>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](https://developers.activecampaign.com/reference#saved-responses-1)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-saved-responses "Opens in new tab: ActiveCampaign API method") |

saved\_responses table foreign keys

| Join saved\_responses with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>saved_responses.last_sent_user_id = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>saved_responses.last_sent_user_id = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>saved_responses.last_sent_user_id = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>saved_responses.last_sent_user_id = messages.userid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>saved_responses.last_sent_user_id = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>saved_responses.last_sent_user_id = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>saved_responses.last_sent_user_id = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>saved_responses.last_sent_user_id = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>saved_responses.last_sent_user_id = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>saved_responses.last_sent_user_id = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>saved_responses.last_sent_user_id = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>saved_responses.last_sent_user_id = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>saved_responses.last_sent_user_id = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>saved_responses.last_sent_user_id = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>saved_responses.last_sent_user_id = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>saved_responses.last_sent_user_id = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>saved_responses.last_sent_user_id = campaigns.userid<br>``` |

saved\_responses table schema

| **body**<br><br><br>STRING |
| --- |
| **cdate**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **last\_sent\_user\_id**<br><br><br>INTEGER |
| **ldate**<br><br><br>DATE-TIME |
| **mdate**<br><br><br>DATE-TIME |
| **subject**<br><br><br>STRING |
| **title**<br><br><br>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](https://developers.activecampaign.com/reference#list-all-scores "Opens in new tab: ActiveCampaign API method") |

scores table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **descript**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **mdate**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **reltype**<br><br><br>STRING |
| **status**<br><br><br>INTEGER |

### segments

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#segments)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-segments "Opens in new tab: ActiveCampaign API method") |

segments table foreign keys

| Join segments with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>segments.id = campaigns.segmentid<br>``` |

segments table schema

| **created\_by**<br><br><br>INTEGER |
| --- |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **hidden**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **logic**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **seriesid**<br><br><br>INTEGER |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### site\_messages

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | ldate |

site\_messages table foreign keys

| Join site\_messages with | on |
| --- | --- |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>site_messages.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>site_messages.automation = deal_activities.automation<br>``` |
| [goals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#goals) | ```<br>site_messages.automation = goals.automation<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>site_messages.automation = sms.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automation-blocks) | ```<br>site_messages.automation = automation_blocks.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>site_messages.automation = campaigns.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>site_messages.automation = contact_automations.automation<br>``` |

site\_messages table schema

| **automation**<br><br><br>INTEGER |
| --- |
| **id**<br><br><br>INTEGER |
| **ldate**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **template**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li><b>detailed</b>: OBJECT, which is also a nested data structure.</li><li><b>initial</b>: OBJECT, which is also a nested data structure.</li></ul> |

### sms

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | id |
| **Replication Key** | ldate |

sms table foreign keys

| Join sms with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>sms.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>sms.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>sms.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>sms.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>sms.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>sms.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>sms.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>sms.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>sms.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>sms.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>sms.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>sms.userid = deal_activities.userid<br>```<br><br>```<br>sms.automation = deal_activities.automation<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>sms.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>sms.userid = email_activities.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>sms.userid = automations.userid<br>```<br><br>```<br>sms.automation = automations.id<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>sms.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>sms.userid = campaigns.userid<br>```<br><br>```<br>sms.automation = campaigns.automation<br>``` |
| [goals](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#goals) | ```<br>sms.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#site-messages) | ```<br>sms.automation = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automation-blocks) | ```<br>sms.automation = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-automations) | ```<br>sms.automation = contact_automations.automation<br>``` |

sms table schema

| **automation**<br><br><br>INTEGER |
| --- |
| **failed**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **ldate**<br><br><br>DATE-TIME |
| **msg**<br><br><br>STRING |
| **replies**<br><br><br>INTEGER |
| **sdate**<br><br><br>DATE-TIME |
| **sent**<br><br><br>INTEGER |
| **seriesid**<br><br><br>INTEGER |
| **tf\_day**<br><br><br>STRING |
| **tf\_hr\_from**<br><br><br>INTEGER |
| **tf\_hr\_to**<br><br><br>INTEGER |
| **tstamp**<br><br><br>DATE-TIME |
| **uniquereplies**<br><br><br>INTEGER |
| **unsubscribes**<br><br><br>INTEGER |
| **user**<br><br><br>INTEGER |
| **userid**<br><br><br>INTEGER |

### tags

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign API method](https://developers.activecampaign.com/reference#retrieve-all-tags "Opens in new tab: ActiveCampaign API method") |

tags table foreign keys

| Join tags with | on |
| --- | --- |
| [contact_tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-tags) | ```<br>tags.id = contact_tags.tag<br>``` |

tags table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **created\_by**<br><br><br>INTEGER |
| **created\_timestamp**<br><br><br>DATE-TIME |
| **description**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **tag**<br><br><br>STRING |
| **tag\_type**<br><br><br>STRING |
| **updated\_by**<br><br><br>INTEGER |
| **updated\_timestamp**<br><br><br>DATE-TIME |

### task\_types

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#deal-task-types)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-deal-task-types "Opens in new tab: ActiveCampaign API method") |

task\_types table foreign keys

| Join task\_types with | on |
| --- | --- |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>task_types.id = tasks.deal_tasktype<br>``` |

task\_types table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **defduration**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **status**<br><br><br>INTEGER |
| **title**<br><br><br>STRING |
| **udate**<br><br><br>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](https://developers.activecampaign.com/reference#tasks)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-tasks "Opens in new tab: ActiveCampaign API method") |

tasks table foreign keys

| Join tasks with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>tasks.user = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>tasks.user = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>tasks.user = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>tasks.user = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>tasks.user = saved_responses.last_sent_user_id<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>tasks.user = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>tasks.user = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>tasks.user = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>tasks.user = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>tasks.user = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>tasks.user = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>tasks.user = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>tasks.user = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>tasks.user = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>tasks.user = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>tasks.user = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>tasks.user = campaigns.userid<br>``` |
| [task_types](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#task-types) | ```<br>tasks.deal_tasktype = task_types.id<br>``` |

tasks table schema

| **assignee**<br><br><br>INTEGER |
| --- |
| **automation**<br><br><br>INTEGER |
| **cdate**<br><br><br>DATE-TIME |
| **deal\_tasktype**<br><br><br>INTEGER |
| **done\_automation**<br><br><br>INTEGER |
| **duedate**<br><br><br>DATE-TIME |
| **edate**<br><br><br>DATE-TIME |
| **id**<br><br><br>INTEGER |
| **note**<br><br><br>STRING |
| **owner**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li><b>id</b>: INTEGER</li><li><b>type</b>: STRING</li></ul> |
| **relid**<br><br><br>INTEGER |
| **reltype**<br><br><br>STRING |
| **status**<br><br><br>INTEGER |
| **title**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **user**<br><br><br>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](https://developers.activecampaign.com/reference#templates "Opens in new tab: ActiveCampaign API method") |

templates table foreign keys

| Join templates with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#users) | ```<br>templates.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>templates.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>templates.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>templates.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>templates.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>templates.userid = tasks.user<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>templates.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>templates.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>templates.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>templates.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>templates.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>templates.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>templates.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>templates.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>templates.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>templates.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>templates.userid = campaigns.userid<br>``` |

templates table schema

| **categoryid**<br><br><br>INTEGER |
| --- |
| **content**<br><br><br>STRING |
| **ed\_instanceid**<br><br><br>INTEGER |
| **ed\_version**<br><br><br>INTEGER |
| **hidden**<br><br><br>INTEGER |
| **id**<br><br><br>INTEGER |
| **importnum**<br><br><br>INTEGER |
| **mdate**<br><br><br>DATE-TIME |
| **modified**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **preview\_content**<br><br><br>STRING |
| **screenshot**<br><br><br>STRING |
| **subject**<br><br><br>STRING |
| **used**<br><br><br>INTEGER |
| **userid**<br><br><br>INTEGER |
| **waitpreview**<br><br><br>INTEGER |

### users

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#users)<br><br>[ActiveCampaign API method](https://developers.activecampaign.com/reference#list-all-users "Opens in new tab: ActiveCampaign API method") |

users table foreign keys

| Join users with | on |
| --- | --- |
| [forms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#forms) | ```<br>users.id = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>users.id = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#messages) | ```<br>users.id = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#saved-responses) | ```<br>users.id = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#tasks) | ```<br>users.id = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#templates) | ```<br>users.id = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#activities) | ```<br>users.id = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>users.id = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#configs) | ```<br>users.id = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-emails) | ```<br>users.id = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-activities) | ```<br>users.id = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#deal-group-users) | ```<br>users.id = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#email-activities) | ```<br>users.id = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#sms) | ```<br>users.id = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#automations) | ```<br>users.id = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#calendars) | ```<br>users.id = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaigns) | ```<br>users.id = campaigns.userid<br>``` |

users table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **email**<br><br><br>STRING |
| **first\_name**<br><br><br>STRING |
| **id**<br><br><br>INTEGER |
| **last\_name**<br><br><br>STRING |
| **local\_zoneid**<br><br><br>STRING |
| **mfa\_enabled**<br><br><br>INTEGER |
| **password\_updated\_utc\_timestamp**<br><br><br>DATE-TIME |
| **phone**<br><br><br>STRING |
| **signature**<br><br><br>STRING |
| **udate**<br><br><br>DATE-TIME |
| **username**<br><br><br>STRING |

### webhooks

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

| **Replication Method** | Full Table |
| --- | --- |
| **Primary Key** | id |
| **Useful links** | [ActiveCampaign API method](https://developers.activecampaign.com/reference#get-a-list-of-webhook-events "Opens in new tab: ActiveCampaign API method") |

webhooks table foreign keys

| Join webhooks with | on |
| --- | --- |
| [lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#lists) | ```<br>webhooks.listid = lists.id<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#campaign-lists) | ```<br>webhooks.listid = campaign_lists.listid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-ActiveCampaign-v2.htm#contact-lists) | ```<br>webhooks.listid = contact_lists.list<br>``` |

webhooks table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **events**<br><br>ARRAY |
| **id**<br><br><br>INTEGER |
| **listid**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **sources**<br><br>ARRAY |
| **url**<br><br><br>STRING |