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	Description	Use in Adverity
activerss_interval	activerss_interval	The interval for ActiveRSS feeds, indicating how frequently new content is checked or published.	dimension
activerss_items	activerss_items	The number of items in an ActiveRSS feed.	metric
activerss_url	activerss_url	The URL for the ActiveRSS feed.	dimension
activitycount	activitycount	The total count of activities.	dimension
adate	adate	The archive date or another relevant activity date.	dimension
addressid	addressid	The unique identifier for an address record.	metric
allgroups	allgroups	An indicator representing all groups.	metric
allusers	allusers	An indicator representing all users.	metric
anonymized	anonymized	Indicates if the data has been anonymized.	dimension
assigned_date	assigned_date	The date when a task or deal was assigned.	dimension
assignee.cdate	assignee.cdate	The creation date of the assignee.	dimension
assignee.email	assignee.email	The email address of the assignee.	dimension
assignee.firstName	assignee.firstName	The first name of the assignee.	dimension
assignee.id	assignee.id	The unique identifier of the assignee.	dimension
assignee.lastName	assignee.lastName	The last name of the assignee.	dimension
assignee.localZoneid	assignee.localZoneid	The local time zone ID of the assignee.	dimension
assignee.phone	assignee.phone	The phone number of the assignee.	dimension
assignee.udate	assignee.udate	The last update date of the assignee.	dimension
assignee.username	assignee.username	The username of the assignee.	dimension
autoassign	autoassign	Indicates if auto-assignment is enabled.	metric
automation	automation	An indicator related to an automation workflow.	metric
basemessageid	basemessageid	The unique identifier of the base message used in a campaign or automation.	metric
basetemplateid	basetemplateid	The unique identifier of the base template used for an email or campaign.	dimension
bounced_date	bounced_date	The date an email bounced.	dimension
bounced_hard	bounced_hard	Indicates if the email resulted in a hard bounce.	dimension
bounced_soft	bounced_soft	Indicates if the email resulted in a soft bounce.	dimension
bounceid	bounceid	The unique identifier for an email bounce event.	metric
campaign_message_id	campaign_message_id	The unique identifier for a message within a campaign.	dimension
can_skip_approval	can_skip_approval	Indicates if a campaign or message can skip the approval process.	metric
cdate	cdate	The creation date for a record.	dimension
connectionid	connectionid	The unique identifier for a connection.	dimension
contact.adate	contact.adate	The archive date or another relevant activity date for the contact.	dimension
contact.anonymized	contact.anonymized	Indicates if the contact’s data has been anonymized.	dimension
contact.bounced_date	contact.bounced_date	The date an email to this contact bounced.	dimension
contact.bounced_hard	contact.bounced_hard	Indicates if an email to this contact resulted in a hard bounce.	dimension
contact.bounced_soft	contact.bounced_soft	Indicates if an email to this contact resulted in a soft bounce.	dimension
contact.cdate	contact.cdate	The creation date of the contact.	dimension
contact.created_by	contact.created_by	The user who created the contact.	dimension
contact.created_timestamp	contact.created_timestamp	The timestamp when the contact was created.	dimension
contact.created_utc_timestamp	contact.created_utc_timestamp	The UTC timestamp when the contact was created.	dimension
contact.deleted	contact.deleted	Indicates if the contact has been deleted.	dimension
contact.deleted_at	contact.deleted_at	The timestamp when the contact was deleted.	dimension
contact.edate	contact.edate	The last activity date for the contact.	dimension
contact.email	contact.email	The email address of the contact.	dimension
contact.email_domain	contact.email_domain	The domain part of the contact’s email address.	dimension
contact.email_local	contact.email_local	The local part (username) of the contact’s email address.	dimension
contact.firstName	contact.firstName	The first name of the contact.	dimension
contact.gravatar	contact.gravatar	The Gravatar hash for the contact’s email.	dimension
contact.hash	contact.hash	A unique hash identifier for the contact.	dimension
contact.id	contact.id	The unique identifier for the contact.	dimension
contact.ip	contact.ip	The IP address associated with the contact.	dimension
contact.lastName	contact.lastName	The last name of the contact.	dimension
contact.organization	contact.organization	The organization the contact belongs to.	dimension
contact.orgid	contact.orgid	The unique identifier for the contact’s organization.	dimension
contact.orgname	contact.orgname	The name of the contact’s organization.	dimension
contact.phone	contact.phone	The phone number of the contact.	dimension
contact.rating_tstamp	contact.rating_tstamp	The timestamp of the last rating update for the contact.	dimension
contact.sentcnt	contact.sentcnt	The count of emails sent to the contact.	dimension
contact.socialdata_lastcheck	contact.socialdata_lastcheck	The timestamp of the last check for social data for the contact.	dimension
contact.ua	contact.ua	The user agent string associated with the contact’s activity.	dimension
contact.udate	contact.udate	The last update date for the contact.	dimension
contact.updated_by	contact.updated_by	The user who last updated the contact.	dimension
contact.updated_timestamp	contact.updated_timestamp	The timestamp when the contact was last updated.	dimension
contact.updated_utc_timestamp	contact.updated_utc_timestamp	The UTC timestamp when the contact was last updated.	dimension
created_by	created_by	The user who created the record.	metric
created_date	created_date	The date when the record was created.	dimension
created_timestamp	created_timestamp	The timestamp when the record was created.	dimension
created_utc_timestamp	created_utc_timestamp	The UTC timestamp when the record was created.	dimension
createdseriesid	createdseriesid	The unique identifier for the created series.	dimension
currency	currency	The currency used for a financial value.	dimension
customField[{PLACEHOLDER}]	customField[{PLACEHOLDER}]	A custom field created within ActiveCampaign to store additional, user-defined information for contacts or deals. The [{PLACEHOLDER}] indicates a specific custom field name.	dimension
customerAccount	customerAccount	The customer account associated with an order or transaction.	dimension
customerid	customerid	The unique identifier for a customer.	dimension
dealGroup.allgroups	dealGroup.allgroups	An indicator representing all deal groups within a deal pipeline.	dimension
dealGroup.allusers	dealGroup.allusers	An indicator representing all users associated with a deal group.	dimension
dealGroup.autoassign	dealGroup.autoassign	Indicates if auto-assignment is enabled for the deal group.	dimension
dealGroup.cdate	dealGroup.cdate	The creation date of the deal group (pipeline).	dimension
dealGroup.currency	dealGroup.currency	The currency used for deals within this group (pipeline).	dimension
dealGroup.id	dealGroup.id	The unique identifier for the deal group (pipeline).	dimension
dealGroup.title	dealGroup.title	The title or name of the deal group (pipeline).	dimension
dealGroup.udate	dealGroup.udate	The last update date of the deal group (pipeline).	dimension
dealGroup.win_probability_initialize_date	dealGroup.win_probability_initialize_date	The initialization date for the win probability calculation for the deal group.	dimension
dealStage.cardRegion1	dealStage.cardRegion1	A configurable region on the deal card for display purposes.	dimension
dealStage.cardRegion2	dealStage.cardRegion2	A configurable region on the deal card for display purposes.	dimension
dealStage.cardRegion3	dealStage.cardRegion3	A configurable region on the deal card for display purposes.	dimension
dealStage.cardRegion4	dealStage.cardRegion4	A configurable region on the deal card for display purposes.	dimension
dealStage.cardRegion5	dealStage.cardRegion5	A configurable region on the deal card for display purposes.	dimension
dealStage.cdate	dealStage.cdate	The creation date of the deal stage.	dimension
dealStage.color	dealStage.color	The color assigned to the deal stage.	dimension
dealStage.dealOrder	dealStage.dealOrder	The order of deals within this stage.	dimension
dealStage.group	dealStage.group	The deal group (pipeline) to which this stage belongs.	dimension
dealStage.id	dealStage.id	The unique identifier for the deal stage.	dimension
dealStage.order	dealStage.order	The display order of the deal stage within its pipeline.	dimension
dealStage.title	dealStage.title	The title or name of the deal stage.	dimension
dealStage.udate	dealStage.udate	The last update date of the deal stage.	dimension
dealStage.width	dealStage.width	The width setting for the deal stage display.	dimension
dealTasktype.cdate	dealTasktype.cdate	The creation date of the deal task type.	dimension
dealTasktype.defduration	dealTasktype.defduration	The default duration for this type of deal task.	dimension
dealTasktype.id	dealTasktype.id	The unique identifier for the deal task type.	dimension
dealTasktype.status	dealTasktype.status	The status associated with this deal task type.	dimension
dealTasktype.title	dealTasktype.title	The title or name of the deal task type.	dimension
dealTasktype.udate	dealTasktype.udate	The last update date of the deal task type.	dimension
deleted	deleted	Indicates if the record has been deleted.	dimension
deleted_at	deleted_at	The timestamp when the record was deleted.	dimension
deletestamp	deletestamp	The timestamp when the record was marked for deletion.	dimension
description	description	A descriptive text for the record.	dimension
doneAutomation	doneAutomation	Indicates if an automation process is completed.	dimension
donedate	donedate	The date when a task or item was completed.	dimension
duedate	duedate	The due date for a task or item.	dimension
duration	duration	The duration of a task or event.	dimension
ecomCustomer.email	ecomCustomer.email	The email address of the e-commerce customer.	dimension
ecomCustomer.externalid	ecomCustomer.externalid	The external ID of the e-commerce customer.	dimension
ed_version	ed_version	The version of the email designer used.	metric
edate	edate	The end date or last activity date for a record.	dimension
email	email	The email address.	dimension
email_domain	email_domain	The domain part of an email address.	dimension
email_local	email_local	The local part (username) of an email address.	dimension
embed_images	embed_images	Indicates if images are embedded in the email content.	metric
externalid	externalid	An external unique identifier for a record.	dimension
facebook	facebook	An indicator related to Facebook integration or sharing.	metric
firstName	firstName	The first name of an individual.	dimension
formid	formid	The unique identifier for a form submission.	metric
forwards	forwards	The total number of times an email was forwarded.	metric
gravatar	gravatar	The Gravatar hash.	dimension
group	group	The group or pipeline to which a deal belongs.	dimension
hardbounces	hardbounces	The number of hard bounces for an email campaign.	metric
has_predictive_content	has_predictive_content	Indicates if the content uses predictive features.	metric
hash	hash	A unique hash value for the record.	dimension
htmlunsub	htmlunsub	Indicates if an HTML unsubscribe link was included.	metric
htmlunsubdata	htmlunsubdata	Data related to HTML unsubscribe links.	dimension
id	id	The unique identifier for the record.	dimension
ip	ip	The IP address associated with an activity or record.	metric
ip4	ip4	The IPv4 address associated with an activity or record.	metric
isDisabled	isDisabled	Indicates if a user or entity is disabled.	dimension
lastName	lastName	The last name of an individual.	dimension
laststep	laststep	The last step completed in an automation or process.	dimension
ldate	ldate	The last date of an activity or event.	dimension
linkclicks	linkclicks	The total number of clicks on links within an email or campaign.	metric
localZoneid	localZoneid	The local time zone identifier.	dimension
mail_cleanup	mail_cleanup	An indicator for mail cleanup processes.	metric
mail_send	mail_send	An indicator related to the mail sending process.	metric
mail_transfer	mail_transfer	An indicator related to mail transfer.	metric
mailer_log_file	mailer_log_file	The log file for the mailer service.	metric
mdate	mdate	The modification date for a record.	dimension
message_id	message_id	The unique identifier for a message.	dimension
mfaEnabled	mfaEnabled	Indicates if Multi-Factor Authentication (MFA) is enabled for a user.	metric
name	name	The name of the record.	dimension
nextTask	nextTask	Information about the next task in a sequence.	dimension
nextdate	nextdate	The date of the next scheduled event or action.	dimension
nextdealid	nextdealid	The unique identifier of the next deal in a sequence.	dimension
nexttaskid	nexttaskid	The unique identifier of the next task in a sequence.	dimension
note	note	A textual note associated with the record.	dimension
opens	opens	The total number of times an email was opened.	metric
orderDate	orderDate	The date when an e-commerce order was placed.	dimension
orderNumber	orderNumber	The unique number for an e-commerce order.	dimension
orderProducts	orderProducts	Details about the products included in an e-commerce order.	dimension
orderUrl	orderUrl	The URL to view the e-commerce order details.	dimension
organization	organization	The organization associated with a contact or deal.	dimension
orgid	orgid	The unique identifier for an organization.	dimension
orgname	orgname	The name of the organization.	dimension
owner.cdate	owner.cdate	The creation date of the owner.	dimension
owner.email	owner.email	The email address of the owner.	dimension
owner.firstName	owner.firstName	The first name of the owner.	dimension
owner.id	owner.id	The unique identifier of the owner.	dimension
owner.lastName	owner.lastName	The last name of the owner.	dimension
owner.localZoneid	owner.localZoneid	The local time zone ID of the owner.	dimension
owner.phone	owner.phone	The phone number of the owner.	dimension
owner.udate	owner.udate	The last update date of the owner.	dimension
owner.username	owner.username	The username of the owner.	dimension
password_updated_utc_timestamp	password_updated_utc_timestamp	The UTC timestamp when the user’s password was last updated.	dimension
percent	percent	A percentage value.	dimension
phone	phone	The phone number.	dimension
public	public	An indicator if the record is publicly accessible.	metric
rating_tstamp	rating_tstamp	The timestamp of the last rating update.	dimension
realcid	realcid	The real campaign ID.	metric
recurring	recurring	Indicates if a campaign or process is recurring.	dimension
relid	relid	A related unique identifier.	dimension
reltype	reltype	The type of relationship.	dimension
reminder_field	reminder_field	The field used to trigger a reminder.	dimension
reminder_format	reminder_format	The format of the reminder.	dimension
reminder_last_cron_run	reminder_last_cron_run	The timestamp of the last cron job run for reminders.	dimension
reminder_offset	reminder_offset	The offset value for a reminder.	metric
reminder_offset_sign	reminder_offset_sign	The sign (+/-) of the reminder offset.	dimension
reminder_offset_type	reminder_offset_type	The type of offset used for a reminder (e.g., days, hours).	dimension
reminder_type	reminder_type	The type of reminder.	dimension
replies	replies	The total number of replies received for an email or campaign.	metric
replysys	replysys	An indicator for the reply system.	metric
responder_existing	responder_existing	Indicates if a responder is already existing.	metric
responder_offset	responder_offset	The offset value for a responder.	metric
responder_type	responder_type	The type of responder.	dimension
schedule	schedule	An indicator related to the scheduling of a campaign or task.	metric
scheduleddate	scheduleddate	The date when an item is scheduled.	dimension
screenshot	screenshot	A URL or reference to a screenshot of an email or page.	dimension
sdate	sdate	The start date of a campaign or event.	dimension
segmentid	segmentid	The unique identifier for a contact segment.	metric
send_amt	send_amt	The amount to send for a campaign.	metric
sendid	sendid	The unique identifier for a send event.	metric
sentcnt	sentcnt	The count of sent items.	dimension
series_send_lock_time	series_send_lock_time	The timestamp when a series send was locked.	dimension
seriesid	seriesid	The unique identifier for an email series.	metric
shippingMethod	shippingMethod	The shipping method used for an e-commerce order.	dimension
signature	signature	The email signature used.	dimension
socialdata_lastcheck	socialdata_lastcheck	The timestamp of the last check for social data.	dimension
socialshares	socialshares	The number of social shares for a campaign.	metric
softbounces	softbounces	The number of soft bounces for an email campaign.	metric
source	source	The source of the record or event.	dimension
split_content	split_content	An indicator related to A/B split testing content.	metric
split_offset	split_offset	The offset value for a split test.	metric
split_offset_type	split_offset_type	The type of offset used for a split test.	dimension
split_type	split_type	The type of split test.	dimension
split_winner_awaiting	split_winner_awaiting	Indicates if the split test is awaiting a winner.	metric
split_winner_messageid	split_winner_messageid	The message ID of the winning split test variation.	metric
stage	stage	The current stage of a deal in a sales pipeline.	dimension
status	status	The current status of the record or item.	metric
subscriberclicks	subscriberclicks	The number of clicks by subscribers.	metric
survey	survey	An indicator related to a survey.	dimension
textunsub	textunsub	Indicates if a text unsubscribe option was available.	metric
textunsubdata	textunsubdata	Data related to text unsubscribe options.	dimension
threadid	threadid	The unique identifier for a conversation thread.	metric
title	title	The title or name of the record.	dimension
totalPrice	totalPrice	The total price of an e-commerce order.	dimension
total_amt	total_amt	The total amount.	metric
tracklinks	tracklinks	Indicates if link clicks are being tracked.	dimension
tracklinksanalytics	tracklinksanalytics	An indicator for tracking link click analytics.	metric
trackreads	trackreads	Indicates if email reads (opens) are being tracked.	metric
trackreadsanalytics	trackreadsanalytics	An indicator for tracking read analytics.	metric
tweet	tweet	An indicator related to Twitter integration or sharing.	metric
type	type	The type of the record or object.	dimension
ua	ua	The user agent string.	dimension
udate	udate	The last update date for a record.	dimension
uniqueforwards	uniqueforwards	The number of unique forwards for an email.	metric
uniquelinkclicks	uniquelinkclicks	The number of unique clicks on links within an email or campaign.	metric
uniqueopens	uniqueopens	The number of unique opens for an email.	metric
uniquereplies	uniquereplies	The number of unique replies received for an email or campaign.	metric
unsubreasons	unsubreasons	The reasons provided for unsubscribing.	metric
unsubscribes	unsubscribes	The total number of unsubscribes from an email list or campaign.	metric
updated_by	updated_by	The user who last updated the record.	metric
updated_timestamp	updated_timestamp	The timestamp when the record was last updated.	dimension
updated_utc_timestamp	updated_utc_timestamp	The UTC timestamp when the record was last updated.	dimension
updates	updates	The number of updates to a record.	metric
use_quartz_scheduler	use_quartz_scheduler	Indicates if the Quartz scheduler is used for scheduling tasks.	metric
user	user	An indicator related to a user record.	metric
user.cdate	user.cdate	The creation date of the user.	dimension
user.email	user.email	The email address of the user.	dimension
user.firstName	user.firstName	The first name of the user.	dimension
user.id	user.id	The unique identifier of the user.	dimension
user.lastName	user.lastName	The last name of the user.	dimension
user.localZoneid	user.localZoneid	The local time zone ID of the user.	dimension
user.phone	user.phone	The phone number of the user.	dimension
user.udate	user.udate	The last update date of the user.	dimension
user.username	user.username	The username of the user.	dimension
userid	userid	The unique identifier for a user.	metric
username	username	The username for an account.	dimension
value	value	The monetary value associated with a deal or another record in ActiveCampaign.	dimension
verified_opens	verified_opens	The number of verified email opens.	metric
verified_unique_opens	verified_unique_opens	The number of unique and verified email opens.	metric
waitpreview	waitpreview	Indicates if a preview is awaiting completion.	metric
willrecur	willrecur	Indicates if a campaign or process is set to recur.	metric
winProbability	winProbability	The probability of successfully winning a deal, typically expressed as a percentage.	dimension
winProbabilityMdate	winProbabilityMdate	The date and time when the win probability of a deal was last modified.	dimension
win_probability_initialize_date	win_probability_initialize_date	The date when the win probability for a deal or deal group (pipeline) was initially set.	dimension