How to Join _Sent to _Click in SFMC SQL

Click tracking grain

_Click records link clicks in email sends. Like _Open, each row sits at the engagement event grain — the same four keys that tie a subscriber to a specific deployment batch within a job.

Analysts join _Sent to _Click to measure click-through rate, time-to-click, and link-level engagement after send.

Four-key join pattern

SELECT TOP 1000
  s.SubscriberKey,
  s.EventDate AS SentDate,
  c.EventDate AS ClickDate,
  c.URL,
  c.IsUnique
FROM _Sent s
INNER JOIN _Click c
  ON s.JobID = c.JobID
  AND s.ListID = c.ListID
  AND s.BatchID = c.BatchID
  AND s.SubscriberID = c.SubscriberID
WHERE s.EventDate >= DATEADD(day, -30, GETDATE())
  AND c.EventDate >= DATEADD(day, -30, GETDATE())
ORDER BY c.EventDate DESC

Practitioner tips

• Filter EventDate on both legs — _Click volume rivals _Open in many accounts.
• Use IsUnique = 1 when reporting first-click metrics per send job.
• Join _Job when you need email name or subject alongside click URLs.