Joining _Sent to _Unsubscribe for Opt-Out Analysis

Post-send unsubscribe analysis

_Unsubscribe records list-level opt-out events. Join to _Sent on the four engagement keys to identify which deployment preceded an unsubscribe — critical for deliverability and content audits.

Unsubscribes within 24 hours of send

SELECT
  s.JobID,
  j.EmailName,
  s.SubscriberKey,
  s.EventDate AS SentDate,
  u.EventDate AS UnsubscribeDate
FROM _Sent s
INNER JOIN _Unsubscribe u
  ON s.JobID = u.JobID
  AND s.ListID = u.ListID
  AND s.BatchID = u.BatchID
  AND s.SubscriberID = u.SubscriberID
INNER JOIN _Job j ON s.JobID = j.JobID
WHERE u.EventDate >= DATEADD(day, -30, GETDATE())
  AND DATEDIFF(hour, s.EventDate, u.EventDate) <= 24
ORDER BY u.EventDate DESC

Reporting guidance

• High same-day unsubscribes may signal frequency or relevance issues.
• Filter by JobID when auditing a specific campaign deployment.
• Combine with _Complaint for full deliverability friction picture.