Are you using DESelect Segment functionalities correctly?
This article shows the most common functionalities that are in some cases, being intertwined with each other. The below comparisons will serve as a guide on which functionalities or features should be used for your use cases.
Let's proceed!
In / Not In Results |
Selected Data Extensions |
- Filter fields using other Data Extensions that are not inside the Selected Data Extensions.
- Since the Data Extensions where the fields the user wants to filter on are not included in the Selected Data Extensions, the user cannot add those fields onto the Target Data Extension.
- Eg: Customers' details who placed orders in the month of July 2021.
|
- Can only filter fields that are inside the Selected Data Extensions.
- Since the Data Extensions where the fields the user wants to filter on are included in the Selected Data Extensions, the user can add those fields onto the Target Data Extension.
- Multiple rows might get generated in case of a one-to-many relationship.
- Eg: Customers and Orders details who placed an order in the month of July 2021.
|
Append Data Extension |
Append Data Action |
|
- The results of the selection will be added to the existing ones on the Target Data Extension and will be treated as new data.
- Eg: Updating the latest delivery address of existing customers and adding new lines of data for new customers who placed delivery orders.
|
Custom Value - Aggregation |
FX function |
-
Includes count, sum, minimum, maximum, and average which can be added as a new field onto the Target Data Extension. Any additional filter conditions apply only inside the aggregation custom value field and do not affect the rest of the selection.
- Eg: Number of Orders amounting to greater than 100 EUR for one Contact.
|
- Includes operators that can perform count, sum, minimum, maximum, and average which will be used as a filter condition that affects the Selection result itself.
- Eg: Contacts who placed Orders amounting to greater than 100 EUR.
|
Comments
0 comments
Please sign in to leave a comment.