0

I have a journey builder send in a child BU without using any publication list. In the journey builder UI and email tracking, I can see that sends were being delivered and opened.

However, querying and joining the _job and _sent data view, I am getting null values for the _bob's DeliveredTime field.

Here is my query:

a.JobID,
a.SubscriberKey,
a.EventDate,
b.DeliveredTime,
b.EmailName,
a.AccountID
FROM
_sent a
INNER JOIN
_job b
ON a.JobID = b.JobID
WHERE
b.EmailName LIKE '%EmailName%'

Also, any idea why the _sent AccountID is returning the Parent's MID when I am querying in the child BU? Adding the a.AccountID = MID of the child BU is not returning any rows at all.

Thanks in advance.

Your Answer

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

Browse other questions tagged or ask your own question.