In an effort to continuously provide our users better tools to segment and target in Salesforce Marketing Cloud, we have recently released additional filtering options. Now, when you create a DESelect selection, you have the option to use the “IN” and “BETWEEN” filters!
The “IN” operator
Using “IN” essentially allows you to list a series of comma separated text values. Previously, when you wanted to filter on several potential values of a picklist field, you would have to create separate filters for every value and use the “OR” operator. For instance:
Now instead, you can use the “IN” operator and separate values with a comma:
This is especially useful and time-saving when you have a large number of values.
The “BETWEEN” operator
When you want to filter on a number based on a range, you can now simply use the “BETWEEN” operator:
This filter option is available for fields that have the number and decimal type.
Previously when you incorrectly added a filter (for instance within the wrong “AND”-grouping) you would have to delete this filter and add it again. Not anymore!
It is now possible to simply drag-and-drop filters after they have been added, using the arrows-icon on the right side of the filter.
All of these filtering options are now available for all DESelect editions for Salesforce Marketing Cloud.