NULL Value Qualifying for Smart List Filter With Less Than Operator

Report Inappropriate Content

Issue

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.

Solution

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