To start with, let’s go through how to create a filter for customers.
Go to Customer Data Platform → Customers:
The filter conditions field contains the Add AND condition and Add OR conditions buttons.
Below the buttons on the left, you can see the total customer database size — in our case, it's 22,914 customers.
How to add AND condition
Click on the Add AND condition field. A dropdown menu will appear with a list of customer attributes you can filter by. At the top, you’ll see standard profile properties (e.g. name, gender, birthday), followed by grouped property categories (e.g. custom fields, orders and product lists).
Click a group name to reveal related filter options:
After selecting a filter, fill in any additional settings if available.
For example, if you select the Subscription condition, additional fields will appear where you can specify the brand (if you have more then 1), channel and topic:
Once you’ve filled in all the required fields, click the Add condition button:
Click Apply to save the condition(s) you selected. The system will display the filtered customers and their total number:
AND conditions are connected by a light blue branching line (connector).
This condition means we want to find customers who have a valid, non-empty email AND a valid non-empty phone number AND a filled-in name.
How to add OR condition
Use this feature when you want to match customers who meet any of the selected conditions.
For example, to create a segment of customers with valid emails OR valid phone numbers, follow these steps:
1. Click Add OR condition
2. Click Add AND condition → Email, and select the "not empty and valid" from the dropdown on the right. After that, click Add condition.
3. Then, on the same panel below click Add condition → Phone number and select the "not empty and valid" from the dropdown on the right. Click Add condition.
4. Finally, click Apply.
For more details on how to create filters with OR conditions, please refer to this article.
OR conditions are connected by a lilac branching line (connector).
This condition means we want to find customers who either have a filled-in valid email OR have a filled-in valid phone number. Satisfying at least one of these two conditions is sufficient.
How to add a nested condition
A field may contain additional conditions.
The main condition and its more detailed nested condition are linked by a blue line of different levels.
For example, to find customers who have placed an order and whose order value exceeds $100 and whose previous orders have been fully paid select the following conditions:
To apply additional conditions, click + next to the relevant condition.
To apply nested conditions, click the links of the adjacent conditions.
For example, to make the Status condition more detailed with a nested order line condition, you can choose from the following two options:
1. Click +:
2. Click on the side line:
Search
You can look up the required field using its name:
Cross-search through nested conditions
You can find the field you need among the list of nested conditions.
For example, if you want to find an Action template condition which is nested in the Customer action field, one way to do this would be to select Actions → Customer action → Action template:
But you can also do this in one step if you use the search bar — simply start typing the field name in the Condition name field and click on the line you’re looking for:
The cross-search function works across first- and second-level nested fields only.