Resend Automation

PHOTO EMBED

Tue Sep 26 2023 14:35:54 GMT+0000 (Coordinated Universal Time)

Saved by @shirnunn

SELECT
j.TriggeredSendCustomerKey,
j.DeliveredTime as SendTime,
o.EventDate as OpenTime,
s.EmailAddress,
s.SubscriberKey
from [_Job] j
INNER JOIN [_Open] o ON j.JobID = o.JobID
INNER JOIN ENT._Subscribers s ON o.SubscriberID = s.SubscriberID
WHERE
o.isunique = 1 
AND o.EventDate > dateadd(d,-30,getdate()) 
AND j.TriggeredSendCustomerKey in ('163400','163399') 
content_copyCOPY