How do I use IN and NOT IN operators in segment clauses?

There may be instances where you need to evaluate several values in a demographic field for a segment.  You can save time using the IN or NOT IN operators when building your segment clauses.

IN means you're looking for the list of values entered; NOT IN means you're looking for anything but the list of values entered.

For the example in this article, we want to find all contacts NOT IN the states of Ohio, Indiana and Kentucky. 

How-To

1. Navigate to the Contacts dashboard & choose "Segments" from the left-hand navigation.
   
   
2. Click the "Create Email Segment" button & choose the "Regular Segment" type from the pop-up.
   
   
   
3. Enter name and description for the new segment.
   
   
4. Open the "Select Field" drop-down and search for the State contact field.
   
   
5. In the pop-up, finish building the clause.
   • Select "NOT IN" from the operator drop-down menu.
   • Type each individual value (click "Add" after each), copy/paste values, or import a list of values.
     
     
     
6. Click the "Ok" button when all values have been entered.
   
   
7. Click "Save and Test"' to see your results.

Notes

1. IN and NOT IN operators are available for text or numeric fields only.
2. Use "Download my data values" to see all of the entries for the chosen text field (in this case State) to make sure you are not misspelling values, etc.
3. Do you need to create a segment to see if a contact is in or not in multiple categories? Follow the steps from this article