Integrations
ActiveCampaign datasets and fields
The 15 datasets Maven lands from ActiveCampaign, every field in them, and how the connection syncs.
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.
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 |
| 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 |
| 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 |