1

I've created a series of Tracking Extracts on my account. Which field should I use to export the Journey Name that is associated with the email data of each extract?

Improve this question
1
  • 1
    I don't think you can do this directly. You have to use SQL Query for this. here is the list of the fields and their description help.salesforce.com/… I do not see any journey name field.
    – Swati Mishra
    May 18, 2020 at 13:37

1 Answer 1

Reset to default
3

If you want to track the email sent from journey then you can use the sent tracking output from tracking extract.

Once you are done with the tracking extract and file transfer activity. You can the get the file from SFMC SFTP and filter with the 'TriggeredSendExternalKey'. You can find your journey triggered send external key by going into Email Studio > Email > Interactions > Journey builder sends > Select your journey.

Take the csv or extract the zip file from SFTP and filter it with your journey builder triggered send external key.

Since this tracking extract involves so much of activity i would prefer SQL query if I need the data of less than 180 days.

Here is the salesforce documentation for last 24 hours of journey builder sends. You can extend as per your convenient if its withing 180 days.

If its more than 180 days then you can go with this tracking data extract option.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .