Skip to content

Instantly share code, notes, and snippets.

@marketingclouded

marketingclouded/Updates Subscriber_Last_Open w _Open and _Job Info

Last active September 23, 2020 20:43
Show Gist options
  • Save marketingclouded/95fed983b1abbec42adceba0947cae94 to your computer and use it in GitHub Desktop.
Save marketingclouded/95fed983b1abbec42adceba0947cae94 to your computer and use it in GitHub Desktop.
Download ZIP
Tracking Inactive Subscribers in SFMC: Updates Subscriber_Last_Open w _Open and _Job Info
Raw
Updates Subscriber_Last_Open w _Open and _Job Info
SELECT
g.SubscriberID,
MAX(a.EventDate) AS 'LastOpenDate',
MAX(a.JobID) AS 'JobID',
y.EmailName
FROM Subscriber_Last_Open g
JOIN _Open a
ON g.SubscriberID = a.SubscriberID
JOIN _Job y
ON a.JobID = y.JobID
GROUP BY g.SubscriberID, y.EmailName
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment