Advertisement
Guest User

Untitled

a guest
Oct 16th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. SELECT DISTINCT
  2. s.SubscriberKey,
  3. j.EmailName
  4. FROM _Sent s
  5. LEFT JOIN _Job j
  6. ON s.JobID = j.JobID
  7. LEFT JOIN _Open o
  8. ON s.JobID = o.JobID AND s.ListID = o.ListID AND s.BatchID = o.BatchID AND s.SubscriberID = o.SubscriberID AND o.IsUnique = 1
  9. LEFT JOIN _Click c
  10. ON s.JobID = c.JobID AND s.ListID = c.ListID AND s.BatchID = c.BatchID AND s.SubscriberID = c.SubscriberID AND c.IsUnique = 1
  11. WHERE
  12. s.EventDate > dateadd(d,-7,getdate())
  13. AND (o.SubscriberID is NULL AND c.SubscriberID is NULL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement