How do I create a segment that includes or excludes the results for multiple values using the IN or NOT IN operators?

DESCRIPTION

Create a segment that queries or excludes the results for multiple values using the IN or NOT IN operators. Three example scenarios using the IN or NOT IN operator have been provided. 

HOW-TO

Example 1: Create a Segment based on multiple Store Numbers using the IN operator-

1. Go to Segments dashboard
2. Click "Regular" on the left menu
3. Give your segment a name and description
4. Click "Create a Clause"
5. Select applicable clause type (I am selecting Numeric for my example)
6. Select the correct field from the field drop-down menu (I am selecting Store Number for my example)
7. Select operator  "in"
8. Enter a value into the 'Value' box and click Add, repeat as needed for all values
9. Click "OK" once all of the values have been entered
10. Click "Save & Test" to save the segment and return results.  Results will return all Contacts who DO have one of the provided store numbers in their record.

Example 2: Create a Segment based on the exclusion of multiple Store Numbers using the NOT IN operator-

1. Go to Segments dashboard
2. Click "Regular" on the left menu
3. Give your segment a name and description
4. Click "Create a Clause"
5. Select applicable clause type (I am selecting Numeric for my example)
6. Select the correct field from the field drop-down menu (I am selecting Store Number for my example)
7. Select operator "not in "
8. Enter a value into the 'Value' box and click Add, repeat as needed for all values
9. Click "OK" once all of the values have been entered
10. Click "Save & Test" to save the segment and return results.  Results will return all Contacts who DO NOT have one of the provided store numbers in their record, including null values.

Example 3: Create a Segment based on the inclusion of multiple Product Types using the eCommerce extended tables using the IN operator-

1. Go to Segments dashboard
2. Click "Regular" on the left menu
3. Give your segment a name and description
4. Click "Create a Clause"
5. Select applicable clause type (I am selecting Numeric for my example)
6. Select the correct field from the field dropdown menu (I am using eCommercerceOrderLineItems.ProductType for my example)
7. Select operator "in"
8. Place a check next to all of the values you want to include with this query
9. Click "OK" once all of the values have been entered
10. Click "Save & Test" to save the segment and return results. Results will return all Contacts who DO have one of the provided Product Types in their ecommercerceOrderLineItems.ProductType data record. 

NOTES

1. These operators can also be used with extended tables and in conjunction with the 'Review my Data' feature.
2. If you have a large list of values to input, an import feature is available for IN and NOT IN operators.