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
Assignment_Date	Assignment_Date		dimension
BatchID	BatchID	An identifier that connects sends to later events like clicks and opens.	dimension
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 when engaging with an email or other marketing content.	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.	dimension
CodeID	CodeID	An identifier for a code within MobileConnect, potentially referring to a short code or other messaging-related code.	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	An identifier that links activities within an asynchronous process of an overall MobileConnect conversation or program.	dimension
ConversationStateID	ConversationStateID	An identifier indicating the current state or stage of a conversation within a Journey Builder journey.	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 type of device (e.g., desktop, mobile, tablet) used by the recipient when engaging with marketing content.	dimension
Deviceid	Deviceid	A unique identifier generated by Marketing Cloud for the mobile device used by a contact, typically in MobilePush.	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.	dimension
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 (e.g., Outlook, Gmail) used by the recipient to open an email, often available as a dimension in reporting.	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	Demographic data indicating the gender of a contact, used for personalization and segmentation. This data can be enriched from CRM and synced to Marketing Cloud.	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.	metric
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	A boolean indicator of whether a data record or field value is considered valid based on defined criteria, such as email address format in a Data Extension.	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	A unique identifier for a specific keyword used in MobileConnect SMS messaging.	dimension
Lang	Lang	The language or locale preference associated with a subscriber or account.	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.	dimension
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 actual content of an SMS or MMS message sent or received via MobileConnect.	dimension
Mobile	Mobile	Indicates if the interaction or engagement occurred on a mobile device.	dimension
MobileMessageRecurrenceID	MobileMessageRecurrenceID	A unique identifier for a recurring mobile message series or schedule.	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 (e.g., Windows, iOS, Android) of the device used by the recipient.	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	An identifier used in the _SMSMessageTracking data view to link a response message to a specific outbound MobileConnect message for tracking purposes.	dimension
ResponseType	ResponseType	The type of response or engagement from a recipient, such as an email open, click, bounce, or a mobile message response.	dimension
SMSBatchID	SMSBatchID	An identifier that groups related SMS messages within a triggered send or batch.	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	A standard numeric code indicating the delivery status of an SMS message, returned from MobileConnect API calls or _SMSMessageTracking data view.	dimension
SendDate	SendDate	The date when an email send occurred or was scheduled.	dimension
SendGroupID	SendGroupID	A unique identifier for a group of sends, used to track performance of related email or message sends.	dimension
SendID	SendID	A unique identifier for a specific send.	dimension
SendJobID	SendJobID	The unique identifier for a specific send job.	dimension
SendPersonID	SendPersonID		dimension
SendSegmentID	SendSegmentID	A unique identifier for the audience segment targeted by a specific send.	dimension
SendSplitID	SendSplitID	A unique identifier for a specific split or variation within an A/B test or a Journey Builder path.	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	The text of a keyword used for SMS messaging in MobileConnect, which can be configured for shared short codes.	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	A universally unique identifier for a record or entity within Marketing Cloud.	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
confirm_date	confirm_date	The date when a confirmation event occurred, such as a subscription confirmation.	dimension
confirmed	confirmed	A boolean indicator specifying whether a subscription or other action has been confirmed, often in MobileConnect’s opt-in processes.	dimension
emailAddress	emailAddress	The email address of the subscriber.	dimension
insertDate	insertDate	The date and time when the record was first inserted.	dimension
isProcessed	isProcessed		dimension
sent	sent	Indicates if the message or item has been sent.	metric
sms	sms	Refers to Short Message Service (SMS) communications, primarily managed through the MobileConnect application.	dimension
sms_date	sms_date	The date and time an SMS message event occurred.	dimension
status	status	The current status of the object or record.	dimension
updateDate	updateDate	The date and time when the record was last updated.	dimension
uuid	uuid	A universally unique identifier for a record or entity within Marketing Cloud.	dimension