Why _Sent EmailName Is Null — Join _Job on JobID

The EmailName gotcha

_Sent records every deployment event but EmailName is always null on this view. Campaign reporting that needs the email asset name must JOIN _Job on JobID.

This is one of the most common Query Studio mistakes — the send count looks right but the email name column is blank.

Send volume by email name

SELECT
  j.EmailName,
  j.EmailSubject,
  COUNT(DISTINCT s.SubscriberKey) AS Sends
FROM _Sent s
INNER JOIN _Job j ON s.JobID = j.JobID
WHERE s.EventDate >= DATEADD(day, -30, GETDATE())
GROUP BY j.EmailName, j.EmailSubject
ORDER BY Sends DESC

Practitioner tips

• Filter EventDate on _Sent before joining — _Job is smaller but the join multiplies if _Sent is unbounded.
• Triggered sends populate TriggererSendDefinitionObjectID on both _Sent and _Job — use it for Journey attribution.
• Exclude test sends with TestStormObjID IS NULL on _Sent when reporting production volume.