Resend Automation
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
Comments