Print this page

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

  • Remove any NULL values from fields to get the most accurate results.
  • A work around would be to filter just the data you don't want and to use it as an exclusion list.

promote demote