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.
When working with Salesforce Marketing Cloud there are a few common pitfalls that most users fall into at some point in time – at least if they are not aware of them upfront. Some of the problems are easier to debug, but others are quite a challenge, even for experienced users. Therefore this article highlights […]December 7, 2022At DESelect, we increase marketing efficiency while reducing technical dependency. These success stories span industries. From financial services to entertainment, we enable marketers to get the most out of their data. Benefits Based on current customer success, here are the benefits you can expect from DESelect Connect: Unlock exciting new use cases: With new data […]October 14, 2022AMPScript and CloudPages together give you possibilities to integrate with SFMC, but: Disadvantages are like API integration AMPScript is a proprietary Salesforce code library that is less known CloudPages can capture leads but, again, marketers are better off using CMS or drag-and-drop landing page builders. No-code integration solutions require no rare knowledge and allow users […]October 14, 2022Sometimes marketers request a data file for a campaign, upload the file, and then send an email to the resulting list. This has become uncommon yet still exists. Manual processes like these are slow and often induce error. The FileZilla interface when connecting the FTP to SFMC to do data imports and exports Fortunately, manual […]October 14, 2022
Join the companies using DESelect to:
Unlock the full power of Marketing Cloud