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

DESCRIPTION

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.  (IN means you're looking for the values entered; NOT IN means you're looking for anything but the values entered)  

For an example, let's say we want to find all contacts NOT IN the states of Ohio, Indiana and Kentucky. 

HOW-TO

1. Navigate to the Contacts dashboard
2. Choose Segments from the left-hand navigation
3. Click the Create a Regular Segment button at the top-right.
4. Enter name and description for the segment
5. Click the 'Choose a Clause' button
6. Select 'Text' (as the State demographic field is a text type field)
7. Select the State field from the top drop-down menu
8. Select 'NOT IN' from the operator drop-down menu
9. Enter applicable value and click the Add button (there is also an import available)
10. Repeat for each value
11. Click 'Ok'
12. Click 'Save and Test' to see your results

 
NOTE

IN and NOT IN operators are available for text or numeric fields only.

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 misspellings, etc.