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	Description	Use in Adverity
ActionDateTime	ActionDateTime	The date and time when a specific event or action occurred, such as an email open or click.	dimension
ActivityExternalKey	ActivityExternalKey	A unique, user-defined identifier for an activity, often used in Journey Builder.	dimension
ActivityID	ActivityID	The unique identifier for an activity.	dimension
ActivityName	ActivityName	The name of the activity.	dimension
ActivityType	ActivityType	The type of activity, e.g., ‘Email’, ‘SMS’, or ‘Wait’.	dimension
BatchID	BatchID	An identifier that connects sends to later events like clicks and opens.	metric
BounceCategory	BounceCategory	The category of an email bounce (e.g., ‘Soft Bounce’, ‘Hard Bounce’).	dimension
BounceCategoryID	BounceCategoryID	The unique identifier for the email bounce category.	dimension
BounceType	BounceType	The specific type of email bounce.	dimension
BounceTypeID	BounceTypeID	The unique identifier for the email bounce type.	dimension
Browser	Browser	The web browser used by the recipient, typically for tracking email opens or clicks.	dimension
CUSTOMER_ID	CUSTOMER_ID	The unique identifier for a customer.	dimension
Campaign	Campaign	The name of the marketing campaign.	dimension
CampaignID	CampaignID	The unique identifier for the marketing campaign.	dimension
ClickLinkName	ClickLinkName	The descriptive name of the link that was clicked in an email.	dimension
ClickURL	ClickURL	The URL of the link that was clicked in an email.	dimension
Client.ID	Client.ID	The ID of the account that originated the send.	metric
CodeID	CodeID		dimension
Contactid	Contactid	The unique identifier for a contact.	dimension
Contactkey	Contactkey	A unique identifier for a contact across multiple Marketing Cloud systems.	dimension
ConversationID	ConversationID	The unique identifier for a conversation, typically in MobileConnect for SMS messages.	dimension
ConversationStateID	ConversationStateID		dimension
CreateDateTime	CreateDateTime	The date and time when the record or object was created.	dimension
CreatedDate	CreatedDate	The date and time of the object’s creation.	dimension
CustomerID	CustomerID	The unique identifier for a customer.	dimension
Customer_id	Customer_id	The unique identifier for a customer.	dimension
DE_insertDate	DE_insertDate	The date and time when a record was inserted into a Data Extension.	dimension
DOI	DOI	Indicates Double Opt-In status.	dimension
DOIDate	DOIDate	The date and time of the Double Opt-In confirmation.	dimension
Date	Date	The date of the event or record.	dimension
DateAdded	DateAdded	The date when the record was added.	dimension
Delivered	Delivered	Indicates whether the message was successfully delivered to the recipient.	dimension
Description	Description	A descriptive text for the object.	dimension
Device	Device	The device used by the recipient, typically for tracking email opens or clicks.	dimension
Deviceid	Deviceid	The unique identifier for a device.	dimension
Duplicates	Duplicates	The number of duplicate email addresses associated with a send. This property exists only when a send targets multiple lists.	metric
EID	EID	The Enterprise ID, representing the unique identifier for the enterprise account.	dimension
Email.ID	Email.ID	A unique identifier for an email.	metric
Email.ObjectID	Email.ObjectID	A system-controlled, read-only text string identifier for an email object.	dimension
Email.PartnerKey	Email.PartnerKey	A unique identifier provided by a partner for an email object.	dimension
EmailAddress	EmailAddress	The email address of the subscriber.	dimension
EmailClient	EmailClient	The email client used by the recipient, typically for tracking email opens.	dimension
EmailName	EmailName	The name of the email asset.	dimension
EmailOptOuts	EmailOptOuts	Indicates the email opt-out status for the contact.	metric
EventDate	EventDate	The date when a tracking event occurred.	dimension
EventType	EventType	The type of tracking event (e.g., Sent, Open, Click, Bounce, Unsubscribe).	dimension
ExistingUndeliverables	ExistingUndeliverables	The number of bounces that occurred on previous sends.	metric
ExistingUnsubscribes	ExistingUnsubscribes	The number of unsubscribe events that occurred in previous sends.	metric
FirstName	FirstName	The first name of the contact or subscriber.	dimension
ForwardedEmails	ForwardedEmails	The number of emails forwarded.	metric
FromAddress	FromAddress	The email address that appears as the sender.	dimension
FromName	FromName	The name of the sender.	dimension
Gender	Gender		dimension
HardBounces	HardBounces	The number of hard bounces for an email send. Hard bounces indicate permanent delivery failures.	metric
ID	ID	A read-only identifier for an object, often an integer.	dimension
ID_Campaign	ID_Campaign	The unique identifier for the marketing campaign.	dimension
Inbound	Inbound	Indicates if a message is an inbound message (e.g., from a subscriber to the system).	dimension
InvalidAddresses	InvalidAddresses	The number of invalid addresses associated with a send.	metric
IsMultipart	IsMultipart	Indicates if an email send definition is composed of multiple parts, such as HTML and plain text versions.	dimension
IsTest	IsTest	Indicates if the activity or send was a test.	dimension
IsUnique	IsUnique	Indicates if the event or record is unique.	dimension
IsValid	IsValid		dimension
JBActivityID	JBActivityID	The unique identifier for a specific activity within Journey Builder.	dimension
JBDefinitionID	JBDefinitionID	The unique identifier for a Journey Builder definition or journey.	dimension
JobID	JobID	The unique identifier for an email send job.	dimension
Job_CreatedDate	Job_CreatedDate	The date and time when the email send job was created.	dimension
JourneyActivityObjectID	JourneyActivityObjectID	The unique object identifier for an activity within a Journey Builder journey.	dimension
JourneyID	JourneyID	The unique identifier for a Journey Builder journey.	dimension
JourneyName	JourneyName	The name of the Journey Builder journey.	dimension
JourneyStatus	JourneyStatus	The current status of a Journey Builder journey, e.g., ‘Running’, ‘Paused’.	dimension
KeywordID	KeywordID	The unique identifier for a keyword, typically used in MobileConnect.	dimension
Lang	Lang		dimension
LastName	LastName	The last name of the contact or subscriber.	dimension
LastPublishedDate	LastPublishedDate	The date and time when the journey or content was last published.	dimension
LinkContent	LinkContent	The content of the link that was clicked.	dimension
LinkName	LinkName	The descriptive name of the link that was clicked.	dimension
List.ID	List.ID	The unique identifier for the list of subscribers.	metric
List.ListName	List.ListName	The name of the subscriber list.	dimension
List.ObjectID	List.ObjectID	A system-controlled, read-only text string identifier for a list object.	dimension
List.PartnerKey	List.PartnerKey	A unique identifier provided by a partner for a list object.	dimension
ListName	ListName	The name of the list to which the subscriber belongs.	dimension
MID	MID	The Member ID, representing the unique identifier for a Marketing Cloud account or business unit.	dimension
MessageID	MessageID	The unique identifier for a specific message instance, such as an email or SMS.	dimension
MessageText	MessageText	The content of the message, typically for SMS.	dimension
Mobile	Mobile	Indicates if the interaction is related to mobile messaging.	dimension
MobileMessageRecurrenceID	MobileMessageRecurrenceID	The unique identifier for a recurring mobile message.	dimension
MobileMessageTrackingID	MobileMessageTrackingID	The unique identifier for tracking a mobile message.	dimension
ModifiedDate	ModifiedDate	The date and time when the object information was last modified.	dimension
ModifiedDateTime	ModifiedDateTime	The date and time when the record or object was last modified.	dimension
Name	Name	The name of the object or record.	dimension
NumberDelivered	NumberDelivered	The total number of emails successfully delivered.	metric
NumberErrored	NumberErrored	The total number of emails that encountered an error during delivery.	metric
NumberExcluded	NumberExcluded	The total number of subscribers excluded from a send.	metric
NumberSent	NumberSent	The total number of emails sent.	metric
NumberTargeted	NumberTargeted	The total number of recipients targeted for a send.	metric
ObjectID	ObjectID	A system-controlled, read-only text string identifier for an object.	dimension
OperatingSystem	OperatingSystem	The operating system used by the recipient, typically for tracking email opens or clicks.	dimension
OptedIntoEmail	OptedIntoEmail	Indicates whether the subscriber has opted in to receive email communications.	metric
OptedIntoSMS	OptedIntoSMS	Indicates whether the subscriber has opted in to receive SMS communications.	metric
Optedin	Optedin	Indicates whether the subscriber has opted in to receive communications.	dimension
Optindate	Optindate	The date and time when the subscriber opted in.	dimension
Optoutdate	Optoutdate	The date and time when the subscriber opted out.	dimension
Ordinal	Ordinal		dimension
OtherBounces	OtherBounces	The number of bounces that are not classified as hard or soft bounces.	metric
Outbound	Outbound	Indicates if a message is an outbound message (e.g., from the system to a subscriber).	dimension
PartnerKey	PartnerKey	A unique identifier provided by a partner for an object, accessible only via SOAP API.	dimension
PreviewURL	PreviewURL	The URL that can be used to preview the message associated with a send.	dimension
Reason	Reason	The reason for an action, such as an unsubscribe.	dimension
ResponseToMobileMessageTrackingID	ResponseToMobileMessageTrackingID	The unique identifier of the mobile message that this message is a response to.	dimension
ResponseType	ResponseType	The type of response received, typically for mobile messages.	dimension
SMSBatchID	SMSBatchID	The unique identifier for a batch of SMS messages.	dimension
SMSJobID	SMSJobID	The unique identifier for an SMS send job.	dimension
SMSOptOuts	SMSOptOuts	Indicates the SMS opt-out status for the contact.	metric
SMSStandardStatusCodeId	SMSStandardStatusCodeId	The unique identifier for the standard status code of an SMS message.	dimension
SendDate	SendDate	The date when an email send occurred or was scheduled.	dimension
SendGroupID	SendGroupID		dimension
SendID	SendID	A unique identifier for a specific send.	metric
SendJobID	SendJobID	The unique identifier for a specific send job.	dimension
SendPersonID	SendPersonID		dimension
SendSegmentID	SendSegmentID		dimension
SendSplitID	SendSplitID		dimension
SendStatus	SendStatus	The status of the send, e.g., ‘Sent’, ‘Delivered’, ‘Bounced’.	dimension
Sent	Sent	Indicates whether the message was sent to the recipient.	dimension
SentDate	SentDate	The date when an email was sent.	dimension
SharedKeyword	SharedKeyword	Indicates if the keyword is shared across multiple accounts.	dimension
ShortCode	ShortCode	The short code used for mobile messaging.	dimension
SoftBounces	SoftBounces	The number of soft bounces for an email send, indicating temporary delivery failures.	metric
Source	Source	The source of the data or event.	dimension
Status	Status	The status of a send job or other object.	dimension
Subject	Subject	The subject line of an email.	dimension
SubjectLine	SubjectLine	The subject line of the email that was sent.	dimension
SubscriberID	SubscriberID	The unique identifier for a subscriber.	dimension
SubscriberKey	SubscriberKey	A unique identifier for a subscriber.	dimension
TimeStamp	TimeStamp	The date and time when an event occurred.	dimension
TriggeredSendCustomerKey	TriggeredSendCustomerKey	A unique, user-defined identifier for a triggered send definition.	dimension
TriggeredSendDefinitionObjectID	TriggeredSendDefinitionObjectID	Identifies the triggered send definition associated with an event.	dimension
URL	URL	A URL associated with an email or click event.	dimension
URLID	URLID	The ID associated with a specific URL in a tracked email.	metric
UUID	UUID		dimension
Undelivered	Undelivered	Indicates whether the message was not delivered to the recipient.	dimension
UniqueClicks	UniqueClicks	The number of unique clicks on links within an email.	metric
UniqueOpens	UniqueOpens	The number of unique opens for an email.	metric
UnsubDate	UnsubDate	The date and time when the subscriber unsubscribed.	dimension
Unsubscribes	Unsubscribes	The total number of unsubscribes from an email send or list.	metric
VersionID	VersionID	The unique identifier for a specific version of an object, such as a journey.	dimension
VersionNumber	VersionNumber	The version number of an object, such as a journey.	dimension
assetType.displayName	assetType.displayName	The human-readable name of the asset’s type.	dimension
assetType.id	assetType.id	The unique identifier for the asset’s type.	metric
assetType.name	assetType.name	The programmatic name of the asset’s type.	dimension
category.id	category.id	The unique identifier for the content asset’s category.	metric
category.name	category.name	The name of the content asset’s category.	dimension
category.parentId	category.parentId	The unique identifier of the parent category for the content asset.	metric
confirm_date	confirm_date		dimension
confirmed	confirmed		dimension
createdBy.email	createdBy.email	The email address of the user who created the asset.	dimension
createdBy.id	createdBy.id	The unique identifier of the user who created the asset.	metric
createdBy.name	createdBy.name	The name of the user who created the asset.	dimension
createdBy.userId	createdBy.userId	The user ID of the user who created the asset.	metric
createdDate	createdDate	The date and time when the asset was created.	dimension
customerKey	customerKey	A unique, user-defined identifier for an object, often used for external system integration.	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
description	description	A descriptive text for the asset or object.	dimension
emailAddress	emailAddress	The email address of the subscriber.	dimension
enterpriseId	enterpriseId	The unique identifier for the enterprise account.	dimension
id	id	The unique identifier for the object or record.	metric
insertDate	insertDate	The date and time when the record was first inserted.	dimension
isProcessed	isProcessed		dimension
legacyData.legacyCategoryId	legacyData.legacyCategoryId		metric
legacyData.legacyId	legacyData.legacyId		metric
legacyData.legacyKey	legacyData.legacyKey		dimension
legacyData.legacyType	legacyData.legacyType		dimension
memberId	memberId	The unique identifier for the Marketing Cloud account or business unit.	dimension
modelVersion	modelVersion		metric
modifiedBy.email	modifiedBy.email	The email address of the user who last modified the object.	dimension
modifiedBy.id	modifiedBy.id	The unique identifier of the user who last modified the object.	metric
modifiedBy.name	modifiedBy.name	The name of the user who last modified the object.	dimension
modifiedBy.userId	modifiedBy.userId	The user ID of the user who last modified the object.	metric
modifiedDate	modifiedDate	The date and time when the object was last modified.	dimension
name	name	The name of the object or record.	dimension
objectID	objectID	The unique identifier for the object, often used in Content Builder.	dimension
owner.email	owner.email	The email address of the owner of the object.	dimension
owner.id	owner.id	The unique identifier of the owner of the object.	metric
owner.name	owner.name	The name of the owner of the object.	dimension
owner.userId	owner.userId	The user ID of the owner of the object.	metric
sent	sent	Indicates if the message or item has been sent.	metric
sms	sms	Indicates if the communication is an SMS message.	dimension
sms_date	sms_date		dimension
status	status	The current status of the object or record.	dimension
status.id	status.id	The unique identifier for the current status of the object.	metric
status.name	status.name	The name of the current status of the object.	dimension
thumbnail.thumbnailUrl	thumbnail.thumbnailUrl	The URL for a thumbnail image associated with the asset.	dimension
updateDate	updateDate	The date and time when the record was last updated.	dimension
uuid	uuid		dimension