Data Filter excluding Subscribers in Contact Builder
|Knowledge Article Number||000220896|
The cause lies with the way SQL interprets NULL values when excluding data. A filter is set up to exclude a certain value, like "exclude all subscribers whose city is Chicago," but if any subscribers have a NULL value in the "City" field, those records are excluded. The report then contains inaccurate results.
How to resolve the issue