Top 10 Salesforce Marketing Cloud data views

A little more than a year ago, we compiled  our list of the top 10 data views in Salesforce Marketing Cloud. Today we decided this list could definitely use an update. Salesforce’s Marketing Cloud platform changes rapidly, and part of our job is to keep up, adapting accordingly. That’s why we decided to share our findings in this revised article, top 10 data views in SFMC [updated].

What are Salesforce Marketing Cloud data views?

Data views are system-generated tables (or data extensions (DEs) in Salesforce Marketing Cloud (SFMC). They contain different information about subscribers and events such as email/SMS sends, email opens, or links clicked. You can also view behavioral information such as emails forwarded to friends, or the status of your subscribers and contacts. In addition, it’s possible to view the bounce rate using data views in SFMC. In total, there are 24 different data views in SFMC that you can check out here

Unlike with data extensions, you can’t find data views in the normal overview, which is why some marketers might have never heard of them. You can use data views to create queries in the Marketing Cloud using SQL. If you’re not too technically savvy and still want to leverage important information found in data views, you can use third-party no-code solutions like DESelect.

We actually have a nice guide on how you can leverage data views in Marketing Cloud to avoid marketing pressure that introduces you to querying data views in Marketing Cloud, using SQL and DESelect respectively.

The goal of this article, however, is to present a list of the 10 most important data views to use in SFMC — especially if you work with Email Studio. So let’s get to it.

Top 10 data views in SFMC [updated]

  1. _Subscribers

Using this data view you can find out which accounts are subscribers in SFMC, as well as know their status. 

Check out this article where we explain how to exclude recently targeted audiences from your future campaign.

2.  _Click

This data view is used to find out about the data on email clicks from your campaign in SFMC. 

 3. _Bounce

Using this data view you can find data on bounces from your email campaigns in Salesforce Marketing Cloud.

4.  _Job

This data view allows you to obtain information about email send jobs in SFMC. It includes the email, account, job, and event-related data.

5.  _Unsubscribe

Using this data view, you can obtain data on unsubscribes.

6.  _Open

The _Open data view contains information about email opens within SFMC.

7. _Sent

Using this data view you can find subscribers to whom communication was sent from your Salesforce Marketing Cloud account.

For instance, you would like to get the details of all Contacts that have not received any emails in the last 14 days. Curious how to easily extract this information in SFMC? Check out our guide here.

8. _Journey

This data view concerns information regarding the Journey Builder. For instance, it stores the information about the journey’s status, the date it was created, and/or modified, created, and last modified, version ID, and number.

9. _ListSubscribers

Using this data view you can obtain information about the subscribers in your SFMC account on lists. It contains information about the subscriber, together with the email and unsubscribes information. This data view contains the information about subscribers found on the Triggered Send Managed List.

10. Data View  _FTAF

Query this data view in Automation Studio to view behavioral information related to email messages from your Marketing Cloud account that were forwarded to friends.

Conclusion

In this article we combined the top 10 data views for Salesforce Marketing Cloud that can be used to segment your audience for your future email campaigns. Marketing Cloud data views contain a lot of relevant information that can be used in your email or mobile campaigns. 

With DESelect you can easily create segments based on data views, without the need to apply SQL. If you’re curious to see how it works, book a demo with one of the DESelect professionals.

Other blog posts

DESelect Blog

Salesforce Marketing Cloud best practices
and DESelect updates

Launch campaigns 20% faster
Save 50% on customer data
management

© 2021 DESelect bv. All rights reserved

Salesforce-AppExchange-Partner-2015

​Get your copy of Your data and Salesforce Marketing Cloud

70+ pages of actionable content and best practices to help you ROCK Marketing Cloud once and forever…