Using the IN and NOT IN operators

Using the IN and NOT IN operators

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 clauses.

IN means you're looking for the list of values entered; NOT IN means you're looking for anything but the list of values entered.

For the example in this article, we want to find all contacts NOT IN the states of Ohio, Indiana and Kentucky. 

How-To

  1. Navigate to the Contacts dashboard & choose "Segments" from the left-hand navigation.

  2. Click the "Create Email Segment" button & choose the "Regular Segment" type from the pop-up.
    seg1.png

  3. Enter name and description for the new segment.

  4. Open the "Select Field" drop-down and search for the State contact field.

  5. In the pop-up, finish building the clause.
    • Select "NOT IN" from the operator drop-down menu.
    • Type each individual value (click "Add" after each), copy/paste values, or import a list of values.
      seg2.png

  6. Click the "Ok" button when all values have been entered.

  7. Click "Save and Test"' to see your results.

 

Notes

  1. IN and NOT IN operators are available for text or numeric fields only.
  2. 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 misspelling values, etc.
  3. Do you need to create a segment to see if a contact is in or not in multiple categories? Follow the steps from this article

    • Related Articles

    • Using the IN CATEGORY and NOT IN CATEGORY clauses

      You can use our segment builder to create clauses to find contacts that are in or not in single or multiple categories. Navigate to the Contacts dashboard and select "Segments" from the left menu to get started building your new segment. Find ...

    • Using the OPEN and DID NOT OPEN Clauses

      Our segmentation tool allows you to use contact behavior to target them for future campaign. Using the open field in our Action clauses when building a regular segment will retrieve only contacts who received but opened or did not open a campaign. ...

    • Contacts | Delivra Air

      Your Contacts dashboard is designed to provide statistics for contact status changes for the month as well as shortcuts to common tasks performed. Here you can view & search a listing of all contacts in the account, manage & add contact records, ...

    • Using Snippet Segments

      Segments can be developed based on a multitude of demographic and behavioral tidbits of subscriber data, allowing you to hone in on specific audiences you want to reach. While segmented lists are extremely beneficial, they can often become complex to ...

    • How do I edit a contact record? | Delivra Air

      This article references steps in the Delivra Air platform. If you are not a Delivra Air user, please visit this article for steps to complete in the legacy system. You will manage contact records in the Contacts dashboard in your account. How-To From ...