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?