Not Opened Measure not returning records

Question

I want to use Measures to return Subscribers that did not open a specific email.

I sent the email to 4 Subscribers and one of the Subscribers opened the email. I can see this in the tracking view:

And also by querying the _Open Data View using:

SELECT SubscriberKey, EventDate
FROM _Open
WHERE JobID = 4331396

Which inserts one record to the target Data Extension.

So far, so good, now moving onto Measures...

If I create a Measure that looks like this:

Then I apply that measure in a Filter against the Sendable DE containing the 4 Subscribers, where my filter looks like:

(where 'Opens for 4331396' is the Measure name), then my filtered DE returns the one record that opened the email. Great.

Now, if I use the 'Not Opened' Measure:

And create a filter that looks like this:

...then I have 0 records in the Filtered DE, when I would expect to have 3 (the 3 Subscribers who did not open the email).

I'm pretty sure that my logic is correct in my filter, as it follows this example. I've also tried changing the filter expression to 'is equal to 0' but still returns 0 records.

Does anyone know why my 'Not Opened' Measure is not returning any records?

Answer 1

I've just refreshed the filter and it's now returning results for the 'is greater than 0' filter condition, which is odd, as it wasn't working previously.

I'm aware that open/click tracking is not real-time (more like near-time). However, this behavior is odd as the 'Open' measure was returning the correct results, but not the 'Not Opened' measure. Still, it appears to be working as expected now.

So, my answer for other users who experience the same issue is that you should try refreshing the filter at a later time.