Skip to content

Instantly share code, notes, and snippets.

@camrobert

camrobert/List of Unsubscribed Records Sent Emails

Created April 1, 2023 06:50
Show Gist options
  • Save camrobert/955b8c4a9c4911e423ae0a5dc1416105 to your computer and use it in GitHub Desktop.
Save camrobert/955b8c4a9c4911e423ae0a5dc1416105 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
List of Unsubscribed Records Sent Emails
SELECT DISTINCT
a.SubscriberKey
, a.EmailAddress
, j.JobID
, j.EmailName
, s.EventDate
, j.SendClassificationType
, j.SendType
, a.DateUnsubscribed
FROM _Subscribers a
INNER JOIN _Sent s ON a.SubscriberKey = s.SubscriberKey
INNER JOIN _Job j ON j.JobID = s.JobID
WHERE a.Status = 'Unsubscribed'
AND a.DateUnsubscribed < s.EventDate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment