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.
ActionDateTime Dimension
The date and time when a specific event or action occurred, such as an email open or click.
ActivityExternalKey Dimension
A unique, user-defined identifier for an activity, often used in Journey Builder.
ActivityID Dimension
The unique identifier for an activity.
ActivityName Dimension
The name of the activity.
ActivityType Dimension
The type of activity, e.g., 'Email', 'SMS', or 'Wait'.
Assignment_Date Dimension
The date and time when a specific event (such as an email send, open, click, bounce, or unsubscribe) occurred.
BatchID Dimension
An identifier that connects sends to later events like clicks and opens.
BounceCategory Dimension
The category of an email bounce (e.g., 'Soft Bounce', 'Hard Bounce').
BounceCategoryID Dimension
The unique identifier for the email bounce category.
BounceType Dimension
The specific type of email bounce.
BounceTypeID Dimension
The unique identifier for the email bounce type.
Browser Dimension
The web browser used by the recipient when engaging with an email or other marketing content.
CUSTOMER_ID Dimension
The unique identifier for a customer.
Campaign Dimension
The name of the marketing campaign.
CampaignID Dimension
The unique identifier for the marketing campaign.
Client.ID Metric
The ID of the account that originated the send.
CodeID Dimension
An identifier for a specific code, such as a status code, an error code (e.g., SMTP code for email bounces), or a custom classification used within a marketing activity.
Contactid Dimension
The unique identifier for a contact.
Contactkey Dimension
A unique identifier for a contact across multiple Marketing Cloud systems.
ConversationID Dimension
An identifier that links activities within an asynchronous process of an overall MobileConnect conversation or program.
ConversationStateID Dimension
A unique identifier that correlates mobile originated messages (MO messages) and mobile terminated messages (MT messages) in a single conversation within MobileConnect. This field is considered a legacy field in some contexts.
CreateDateTime Dimension
The date and time when the record or object was created.
CreatedDate Dimension
The date and time of the object's creation.
CustomerID Dimension
The unique identifier for a customer.
Customer_id Dimension
The unique identifier for a customer.
DE_insertDate Dimension
The date and time when a record was inserted into a Data Extension.
DOI Dimension
Indicates the status or date related to the Double Opt-In (DOI) process for a subscriber, confirming their explicit consent to receive communications. This often involves a subscriber taking an action, such as clicking a link in a confirmation email.
DOIDate Dimension
The date and time when a subscriber completed the Double Opt-In (DOI) process, providing their confirmed consent. This date is often stored in the CRM or subscriber data.
Date Dimension
The date and time associated with a subscriber record or event, such as the creation date of the subscriber, the date of modification, or the date of an email/SMS event.
DateAdded Dimension
The date when the record was added.
Delivered Dimension
Indicates whether the message was successfully delivered to the recipient.
Description Dimension
A descriptive text for the object.
Device Dimension
The type of device (e.g., desktop, mobile, tablet) used by the recipient when engaging with marketing content.
Deviceid Dimension
The unique identifier for a mobile device, used for tracking mobile interactions or push notifications.
Duplicates Metric
The number of duplicate email addresses associated with a send. This property exists only when a send targets multiple lists.
EID Dimension
The Enterprise ID, representing the unique identifier for the enterprise account.
Email.ID Metric
A unique identifier for an email.
Email.ObjectID Dimension
A system-controlled, read-only text string identifier for an email object.
Email.PartnerKey Dimension
A unique identifier provided by a partner for an email object.
EmailAddress Dimension
The email address of the subscriber.
EmailClient Dimension
The email client (e.g., Outlook, Gmail) used by the recipient to open an email, often available as a dimension in reporting.
EmailName Dimension
The name of the email asset.
EmailOptOuts Metric
Records a subscriber's decision to opt out of receiving email communications, indicating they no longer wish to receive marketing emails from the platform. This can be at a list-specific, universal, or global level.
EventDate Dimension
The date when a tracking event occurred.
EventType Dimension
The type of tracking event (e.g., Sent, Open, Click, Bounce, Unsubscribe).
ExistingUndeliverables Metric
The number of bounces that occurred on previous sends.
ExistingUnsubscribes Metric
The number of unsubscribe events that occurred in previous sends.
FirstName Dimension
The first name of the contact or subscriber.
ForwardedEmails Metric
The number of emails forwarded.
FromAddress Dimension
The email address that appears as the sender.
FromName Dimension
The name of the sender.
Gender Dimension
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.
HardBounces Metric
The number of hard bounces for an email send. Hard bounces indicate permanent delivery failures.
ID Dimension
A read-only identifier for an object, often an integer.
ID_Campaign Dimension
The unique identifier for a send that customers use as a campaign ID.
Inbound Dimension
Indicates if a message is an inbound message (e.g., from a subscriber to the system).
InvalidAddresses Metric
The number of invalid addresses associated with a send.
IsMultipart Dimension
Indicates if an email send definition is composed of multiple parts, such as HTML and plain text versions.
IsTest Dimension
Indicates if the activity or send was a test.
IsUnique Dimension
Indicates if the event or record is unique.
IsValid Dimension
A boolean indicator that determines if a record, such as an email address, or an event meets predefined validation criteria. For email addresses, this can include syntax, MX record existence, and checks against the List Detective database.
JBActivityID Dimension
The unique identifier for a specific activity within Journey Builder.
JBDefinitionID Dimension
The unique identifier for a Journey Builder definition or journey.
JobID Dimension
The unique identifier for an email send job.
Job_CreatedDate Dimension
The date and time when the email send job was created.
JourneyActivityObjectID Dimension
The unique object identifier for an activity within a Journey Builder journey.
JourneyID Dimension
The unique identifier for a Journey Builder journey.
JourneyName Dimension
The name of the Journey Builder journey.
JourneyStatus Dimension
The current status of a Journey Builder journey, e.g., 'Running', 'Paused'.
KeywordID Dimension
A unique identifier for a specific keyword used in MobileConnect SMS messaging.
Lang Dimension
The language or locale preference associated with a subscriber or account.
LastName Dimension
The last name of the contact or subscriber.
LastPublishedDate Dimension
The date and time when the journey or content was last published.
LinkContent Dimension
The content of the link that was clicked.
LinkName Dimension
The descriptive name of the link that was clicked.
List.ID Metric
The unique identifier for the list of subscribers.
List.ListName Dimension
The name of the subscriber list.
List.ObjectID Dimension
A system-controlled, read-only text string identifier for a list object.
List.PartnerKey Dimension
A unique identifier provided by a partner for a list object.
ListName Dimension
The name of the list to which the subscriber belongs.
MID Dimension
The Member ID, representing the unique identifier for a Marketing Cloud account or business unit.
MessageID Dimension
The unique identifier for a specific message instance, such as an email or SMS.
MessageText Dimension
The actual content of an SMS or MMS message sent or received via MobileConnect.
Mobile Dimension
Indicates if the interaction or engagement occurred on a mobile device.
MobileMessageRecurrenceID Dimension
The identifier for a recurring mobile message series, used to track repeated sends of SMS or MMS messages.
MobileMessageTrackingID Dimension
The unique identifier for tracking a mobile message.
ModifiedDate Dimension
The date and time when the object information was last modified.
ModifiedDateTime Dimension
The date and time when the record or object was last modified.
Name Dimension
The name of the object or record.
NumberDelivered Metric
The total number of emails successfully delivered.
NumberErrored Metric
The total number of emails that encountered an error during delivery.
NumberExcluded Metric
The total number of subscribers excluded from a send.
NumberSent Metric
The total number of emails sent.
NumberTargeted Metric
The total number of recipients targeted for a send.
ObjectID Dimension
A system-controlled, read-only text string identifier for an object.
OperatingSystem Dimension
The operating system (e.g., Windows, iOS, Android) of the device used by the recipient.
OptedIntoEmail Metric
Indicates whether a subscriber has given explicit permission to receive email communications, often established through an opt-in process.
OptedIntoSMS Metric
This field indicates whether a contact has explicitly opted into receiving SMS messages through Salesforce Marketing Cloud's MobileConnect. It reflects their subscription status for SMS communications.
Optedin Dimension
Indicates whether the subscriber has opted in to receive communications.
Optindate Dimension
The date and time when the subscriber opted in.
Optoutdate Dimension
The date and time when the subscriber opted out.
Ordinal Dimension
The numerical position or order of a column within a Salesforce Marketing Cloud Data Extension.
OtherBounces Metric
The number of bounces that are not classified as hard or soft bounces.
Outbound Dimension
Indicates if a message is an outbound message (e.g., from the system to a subscriber).
PartnerKey Dimension
A unique identifier provided by a partner for an object, accessible only via SOAP API.
PreviewURL Dimension
The URL that can be used to preview the message associated with a send.
Reason Dimension
The reason for an action, such as an unsubscribe.
ResponseToMobileMessageTrackingID Dimension
The tracking identifier for a response received in relation to a previously sent mobile message.
SMSBatchID Dimension
An identifier that groups related SMS messages within a triggered send or batch.
SMSJobID Dimension
The unique identifier for an SMS send job.
SMSOptOuts Metric
Records a subscriber's decision to opt out of receiving SMS communications, often initiated by sending a 'STOP' keyword. The platform also automatically processes carrier deactivation files to opt out phone numbers.
SMSStandardStatusCodeId Dimension
A standard numeric code indicating the delivery status of an SMS message, returned from MobileConnect API calls or `_SMSMessageTracking` data view.
SendDate Dimension
The date when an email send occurred or was scheduled.
SendGroupID Dimension
The identifier for a group of recipients targeted in an email or mobile message send.
SendID Metric
A unique identifier for a specific send.
SendJobID Dimension
The unique identifier for a specific send job.
SendPersonID Dimension
An identifier for the individual or system responsible for initiating a send job, such as an email send. This relates to aggregate send data from ET_Send or subscriber information from ET_Subscriber.
SendSegmentID Dimension
The identifier of the audience segment targeted by an email or mobile message send.
SendSplitID Dimension
The identifier for a specific split in a send, often used in A/B testing or Journey Builder paths to track performance of different message versions.
Sent Dimension
Indicates whether the message was sent to the recipient.
SentDate Dimension
The date when an email was sent.
SharedKeyword Dimension
The text of a keyword used for SMS messaging in MobileConnect, which can be configured for shared short codes.
ShortCode Dimension
The short code used for mobile messaging.
SoftBounces Metric
The number of soft bounces for an email send, indicating temporary delivery failures.
Source Dimension
The source of the data or event.
Status Dimension
The status of a send job or other object.
Subject Dimension
The subject line of an email.
SubscriberID Dimension
The unique identifier for a subscriber.
SubscriberKey Dimension
A unique identifier for a subscriber.
TimeStamp Dimension
The date and time when an event occurred.
TriggeredSendCustomerKey Dimension
A unique, user-defined identifier for a triggered send definition.
TriggeredSendDefinitionObjectID Dimension
Identifies the triggered send definition associated with an event.
URL Dimension
A URL associated with an email or click event.
URLID Metric
The ID associated with a specific URL in a tracked email.
UUID Dimension
A universally unique identifier for a record or entity within Marketing Cloud.
Undelivered Dimension
Indicates whether the message was not delivered to the recipient.
UniqueClicks Metric
The number of unique clicks on links within an email.
UniqueOpens Metric
The number of unique opens for an email.
UnsubDate Dimension
The date and time when the subscriber unsubscribed.
Unsubscribes Metric
The total number of unsubscribes from an email send or list.
VersionID Dimension
The unique identifier for a specific version of an object, such as a journey.
VersionNumber Dimension
The version number of an object, such as a journey.
confirm_date Dimension
The date on which a confirmation event occurred, such as a Double Opt-In confirmation for a subscriber.
confirmed Dimension
A boolean indicator specifying whether a subscription or other action has been confirmed, often in MobileConnect's opt-in processes.
emailAddress Dimension
The email address of the subscriber.
insertDate Dimension
The date and time when the record was first inserted.
isProcessed Dimension
Indicates whether a specific data record or API request has been successfully processed by the Salesforce Marketing Cloud platform.
sent Metric
Indicates if the message or item has been sent.
sms Dimension
Refers to Short Message Service (SMS) communications, primarily managed through the MobileConnect application.
sms_date Dimension
The date and time an SMS message event occurred.
status Dimension
The current status of the object or record.
updateDate Dimension
The date and time when the record was last updated.
uuid Dimension
A universally unique identifier for a record or entity within Marketing Cloud.