ActiveCampaign Fields
This page provides a comprehensive reference of all supported metrics and breakdowns available for ActiveCampaign data extraction through Adzviser.
Metrics
Accounts (computed aggregates)
| Field Name | Description |
|---|---|
| Total number of contacts | computed |
| Total number of deals | computed |
| Total number of accounts | computed |
Campaigns (top-level fields on campaign object)
| Field Name | Description |
|---|---|
| Sends | Total sends |
| Total opens/reads | Total opens/reads |
| Unique opens/reads | Unique opens/reads |
| Open rate | calculated: uniqueopens / send_amt |
| Total link clicks | Total total link clicks |
| Unique link clicks | Total unique link clicks |
| Unique subscriber clicks | Total unique subscriber clicks |
| Click rate | calculated: uniquelinkclicks / send_amt |
| Click to open rate | calculated: uniquelinkclicks / uniqueopens |
| Forwards | Forwards |
| Forward rate | calculated: forwards / send_amt |
| Unsubscribes | Unsubscribes |
| Unsubscribe rate | calculated: unsubscribes / send_amt |
| Campaign hard bounces | Total campaign hard bounces |
| Campaign soft bounces | Total campaign soft bounces |
| Total bounces | calculated: hardbounces + softbounces |
| Twitter mentions | social shares counter |
| Facebook shares | same field — social sharing metric |
| Number of campaigns | computed aggregate |
Contacts (per-contact fields)
| Field Name | Description |
|---|---|
| Contacts hard bounces | Total contacts hard bounces |
| Contacts soft bounces | Total contacts soft bounces |
Deals (computed from deal list)
| Field Name | Description |
|---|---|
| Deal total value | sum across deals |
| Deal average value | computed average |
| Deal average win probability | computed average of percent |
Breakdowns
Accounts (Organizations)
| Field Name | Description |
|---|---|
| Account name | Account name |
| Account ID | Account identifier |
| Account URL | Account URL |
| Account created date & time | Account created date & time |
| Account created date | Account created date |
| Account updated date & time | Account updated date & time |
| Account updated date | Account updated date |
Campaigns
| Field Name | Description |
|---|---|
| Campaign ID | Campaign identifier |
| Campaign name | Campaign name |
| Analytics campaign name | Analytics campaign name |
| Campaign type | Campaign type |
| Campaign segment ID | Campaign segment identifier |
| Campaign segment name | must resolve via segments API |
| Campaign automation ID | Campaign automation identifier |
| Campaign created date & time | Campaign created date & time |
| Campaign created date | Campaign created date |
| Campaign last modified date & time | Campaign last modified date & time |
| Campaign last modified date | Campaign last modified date |
| Campaign last sent date & time | Campaign last sent date & time |
| Campaign last sent date | Campaign last sent date |
| Campaign sender email | via basemessageid → message |
| Campaign subject | via basemessageid → message |
Contacts
| Field Name | Description |
|---|---|
| Contact ID | Contact identifier |
| Contact email | Contact email |
| Contact phone | Contact phone |
| Contact first name | Contact first name |
| Contact last name | Contact last name |
| Contact organization ID | Contact organization identifier |
| Contact organization name | available in contact response w/ include |
| Contact email local | Contact email local |
| Contact email domain | Contact email domain |
| Contact created date & time | Contact created date & time |
| Contact created date | Contact created date |
| Contact updated date & time | Contact updated date & time |
| Contact updated date | Contact updated date |
Deals
| Field Name | Description |
|---|---|
| Deal ID | Deal identifier |
| Deal title | Deal title |
| Deal description | Deal description |
| Deal status ID | 0=open, 1=won, 2=lost |
| Deal status | Deal status |
| Deal created date | Deal created date |
| Deal created date & time | Deal created date & time |
| Deal last modified date | Deal last modified date |
| Deal last modified date & time | Deal last modified date & time |
| Deal win probability | Deal win probability |
| Deal win probability last modified date | Deal win probability last modified date |
| Deal currency | Deal currency |
| Deal contact ID | Deal contact identifier |
| Deal contact first name | via contact relationship |
| Deal contact last name | via contact relationship |
| Deal contact email | via contact relationship |
| Deal contact phone | via contact relationship |
| Deal organization ID | Deal organization identifier |
| Deal organization name | via organization relationship |
| Deal owner ID | Deal owner identifier |
| Deal owner email | via owner relationship |
| Deal owner first name | via owner relationship |
| Deal owner last name | via owner relationship |
| Deal pipeline ID | AC uses "group" for pipeline |
| Deal pipeline title | via dealGroup relationship |
| Deal stage ID | Deal stage identifier |
| Deal stage title | via dealStage relationship |