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]
- _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.
Latest Articles
-
What Is Salesforce Sales Cloud? (And How It Really Works in 2026)
What Is Salesforce Sales Cloud? (And How It Really Works in 2026) Salesforce Sales Cloud is Salesforce’s flagship CRM platform for managing the entire sales process from tracking leads and contacts through to closing deals and forecasting revenue. At its core, it’s a cloud-based system that brings together Leads, Accounts, Contacts, Opportunities, Activities, and AI-driven […]March 3, 2026WhoId and WhatId in Salesforce: Clear Definitions, Examples and SOQL Usage
WhoId and WhatId in Salesforce: Clear Definitions, Examples and SOQL Usage If you have ever wondered why a Task you created does not appear where you expected it in Salesforce, the answer often comes down to two small fields: WhoId and WhatId. These fields play a crucial role in linking activities to the correct records, […]March 3, 2026Salesforce Backup Solutions: Why They Matter, How They Work, And What To Choose
Salesforce Backup Solutions: Why They Matter, How They Work, And What To Choose Introduction: “Salesforce Already Backs Up My Data… Don’t They?” One of the most common assumptions we hear from businesses using Salesforce is that their data is automatically protected. After all, Salesforce is a massive enterprise platform trusted by millions of organisations worldwide. […]March 3, 2026Salesforce Health Cloud Explained: Managing Patient Data at Scale
Salesforce Health Cloud Explained: Managing Patient Data at Scale Managing patient data across fragmented systems is one of the most persistent challenges facing healthcare providers today. Electronic health records sit in silos. Claims data lives in separate platforms. Patient engagement happens through disconnected channels. The result is a fractured view of the patient that undermines […]January 30, 2026
Join our newsletter to receive updates and helpful SFMC guides.
