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?

1 Answer 1


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 :)

  • 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, 2019 at 14:34
  • For that you can use the ActivityExternalKey. That is your identifier for each activity.
    – DonL
    Oct 21, 2019 at 6:56
  • I see! But the ActivityExternalKeys that are returned look like "EMAILV2-10". How should I interpret that?
    – K K
    Oct 24, 2019 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, 2019 at 12:51

You must log in to answer this question.

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