--- title: Data Views slug: segment/data-views docTags: createdAt: 2026-01-15T01:03:10.716Z --- Data Views are system-managed tables in SFMC that store the last six months of customer behavioural and event tracking data, such as email sends, opens, and link clicks. For example, you can get the first and last names of all contacts in a Data Extension that are already **Subscribers** in Salesforce Marketing Cloud. ::Image[]{src="https://support.deselect.com/hc/article_attachments/13919371700497" size="60" width="1660" height="901" isUploading="false" darkWidth="1660" darkHeight="901" alt="Available Data Views overview" showCaption="true" caption="Available Data Views overview"} All Data Views available in SFMC can be used in Unaric Segment. These are located under **Available Data Extensions** and are available to query from (just like you would work with a Data Extension). They can be distinguished from Data Extensions easily since they all start with an underscore. ::Image[]{src="https://support.deselect.com/hc/article_attachments/4414394603793" size="50" width="588" height="286" isUploading="false" darkWidth="588" darkHeight="286" showCaption="false"} :::hint{type="info"} Data Views are treated as a log, which means they are not normalized tables and you may find some duplicated information in them. ::: :::hint{type="info"} In case, you need to disable Data Views on certain instances, create a support ticket through [support@deselect.com.](mailto\:support@deselect.com) ::: ## Use cases This section lists some use cases you could try out working with Data Views within Unaric Segment. :::hint{type="info"} If you have any questions on how to leverage Data Views on your concrete case, contact us through your Customer Success Manager. ::: :::ExpandableHeading ### Update contact campaign to held customers SFMC automatically blocks all the emails you try to send to customers that have a Held status because it has determined that it is an invalid email after several unsuccessful tries to reach them. This is done to prevent you from having a bad IP reputation that will affect the rest of the sends you perform to valid email addresses. If you want to get these customers back on track so you can send them all your content through email, you can try to reach them using a different channel and ask them to update their contact details. For doing that, you can use the **\_Subscribers** data view combined with your** Sendable Data Extension** containing all your contacts, filtering the ones that have a* Held* status. Then, create a journey to impact them through SMS or Push, or export that information, so the Customer Support team can reach them using other channels. ::: :::ExpandableHeading ### Journey interaction report Create a custom Data Extension that combines all the information that may be useful from the previous Data Views, so you can use it in all the future use cases you may face. For example, you can create a Data Extension with the following structure: | **CustomerID** | **JobID** | **EmailName** | **Sent** | **Open** | **Click** | | -------------- | --------- | ------------- | -------- | -------- | --------- | | 1 | 1 | Test Email | Yes | No | No | | 2 | 1 | Test Email | Yes | Yes | No | | 1 | 2 | Another Email | Yes | Yes | Yes | Schedule the selection that generates this table and have updated information every day. You can easily extract the people that opened a specific email (filtering Open = "Yes") or get all the emails sent to a customer and his interaction with them (filtering CustomerID = "X") ::: :::ExpandableHeading ### Preferences based on Interactions If you classify all the content you send to customers using UTMs or different web sections, you can analyze the clicks they do and group them into your existing classifications. With this information, you can try to determine the preferences of each customer in one Data Extension that you can later use to segment or personalize the communications you send to them based on it. ::: :::ExpandableHeading ### Control Email Saturation If you have saturation rules that you want to apply on a recurring basis, you can create a scheduled selection to determine if you are sending each customer more volume than you should. With this Data Extension, you can later apply filters so you don't over-saturate customers that have reached a specific limit in a period of time, avoiding unsubscription. ::: :::ExpandableHeading ### Avoid iOS15's MPP Issues As we discussed before, the Mail Protection Protocol feature can affect your open rate and all the open-based functionality in Salesforce Marketing Cloud, like Engagement Splits or A/B testing. To reduce this impact, you can use the Open Data Extract Activity in the Automation Studio to set a Data Extension regarding the details of the device your customers are using, and then use Unaric Segment to: - Filter out the customers using Apple devices when you are creating a campaign with A/B testing - Compare Open Rate between Apple customers vs the rest, to get an insight on the real impact you are experiencing with iOS 15. - Determine separate paths for Apple and the rest, so you can compare metrics between them. ::: :::ExpandableHeading ### Creating Selection Templates for the most recurring use cases Apart from the above, you can also set Selections as [templates](docId\:jMnIh3dAASUB4OdTksNoy) for the most important use cases so the rest of the team can easily reuse the structure you have previously created without any effort. ::: ## Guides :::hint{type="success"} For an example use case of data views, see [How to query the ‘\_Subcribers’ data view with SQL in Salesforce Marketing Cloud (SFMC)](https://deselect.io/how-to-use-data-views-in-sfmc-a-guide-to-select-contacts-that-are-known-subscribers/)? ::: :::hint{type="success"} For a comparative analysis of the same operation using SQL in Salesforce Marketing Cloud (SFMC) and how you can work with Data Views, see [How to manage marketing pressure in Salesforce Marketing Cloud.](https://deselect.io/how-to-manage-marketing-pressure-in-salesforce-marketing-cloud-a-practical-guide/) ::: ## Recreate custom Data Views Unaric Segment currently does not support custom Data Views, however, there is a simple way of recreating these: 1. In **Email Studio**, create a new Data Extension with the same fields as the **Custom Data View **that you want to re-create. 2. Go to **Automation Studio **and create an SQL Activity to **SELECT \* FROM** the Custom Data View into the newly created Data Extension. 3. Set this Automation to update it daily or hourly , depending on the cadence necessary. 4. The Data Extension will then be visible in Unaric Segment and can then be queried.