Using Joined Data Views vs AND Operator

Data Set

There are 2 options for setting multiple conditions.

In our example, we test both options with a small data set:

1. Data

   Email	Number	Amount
   jane@example.com	1003	25
   steve@example.com	1003	0
   steve@example.com	1005	75

2. Criteria:

   Number = 1003 AND  Amount > 0

Segment Option 1

Use one segment criterion and add two filters to it.

Result:

Only the contact jane@example.com is selected, as it fulfills both criteria:

Segment Option 2

Use two separate segment criteria.

Result:

Both contacts are selected, as the criteria are considered separately.

Related Topics

Related Data Set - Table Views (tab)
Create Data Views for Cross-table Related Data Queries