# ActiveCampaign datasets and fields

> The 15 datasets Maven lands from ActiveCampaign, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/activecampaign

Maven lands 15 datasets from ActiveCampaign in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [ActiveCampaign integration page](https://mavendata.ai/integrations/activecampaign).

## Connection and sync

You connect ActiveCampaign with API credentials from the ActiveCampaign account. Maven stores them encrypted.

Each ActiveCampaign sync takes a fresh copy of the current records, so the workspace always reflects what is in ActiveCampaign now.

## Datasets

### Contacts

Contacts with lifecycle, subscription, and association references.

| Field | Type |
| --- | --- |
| activecampaign contact ID | Text |
| email | Text |
| first name | Text |
| last name | Text |
| phone | Text |
| status | Integer |
| status label | Text |
| organization ID | Text |
| score | Number |
| sent count | Integer |
| bounced hard | Integer |
| bounced soft | Integer |
| bounced at | Timestamp |
| last click at | Timestamp |
| last open at | Timestamp |
| last mpp open at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| deleted at | Timestamp |
| deleted | True/false |
| contact lists json | Text |
| contact automations json | Text |
| account contacts json | Text |
| deals json | Text |
| custom fields | Text |
| account ID | Text |
| account name | Text |

### Accounts

CRM accounts / organizations.

| Field | Type |
| --- | --- |
| activecampaign account ID | Text |
| account display name | Text |
| account URL | Text |
| owner ID | Text |
| contact count | Integer |
| deal count | Integer |
| created at | Timestamp |
| updated at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |

### Account contacts

Associations between CRM accounts and contacts.

| Field | Type |
| --- | --- |
| activecampaign account contact ID | Text |
| activecampaign account ID | Text |
| activecampaign contact ID | Text |
| job title | Text |
| last contact at | Timestamp |
| last contact type | Text |
| created at | Timestamp |
| updated at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |

### Deals

CRM deals / opportunities.

| Field | Type |
| --- | --- |
| activecampaign deal ID | Text |
| deal name | Text |
| description | Text |
| status | Integer |
| status label | Text |
| activecampaign contact ID | Text |
| activecampaign account ID | Text |
| owner ID | Text |
| pipeline ID | Text |
| stage ID | Text |
| currency | Text |
| value | Number |
| value raw | Text |
| stage probability | Number |
| activity count | Integer |
| next task ID | Text |
| next task at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| expected close at | Timestamp |
| is disabled | True/false |
| links json | Text |
| next task json | Text |
| custom fields | Text |
| account ID | Text |
| account name | Text |

### Contact deals

Secondary contacts associated with CRM deals.

| Field | Type |
| --- | --- |
| activecampaign contact deal ID | Text |
| activecampaign deal ID | Text |
| activecampaign contact ID | Text |
| role | Text |
| created at | Timestamp |
| updated at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |

### Deal activities

Deal activity history including explicit stage changes.

| Field | Type |
| --- | --- |
| activecampaign deal activity ID | Text |
| activecampaign deal ID | Text |
| stage ID | Text |
| user ID | Text |
| automation ID | Text |
| series ID | Text |
| data type | Text |
| data ID | Text |
| data action | Text |
| data old value | Text |
| is deleted | True/false |
| is add task | True/false |
| created at | Timestamp |
| sort at | Timestamp |
| account ID | Text |
| account name | Text |

### Users

ActiveCampaign users / owners.

| Field | Type |
| --- | --- |
| activecampaign user ID | Text |
| email | Text |
| first name | Text |
| last name | Text |
| username | Text |
| phone | Text |
| language | Text |
| local zone ID | Text |
| mfa enabled | True/false |
| roles json | Text |
| links json | Text |
| account ID | Text |
| account name | Text |

### Pipelines

Deal pipelines.

| Field | Type |
| --- | --- |
| activecampaign pipeline ID | Text |
| pipeline name | Text |
| currency | Text |
| deal count | Integer |
| source | Text |
| auto assign | Integer |
| all groups | True/false |
| all users | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| win probability initialized at | Timestamp |
| stages json | Text |
| links json | Text |
| account ID | Text |
| account name | Text |

### Stages

Deal pipeline stages.

| Field | Type |
| --- | --- |
| activecampaign stage ID | Text |
| activecampaign pipeline ID | Text |
| stage name | Text |
| display order | Integer |
| color | Text |
| width | Integer |
| deal order | Text |
| card region 1 | Text |
| card region 2 | Text |
| card region 3 | Text |
| card region 4 | Text |
| card region 5 | Text |
| created at | Timestamp |
| updated at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |

### Campaigns

Email campaigns with aggregate activity where available.

| Field | Type |
| --- | --- |
| activecampaign campaign ID | Text |
| campaign name | Text |
| subject | Text |
| status | Integer |
| status label | Text |
| campaign type | Text |
| automation ID | Text |
| list ID | Text |
| message ID | Text |
| send date | Date |
| sent at | Timestamp |
| last sent at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| from name | Text |
| from email | Text |
| sends | Integer |
| opens | Integer |
| unique opens | Integer |
| open rate | Number |
| clicks | Integer |
| unique clicks | Integer |
| click rate | Number |
| bounces | Integer |
| unsubscribes | Integer |
| forwards | Integer |
| links json | Text |
| account ID | Text |
| account name | Text |

### Lists

Email lists.

| Field | Type |
| --- | --- |
| activecampaign list ID | Text |
| list name | Text |
| description | Text |
| channel | Text |
| sender name | Text |
| sender URL | Text |
| sender addr1 | Text |
| sender city | Text |
| sender state | Text |
| sender country | Text |
| sender zip | Text |
| active subscribers | Integer |
| non deleted subscribers | Integer |
| created by | Text |
| created at | Timestamp |
| updated at | Timestamp |
| deleted at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |

### Contact lists

Contact list memberships.

| Field | Type |
| --- | --- |
| activecampaign contact list ID | Text |
| activecampaign contact ID | Text |
| activecampaign list ID | Text |
| status | Integer |
| status label | Text |
| subscribed at | Timestamp |
| updated at | Timestamp |
| first name | Text |
| last name | Text |
| form ID | Text |
| automation ID | Text |
| campaign ID | Text |
| message ID | Text |
| source ID | Text |
| responder | True/false |
| sync | True/false |
| unsubscribe reason | Text |
| created by | Text |
| created at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |

### Automations

Automation workflows.

| Field | Type |
| --- | --- |
| activecampaign automation ID | Text |
| automation name | Text |
| description | Text |
| status | Integer |
| status label | Text |
| user ID | Text |
| source | Text |
| entered contacts | Integer |
| exited contacts | Integer |
| hidden | True/false |
| multi entry | True/false |
| exit on unsubscribe | True/false |
| exit on conversion | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |

### Contact automations

Contact enrollment/progress through automations.

| Field | Type |
| --- | --- |
| activecampaign contact automation ID | Text |
| activecampaign contact ID | Text |
| activecampaign automation ID | Text |
| series ID | Text |
| status | Integer |
| status label | Text |
| added at | Timestamp |
| removed at | Timestamp |
| last at | Timestamp |
| last block | Text |
| last log ID | Text |
| start ID | Text |
| batch ID | Text |
| completed elements | Integer |
| total elements | Integer |
| completed | True/false |
| complete value | Number |
| timespan | Integer |
| in als | True/false |
| subscriber series end ID | Text |
| links json | Text |
| account ID | Text |
| account name | Text |

### Tags

Tag definitions used for contact and deal segmentation.

| Field | Type |
| --- | --- |
| activecampaign tag ID | Text |
| tag name | Text |
| tag type | Text |
| description | Text |
| subscriber count | Integer |
| created at | Timestamp |
| updated at | Timestamp |
| links json | Text |
| account ID | Text |
| account name | Text |
