The Proper Use of AND and OR (Text Tutorials)

If you use more than one search filter when creating a basic search with the Segments tool, you’ll be prompted to connect those two (or more) filters using the AND / OR drop down menu that appears to the right of each filter.  Under which scenarios should you use one or the other?

Jump to:
OR
AND
Using AND / OR Together

OR

You should use OR as the connector between multiple search filters when you want  the Segments tool to find everyone who matches any of your filters.  For example:

“City” “Equals” “San Francisco”

OR

“City” “Equals” “London”


Would pull up everyone in your chosen lists who was noted as being in either San Francisco or London.  Whereas using AND as a connector:

“City” “Equals” “San Francisco”

AND

“City” “Equals” “London”


Would pull up only those people whose city was marked as being both San Francisco and London.  Which would be no one.


AND

So you should use the AND connector when you want the Segments tool to only find those people who match ALL of your filters.  For example:

“Email Address” “Contains” “Gmail.com”

AND

“Customer” “Equals” “Yes”


Would only find paying customers who have a Gmail email address.  Whereas using OR as a connector in this scenario:

“Email Address” “Contains” “Gmail.com”

OR

“Customer” “Equals” “Yes”


Would find anyone with a Gmail address along with any customers no matter what their email address happens to be.

Combined AND / OR Searches

You can run searches that use both AND and OR by creating multiple rules in an Advanced Segment.