ActiveCampaign
The table below gives information about all the data fields that you can import from ActiveCampaign.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
account.accountUrl |
account.accountUrl |
String |
|
dimension |
|
|
account.createdTimestamp |
account.createdTimestamp |
String |
|
dimension |
|
|
account.id |
account.id |
String |
|
dimension |
|
|
account.name |
account.name |
String |
|
dimension |
|
|
account.updatedTimestamp |
account.updatedTimestamp |
String |
|
dimension |
|
|
activitycount |
activitycount |
Long |
|
metric |
|
|
adate |
adate |
String |
|
dimension |
|
|
allgroups |
allgroups |
Long |
|
metric |
|
|
allusers |
allusers |
Long |
|
metric |
|
|
anonymized |
anonymized |
Long |
|
metric |
|
|
assigned_date |
assigned_date |
String |
|
dimension |
|
|
assignee |
assignee |
Long |
|
metric |
|
|
assignee.cdate |
assignee.cdate |
String |
|
dimension |
|
|
assignee.email |
assignee.email |
String |
|
dimension |
|
|
assignee.firstName |
assignee.firstName |
String |
|
dimension |
|
|
assignee.id |
assignee.id |
String |
|
dimension |
|
|
assignee.lastName |
assignee.lastName |
String |
|
dimension |
|
|
assignee.localZoneid |
assignee.localZoneid |
String |
|
dimension |
|
|
assignee.phone |
assignee.phone |
String |
|
dimension |
|
|
assignee.udate |
assignee.udate |
String |
|
dimension |
|
|
assignee.username |
assignee.username |
String |
|
dimension |
|
|
autoassign |
autoassign |
Long |
|
metric |
|
|
automation |
automation |
Long |
|
metric |
|
|
bounced_date |
bounced_date |
String |
|
dimension |
|
|
bounced_hard |
bounced_hard |
Long |
|
metric |
|
|
bounced_soft |
bounced_soft |
Long |
|
metric |
|
|
cdate |
cdate |
String |
|
dimension |
|
|
connectionid |
connectionid |
String |
|
dimension |
|
|
contact.adate |
contact.adate |
String |
|
dimension |
|
|
contact.anonymized |
contact.anonymized |
Long |
|
metric |
|
|
contact.bounced_date |
contact.bounced_date |
String |
|
dimension |
|
|
contact.bounced_hard |
contact.bounced_hard |
Long |
|
metric |
|
|
contact.bounced_soft |
contact.bounced_soft |
Long |
|
metric |
|
|
contact.cdate |
contact.cdate |
String |
|
dimension |
|
|
contact.created_by |
contact.created_by |
Long |
|
metric |
|
|
contact.created_timestamp |
contact.created_timestamp |
DateTime |
|
dimension |
|
|
contact.created_utc_timestamp |
contact.created_utc_timestamp |
DateTime |
|
dimension |
|
|
contact.deleted |
contact.deleted |
Long |
|
metric |
|
|
contact.deleted_at |
contact.deleted_at |
String |
|
dimension |
|
|
contact.edate |
contact.edate |
String |
|
dimension |
|
|
contact.email |
contact.email |
String |
|
dimension |
|
|
contact.email_domain |
contact.email_domain |
String |
|
dimension |
|
|
contact.email_local |
contact.email_local |
String |
|
dimension |
|
|
contact.firstName |
contact.firstName |
String |
|
dimension |
|
|
contact.gravatar |
contact.gravatar |
Long |
|
metric |
|
|
contact.hash |
contact.hash |
String |
|
dimension |
|
|
contact.id |
contact.id |
Long |
|
metric |
|
|
contact.ip |
contact.ip |
Long |
|
metric |
|
|
contact.lastName |
contact.lastName |
String |
|
dimension |
|
|
contact.organization |
contact.organization |
Long |
|
metric |
|
|
contact.orgid |
contact.orgid |
Long |
|
metric |
|
|
contact.orgname |
contact.orgname |
String |
|
dimension |
|
|
contact.phone |
contact.phone |
Long |
|
metric |
|
|
contact.rating_tstamp |
contact.rating_tstamp |
String |
|
dimension |
|
|
contact.segmentio_id |
contact.segmentio_id |
String |
|
dimension |
|
|
contact.sentcnt |
contact.sentcnt |
Long |
|
metric |
|
|
contact.socialdata_lastcheck |
contact.socialdata_lastcheck |
String |
|
dimension |
|
|
contact.ua |
contact.ua |
String |
|
dimension |
|
|
contact.udate |
contact.udate |
String |
|
dimension |
|
|
contact.updated_by |
contact.updated_by |
Long |
|
dimension |
|
|
contact.updated_timestamp |
contact.updated_timestamp |
DateTime |
|
dimension |
|
|
contact.updated_utc_timestamp |
contact.updated_utc_timestamp |
DateTime |
|
dimension |
|
|
created_by |
created_by |
Long |
|
metric |
|
|
created_timestamp |
created_timestamp |
DateTime |
|
dimension |
|
|
created_utc_timestamp |
created_utc_timestamp |
DateTime |
|
dimension |
|
|
createdseriesid |
createdseriesid |
Long |
|
metric |
|
|
currency |
currency |
String |
|
dimension |
|
|
customerAccount |
customerAccount |
Long |
|
metric |
|
|
customerid |
customerid |
String |
|
dimension |
|
|
deal.account |
deal.account |
String |
|
dimension |
|
|
deal.activitycount |
deal.activitycount |
String |
|
dimension |
|
|
deal.cdate |
deal.cdate |
String |
|
dimension |
|
|
deal.contact |
deal.contact |
String |
|
dimension |
|
|
deal.currency |
deal.currency |
String |
|
dimension |
|
|
deal.customerAccount |
deal.customerAccount |
String |
|
dimension |
|
|
deal.description |
deal.description |
String |
|
dimension |
|
|
deal.edate |
deal.edate |
String |
|
dimension |
|
|
deal.group |
deal.group |
String |
|
dimension |
|
|
deal.hash |
deal.hash |
String |
|
dimension |
|
|
deal.id |
deal.id |
String |
|
dimension |
|
|
deal.isDisabled |
deal.isDisabled |
String |
|
dimension |
|
|
deal.mdate |
deal.mdate |
String |
|
dimension |
|
|
deal.nextTask |
deal.nextTask |
String |
|
dimension |
|
|
deal.nextdate |
deal.nextdate |
String |
|
dimension |
|
|
deal.nextdealid |
deal.nextdealid |
String |
|
dimension |
|
|
deal.nexttaskid |
deal.nexttaskid |
String |
|
dimension |
|
|
deal.organization |
deal.organization |
String |
|
dimension |
|
|
deal.percent |
deal.percent |
String |
|
dimension |
|
|
deal.stage |
deal.stage |
String |
|
dimension |
|
|
deal.status |
deal.status |
String |
|
dimension |
|
|
deal.title |
deal.title |
String |
|
dimension |
|
|
deal.value |
deal.value |
String |
|
dimension |
|
|
deal.winProbability |
deal.winProbability |
String |
|
dimension |
|
|
deal.winProbabilityMdate |
deal.winProbabilityMdate |
String |
|
dimension |
|
|
dealGroup.allgroups |
dealGroup.allgroups |
Long |
|
metric |
|
|
dealGroup.allusers |
dealGroup.allusers |
Long |
|
metric |
|
|
dealGroup.autoassign |
dealGroup.autoassign |
Long |
|
metric |
|
|
dealGroup.cdate |
dealGroup.cdate |
String |
|
dimension |
|
|
dealGroup.currency |
dealGroup.currency |
String |
|
dimension |
|
|
dealGroup.id |
dealGroup.id |
Long |
|
metric |
|
|
dealGroup.title |
dealGroup.title |
String |
|
dimension |
|
|
dealGroup.udate |
dealGroup.udate |
String |
|
dimension |
|
|
dealGroup.win_probability_initialize_date |
dealGroup.win_probability_initialize_date |
String |
|
dimension |
|
|
dealStage.cardRegion1 |
dealStage.cardRegion1 |
String |
|
dimension |
|
|
dealStage.cardRegion2 |
dealStage.cardRegion2 |
String |
|
dimension |
|
|
dealStage.cardRegion3 |
dealStage.cardRegion3 |
String |
|
dimension |
|
|
dealStage.cardRegion4 |
dealStage.cardRegion4 |
String |
|
dimension |
|
|
dealStage.cardRegion5 |
dealStage.cardRegion5 |
String |
|
dimension |
|
|
dealStage.cdate |
dealStage.cdate |
String |
|
dimension |
|
|
dealStage.color |
dealStage.color |
String |
|
dimension |
|
|
dealStage.dealOrder |
dealStage.dealOrder |
String |
|
dimension |
|
|
dealStage.group |
dealStage.group |
Long |
|
metric |
|
|
dealStage.id |
dealStage.id |
Long |
|
metric |
|
|
dealStage.order |
dealStage.order |
Long |
|
metric |
|
|
dealStage.title |
dealStage.title |
String |
|
dimension |
|
|
dealStage.udate |
dealStage.udate |
String |
|
dimension |
|
|
dealStage.width |
dealStage.width |
Long |
|
metric |
|
|
dealTasktype.cdate |
dealTasktype.cdate |
String |
|
dimension |
|
|
dealTasktype.defduration |
dealTasktype.defduration |
Long |
|
metric |
|
|
dealTasktype.id |
dealTasktype.id |
Long |
|
metric |
|
|
dealTasktype.status |
dealTasktype.status |
Long |
|
metric |
|
|
dealTasktype.title |
dealTasktype.title |
String |
|
dimension |
|
|
dealTasktype.udate |
dealTasktype.udate |
String |
|
dimension |
|
|
deleted |
deleted |
Long |
|
metric |
|
|
deleted_at |
deleted_at |
String |
|
dimension |
|
|
description |
description |
String |
|
dimension |
|
|
doneAutomation |
doneAutomation |
Long |
|
metric |
|
|
donedate |
donedate |
String |
|
dimension |
|
|
duedate |
duedate |
String |
|
dimension |
|
|
duration |
duration |
Long |
|
metric |
|
|
ecomCustomer.email |
ecomCustomer.email |
String |
|
dimension |
|
|
ecomCustomer.externalid |
ecomCustomer.externalid |
String |
|
dimension |
|
|
edate |
edate |
String |
|
dimension |
|
|
|
|
String |
|
dimension |
|
|
email_domain |
email_domain |
String |
|
dimension |
|
|
email_local |
email_local |
String |
|
dimension |
|
|
externalid |
externalid |
String |
|
dimension |
|
|
firstName |
firstName |
String |
|
dimension |
|
|
gravatar |
gravatar |
Long |
|
metric |
|
|
group |
group |
Long |
|
metric |
|
|
hash |
hash |
String |
|
dimension |
|
|
id |
id |
Long |
|
dimension |
|
|
ip |
ip |
Long |
|
metric |
|
|
isDisabled |
isDisabled |
Boolean |
|
dimension |
|
|
lastName |
lastName |
String |
|
dimension |
|
|
localZoneid |
localZoneid |
String |
|
dimension |
|
|
mdate |
mdate |
String |
|
dimension |
|
|
mfaEnabled |
mfaEnabled |
Long |
|
metric |
|
|
nextTask |
nextTask |
Long |
|
metric |
|
|
nextdate |
nextdate |
String |
|
dimension |
|
|
nextdealid |
nextdealid |
Long |
|
metric |
|
|
nexttaskid |
nexttaskid |
Long |
|
metric |
|
|
note |
note |
String |
|
dimension |
|
|
orderDate |
orderDate |
String |
|
dimension |
|
|
orderNumber |
orderNumber |
String |
|
dimension |
|
|
orderProducts |
orderProducts |
String |
|
dimension |
|
|
orderUrl |
orderUrl |
String |
|
dimension |
|
|
organization |
organization |
Long |
|
metric |
|
|
orgid |
orgid |
Long |
|
metric |
|
|
orgname |
orgname |
String |
|
dimension |
|
|
owner |
owner |
Long |
|
metric |
|
|
owner.cdate |
owner.cdate |
String |
|
dimension |
|
|
owner.email |
owner.email |
String |
|
dimension |
|
|
owner.firstName |
owner.firstName |
String |
|
dimension |
|
|
owner.id |
owner.id |
Long |
|
metric |
|
|
owner.lastName |
owner.lastName |
String |
|
dimension |
|
|
owner.localZoneid |
owner.localZoneid |
String |
|
dimension |
|
|
owner.phone |
owner.phone |
String |
|
dimension |
|
|
owner.udate |
owner.udate |
String |
|
dimension |
|
|
owner.uername |
owner.uername |
String |
|
dimension |
|
|
owner.username |
owner.username |
String |
|
dimension |
|
|
password_updated_utc_timestamp |
password_updated_utc_timestamp |
String |
|
dimension |
|
|
percent |
percent |
Long |
|
metric |
|
|
phone |
phone |
String |
|
dimension |
|
|
rating_tstamp |
rating_tstamp |
Date |
|
dimension |
|
|
relTitle |
relTitle |
String |
|
dimension |
|
|
relid |
relid |
Long |
|
metric |
|
|
reltype |
reltype |
String |
|
dimension |
|
|
segmentio_id |
segmentio_id |
String |
|
dimension |
|
|
sentcnt |
sentcnt |
Long |
|
metric |
|
|
shippingMethod |
shippingMethod |
String |
|
dimension |
|
|
signature |
signature |
String |
|
dimension |
|
|
socialdata_lastcheck |
socialdata_lastcheck |
String |
|
dimension |
|
|
source |
source |
String |
|
dimension |
|
|
stage |
stage |
Long |
|
metric |
|
|
status |
status |
Long |
|
metric |
|
|
title |
title |
String |
|
dimension |
|
|
totalPrice |
totalPrice |
Long |
|
metric |
|
|
ua |
ua |
String |
|
dimension |
|
|
udate |
udate |
String |
|
dimension |
|
|
updated_by |
updated_by |
Long |
|
dimension |
|
|
updated_timestamp |
updated_timestamp |
DateTime |
|
dimension |
|
|
updated_utc_timestamp |
updated_utc_timestamp |
DateTime |
|
dimension |
|
|
user.cdate |
user.cdate |
String |
|
dimension |
|
|
user.email |
user.email |
String |
|
dimension |
|
|
user.firstName |
user.firstName |
String |
|
dimension |
|
|
user.id |
user.id |
Long |
|
metric |
|
|
user.lastName |
user.lastName |
String |
|
dimension |
|
|
user.localZoneid |
user.localZoneid |
String |
|
dimension |
|
|
user.mfaEnabled |
user.mfaEnabled |
Long |
|
metric |
|
|
user.password_updated_utc_timestamp |
user.password_updated_utc_timestamp |
String |
|
dimension |
|
|
user.phone |
user.phone |
String |
|
dimension |
|
|
user.signature |
user.signature |
String |
|
dimension |
|
|
user.udate |
user.udate |
String |
|
dimension |
|
|
user.username |
user.username |
String |
|
dimension |
|
|
username |
username |
String |
|
dimension |
|
|
value |
value |
Long |
|
metric |
|
|
winProbability |
winProbability |
Long |
|
metric |
|
|
winProbabilityMdate |
winProbabilityMdate |
String |
|
dimension |
|
|
win_probability_initialize_date |
win_probability_initialize_date |
String |
|
dimension |
|