katydorjee · October 20, 2025 00:27
diff --git a/Get Email bounce data of a Journey builder email sent.sql b/Get Email bounce data of a Journey builder email sent.sql
 SELECT su.emailaddress,
       su.subscriberkey AS ContactKey,
       j.journeyname,j.versionnumber,ja.activityname AS EmailName,
       s.eventdate AS SendTime, s.jobid, s.listid, 
       b.eventdate AS BounceTime, b.BounceType,b.SMTPBounceReason, b.SMTPMessage, b.SMTPCode
 FROM   [_sent] AS s
       INNER JOIN [_journeyactivity] AS ja
               ON s.triggerersenddefinitionobjectid = ja.journeyactivityobjectid
       INNER JOIN [_journey] AS j
               ON ja.versionid = j.versionid
       INNER JOIN [_bounce] AS b
               ON s.jobid = b.jobid
                  AND s.listid = b.listid
                  AND s.batchid = b.batchid
                  AND s.subscriberid = b.subscriberid
       INNER JOIN [_subscribers] AS su
               ON s.subscriberid = su.subscriberid
       INNER JOIN [<Name_of_the_journey_data_extension] AS de
               ON s.subscriberkey = de.SUBSCRIBER_KEY
 WHERE j.journeyname = '<Name_of_the_journey>'
	SELECT su.emailaddress,
	su.subscriberkey AS ContactKey,
	j.journeyname,j.versionnumber,ja.activityname AS EmailName,
	s.eventdate AS SendTime, s.jobid, s.listid,
	b.eventdate AS BounceTime, b.BounceType,b.SMTPBounceReason, b.SMTPMessage, b.SMTPCode
	FROM [_sent] AS s
	INNER JOIN [_journeyactivity] AS ja
	ON s.triggerersenddefinitionobjectid = ja.journeyactivityobjectid
	INNER JOIN [_journey] AS j
	ON ja.versionid = j.versionid
	INNER JOIN [_bounce] AS b
	ON s.jobid = b.jobid
	AND s.listid = b.listid
	AND s.batchid = b.batchid
	AND s.subscriberid = b.subscriberid
	INNER JOIN [_subscribers] AS su
	ON s.subscriberid = su.subscriberid
	INNER JOIN [<Name_of_the_journey_data_extension] AS de
	ON s.subscriberkey = de.SUBSCRIBER_KEY
	WHERE j.journeyname = '<Name_of_the_journey>'
No results found