sfmc // SQLPRODUCTION
Journey → Activity → Email Tracking
Map email tracking events back to Journey Builder journey and activity names.
sqljourneytrackingsentjourneyactivity
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verifiedNot recorded
Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.
SELECT
s.SubscriberKey,
s.EventDate AS SendDate,
j.JourneyName,
j.VersionNumber,
ja.ActivityName,
ja.ActivityType
FROM _Sent s
INNER JOIN _JourneyActivity ja
ON s.TriggererSendDefinitionObjectID = ja.JourneyActivityObjectID
INNER JOIN _Journey j
ON ja.VersionID = j.VersionID
WHERE ja.ActivityType LIKE 'EMAIL%'Salesforce documents JourneyActivityObjectID as the bridge to TriggererSendDefinitionObjectID.
Filter by ActivityType to avoid unrelated activities.