Segment conditions pulling wrong customers

Hey @lisaspencer,

Instead of using the “doesn’t end with” rule here, I think using “contains” would work better. The reason why using “contains” doesn’t seem to work as intended is due to your OR statement. When using negative conditions together, you’ll actually want to use an AND statement. 

From our AND vs. OR reference Help Center article:

When it comes to negative statements, remember that AND requires every condition to evaluate as true, whereas with OR, only one must be true.

For instance, if you want to create a flow filter that excludes those who live in the USA and Canada, you may think you would use Properties about someone and say Country doesn’t equal USA OR Country doesn’t equal Canada. However, the OR connector means that someone can live in Canada (and not the United States) and still go through this flow, since only one of these conditions must be true. To exclude people in both countries, use the AND joiner.

Because you’re using an OR statement to capture users whose email does not end in Gmail or Outlook, someone with a Gmail address technically isn’t an Outlook address either. This means that they would qualify for the segment. 

I would also encourage you to check out some past Community posts on this topic as well. I’ve included some below that other members have found helpful:

David