NULL Value Qualifying for Smart List Filter With "Less Than" Operator

A document by KCS Integration on behalf of Miles Ybaben on Jul 2, 2019Last modified by Roxann McGlumphy on Jul 10, 2019
Version 2Show Document
  • View in full screen mode

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. 


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

1 person found this helpful