I ran a journey where I used a decision split to separate the audience into 4 branches and then sent each branch the same series of emails with varying wait times in between sends. Now I want to measure which branch performed better in terms of opens/clicks/goal achievement.

I can locate the Triggered Send Name and Triggered Send External Key for each email activity by viewing the activity summary in Journey Builder, but I can't find any of those values in any of the fields when I query the _JourneyActivity data view. I also can't figure out which version ID goes to which version number.

In short, I can't figure out how to query data views for activities I can see in Journey Builder. What's the most efficient way to query data on a specific email activity in a specific version of a journey?


If I get it right what you are missing might be the following information:

JourneyActivityObjectID corresponds to TriggererSendDefinitionObjectID in the _Sent, _Open, _Click, and _Bounce, data views.

With that information you can query data regarding opens, clicks and so on. I hope this helps :)

| improve this answer | |
  • That is a good place to start, but how can I be sure which JourneyActivityObjectID goes to which Email Activity in Journey Builder? I need to be able to query for specific values. – K K Oct 18 '19 at 14:34
  • For that you can use the ActivityExternalKey. That is your identifier for each activity. – DonL Oct 21 '19 at 6:56
  • I see! But the ActivityExternalKeys that are returned look like "EMAILV2-10". How should I interpret that? – K K Oct 24 '19 at 19:41
  • I thought that the External Key was editable. But I cant find that option in the UI. Maybe there is an option via API. Even then it would be quite annoying to go through all activities. Sorry :/ – DonL Oct 29 '19 at 12:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.