Float Field Operator Change - Removal of "is" and "is not" Operators

What changed? 

Operators are used within FiltersTriggers, or Flow Steps to define selection criteria.  The list of operators available for use for given field depends on the field type (e.g. Integer, String, Date).  A list of field types and their operators can be found here.   In the June 2020 release, we removed both the “is” and “is not” operators for Float field types.  As a result, these two operators are no longer available in filterstriggers, or flow steps that use the Float field. 

Filter

David_Everly_1-1598908954033.png

Trigger

David_Everly_2-1598908954035.png

Flow Step

David_Everly_3-1598908954037.png

What didn’t change (yet)? 

The “is” and “is not” operators still exist in Marketo Sky, but we will be removing them as soon as possible.  Until these operators are removedplease refrain from selecting them within the Marketo Sky interface.  Otherwise, you run the risk of adversely impacting your campaigns. 

Why is this change being made? 

Float fields store an approximation of a value, not the literal value.  For example, a float field could store 10.5 as 10.5995485730481245 or something similar.  So "is 10.5" would not qualify.  As a result, comparisons using “is” and “is not” were not consistent.  In some cases, comparisons worked as expected, in others they did not.  To eliminate this ambiguity, we removed these operators as choices. 

What action is required? 

If you are currently using “is” or “is not” operator for Float field in a filter you must change your filter to use different operator.  We recommend using either “between” operator. 

For example, suppose you are using a filter with “is” operator to match the number “10.5”.

David_Everly_4-1598908954039.png

To correct, replace ”is” with “between” and supply a range that encloses the number.  In this example we use the range from “10.5” to “10.6” to enclose the number ”10.5”.

David_Everly_5-1598908954041.png

How can I determine if I am using “is” or “is not” operator with Float field? 

1. Gather list of Float fields using the Marketo REST API.  The Describe endpoint returns a list of all person fields with their data types.  Search the response body for “float” to identify all Float fields in your instance. 

2. Identify places where a given field is used by going to Admin > Field Management and searching for the given field name.  Select the field and see “Field Used By” for a list of places where used.

David_Everly_6-1598908954042.png

What if we don’t take this action? 

Since results can be inconsistent, you may not be identifying audiences correctly.  Some persons could be erroneouslincluded or excluded from a campaign or smart list.  In addition, some trigger campaigns could execute or not execute based on an inconsistent comparison.