SHARE
TWEET

Untitled

a guest Jul 22nd, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT count(*) AS TotalSent,  
  2. DATENAME(month, p.EventDate) as [Month],
  3. p.SubscriberKey as SubscriberKey
  4. FROM _Sent p
  5. INNER JOIN [Clients_DE] B ON p.SubscriberKey = B.AccountID
  6. WHERE p.EventDate BETWEEN GETDATE()-30 AND GETDATE()
  7. GROUP BY p.EventDate, p.SubscriberKey
  8. HAVING COUNT(*) > 0
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top