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 Hyper-Personalization? Learn from Over 30 Industry-Specific Examples!
Consumers love it when a brand suits their needs and is personalized to their preferences. If you excel at creating a highly individualized experience for your audience, you’ll win their hearts and build successful campaigns. This is where hyper-personalization comes into play. What is hyper-personalization? Hyper-personalization is an advanced marketing strategy that uses AI and […]September 25, 2023How Do Enterprises Do Marketing Automation Differently? 3 Major Considerations
When it comes to large-scale operations, the marketing teams at enterprise businesses have unique needs and challenges that demand a distinctive approach. So, what sets enterprise marketing automation strategies apart? Let’s dive into three significant considerations that data teams must prioritize. 1. Integrating Complex Data Streams The sheer volume and variety of data enterprises handle […]September 21, 2023Optimizing the Touchpoints and Channels of a Digital Customer Journey
In the digital age, the emphasis on curating an immersive digital customer journey has never been more vital. It’s not enough to merely attract visitors. Brands must foster an integrated and seamless experience across every touchpoint and channel. Let’s delve into the strategic art of enhancing each interaction and touchpoint within your customer journeys. Understanding […]September 21, 20234 More Opportunities for Personalization in eCommerce Email Marketing
You’re a creative marketer hot on the heels of our deep dive into foundational email marketing techniques, right? Well, let’s shift gears a bit. You’ve got to grips with 8 of the best types of email marketing campaigns for retail segments, but there’s always room to refine, innovate, and surprise your email audience. Let’s journey […]September 7, 2023Join our newsletter to receive updates and helpful SFMC guides.
