ActiveCampaign: Most-used fields

The table below gives information about most-used fields that you can import from ActiveCampaign. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Use in Adverity
activerss_interval	activerss_interval	dimension
activerss_items	activerss_items	metric
activerss_url	activerss_url	dimension
activitycount	activitycount	dimension
adate	adate	dimension
addressid	addressid	metric
allgroups	allgroups	metric
allusers	allusers	metric
anonymized	anonymized	dimension
assigned_date	assigned_date	dimension
assignee.cdate	assignee.cdate	dimension
assignee.email	assignee.email	dimension
assignee.firstName	assignee.firstName	dimension
assignee.id	assignee.id	dimension
assignee.lastName	assignee.lastName	dimension
assignee.localZoneid	assignee.localZoneid	dimension
assignee.phone	assignee.phone	dimension
assignee.udate	assignee.udate	dimension
assignee.username	assignee.username	dimension
autoassign	autoassign	metric
automation	automation	metric
basemessageid	basemessageid	metric
basetemplateid	basetemplateid	dimension
bounced_date	bounced_date	dimension
bounced_hard	bounced_hard	dimension
bounced_soft	bounced_soft	dimension
bounceid	bounceid	metric
campaign_message_id	campaign_message_id	dimension
can_skip_approval	can_skip_approval	metric
cdate	cdate	dimension
connectionid	connectionid	dimension
contact.adate	contact.adate	dimension
contact.anonymized	contact.anonymized	dimension
contact.bounced_date	contact.bounced_date	dimension
contact.bounced_hard	contact.bounced_hard	dimension
contact.bounced_soft	contact.bounced_soft	dimension
contact.cdate	contact.cdate	dimension
contact.created_by	contact.created_by	dimension
contact.created_timestamp	contact.created_timestamp	dimension
contact.created_utc_timestamp	contact.created_utc_timestamp	dimension
contact.deleted	contact.deleted	dimension
contact.deleted_at	contact.deleted_at	dimension
contact.edate	contact.edate	dimension
contact.email	contact.email	dimension
contact.email_domain	contact.email_domain	dimension
contact.email_local	contact.email_local	dimension
contact.firstName	contact.firstName	dimension
contact.gravatar	contact.gravatar	dimension
contact.hash	contact.hash	dimension
contact.id	contact.id	dimension
contact.ip	contact.ip	dimension
contact.lastName	contact.lastName	dimension
contact.organization	contact.organization	dimension
contact.orgid	contact.orgid	dimension
contact.orgname	contact.orgname	dimension
contact.phone	contact.phone	dimension
contact.rating_tstamp	contact.rating_tstamp	dimension
contact.sentcnt	contact.sentcnt	dimension
contact.socialdata_lastcheck	contact.socialdata_lastcheck	dimension
contact.ua	contact.ua	dimension
contact.udate	contact.udate	dimension
contact.updated_by	contact.updated_by	dimension
contact.updated_timestamp	contact.updated_timestamp	dimension
contact.updated_utc_timestamp	contact.updated_utc_timestamp	dimension
created_by	created_by	metric
created_date	created_date	dimension
created_timestamp	created_timestamp	dimension
created_utc_timestamp	created_utc_timestamp	dimension
createdseriesid	createdseriesid	dimension
currency	currency	dimension
customField[{PLACEHOLDER}]	customField[{PLACEHOLDER}]	dimension
customerAccount	customerAccount	dimension
customerid	customerid	dimension
dealGroup.allgroups	dealGroup.allgroups	dimension
dealGroup.allusers	dealGroup.allusers	dimension
dealGroup.autoassign	dealGroup.autoassign	dimension
dealGroup.cdate	dealGroup.cdate	dimension
dealGroup.currency	dealGroup.currency	dimension
dealGroup.id	dealGroup.id	dimension
dealGroup.title	dealGroup.title	dimension
dealGroup.udate	dealGroup.udate	dimension
dealGroup.win_probability_initialize_date	dealGroup.win_probability_initialize_date	dimension
dealStage.cardRegion1	dealStage.cardRegion1	dimension
dealStage.cardRegion2	dealStage.cardRegion2	dimension
dealStage.cardRegion3	dealStage.cardRegion3	dimension
dealStage.cardRegion4	dealStage.cardRegion4	dimension
dealStage.cardRegion5	dealStage.cardRegion5	dimension
dealStage.cdate	dealStage.cdate	dimension
dealStage.color	dealStage.color	dimension
dealStage.dealOrder	dealStage.dealOrder	dimension
dealStage.group	dealStage.group	dimension
dealStage.id	dealStage.id	dimension
dealStage.order	dealStage.order	dimension
dealStage.title	dealStage.title	dimension
dealStage.udate	dealStage.udate	dimension
dealStage.width	dealStage.width	dimension
dealTasktype.cdate	dealTasktype.cdate	dimension
dealTasktype.defduration	dealTasktype.defduration	dimension
dealTasktype.id	dealTasktype.id	dimension
dealTasktype.status	dealTasktype.status	dimension
dealTasktype.title	dealTasktype.title	dimension
dealTasktype.udate	dealTasktype.udate	dimension
deleted	deleted	dimension
deleted_at	deleted_at	dimension
deletestamp	deletestamp	dimension
description	description	dimension
doneAutomation	doneAutomation	dimension
donedate	donedate	dimension
duedate	duedate	dimension
duration	duration	dimension
ecomCustomer.email	ecomCustomer.email	dimension
ecomCustomer.externalid	ecomCustomer.externalid	dimension
ed_version	ed_version	metric
edate	edate	dimension
email	email	dimension
email_domain	email_domain	dimension
email_local	email_local	dimension
embed_images	embed_images	metric
externalid	externalid	dimension
facebook	facebook	metric
firstName	firstName	dimension
formid	formid	metric
forwards	forwards	metric
gravatar	gravatar	dimension
group	group	dimension
hardbounces	hardbounces	metric
has_predictive_content	has_predictive_content	metric
hash	hash	dimension
htmlunsub	htmlunsub	metric
htmlunsubdata	htmlunsubdata	dimension
id	id	dimension
ip	ip	metric
ip4	ip4	metric
isDisabled	isDisabled	dimension
lastName	lastName	dimension
laststep	laststep	dimension
ldate	ldate	dimension
linkclicks	linkclicks	metric
localZoneid	localZoneid	dimension
mail_cleanup	mail_cleanup	metric
mail_send	mail_send	metric
mail_transfer	mail_transfer	metric
mailer_log_file	mailer_log_file	metric
mdate	mdate	dimension
message_id	message_id	dimension
mfaEnabled	mfaEnabled	metric
name	name	dimension
nextTask	nextTask	dimension
nextdate	nextdate	dimension
nextdealid	nextdealid	dimension
nexttaskid	nexttaskid	dimension
note	note	dimension
opens	opens	metric
orderDate	orderDate	dimension
orderNumber	orderNumber	dimension
orderProducts	orderProducts	dimension
orderUrl	orderUrl	dimension
organization	organization	dimension
orgid	orgid	dimension
orgname	orgname	dimension
owner.cdate	owner.cdate	dimension
owner.email	owner.email	dimension
owner.firstName	owner.firstName	dimension
owner.id	owner.id	dimension
owner.lastName	owner.lastName	dimension
owner.localZoneid	owner.localZoneid	dimension
owner.phone	owner.phone	dimension
owner.udate	owner.udate	dimension
owner.username	owner.username	dimension
password_updated_utc_timestamp	password_updated_utc_timestamp	dimension
percent	percent	dimension
phone	phone	dimension
public	public	metric
rating_tstamp	rating_tstamp	dimension
realcid	realcid	metric
recurring	recurring	dimension
relid	relid	dimension
reltype	reltype	dimension
reminder_field	reminder_field	dimension
reminder_format	reminder_format	dimension
reminder_last_cron_run	reminder_last_cron_run	dimension
reminder_offset	reminder_offset	metric
reminder_offset_sign	reminder_offset_sign	dimension
reminder_offset_type	reminder_offset_type	dimension
reminder_type	reminder_type	dimension
replies	replies	metric
replysys	replysys	metric
responder_existing	responder_existing	metric
responder_offset	responder_offset	metric
responder_type	responder_type	dimension
schedule	schedule	metric
scheduleddate	scheduleddate	dimension
screenshot	screenshot	dimension
sdate	sdate	dimension
segmentid	segmentid	metric
send_amt	send_amt	metric
sendid	sendid	metric
sentcnt	sentcnt	dimension
series_send_lock_time	series_send_lock_time	dimension
seriesid	seriesid	metric
shippingMethod	shippingMethod	dimension
signature	signature	dimension
socialdata_lastcheck	socialdata_lastcheck	dimension
socialshares	socialshares	metric
softbounces	softbounces	metric
source	source	dimension
split_content	split_content	metric
split_offset	split_offset	metric
split_offset_type	split_offset_type	dimension
split_type	split_type	dimension
split_winner_awaiting	split_winner_awaiting	metric
split_winner_messageid	split_winner_messageid	metric
stage	stage	dimension
status	status	metric
subscriberclicks	subscriberclicks	metric
survey	survey	dimension
textunsub	textunsub	metric
textunsubdata	textunsubdata	dimension
threadid	threadid	metric
title	title	dimension
totalPrice	totalPrice	dimension
total_amt	total_amt	metric
tracklinks	tracklinks	dimension
tracklinksanalytics	tracklinksanalytics	metric
trackreads	trackreads	metric
trackreadsanalytics	trackreadsanalytics	metric
tweet	tweet	metric
type	type	dimension
ua	ua	dimension
udate	udate	dimension
uniqueforwards	uniqueforwards	metric
uniquelinkclicks	uniquelinkclicks	metric
uniqueopens	uniqueopens	metric
uniquereplies	uniquereplies	metric
unsubreasons	unsubreasons	metric
unsubscribes	unsubscribes	metric
updated_by	updated_by	metric
updated_timestamp	updated_timestamp	dimension
updated_utc_timestamp	updated_utc_timestamp	dimension
updates	updates	metric
use_quartz_scheduler	use_quartz_scheduler	metric
user	user	metric
user.cdate	user.cdate	dimension
user.email	user.email	dimension
user.firstName	user.firstName	dimension
user.id	user.id	dimension
user.lastName	user.lastName	dimension
user.localZoneid	user.localZoneid	dimension
user.phone	user.phone	dimension
user.udate	user.udate	dimension
user.username	user.username	dimension
userid	userid	metric
username	username	dimension
value	value	dimension
verified_opens	verified_opens	metric
verified_unique_opens	verified_unique_opens	metric
waitpreview	waitpreview	metric
willrecur	willrecur	metric
winProbability	winProbability	dimension
winProbabilityMdate	winProbabilityMdate	dimension
win_probability_initialize_date	win_probability_initialize_date	dimension