Skip to content

Instantly share code, notes, and snippets.

@kylekeesling

kylekeesling/already-sent-to.sql

Created December 14, 2012 20:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • 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 ('email1@et.com','email2@et.com''email3@et.com')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment