What are Data Views in Marketing Cloud?

Ujjwal Uncategorized Leave a Comment

In Salesforce Marketing Cloud, data views are pre-built tables of data that store subscriber information and the last six months of tracking data for your account. While data views cannot be accessed from the user interface, they can be used like any other data extension: you can write a query against a data view in Automation Studio or in the Query Studio and extract/save the results into a new data extension. You can join data views with each other and with other data extensions.

Data views can only store data for the last six months, after which the data is purged. You can create automations to store this data in a data extension every month so that you can retain all the useful information for as long as you need.

They can provide valuable insights and help you better understand and engage with your audience. Some common data views in Marketing Cloud include:

Data ViewDescription
_SubscribersContains information about your email subscribers, including their email addresses and subscriber keys.
_OpenContains information about email opens, including the email subject, the email address of the subscriber who opened the email, and the date and time of the open.
_ClickContains information about clicks on links in your emails, including the email subject, the email address of the subscriber who clicked on the link, and the date and time of the click.
_SentContains information about emails that have been sent, including the email subject, the email address of the recipient, and the date and time of the send.
_BounceContains information about bounced emails, including the email address of the recipient, the reason for the bounce, and the date and time of the bounce.
_UnsubscribeContains information about unsubscribes, including the email address of the unsubscribing subscriber and the date and time of the unsubscribe.
_SendLogContains information about email sends, including the email subject, the email address of the recipient, and the date and time of the send.
_JobContains information about email sends, including the email subject, the email list that the email was sent to, and the date and time of the send.
_ListContains information about email lists, including the list name, the list owner, and the list type.
_DataFilterContains information about data filters, including the filter name, the filter type, and the filter definition.
_DataExtensionContains information about data extensions, including the data extension name, the data extension type, and the data extension fields.

Some common uses of data views in Salesforce Marketing Cloud:

  1. Creating reports: Data views can be used to create reports on various aspects of marketing activities, such as subscriber data, email send data, open and click data, and more.
  2. Segmenting subscribers: Data views can be used to segment subscribers based on various criteria, such as email address, subscriber type, status, and more.
  3. Analyzing campaign performance: Data views can be used to analyze the performance of marketing campaigns, including email open and click rates, delivery rates, and more.
  4. Personalizing email content: Data views can be used to personalize email content based on subscriber data, such as location, preferences, and past behavior.
  5. Building marketing automation workflows: Data views can be used in combination with marketing automation tools to create workflows that trigger actions based on subscriber data or other criteria.
  6. Creating dashboards: Data views can be used to create dashboards that display marketing metrics in real-time, such as email open rates, click-through rates, and more.
  7. Email list management: Data views can be used to manage email lists, such as adding or removing subscribers, updating subscriber data, and more.
  8. Email deliverability analysis: Data views can be used to analyze email deliverability, including the reasons for bounces or other delivery failures.

Table visualization of the _Subscribers data view:

Subscriber IDEmail AddressSubscriber KeySubscriber TypeDate JoinedDate UndeliverableDate UnsubscribedDomainBounce CountStatusLocale
1john@example.comabc123Customer01/01/202201/01/2022example.com0Activeen_US
2jane@example.comdef456Customer01/15/202201/15/2022example.com0Activeen_US
3robert@example.comghi789Prospect02/01/202202/01/2022example.com0Activeen_US
4maria@example.comjkl012Customer02/15/202202/15/2022example.com0Activeen_US
5david@example.commno345Customer03/01/202203/01/202203/15/2022example.com0Unsubscribeden_US
6sarah@example.compqr678Prospect04/01/202204/01/2022example.com3Activeen_US
7mike@example.comstu901Customer04/15/202204/15/2022example.com2Activeen_US

Explanation of fields:

  • Subscriber ID: a unique identifier for each subscriber
  • Email Address: the email address of the subscriber
  • Subscriber Key: a unique identifier for the subscriber, which may be different from the Subscriber ID
  • Subscriber Type: the type of subscriber (e.g. “customer,” “prospect,” etc.)
  • Date Joined: the date on which the subscriber joined the email list
  • Date Undeliverable: the date on which an email to the subscriber was returned as undeliverable
  • Date Unsubscribed: the date on which the subscriber unsubscribed from the email list
  • Domain: the domain of the subscriber’s email address (e.g. “gmail.com,” “yahoo.com,” etc.)
  • Bounce Count: the number of times an email to the subscriber has bounced back as undeliverable
  • Status: the current status of the subscriber (e.g. “active,” “unsubscribed,” etc.)
  • Locale: the language and location of the subscriber (e.g. “en_US” for English in the United States)

Note: This table is for illustrative purposes only.


Table visualization of the _Open data view:

OYBAccountIDJobIDListIDBatchIDSubscriber IDSubscriber KeyEvent DateDomainIs UniqueTriggerer Send Definition Object IDTriggered Send Customer Key
1234511002001abc12301/01/2022 10:00example.comTrue1000Welcome Email
1234511002002def45601/15/2022 9:00example.comTrue1000Welcome Email
1234511002003ghi78902/01/2022 11:00example.comTrue1000Welcome Email
1234521002014jkl01202/15/2022 12:00example.comTrue1001Promotional Email

Explanation of fields:

  • OYBAccountID: the account ID of the owner of the triggered send definition
  • JobID: the unique identifier for the job that processed the open event
  • ListID: the ID of the list to which the subscriber belongs
  • BatchID: the ID of the batch in which the open event occurred
  • Subscriber ID: the unique identifier for the subscriber who opened the email
  • Subscriber Key: a unique identifier for the subscriber, which may be different from the Subscriber ID
  • Event Date: the date and time on which the open event occurred
  • Domain: the domain of the subscriber’s email address (e.g. “gmail.com,” “yahoo.com,” etc.)
  • Is Unique: a boolean value indicating whether the open event is the first time the email has been opened by the subscriber (True) or not (False)
  • Triggerer Send Definition Object ID: the ID of the triggered send definition that generated the email
  • Triggered Send Customer Key: the customer-defined key for the triggered send definition

Note: This table is for illustrative purposes only.


Useful Reading:


Leave a Reply

Your email address will not be published. Required fields are marked *