NULL Value Qualifying for Smart List Filter With “Less Than” Operator

Description description

Issue Description
A Smart List with a filter for an integer field with a specified range value, such as ‘less than 100’, is qualifying records that have a NULL(empty) value for the integer field.

Resolution resolution

Issue Resolution

Marketo will treat NULL/empty as equivalent to 0 in this case, and qualify the lead as having a value less than 100. However, Marketo does not treat 0 as NULL/empty

Adding the filter “[ field] is not empty” to block records with NULL values will resolve this