{"id":22770,"date":"2023-06-08T11:56:41","date_gmt":"2023-06-08T09:56:41","guid":{"rendered":"https:\/\/www.marketinet.com\/blog\/examples-dataviews-sql-query-salesforce-marketing-cloud\/"},"modified":"2025-04-04T11:57:10","modified_gmt":"2025-04-04T09:57:10","slug":"examples-dataviews-sql-query-salesforce-marketing-cloud","status":"publish","type":"post","link":"https:\/\/www.marketinet.com\/en\/blog\/examples-dataviews-sql-query-salesforce-marketing-cloud\/","title":{"rendered":"How to Use DataViews with SQL in Salesforce Marketing Cloud"},"content":{"rendered":"

As we have commented in previous articles, if we want to improve our segmentations<\/a> and especially our results in our Marketing Cloud strategy, it is essential to develop increasingly precise queries, and this is where DataViews come into play.<\/p>\n

<\/p>\n

If we want to identify a potential customer of a product, a signal may be that in a generic email, the user clicks on the link of that product. Also, a customer always clicks on a specific product category. For this, it is important to use the LinkName intelligently. Many times only a descriptive name is used, but if you put a category, a separator and then the descriptive name, it will activate other interesting options to identify users who are interested not only in a specific product but in a category as such.<\/p>\n

\u00a0<\/p>\n

{{cta(’52fa9c99-860e-4fbd-b8e0-8084060f20e8′,’justifycenter’)}}<\/p>\n

A first query to know the status of the subscribers<\/h2>\n

\u00a0<\/p>\n

A very simple first query can be the status of your subscribers in a DE, through this query you can see the true impact or final delivery that you will have based on that status:<\/p>\n

\u00a0<\/p>\n

SELECT firstname, de.lastname, de.cathegory, de.email, s.[Status]<\/em>
FROM Test_Data_Extension as de LEFT JOIN _Subscribers s<\/em>
ON email=s.SubscriberKey<\/em><\/p>\n