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 are provided below.
HOW-TO
Example 1: Create a Segment based on multiple Store Numbers using the IN operator-
- Navigate to the Contacts dashboard
- Choose Segments from the left-hand navigation
- Click the Create a Regular Segment button at the top-right
- Give your segment a name and description
- Open the Select Field drop down and search for the relevant database field. (I am selecting Store Number for my example)
- Select operator "in"
- Enter a value into the 'Value' box and click Add, repeat as needed for all values
- Click "OK" once all of the values have been entered
- 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-
- Navigate to the Contacts dashboard
- Choose Segments from the left-hand navigation
- Click the Create a Regular Segment button at the top-right
- Give your segment a name and description
- Open the Select Field drop down and search for the relevant database field. (I am selecting Store Number for my example)
- Select operator "not in "
- Enter a value into the 'Value' box and click Add, repeat as needed for all values
- Click "OK" once all of the values have been entered
- 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-
- Navigate to the Contacts dashboard
- Choose Segments from the left-hand navigation
- Click the Create a Regular Segment button at the top-right
- Give your segment a name and description
- Open the Select Field drop down and search for the relevant database field.
- Select operator "in"
- Place a check next to all of the values you want to include with this query
- Click "OK" once all of the values have been entered
- 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 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.
Comments
0 comments
Article is closed for comments.