Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- s.SubscriberKey,
- j.EmailName
- FROM _Sent s
- LEFT JOIN _Job j
- ON s.JobID = j.JobID
- LEFT JOIN _Open o
- ON s.JobID = o.JobID AND s.ListID = o.ListID AND s.BatchID = o.BatchID AND s.SubscriberID = o.SubscriberID AND o.IsUnique = 1
- LEFT JOIN _Click c
- ON s.JobID = c.JobID AND s.ListID = c.ListID AND s.BatchID = c.BatchID AND s.SubscriberID = c.SubscriberID AND c.IsUnique = 1
- WHERE
- s.EventDate > dateadd(d,-7,getdate())
- AND (o.SubscriberID is NULL AND c.SubscriberID is NULL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement