I would like to retrieve the list of bounces of all the emails are included in the different journeys on a daily basis.
I know we would have to use the Data Views but I need help to build the query as it requires to join _Bounces, _Journey, _JourneyActivity (if I am not mistaken).
Could someone provide some light on how the query should look like? This is what I have so far:
Would it work like this?
select j.JourneyName, j.VersionNumber, ja.ActivityName as 'EmailName', s.EventDate as 'SendTime', su.EmailAddress, su.SubscriberKey as 'ContactKey', s.SubscriberID as 'ContactID' , b.EventDate, b.Domain, b.BounceCategoryID, b.BounceCategory, b.BounceSubcategoryID, b.BounceSubcategory, b.BounceTypeID, b.BounceType, s.JobID, s.ListID, s.BatchID from [_Sent] s join [_JourneyActivity] ja on s.TriggererSendDefinitionObjectID = ja.JourneyActivityObjectID join [_Journey] j on ja.VersionID = j.VersionID join [_Subscribers] su on s.SubscriberID = su.SubscriberID join [_Bounce] b on s.TriggererSendDefinitionObjectID = b.TriggererSendDefinitionObjectID