Skip to content

Instantly share code, notes, and snippets.

@kylekeesling

kylekeesling/already-sent-to.sql

Created December 14, 2012 20:49
Show Gist options
  • Save kylekeesling/4288530 to your computer and use it in GitHub Desktop.
Save kylekeesling/4288530 to your computer and use it in GitHub Desktop.
Download ZIP
Query that uses ExactTarget Data Views to find all subcribers who've been sent to today. Also includes an optional qualifier to ignore emails that you may use on a seed list
Raw
already-sent-to.sql
SELECT DISTINCT
SubscriberKey
FROM _Sent
WHERE
DATEDIFF(day, EventDate, GETDATE()) = 0
AND SubscriberKey NOT IN ('[email protected]','[email protected]''[email protected]')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment