# ActiveCampaign (v1)

Information note **ActiveCampaign extraction is supported by Stitch**   
This integration is powered by [Singer's](https://www.singer.io/) ActiveCampaign tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-activecampaign).  
  
For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport).

## ActiveCampaign integration summary

Stitch’s ActiveCampaign integration replicates data using the [ActiveCampaign v3 API](https://developers.activecampaign.com/reference#overview). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#schema) section for a list of objects available for replication.

## ActiveCampaign feature snapshot

A high-level look at Stitch's ActiveCampaign (v1) integration, including release status, useful links, and the features supported in Stitch.

| **STITCH** |  |  |  |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on February 8, 2022 | **Supported by**<br><br>the Info icon<br><br>Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan**<br><br>the Info icon<br><br>The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**<br><br>the Info icon<br><br>Indicates if the integration is available as a source in Stitch Connect. | the Success icon<br><br>This version of the integration is available via the API.<br><br><br>Available |
| **Singer GitHub repository** | [singer-io/tap-activecampaign](https://github.com/singer-io/tap-activecampaign) |  |  |
| **REPLICATION SETTINGS** |  |  |  |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Table-level reset**<br><br>the Info icon<br><br>Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon<br><br>Table-level resets are not supported for this integration. Resets are only supported at the integration level.<br><br><br>Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**<br><br>the Info icon<br><br>Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon<br><br>Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.<br><br><br>Unsupported |
| **DATA SELECTION** |  |  |  |
| **Table selection**<br><br>the Info icon<br><br>The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **Column selection**<br><br>the Info icon<br><br>The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Select all**<br><br>the Info icon<br><br>Indicates if the integration supports selecting all available tables and columns. | the Success icon<br><br>Supported<br><br><br>Supported |  |  |
| **TRANSPARENCY** |  |  |  |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**<br><br>the Info icon<br><br>Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**<br><br>the Info icon<br><br>Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |

## Connecting ActiveCampaign

### Step 1: Retrieve your ActiveCampaign API URL and token

1. Login to your ActiveCampaign account.
2. Go to the **My Settings** page.
3. Click on the **Developer** tab.
4. Copy your API URL and API token and keep them readily available for the next step.

### Step 2: Add ActiveCampaign as a Stitch data source

1. [Sign into your Stitch account](https://app.stitchdata.com/).

2. On the Stitch Dashboard page, click the **Add Integration** button.

3. Click the **ActiveCampaign** icon.

4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

   For example, the name “Stitch ActiveCampaign” would create a schema called `stitch_activecampaign` in the destination. **Note**: Schema names cannot be changed after you save the integration.

5. In the **API Token** field, paste the token you copied from [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#retrieve-api).

6. In the **API Url** field, paste the URL you copied from [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#retrieve-api).

### Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your ActiveCampaign integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond ActiveCampaign’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide.

### Step 4: Create a replication schedule

Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information.

In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

ActiveCampaign integrations support the following replication scheduling methods:

* [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency)

* [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)

* [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage.

### Step 5: Set objects to replicate

Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements).

The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#schema)

**Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts.

* Selection options
* Individual tables and columns
* All tables and columns

For ActiveCampaign integrations, you can select:

1. **Individual tables and columns**

2. **All tables and columns**

Click the tabs to view instructions for each selection method.

1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate.

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

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

4. Repeat this process for all the tables and columns you want to replicate.

5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections.

Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature.

1. Click into the integration from the Stitch Dashboard page.

2. Click the **Tables to Replicate** tab.

3. In the list of tables, click the box next to the **Table Names** column.

4. In the menu that displays, click **Track all Tables and Fields**:

   ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab

5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections.

### Initial and historical replication jobs

After you finish setting up ActiveCampaign, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.**

Information note

**Initial replication jobs with Anchor Scheduling**

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information.

#### Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage.

## ActiveCampaign table reference

Information note

**Schemas and versioning**

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for **version 1** of this integration.

This is the latest version of the ActiveCampaign integration.

Information note

**Table and column names in your destination**

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

For example: Object names are lowercased in Redshift (`CusTomERs` &gt; `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` &gt; `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info.

### account\_contacts

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

| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#account-contacts "Opens in new tab: ActiveCampaign documentation")<br><br><br>[account_contacts schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/account_contacts.json "Opens in new tab: account_contacts schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#accounts) | ```<br>account_contacts.account = accounts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#account-custom-field-values) | ```<br>account_contacts.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contacts) | ```<br>account_contacts.contact = contacts.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>account_contacts.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>account_contacts.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>account_contacts.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>account_contacts.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>account_contacts.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>account_contacts.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>account_contacts.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>account_contacts.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#custom-account-field-values "Opens in new tab: ActiveCampaign documentation")<br><br><br>[account_custom_field_values schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/account_custom_field_values.json "Opens in new tab: account_custom_field_values schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#account-custom-fields) | ```<br>account_custom_field_values.custom_field_id = account_custom_fields.id<br>``` |
| [accounts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#accounts) | ```<br>account_custom_field_values.account_id = accounts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>account_custom_field_values.account_id = deals.account<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>account_custom_field_values.account_id = contact_emails.account<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>account_custom_field_values.account_id = email_activities.account<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#custom-account-fields-1 "Opens in new tab: ActiveCampaign documentation")<br><br><br>[account_custom_fields schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/account_custom_fields.json "Opens in new tab: account_custom_fields schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#accounts "Opens in new tab: ActiveCampaign documentation")<br><br><br>[accounts schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/accounts.json "Opens in new tab: accounts schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#deals) | ```<br>accounts.id = deals.account<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>accounts.id = contact_emails.account<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>accounts.id = email_activities.account<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>accounts.id = account_contacts.account<br>``` |
| [account_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | tstamp |
| **Useful links** | [activities schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/activities.json "Opens in new tab: activities schema on GitHub") |

activities table foreign keys

| Join activities with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>activities.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>activities.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>activities.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>activities.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>activities.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>activities.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>activities.userid = templates.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>activities.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>activities.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>activities.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>activities.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>activities.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>activities.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>activities.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>activities.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>activities.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand reference<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#address "Opens in new tab: ActiveCampaign documentation")<br><br><br>[addresses schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/addresses.json "Opens in new tab: addresses schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#campaigns) | ```<br>addresses.id = campaigns.addressid<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [automation_blocks schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/automation_blocks.json "Opens in new tab: automation_blocks schema on GitHub") |

automation\_blocks table foreign keys

| Join automation\_blocks with | on |
| --- | --- |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>automation_blocks.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>automation_blocks.automation = deal_activities.automation<br>``` |
| [goals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#goals) | ```<br>automation_blocks.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#site-messages) | ```<br>automation_blocks.automation = site_messages.automation<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>automation_blocks.automation = sms.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>automation_blocks.automation = campaigns.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **parent**<br><br><br>INTEGER |

### automations

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

| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | mdate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#automation "Opens in new tab: ActiveCampaign documentation")<br><br><br>[automations schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/automations.json "Opens in new tab: automations schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#users) | ```<br>automations.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>automations.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>automations.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>automations.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>automations.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>automations.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>automations.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>automations.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>automations.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>automations.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>automations.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>automations.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>automations.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>automations.userid = sms.userid<br>```<br><br>```<br>automations.id = sms.automation<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>automations.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>automations.userid = campaigns.userid<br>```<br><br>```<br>automations.id = campaigns.automation<br>``` |
| [goals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#goals) | ```<br>automations.id = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#site-messages) | ```<br>automations.id = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automation-blocks) | ```<br>automations.id = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [bounce_logs schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/bounce_logs.json "Opens in new tab: bounce_logs schema on GitHub") |

bounce\_logs table foreign keys

| Join bounce\_logs with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>bounce_logs.campaignid = campaigns.id<br>``` |
| [campaign_links](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>bounce_logs.campaignid = campaign_lists.campaignid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contacts) | ```<br>bounce_logs.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>bounce_logs.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>bounce_logs.contact = forms.contacts<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>bounce_logs.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>bounce_logs.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>bounce_logs.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>bounce_logs.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>bounce_logs.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>bounce_logs.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>bounce_logs.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>bounce_logs.contact = contact_deals.contact<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#branding "Opens in new tab: ActiveCampaign documentation")<br><br><br>[brandings schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/brandings.json "Opens in new tab: brandings schema on GitHub")<br><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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | mdate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#calendar-feeds "Opens in new tab: ActiveCampaign documentation")<br><br><br>[calendars schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/calendars.json "Opens in new tab: calendars schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#users) | ```<br>calendars.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>calendars.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>calendars.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>calendars.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>calendars.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>calendars.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>calendars.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>calendars.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>calendars.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>calendars.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>calendars.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>calendars.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>calendars.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>calendars.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>calendars.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>calendars.userid = automations.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#test-1 "Opens in new tab: ActiveCampaign documentation")<br><br><br>[campaign_links schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/campaign_links.json "Opens in new tab: campaign_links schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#campaigns) | ```<br>campaign_links.campaignid = campaigns.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>campaign_links.campaignid = campaign_lists.campaignid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#messages) | ```<br>campaign_links.messageid = messages.id<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [campaign_lists schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/campaign_lists.json "Opens in new tab: campaign_lists schema on GitHub") |

campaign\_lists table foreign keys

| Join campaign\_lists with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#campaign-links) | ```<br>campaign_lists.campaignid = campaign_links.campaignid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>campaign_lists.campaignid = bounce_logs.campaignid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-messages) | ```<br>campaign_lists.campaignid = campaign_messages.campaignid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#users) | ```<br>campaign_lists.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>campaign_lists.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>campaign_lists.userid = lists.userid<br>```<br><br>```<br>campaign_lists.listid = lists.id<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>campaign_lists.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>campaign_lists.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>campaign_lists.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>campaign_lists.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>campaign_lists.userid = activities.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>campaign_lists.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>campaign_lists.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>campaign_lists.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>campaign_lists.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>campaign_lists.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>campaign_lists.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>campaign_lists.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>campaign_lists.userid = calendars.userid<br>``` |
| [webhooks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [campaign_messages schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/campaign_messages.json "Opens in new tab: campaign_messages schema on GitHub") |

campaign\_messages table foreign keys

| Join campaign\_messages with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>campaign_messages.campaignid = campaigns.id<br>``` |
| [campaign_links](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>campaign_messages.campaignid = campaign_lists.campaignid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#messages) | ```<br>campaign_messages.messageid = messages.id<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#test-1 "Opens in new tab: ActiveCampaign documentation")<br><br><br>[campaigns schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/campaigns.json "Opens in new tab: campaigns schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#addresses) | ```<br>campaigns.addressid = addresses.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>campaigns.addressid = forms.addressid<br>```<br><br>```<br>campaigns.userid = forms.userid<br>``` |
| [campaign_links](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-links) | ```<br>campaigns.id = campaign_links.campaignid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>campaigns.id = bounce_logs.campaignid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#campaign-messages) | ```<br>campaigns.id = campaign_messages.campaignid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>campaigns.id = contact_lists.campaign<br>``` |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>campaigns.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>campaigns.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>campaigns.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>campaigns.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>campaigns.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>campaigns.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>campaigns.userid = activities.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>campaigns.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>campaigns.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>campaigns.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>campaigns.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>campaigns.userid = sms.userid<br>```<br><br>```<br>campaigns.automation = sms.automation<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>campaigns.userid = automations.userid<br>```<br><br>```<br>campaigns.automation = automations.id<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>campaigns.userid = calendars.userid<br>``` |
| [goals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#goals) | ```<br>campaigns.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#site-messages) | ```<br>campaigns.automation = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automation-blocks) | ```<br>campaigns.automation = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>campaigns.automation = contact_automations.automation<br>``` |
| [segments](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [configs schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/configs.json "Opens in new tab: configs schema on GitHub") |

configs table foreign keys

| Join configs with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>configs.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>configs.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>configs.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>configs.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>configs.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>configs.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>configs.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>configs.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>configs.userid = campaign_lists.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>configs.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>configs.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>configs.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>configs.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>configs.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>configs.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>configs.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#automations "Opens in new tab: ActiveCampaign documentation")<br><br><br>[contact_automations schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_automations.json "Opens in new tab: contact_automations schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_automations.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>contact_automations.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>contact_automations.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>contact_automations.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contact_automations.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>contact_automations.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>contact_automations.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contact_automations.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contact_automations.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>contact_automations.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contact_automations.contact = account_contacts.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>contact_automations.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>contact_automations.contact = contact_deals.contact<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>contact_automations.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>contact_automations.automation = deal_activities.automation<br>``` |
| [goals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#goals) | ```<br>contact_automations.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#site-messages) | ```<br>contact_automations.automation = site_messages.automation<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>contact_automations.automation = sms.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automation-blocks) | ```<br>contact_automations.automation = automation_blocks.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | cdate |
| **Useful links** | [contact_conversions schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_conversions.json "Opens in new tab: contact_conversions schema on GitHub") |

contact\_conversions table foreign keys

| Join contact\_conversions with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_conversions.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>contact_conversions.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>contact_conversions.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>contact_conversions.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contact_conversions.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>contact_conversions.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>contact_conversions.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contact_conversions.contact = contact_tags.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>contact_conversions.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contact_conversions.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contact_conversions.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>contact_conversions.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>contact_conversions.contact = contact_deals.contact<br>``` |
| [conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#conversions) | ```<br>contact_conversions.conversion = conversions.id<br>``` |
| [conversion_triggers](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#fields "Opens in new tab: ActiveCampaign documentation")<br><br><br>[contact_custom_field_options schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_custom_fields.json "Opens in new tab: contact_custom_field_options schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#ecommerce-orders) | ```<br>contact_custom_field_options.orderid = ecommerce_orders.id<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-order-products) | ```<br>contact_custom_field_options.orderid = ecommerce_order_products.orderid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-order-activities) | ```<br>contact_custom_field_options.orderid = ecommerce_order_activities.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#fields "Opens in new tab: ActiveCampaign documentation")<br><br><br>[contact_custom_field_rels schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_custom_fields.json "Opens in new tab: contact_custom_field_rels schema on GitHub")<br><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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#fieldvalues "Opens in new tab: ActiveCampaign documentation")<br><br><br>[contact_custom_field_values schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_custom_field_values.json "Opens in new tab: contact_custom_field_values schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_custom_field_values.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>contact_custom_field_values.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>contact_custom_field_values.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>contact_custom_field_values.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contact_custom_field_values.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>contact_custom_field_values.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>contact_custom_field_values.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contact_custom_field_values.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contact_custom_field_values.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>contact_custom_field_values.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contact_custom_field_values.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contact_custom_field_values.contact = contact_automations.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#fields "Opens in new tab: ActiveCampaign documentation")<br><br><br>[contact_custom_fields schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_custom_fields.json "Opens in new tab: contact_custom_fields schema on GitHub")<br><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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | tstamp |
| **Useful links** | [contact_data schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_data.json "Opens in new tab: contact_data schema on GitHub") |

contact\_data table foreign keys

| Join contact\_data with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_data.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>contact_data.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>contact_data.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>contact_data.contact = bounce_logs.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>contact_data.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>contact_data.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contact_data.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contact_data.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>contact_data.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contact_data.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contact_data.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>contact_data.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#secondary-contacts "Opens in new tab: ActiveCampaign documentation")<br><br><br>[contact_deals schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_deals.json "Opens in new tab: contact_deals schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-custom-field-values) | ```<br>contact_deals.deal = deal_custom_field_values.deal_id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>contact_deals.deal = deal_activities.deal<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_deals.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>contact_deals.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contact_deals.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>contact_deals.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contact_deals.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contact_deals.contact = contact_conversions.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contact_deals.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contact_deals.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | sdate |
| **Useful links** | [contact_emails schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_emails.json "Opens in new tab: contact_emails schema on GitHub") |

contact\_emails table foreign keys

| Join contact\_emails with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-custom-field-values) | ```<br>contact_emails.deal = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#accounts) | ```<br>contact_emails.account = accounts.id<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#account-custom-field-values) | ```<br>contact_emails.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_emails.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contact_emails.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contact_emails.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contact_emails.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contact_emails.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>contact_emails.contact = contact_custom_field_values.contact<br>``` |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>contact_emails.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>contact_emails.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>contact_emails.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>contact_emails.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>contact_emails.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>contact_emails.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>contact_emails.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>contact_emails.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>contact_emails.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>contact_emails.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>contact_emails.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>contact_emails.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>contact_emails.userid = campaigns.userid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-messages) | ```<br>contact_emails.messageid = campaign_messages.messageid<br>``` |
| [campaign_links](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [contact_lists schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_lists.json "Opens in new tab: contact_lists schema on GitHub") |

contact\_lists table foreign keys

| Join contact\_lists with | on |
| --- | --- |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>contact_lists.campaign = campaigns.id<br>``` |
| [campaign_links](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_lists.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>contact_lists.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contact_lists.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contact_lists.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contact_lists.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>contact_lists.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contact_lists.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contact_lists.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>contact_lists.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>contact_lists.contact = contact_deals.contact<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>contact_lists.list = lists.id<br>``` |
| [webhooks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#webhooks) | ```<br>contact_lists.list = webhooks.listid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [contact_tags schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contact_tags.json "Opens in new tab: contact_tags schema on GitHub") |

contact\_tags table foreign keys

| Join contact\_tags with | on |
| --- | --- |
| [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contacts) | ```<br>contact_tags.contact = contacts.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>contact_tags.contact = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>contact_tags.contact = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>contact_tags.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contact_tags.contact = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>contact_tags.contact = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>contact_tags.contact = contact_lists.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contact_tags.contact = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>contact_tags.contact = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contact_tags.contact = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contact_tags.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>contact_tags.contact = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>contact_tags.contact = contact_deals.contact<br>``` |
| [tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#contact "Opens in new tab: ActiveCampaign documentation")<br><br><br>[contacts schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/contacts.json "Opens in new tab: contacts schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#deals) | ```<br>contacts.id = deals.contact<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>contacts.id = forms.contacts<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>contacts.id = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>contacts.id = contact_data.contact<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>contacts.id = contact_emails.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>contacts.id = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>contacts.id = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>contacts.id = contact_conversions.contact<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>contacts.id = email_activities.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>contacts.id = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>contacts.id = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>contacts.id = contact_custom_field_values.contact<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>contacts.id = contact_deals.contact<br>``` |

contacts table schema

| **account\_contacts**<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| --- |
| **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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** |  |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [conversion_triggers schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/conversion_triggers.json "Opens in new tab: conversion_triggers schema on GitHub") |

conversion\_triggers table foreign keys

| Join conversion\_triggers with | on |
| --- | --- |
| [conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#conversions) | ```<br>conversion_triggers.conversion = conversions.id<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [conversions schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/conversions.json "Opens in new tab: conversions schema on GitHub") |

conversions table foreign keys

| Join conversions with | on |
| --- | --- |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>conversions.id = contact_conversions.conversion<br>``` |
| [conversion_triggers](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | cdate |
| **Useful links** | [deal_activities schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/deal_activities.json "Opens in new tab: deal_activities schema on GitHub") |

deal\_activities table foreign keys

| Join deal\_activities with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-custom-field-values) | ```<br>deal_activities.deal = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>deal_activities.deal = contact_deals.deal<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-stages) | ```<br>deal_activities.stage = deal_stages.id<br>``` |
| [deal_groups](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-groups) | ```<br>deal_activities.stage = deal_groups.stages<br>``` |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>deal_activities.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>deal_activities.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>deal_activities.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>deal_activities.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>deal_activities.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>deal_activities.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>deal_activities.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>deal_activities.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>deal_activities.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>deal_activities.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>deal_activities.userid = sms.userid<br>```<br><br>```<br>deal_activities.automation = sms.automation<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>deal_activities.userid = automations.userid<br>```<br><br>```<br>deal_activities.automation = automations.id<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>deal_activities.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>deal_activities.userid = campaigns.userid<br>```<br><br>```<br>deal_activities.automation = campaigns.automation<br>``` |
| [goals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#goals) | ```<br>deal_activities.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#site-messages) | ```<br>deal_activities.automation = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automation-blocks) | ```<br>deal_activities.automation = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#dealcustomfielddata "Opens in new tab: ActiveCampaign documentation")<br><br><br>[deal_custom_field_values schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/deal_custom_field_values.json "Opens in new tab: deal_custom_field_values schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#deal-custom-fields) | ```<br>deal_custom_field_values.custom_field_id = deal_custom_fields.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>deal_custom_field_values.deal_id = deals.id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-deals) | ```<br>deal_custom_field_values.deal_id = contact_deals.deal<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>deal_custom_field_values.deal_id = forms.deals<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>deal_custom_field_values.deal_id = deal_activities.deal<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>deal_custom_field_values.deal_id = email_activities.deal<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#dealcustomfieldmeta "Opens in new tab: ActiveCampaign documentation")<br><br><br>[deal_custom_fields schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/deal_custom_fields.json "Opens in new tab: deal_custom_fields schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [deal_group_users schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/deal_group_users.json "Opens in new tab: deal_group_users schema on GitHub") |

deal\_group\_users table foreign keys

| Join deal\_group\_users with | on |
| --- | --- |
| [deal_groups](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-groups) | ```<br>deal_group_users.deal_group = deal_groups.id<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deals) | ```<br>deal_group_users.deal_group = deals.group<br>``` |
| [deal_stages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-stages) | ```<br>deal_group_users.deal_group = deal_stages.group<br>``` |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>deal_group_users.user = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>deal_group_users.user = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>deal_group_users.user = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>deal_group_users.user = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>deal_group_users.user = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>deal_group_users.user = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>deal_group_users.user = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>deal_group_users.user = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>deal_group_users.user = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>deal_group_users.user = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>deal_group_users.user = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>deal_group_users.user = deal_activities.userid<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>deal_group_users.user = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>deal_group_users.user = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>deal_group_users.user = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>deal_group_users.user = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#pipelines "Opens in new tab: ActiveCampaign documentation")<br><br><br>[deal_groups schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/deal_groups.json "Opens in new tab: deal_groups schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>deal_groups.stages = deal_activities.stage<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#deal-stages "Opens in new tab: ActiveCampaign documentation")<br><br><br>[deal_stages schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/deal_stages.json "Opens in new tab: deal_stages schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>deal_stages.id = deal_activities.stage<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>deal_stages.group = deal_group_users.deal_group<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-orders) | ```<br>deal_stages.order = ecommerce_orders.id<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-order-products) | ```<br>deal_stages.order = ecommerce_order_products.orderid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-order-activities) | ```<br>deal_stages.order = ecommerce_order_activities.orderid<br>``` |
| [contact_custom_field_options](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | mdate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#deal "Opens in new tab: ActiveCampaign documentation")<br><br><br>[deals schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/deals.json "Opens in new tab: deals schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#deal-custom-field-values) | ```<br>deals.id = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#forms) | ```<br>deals.id = forms.deals<br>```<br><br>```<br>deals.contact = forms.contacts<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>deals.group = deal_group_users.deal_group<br>``` |
| [accounts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#accounts) | ```<br>deals.account = accounts.id<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#account-custom-field-values) | ```<br>deals.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contacts) | ```<br>deals.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>deals.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>deals.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>deals.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>deals.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>deals.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>deals.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#connections "Opens in new tab: ActiveCampaign documentation")<br><br><br>[ecommerce_connections schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/ecommerce_connections.json "Opens in new tab: ecommerce_connections schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#ecommerce-customers) | ```<br>ecommerce_connections.id = ecommerce_customers.connectionid<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-orders) | ```<br>ecommerce_connections.id = ecommerce_orders.connectionid<br>``` |
| [ecommerce_order_products](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-order-products) | ```<br>ecommerce_connections.id = ecommerce_order_products.connectionid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | tstamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#customers "Opens in new tab: ActiveCampaign documentation")<br><br><br>[ecommerce_customers schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/ecommerce_customers.json "Opens in new tab: ecommerce_customers schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#ecommerce-connections) | ```<br>ecommerce_customers.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#ecommerce-order-products) | ```<br>ecommerce_customers.connectionid = ecommerce_order_products.connectionid<br>``` |
| [ecommerce_order_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_date |
| **Useful links** | [ecommerce_order_activities schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/ecommerce_order_activities.json "Opens in new tab: ecommerce_order_activities schema on GitHub") |

ecommerce\_order\_activities table foreign keys

| Join ecommerce\_order\_activities with | on |
| --- | --- |
| [ecommerce_connections](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-connections) | ```<br>ecommerce_order_activities.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_customers](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-custom-field-options) | ```<br>ecommerce_order_activities.orderid = contact_custom_field_options.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#e-commerce-order-products "Opens in new tab: ActiveCampaign documentation")<br><br><br>[ecommerce_order_products schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/ecommerce_order_products.json "Opens in new tab: ecommerce_order_products schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#ecommerce-connections) | ```<br>ecommerce_order_products.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_customers](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#ecommerce-customers) | ```<br>ecommerce_order_products.connectionid = ecommerce_customers.connectionid<br>``` |
| [ecommerce_orders](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-custom-field-options) | ```<br>ecommerce_order_products.orderid = contact_custom_field_options.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_date |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#orders "Opens in new tab: ActiveCampaign documentation")<br><br><br>[ecommerce_orders schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/ecommerce_orders.json "Opens in new tab: ecommerce_orders schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#ecommerce-connections) | ```<br>ecommerce_orders.connectionid = ecommerce_connections.id<br>``` |
| [ecommerce_customers](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-custom-field-options) | ```<br>ecommerce_orders.id = contact_custom_field_options.orderid<br>``` |
| [deal_stages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [email_activities schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/email_activities.json "Opens in new tab: email_activities schema on GitHub") |

email\_activities table foreign keys

| Join email\_activities with | on |
| --- | --- |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-custom-field-values) | ```<br>email_activities.deal = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#accounts) | ```<br>email_activities.account = accounts.id<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#account-custom-field-values) | ```<br>email_activities.account = account_custom_field_values.account_id<br>``` |
| [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contacts) | ```<br>email_activities.contact = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>email_activities.contact = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>email_activities.contact = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>email_activities.contact = contact_lists.contact<br>``` |
| [contact_tags](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>email_activities.contact = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>email_activities.contact = contact_conversions.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>email_activities.contact = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>email_activities.contact = contact_custom_field_values.contact<br>``` |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>email_activities.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>email_activities.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>email_activities.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>email_activities.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>email_activities.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>email_activities.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>email_activities.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>email_activities.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>email_activities.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>email_activities.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>email_activities.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>email_activities.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>email_activities.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand reference<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#forms "Opens in new tab: ActiveCampaign documentation")<br><br><br>[forms schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/forms.json "Opens in new tab: forms schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#addresses) | ```<br>forms.addressid = addresses.id<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>forms.addressid = campaigns.addressid<br>```<br><br>```<br>forms.userid = campaigns.userid<br>``` |
| [deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-custom-field-values) | ```<br>forms.deals = deal_custom_field_values.deal_id<br>``` |
| [contact_deals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contacts) | ```<br>forms.contacts = contacts.id<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>forms.contacts = bounce_logs.contact<br>``` |
| [contact_data](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-data) | ```<br>forms.contacts = contact_data.contact<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#contact-tags) | ```<br>forms.contacts = contact_tags.contact<br>``` |
| [contact_conversions](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-conversions) | ```<br>forms.contacts = contact_conversions.contact<br>``` |
| [account_contacts](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#account-contacts) | ```<br>forms.contacts = account_contacts.contact<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-automations) | ```<br>forms.contacts = contact_automations.contact<br>``` |
| [contact_custom_field_values](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-custom-field-values) | ```<br>forms.contacts = contact_custom_field_values.contact<br>``` |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>forms.userid = users.id<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>forms.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>forms.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>forms.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>forms.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>forms.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>forms.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>forms.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>forms.userid = configs.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>forms.userid = deal_group_users.user<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>forms.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>forms.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand actiondata<br><br><table> <tr> <td> <p> <strong>								actions							</strong> </p> <p> </p> <p>ARRAY																																</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand actions</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								email							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								list							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand cfields<br><br><table> <tr> <td> <p> <strong>								class							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								default_text							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								header							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								html							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								required							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand options<br><br><table> <tr> <td> <p> <strong>								blank_overwrite							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								confaction							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								confform							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								optin_created							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								optin_id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								sendoptin							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> </table> |
| **parentformid**<br><br><br>INTEGER |
| **recent**<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand recent<br><br><table> </table> |
| **style**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand style<br><br><table> <tr> <td> <p> <strong>								ac_branding							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								background							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								border							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand border</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								color							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								radius							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								style							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								width							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								button							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand button</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								background							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								border							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> <div> <button>Click to expand border</button><div> <div> <div><div><table> <tr> <td> <p> <strong>								color							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								radius							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								style							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								width							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								fontcolor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								padding							</strong> </p> <p>							STRING													</p> </td> </tr> </table></div></div></div> </div></div> </td> </tr> <tr> <td> <p> <strong>								dark							</strong> </p> <p>							BOOLEAN													</p> </td> </tr> <tr> <td> <p> <strong>								fontcolor							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								layout							</strong> </p> <p>							STRING													</p> </td> </tr> <tr> <td> <p> <strong>								width							</strong> </p> <p>							INTEGER													</p> </td> </tr> </table> |
| **submit**<br><br><br>STRING |
| **submitdata**<br><br><br>OBJECT<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand submitdata<br><br><table> <tr> <td> <p> <strong>								url							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [goals schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/goals.json "Opens in new tab: goals schema on GitHub") |

goals table foreign keys

| Join goals with | on |
| --- | --- |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>goals.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>goals.automation = deal_activities.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#site-messages) | ```<br>goals.automation = site_messages.automation<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>goals.automation = sms.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automation-blocks) | ```<br>goals.automation = automation_blocks.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>goals.automation = campaigns.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#groups "Opens in new tab: ActiveCampaign documentation")<br><br><br>[groups schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/groups.json "Opens in new tab: groups schema on GitHub")<br><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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updated\_timestamp |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#lists "Opens in new tab: ActiveCampaign documentation")<br><br><br>[lists schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/lists.json "Opens in new tab: lists schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#users) | ```<br>lists.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>lists.userid = forms.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>lists.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>lists.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>lists.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>lists.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>lists.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#configs) | ```<br>lists.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>lists.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>lists.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>lists.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>lists.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>lists.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>lists.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>lists.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>lists.userid = campaigns.userid<br>``` |
| [webhooks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#webhooks) | ```<br>lists.id = webhooks.listid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | mdate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#messages "Opens in new tab: ActiveCampaign documentation")<br><br><br>[messages schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/messages.json "Opens in new tab: messages schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#users) | ```<br>messages.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>messages.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>messages.userid = lists.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>messages.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>messages.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>messages.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>messages.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>messages.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>messages.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>messages.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>messages.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>messages.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>messages.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>messages.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>messages.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>messages.userid = campaigns.userid<br>``` |
| [bounce_logs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#bounce-logs) | ```<br>messages.id = bounce_logs.messageid<br>``` |
| [campaign_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-messages) | ```<br>messages.id = campaign_messages.messageid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>messages.id = contact_lists.message<br>``` |
| [campaign_links](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | mdate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#saved-responses-1 "Opens in new tab: ActiveCampaign documentation")<br><br><br>[saved_responses schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/saved_responses.json "Opens in new tab: saved_responses schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#users) | ```<br>saved_responses.last_sent_user_id = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>saved_responses.last_sent_user_id = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>saved_responses.last_sent_user_id = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>saved_responses.last_sent_user_id = messages.userid<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>saved_responses.last_sent_user_id = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>saved_responses.last_sent_user_id = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>saved_responses.last_sent_user_id = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>saved_responses.last_sent_user_id = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>saved_responses.last_sent_user_id = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>saved_responses.last_sent_user_id = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>saved_responses.last_sent_user_id = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>saved_responses.last_sent_user_id = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>saved_responses.last_sent_user_id = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>saved_responses.last_sent_user_id = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>saved_responses.last_sent_user_id = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>saved_responses.last_sent_user_id = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | mdate |
| **Useful links** | [scores schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/scores.json "Opens in new tab: scores schema on GitHub")<br><br><br>[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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#segments "Opens in new tab: ActiveCampaign documentation")<br><br><br>[segments schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/segments.json "Opens in new tab: segments schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | ldate |
| **Useful links** | [site_messages schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/site_messages.json "Opens in new tab: site_messages schema on GitHub") |

site\_messages table foreign keys

| Join site\_messages with | on |
| --- | --- |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>site_messages.automation = automations.id<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>site_messages.automation = deal_activities.automation<br>``` |
| [goals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#goals) | ```<br>site_messages.automation = goals.automation<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>site_messages.automation = sms.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automation-blocks) | ```<br>site_messages.automation = automation_blocks.automation<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>site_messages.automation = campaigns.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand template<br><br><table> <tr> <td> <p> <strong>								detailed							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> <tr> <td> <p> <strong>								initial							</strong> </p> <p>							OBJECT																							</p><div><button><div>This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.</div></button></div> <p></p> </td> </tr> </table> |

### sms

| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | ldate |
| **Useful links** | [sms schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/sms.json "Opens in new tab: sms schema on GitHub") |

sms table foreign keys

| Join sms with | on |
| --- | --- |
| [users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#users) | ```<br>sms.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>sms.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>sms.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>sms.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>sms.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>sms.userid = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>sms.userid = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>sms.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>sms.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>sms.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>sms.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>sms.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>sms.userid = email_activities.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>sms.userid = automations.userid<br>```<br><br>```<br>sms.automation = automations.id<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>sms.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>sms.userid = campaigns.userid<br>```<br><br>```<br>sms.automation = campaigns.automation<br>``` |
| [goals](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#goals) | ```<br>sms.automation = goals.automation<br>``` |
| [site_messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#site-messages) | ```<br>sms.automation = site_messages.automation<br>``` |
| [automation_blocks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automation-blocks) | ```<br>sms.automation = automation_blocks.automation<br>``` |
| [contact_automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [tags schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/tags.json "Opens in new tab: tags schema on GitHub")<br><br><br>[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/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#deal-task-types "Opens in new tab: ActiveCampaign documentation")<br><br><br>[task_types schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/task_types.json "Opens in new tab: task_types schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | udate |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#tasks "Opens in new tab: ActiveCampaign documentation")<br><br><br>[tasks schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/tasks.json "Opens in new tab: tasks schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#users) | ```<br>tasks.user = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>tasks.user = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>tasks.user = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>tasks.user = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>tasks.user = saved_responses.last_sent_user_id<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>tasks.user = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>tasks.user = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>tasks.user = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>tasks.user = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>tasks.user = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>tasks.user = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>tasks.user = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>tasks.user = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>tasks.user = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>tasks.user = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>tasks.user = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaigns) | ```<br>tasks.user = campaigns.userid<br>``` |
| [task_types](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;.<br><br>Click to expand owner<br><br><table> <tr> <td> <p> <strong>								id							</strong> </p> <p>							INTEGER													</p> </td> </tr> <tr> <td> <p> <strong>								type							</strong> </p> <p>							STRING													</p> </td> </tr> </table> |
| **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | mdate |
| **Useful links** | [templates schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/templates.json "Opens in new tab: templates schema on GitHub")<br><br><br>[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/stitch/integrations/saas/activecampaign#users) | ```<br>templates.userid = users.id<br>``` |
| [forms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#forms) | ```<br>templates.userid = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>templates.userid = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>templates.userid = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>templates.userid = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>templates.userid = tasks.user<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>templates.userid = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>templates.userid = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>templates.userid = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>templates.userid = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>templates.userid = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>templates.userid = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>templates.userid = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>templates.userid = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>templates.userid = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>templates.userid = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [ActiveCampaign documentation](https://developers.activecampaign.com/reference#users "Opens in new tab: ActiveCampaign documentation")<br><br><br>[users schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/users.json "Opens in new tab: users schema on GitHub")<br><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/stitch/integrations/saas/activecampaign#forms) | ```<br>users.id = forms.userid<br>``` |
| [lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#lists) | ```<br>users.id = lists.userid<br>``` |
| [messages](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#messages) | ```<br>users.id = messages.userid<br>``` |
| [saved_responses](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#saved-responses) | ```<br>users.id = saved_responses.last_sent_user_id<br>``` |
| [tasks](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#tasks) | ```<br>users.id = tasks.user<br>``` |
| [templates](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#templates) | ```<br>users.id = templates.userid<br>``` |
| [activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#activities) | ```<br>users.id = activities.userid<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>users.id = campaign_lists.userid<br>``` |
| [configs](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#configs) | ```<br>users.id = configs.userid<br>``` |
| [contact_emails](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-emails) | ```<br>users.id = contact_emails.userid<br>``` |
| [deal_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-activities) | ```<br>users.id = deal_activities.userid<br>``` |
| [deal_group_users](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#deal-group-users) | ```<br>users.id = deal_group_users.user<br>``` |
| [email_activities](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#email-activities) | ```<br>users.id = email_activities.userid<br>``` |
| [sms](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#sms) | ```<br>users.id = sms.userid<br>``` |
| [automations](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#automations) | ```<br>users.id = automations.userid<br>``` |
| [calendars](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#calendars) | ```<br>users.id = calendars.userid<br>``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id |
| **Useful links** | [webhooks schema on GitHub](https://github.com/singer-io/tap-activecampaign/blob/master/tap_activecampaign/schemas/webhooks.json "Opens in new tab: webhooks schema on GitHub")<br><br><br>[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/stitch/integrations/saas/activecampaign#lists) | ```<br>webhooks.listid = lists.id<br>``` |
| [campaign_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#campaign-lists) | ```<br>webhooks.listid = campaign_lists.listid<br>``` |
| [contact_lists](https://help.qlik.com/en-US/stitch/integrations/saas/activecampaign#contact-lists) | ```<br>webhooks.listid = contact_lists.list<br>``` |

webhooks table schema

| **cdate**<br><br><br>DATE-TIME |
| --- |
| **events**<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **id**<br><br><br>INTEGER |
| **listid**<br><br><br>INTEGER |
| **name**<br><br><br>STRING |
| **sources**<br><br>ARRAY<br><br>This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. &lt;a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'&gt;Learn more&lt;/a&gt;. |
| **url**<br><br><br>STRING |