Skip to main content

Posts

Showing posts with the label dataview

Dataviews in SFMC

Course Link : Why use Data view ? Query data views using Automation Studio for up to six months of Marketing Cloud subscriber and journey information. Few Most Used Dataviews: Open Dataview:  Query this data view in Automation Studio to find email opens for your Marketing Cloud account. Sent Dataview:  Query this data view in Automation Studio to find the subscribers sent emails from your Marketing Cloud account. Job Dataview:  Query this data view in Automation Studio to find data on Marketing Cloud email send jobs. Sample Query: Data Views to retrieve how many times a user opened an email in the last 60 days. SELECT o.SubscriberKey as email , COUNT ( * ) as Count_Opens FROM _Open o WHERE o.JobID IN ( SELECT distinct s.JobID FROM _Sent s WHERE s.EventDate > convert ( date , getDate() -60 ) ) and o.isunique = 1 GROUP BY o.SubscriberKey Dataview Schema Table -  https://sfmarketingcloudhome.files.wordpress.com/2021/02/dataviews_2...