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