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')
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter