Can someone validate the following query for me?
I am trying to retrieve all subscribers that were sent an email in the last 6 months and have not clicked any?
SELECT distinct s.SubscriberID
FROM _Sent s
WHERE s.EventDate > dateadd(day,-180,getdate())
AND s.SubscriberID NOT IN (
SELECT o.SubscriberID
FROM _Click o
WHERE o.EventDate > dateadd(day,-180,getdate())
)
AND s.SubscriberID is not null
The targeted data extensions contains: SubscriberId
field, am I right to think the Contacts added to the DE are those that were sent an email in the last 6 months but not clicked it because they do not exist in the _Click
data view?