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.

    • Related Articles

    • Using the IN Tag and NOT IN Tag clauses

      Segmenting your audience is a key strategy for sending relevant content. In Delivra, you can use the segment builder to identify contacts who are not in a single tag or even not in multiple tags. This is especially useful for quality control and ...

    • Using the OPEN and DID NOT OPEN Clauses

      Targeting the right contacts is a breeze with Delivra's segmentation tool. By using contact behavior—such as opens, clicks, or purchases—you can fine-tune your audience for more relevant and effective email campaigns. What It Does Behavioral ...

    • Using Snippet Segments

      Segmenting your audience is a powerful way to deliver personalized content that resonates, but building complex segments from scratch each time can be a chore—especially when many segments rely on the same criteria. That’s where Segment Snippets come ...

    • How do I find a list of everyone that didn't open a campaign?

      Sometimes you need to find contacts who didn’t open a specific campaign—whether it’s for reporting purposes or to follow up with a re-send. Delivra gives you a few different ways to create and reference these non-opener lists, depending on your ...

    • Segments vs. Tags

      In Delivra, both tags and segments help you organize and target your audience, but they serve different purposes and function differently: Tags are static: A tag is a fixed list of contacts manually assigned through import, workflow updates, or ...