Salesforce Marketing Cloud: Most-used fields

The table below gives information about most-used fields that you can import from Salesforce Marketing Cloud. 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
Account ID	Account ID	dimension
Account Name	Account Name	dimension
AccountID	AccountID	metric
ActionDateTime	ActionDateTime	dimension
ActivityExternalKey	ActivityExternalKey	dimension
ActivityID	ActivityID	dimension
ActivityName	ActivityName	dimension
ActivityType	ActivityType	dimension
AgeGroup	AgeGroup	dimension
Author	Author	dimension
BatchID	BatchID	metric
BounceCategory	BounceCategory	dimension
BounceCategoryID	BounceCategoryID	metric
BounceSubcategory	BounceSubcategory	dimension
BounceType	BounceType	dimension
BounceTypeID	BounceTypeID	metric
Bounced	Bounced	metric
Browser	Browser	dimension
BusinessUnit	BusinessUnit	dimension
CUSTOMER_ID	CUSTOMER_ID	dimension
Campaign	Campaign	dimension
Campaign End Date	Campaign End Date	dimension
Campaign Start Date	Campaign Start Date	dimension
CampaignID	CampaignID	dimension
Category	Category	metric
ChangedOn	ChangedOn	dimension
ClickLinkName	ClickLinkName	dimension
ClickURL	ClickURL	dimension
Clicked	Clicked	metric
Client.ID	Client.ID	metric
CodeID	CodeID	dimension
Contactid	Contactid	metric
Contactkey	Contactkey	dimension
ConversationID	ConversationID	dimension
ConversationStateID	ConversationStateID	dimension
Country	Country	dimension
Country Code	Country Code	dimension
Country Name	Country Name	dimension
CreateDateTime	CreateDateTime	dimension
CreatedDate	CreatedDate	dimension
Currency	Currency	dimension
Customer name	Customer name	dimension
CustomerFirstName	CustomerFirstName	dimension
CustomerID	CustomerID	metric
CustomerKey	CustomerKey	dimension
CustomerLastName	CustomerLastName	dimension
Customer_id	Customer_id	dimension
DOI	DOI	dimension
DOIDate	DOIDate	dimension
Date	Date	dimension
DateAdded	DateAdded	dimension
Delivered	Delivered	metric
Description	Description	dimension
Device	Device	dimension
Deviceid	Deviceid	dimension
Domain	Domain	dimension
Duplicates	Duplicates	metric
EID	EID	metric
Email	Email	dimension
Email.ID	Email.ID	metric
Email.ObjectID	Email.ObjectID	dimension
Email.PartnerKey	Email.PartnerKey	dimension
EmailAddress	EmailAddress	dimension
EmailClient	EmailClient	dimension
EmailID	EmailID	metric
EmailName	EmailName	dimension
EmailOptOuts	EmailOptOuts	metric
EmailSendDefinition.CustomerKey	EmailSendDefinition.CustomerKey	dimension
EmailSendDefinition.ObjectID	EmailSendDefinition.ObjectID	dimension
EmailSendDefinition.PartnerKey	EmailSendDefinition.PartnerKey	dimension
EmailSubject	EmailSubject	dimension
EventDate	EventDate	dimension
EventType	EventType	dimension
ExistingUndeliverables	ExistingUndeliverables	metric
ExistingUnsubscribes	ExistingUnsubscribes	metric
FirstName	FirstName	dimension
ForwardedEmails	ForwardedEmails	metric
FromAddress	FromAddress	dimension
FromName	FromName	dimension
Gender	Gender	dimension
HardBounces	HardBounces	metric
HashedSubscriberKey	HashedSubscriberKey	dimension
ID	ID	dimension
ID_Campaign	ID_Campaign	dimension
Inbound	Inbound	dimension
InvalidAddresses	InvalidAddresses	metric
IsMultipart	IsMultipart	dimension
IsTest	IsTest	dimension
IsUnique	IsUnique	dimension
IsValid	IsValid	dimension
JBActivityID	JBActivityID	dimension
JBDefinitionID	JBDefinitionID	dimension
JobID	JobID	metric
JourneyActivityObjectID	JourneyActivityObjectID	dimension
JourneyID	JourneyID	dimension
JourneyName	JourneyName	dimension
JourneyStatus	JourneyStatus	dimension
KeywordID	KeywordID	dimension
Lang	Lang	dimension
LastName	LastName	dimension
LastPublishedDate	LastPublishedDate	dimension
Leads	Leads	dimension
LinkContent	LinkContent	dimension
LinkName	LinkName	dimension
List.ID	List.ID	metric
List.ListName	List.ListName	dimension
List.ObjectID	List.ObjectID	dimension
List.PartnerKey	List.PartnerKey	dimension
ListClassification	ListClassification	dimension
ListID	ListID	metric
ListName	ListName	dimension
MID	MID	metric
Market Name	Market Name	dimension
MessageID	MessageID	metric
MessageText	MessageText	dimension
Mobile	Mobile	metric
MobileMessageRecurrenceID	MobileMessageRecurrenceID	dimension
MobileMessageTrackingID	MobileMessageTrackingID	metric
ModifiedDate	ModifiedDate	dimension
ModifiedDateTime	ModifiedDateTime	dimension
Name	Name	dimension
NumberDelivered	NumberDelivered	metric
NumberErrored	NumberErrored	metric
NumberExcluded	NumberExcluded	metric
NumberSent	NumberSent	metric
NumberTargeted	NumberTargeted	metric
ObjectID	ObjectID	dimension
Opened	Opened	metric
OperatingSystem	OperatingSystem	dimension
OptedIntoEmail	OptedIntoEmail	metric
OptedIntoSMS	OptedIntoSMS	metric
Optedin	Optedin	dimension
Optindate	Optindate	dimension
Optoutdate	Optoutdate	dimension
Ordinal	Ordinal	metric
OtherBounces	OtherBounces	metric
Outbound	Outbound	dimension
Page Name	Page Name	dimension
PartnerKey	PartnerKey	dimension
PhoneNumber	PhoneNumber	metric
PreviewURL	PreviewURL	dimension
Reason	Reason	dimension
Report Date	Report Date	dimension
ResponseToMobileMessageTrackingID	ResponseToMobileMessageTrackingID	dimension
ResponseType	ResponseType	dimension
Revision	Revision	dimension
SMSBatchID	SMSBatchID	metric
SMSJobID	SMSJobID	dimension
SMSOptOuts	SMSOptOuts	metric
SMSStandardStatusCodeId	SMSStandardStatusCodeId	metric
Segment	Segment	dimension
SendDate	SendDate	dimension
SendGroupID	SendGroupID	dimension
SendID	SendID	metric
SendJobID	SendJobID	dimension
SendPersonID	SendPersonID	dimension
SendSegmentID	SendSegmentID	dimension
SendSplitID	SendSplitID	dimension
SendStatus	SendStatus	dimension
Sent	Sent	metric
SentDate	SentDate	dimension
ServiceID	ServiceID	dimension
SharedKeyword	SharedKeyword	dimension
ShortCode	ShortCode	metric
SoftBounces	SoftBounces	metric
Source	Source	dimension
Status	Status	dimension
Subject	Subject	dimension
SubjectLine	SubjectLine	dimension
SubscriberID	SubscriberID	metric
SubscriberKey	SubscriberKey	dimension
TimeStamp	TimeStamp	dimension
TriggeredSendCustomerKey	TriggeredSendCustomerKey	dimension
TriggeredSendDefinitionObjectID	TriggeredSendDefinitionObjectID	dimension
Type	Type	dimension
URL	URL	dimension
URLID	URLID	metric
UUID	UUID	dimension
Undelivered	Undelivered	metric
UniqueClicks	UniqueClicks	metric
UniqueOpens	UniqueOpens	metric
UnsubDate	UnsubDate	dimension
Unsubscribed	Unsubscribed	metric
Unsubscribes	Unsubscribes	metric
VersionID	VersionID	dimension
VersionNumber	VersionNumber	metric
account_name	account_name	dimension
assetType.displayName	assetType.displayName	dimension
assetType.id	assetType.id	metric
assetType.name	assetType.name	dimension
campaign_type	campaign_type	dimension
category.id	category.id	metric
category.name	category.name	dimension
category.parentId	category.parentId	metric
channel	channel	dimension
channel_grouping	channel_grouping	dimension
channel_name	channel_name	dimension
commonCaseId	commonCaseId	dimension
consumer_id	consumer_id	dimension
country	country	dimension
createdBy.email	createdBy.email	dimension
createdBy.id	createdBy.id	metric
createdBy.name	createdBy.name	dimension
createdBy.userId	createdBy.userId	metric
createdDate	createdDate	dimension
customerKey	customerKey	dimension
data.email.attributes.0.attributeType	data.email.attributes.0.attributeType	dimension
data.email.attributes.0.channel	data.email.attributes.0.channel	dimension
data.email.attributes.0.displayName	data.email.attributes.0.displayName	dimension
data.email.attributes.0.name	data.email.attributes.0.name	dimension
data.email.attributes.0.order	data.email.attributes.0.order	metric
data.email.attributes.0.value	data.email.attributes.0.value	dimension
data.email.legacy.legacyCategoryId	data.email.legacy.legacyCategoryId	metric
data.email.legacy.legacyId	data.email.legacy.legacyId	metric
data.email.legacy.legacyKey	data.email.legacy.legacyKey	dimension
data.email.legacy.legacyType	data.email.legacy.legacyType	dimension
data.email.options.characterEncoding	data.email.options.characterEncoding	dimension
day	day	dimension
description	description	dimension
emailAddress	emailAddress	dimension
emailId	emailId	metric
enterpriseId	enterpriseId	metric
id	id	dimension
impressions	impressions	metric
indexVersion	indexVersion	metric
insertDate	insertDate	dimension
isProcessed	isProcessed	dimension
jobid	jobid	dimension
journey_step	journey_step	dimension
language	language	dimension
lastClickDate	lastClickDate	dimension
lastOpenDate	lastOpenDate	dimension
legacyData.legacyCategoryId	legacyData.legacyCategoryId	metric
legacyData.legacyId	legacyData.legacyId	metric
legacyData.legacyKey	legacyData.legacyKey	dimension
legacyData.legacyType	legacyData.legacyType	dimension
memberId	memberId	metric
modelVersion	modelVersion	metric
modifiedBy.email	modifiedBy.email	dimension
modifiedBy.id	modifiedBy.id	metric
modifiedBy.name	modifiedBy.name	dimension
modifiedBy.userId	modifiedBy.userId	metric
modifiedDate	modifiedDate	dimension
month	month	metric
name	name	dimension
objectID	objectID	dimension
offline_online	offline_online	dimension
organic_paid	organic_paid	dimension
owner.email	owner.email	dimension
owner.id	owner.id	metric
owner.name	owner.name	dimension
owner.userId	owner.userId	metric
platform	platform	dimension
profileID	profileID	dimension
segment	segment	dimension
sent	sent	metric
siteName	siteName	dimension
site_key	site_key	dimension
sms_unsubscribe	sms_unsubscribe	dimension
smtpMessage	smtpMessage	dimension
smtpbouncereason	smtpbouncereason	dimension
status	status	dimension
status.id	status.id	metric
status.name	status.name	dimension
thumbnail.thumbnailUrl	thumbnail.thumbnailUrl	dimension
total bounces	total bounces	metric
url	url	dimension
uuid	uuid	dimension
variant	variant	dimension
version	version	dimension