1

Is it possible to query for open data from an email in a Journey. I've been having trouble extracting that into a data extension. I'm using this query

SELECT c.JobID,c.SubscriberKey
FROM _Open c
INNER JOIN (
    SELECT JobID,EmailName 
    FROM _Job 
) j ON j.JobID = c.JobID
WHERE j.EmailName = 'Journey Email 1'

My results data extension has EmailName, JobID, and SubscriberKey. There are no errors that result from this however I'm not getting any data either.

1
  • Try deleting the data extension and creating it again. Remember to map the query to the. New data extension
    – 0xsegfault
    Commented May 13, 2017 at 0:29

1 Answer 1

1

I assume you are trying to execute the query from a child Business Unit. If so, append an Ent. prefix to your Data Views:

SELECT c.JobID, c.SubscriberKey
FROM Ent._Open c
INNER JOIN (
    SELECT JobID, EmailName 
    FROM Ent._Job 
) j ON j.JobID = c.JobID
WHERE j.EmailName = 'Journey Email 1'
1
  • I tried this but I'm still getting no results. No errors either. I've also recreated the data extension as "Data_Kid" suggested. Is there a way to query for a Journey by JobID? I guess that would be another question.
    – player1
    Commented May 15, 2017 at 23:23

You must log in to answer this question.

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