I'm trying to build SQL query for non-openers for 2 Journeys: X and Y Could you please advice what is wrong here? I didn't get any error. Simply I got 0 results or results are wrong.

s.SubscriberKey as SubscriberKey,
jr.JourneyName as JourneyName
From [_Sent] as s
inner join [_Job] as j on s.JobID = j.JobID
inner join [_Open] as o on o.SubscriberKey = s.SubscriberKey
inner join [_JourneyActivity] as ja on s.TriggererSendDefinitionObjectID = ja.JourneyActivityObjectID
inner join [_Journey] as jr on ja.VersionID = jr.VersionID
where jr.JourneyName = 'X' or jr.JourneyName = 'Y'
and o.SubscriberKey = NULL

1 Answer 1


Few issues:

  1. Open View JOIN a) should be LEFT JOIN to Sent view b) join should include more fields--batchid, listid, jobib & SubscriberKey--See documentation. c) also confirm join field to journey views.

I believe fixing 1A item is your problem that is SQL 101 issue that is causing this

  • I've updated SQL but I'm still not receiving any records.
    – Natalia
    Commented Oct 6, 2023 at 9:01

You must log in to answer this question.

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