Yes, in DESelect Segment you can do this by using Filter Sets.
What are Filter Sets?
Filter Sets are predefined sets of Filters that can be created based on an individual Data Extension or a Data Set and its available fields.
Filter Sets can save you a good amount of time since they are reusable for all users, but can only be created by Administrators.
How can you create a Filter Set?
We need a list of customers with their orders excluding the customers that are males and live in Belgium or Holland, and with an order smaller than 5000 euros.
We will use the Data Set “Customers_Orders_EmailsToExclude” and create a Filter Set named “Exclusions” to exclude the above-mentioned group of customers.
Note: Before starting with the creation of a Filter Set, please ensure that the Data Set that you will use contains all the fields that you want to include on your Filter Set. You can verify this by going to the Admin Panel > Data Sets.
Take into account that this Filter Set can also be build on individual Data Extensions, but for our scenario we will create our Filter Set based on a Data Set.
1. Go to the Admin Panel > Filter Set tab > New Filter Set button.
2. Now, you can name your Filter Set and select a Data Set from the Available Data Sets section: all available Data Sets will be shown in the dropdown.
3. Click on the Select button to scan all the existing fields from the Data Extensions inside that Data Set.
Important Note: Should you need to use another Data Set instead, it is possible to remove the current one by clicking on the Clear button.
4. Click on the Edit Selected Filters button and the Selected Filters pop-up will appear.
5. Start filtering by using the fields from Available Filters, and drag-and-drop these to the Filters section.
You can also access the Data Extensions that are predefined for this: the Related Records section will be available at the bottom of the pop-up.
This pop-up will look exactly the same as the Filters section on the Selection Criteria page.
6. Lastly, click on Save on the Edit Selected Filters pop-up, but also on the Filter Set page.
Let’s now use our Filter Set in a Selection!
1. Create a new Selection.
2. Select a Data Set and drag-and-drop it into the Selected Data Extensions section.
The available Filter Sets related to this Data Set will automatically display under Filter Sets, see below:
3. Drag-and-drop the Filter Set on the Filters section and all the Filter Set created earlier will appear:
Note: You will now be able to remove/ make any modifications to your Filters if needed.
- October ‘22 release
- December '22 release
- Can I predefine multiple relations between Data Extensions?
Please sign in to leave a comment.