I am having an error when trying to implement a data filter using a measure I created. I am implementing this filter to create a filtered data extension. Here are the details:
I am using a data extension with about 133,000 records and I am trying to create a filtered data extension of just the contacts that have not opened an email in the past 180 days. Let's call this data extension 'A'.
I created a measure called Opens_180_A. The measure has:
data source: Subscribers
event source: Unique Opens
Open Date - is after - today minus - 180 - days
Then I created a data filter type data extension which has:
Opens_180_A - is less than - 1
I created a filtered data extension from this data filter and got 0 records. I then changed the data filter to be:
Opens_180_A - is greater than or equal to - 1
and I got ~30,000 records.
Is there a problem with my logic somewhere? I would think that in the original one I should be getting around 103,000 records (133,000 original - 30,000 that opened emails).
How can I fix this issue? Any workarounds that I can use?
Thanks in advance.