Using the IN and NOT IN operators

Using the IN and NOT IN operators

When building segments, there may be times you want to evaluate a contact field against multiple possible values—especially for demographic or custom profile data. Instead of creating multiple "OR" statements, Delivra makes this process more efficient with IN and NOT IN operators.

These operators help you streamline segmentation logic:

  • IN targets a list of values that match any the ones you specify.
  • NOT IN targets values that exclude the ones you specify.

Example Scenario

Let’s say you want to create a segment of contacts who are not located in Ohio, Indiana, or Kentucky. Instead of writing out three separate "State is not equal to" clauses, you can use the NOT IN operator to handle it all in one step.

How to Use IN and NOT IN Operators

  1. Navigate to the Contacts dashboard and choose Segments from the left-hand menu.
  2. Click the Create Email Segment button and select Regular Segment in the pop-up.
  3. Provide a name and description for your segment.
  4. Use the Select Field drop-down to locate the desired contact field (e.g., State).
  5. In the pop-up:
    • Choose NOT IN (or IN) from the operator drop-down.
    • Enter your list of values using one of the following methods:
      • Manually type each value and click Add.
      • Paste a comma-separated list.
      • Import a list of values from file.
  6. Click OK when your list is complete.
  7. Click Save and Test to see the segment results.

Best Practices and Tips

  • IN and NOT IN are supported for text and numeric fields only.
  • Click Download my data values in the segment builder to review existing data for the chosen field. This helps avoid typos or formatting mismatches.
  • Use these operators to check for membership across categories like geography, product interest, job title, or numeric ranges.

Practical Use Cases

  • Build segments that include only certain states or regions.
  • Exclude contacts with specific product interests for a targeted message.
  • Target multiple store locations or event registrations with a single clause.

If you're frequently working with long or changing lists of values, IN and NOT IN can be real time-savers—giving your segmentation wings!

For any questions, feel free to reach out to our Support team at support@delivra.com.