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.