DESelect Segment Cheat Sheet

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 use when a user has many sources with a similar structure to be combined and stored in the same target data extension eg combining 3 retail branches details such as location, manager, and employees name in one master data extension 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