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]
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.
This data view is used to find out about the data on email clicks from your campaign in SFMC.
Using this data view you can find data on bounces from your email campaigns in Salesforce Marketing Cloud.
This data view allows you to obtain information about email send jobs in SFMC. It includes the email, account, job, and event-related data.
Using this data view, you can obtain data on unsubscribes.
The _Open data view contains information about email opens within SFMC.
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.
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.
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.
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.
What is Salesforce Connections? Connections is the biggest Salesforce Marketing Cloud event that brings marketing, commerce, and digital professionals together — to inspire, educate, and connect. The event creates an excellent opportunity for Salesforce professionals to network and learn together. Salesforce Connections 2022 was happening live for the first time since the COVID-19 pandemic and […]June 16, 2022What to choose when it comes to segmentation in SFMC? When it comes to Salesforce Marketing Cloud, it’s not uncommon for marketers to find themselves unsure of what decisions to make that best suit technology to their business needs. Many users facing audience segmentation problems are offered native addons like Audience Builder or a novel […]June 14, 2022This year, Salesforce fans can look forward to an incredible line-up of talks and presentations at Salesforce’s Connections 2022. The event promises to be so packed that we’ll have to plan carefully to ensure we don’t miss out. Trailblazers visiting Chicago will have the ability to create their schedules based on the sessions calendar. Online […]May 30, 2022In 2022, Salesforce Marketing Cloud releases will be synced with Salesforce releases, making it easier to follow the market updates and better promote an omnichannel approach to using Salesforce products. With this article, we took the liberty to predict the development trends for Salesforce Marketing Cloud. AI advances AI has played a part in marketing […]March 18, 2022
Join the companies and partners using
DESelect Marketing Data Enablement Solutions