Include The journey name in Data extract file

Question

I'm working on a data extraction. I implemented it with a file transfer to my FTP, it's for "Sent" journey feedbacks. My customer would like to have the "journey name" in the generated file. I have just the "TriggeredSendExternalKey" for the moment, the customer really wants the journey name instead.

Thank you in advance, Ilyass

Answer 1

Are you using a query to populate the DE that you are then extracting? If so, you can match the TriggererSendDefinitionObjectID on the _Sent data view to the JourneyActivityObjectID on the _JourneyActivity data view. Then you can match VersionID on the _JourneyActivity to VersionID on the _Journey data view, in order to retrieve the JourneyName from the _Journey data view.

Here is an example query that can be tailored to your needs:

select
j.JourneyName
from _Sent s
inner join _JourneyActivity ja on ja.JourneyActivityObjectID = s.TriggererSendDefinitionObjectID 
inner join _Journey j on j.VersionID = ja.VersionID 
where s.TriggererSendDefinitionObjectID = 'YOUR_TriggererSendDefinitionObjectID'

Answer 2

It is still advised to use SQL for such use-case, as @jake314159 suggested already. Here you can find a step-by-step explanation of his suggestion and a bit more on top.

Additionally, there is a similar question has been asked some time ago and there you find a way how to manually map TriggeredSendExternalKey and identify what was the journey used for sending.

There is no special option to add the Journey Name field to the Tracking Extract's file. Maybe the only thing to try is to set some field that you would receive in the file that would include Journey's name, e.g. EmailName field from SendJob would have a naming pattern like - [Journey_Name]_Email_#1. but then you would need to make sure that you are not re-using emails across different journeys.