I'm trying to extract all the customer who have not opened the email I have created an SQL activity and Data Extension but it doesn't seem like its pulling all the customer who have not opened the email. see code below - have I missed something
SELECT de.Email
FROM Immigration_EM de
LEFT JOIN _subscribers sub ON sub.EmailAddress = de.email
LEFT JOIN _Sent s ON s.SubscriberID = sub.SubscriberID
LEFT JOIN _open o ON o.SubscriberID = s.SubscriberID
LEFT JOIN _job j ON j.JobID = s.JobID
WHERE o.SubscriberKey IS NULL
AND j.JOBID= 285269
I will be updating the jobID to Emailname so I can automate it, also I want to only pull the customer who have been sent an email within the last 7 days.
any help would be much appreciated.
thanks in advance Pete