When to opt for a Master DE, a Selection Template, copy the Selection, or Data Sets & Filter Sets?

as a deselect segment user, you will encounter times when you will question what approach/feature is best to use for a specific use case how do you choose between using a selection template instead of copying an existing selection? or should you opt for a data set or master data extension instead? the hesitation can happen because all these 4 features share a common principle simplify audience generation, allowing marketers to reuse existing or recurrent structures in this article, we want to share some best practices to help you choose between these features when needed selection template use case example campaign type template you want your selection to be the base for many future selections with a similar structure, but these future versions will need some small modifications in this base selection, you want to pre set some advanced settings like filters or custom values, not only the relationship between data extensions (since this would be possible to solve by using data sets instead) campaign type get orders placed in a given country in the last 6 months selection template all uk orders made by men in the last 6 months using this template for a new selection all us orders made by men in the last 6 months in this last version, we will update only one filter country equals uk will become country equals us new runs of the same campaign you want your selection to be a template for future versions but the original version to never be modified by anyone else, leaving a description and instructions on how the team can copy it and create future versions note a selection that has been marked as a template can only be modified by the user who created it or an administrator this is to prevent a template from being modified by other users or to avoid deleting it by accident you have a campaign running monthly to give a prize to the top users for each run, you want to generate a different target data extension for archiving purposes you want to save it as a template to prevent end users from modifying the original selection for this campaign copy selection use case example you want to create a selection with the same or similar structure of another selection this is a one/two time copy or you need the same filter but in another business unit you created a selection for the first day of black friday, and now you want to reuse it for the second day, applying the same filter but updating the dates you are using in the filter section as it’s a punctual need, you can just copy the selection of day 1 of black friday, change what you need, and run it note if the structure of this selection you are copying is useful for many future selections, opting for a selection template would be more beneficial data sets & filter sets use case example as a marketer, you always add the same combination of data extensions and filters in your selections, and you find yourself dragging and dropping the same data extensions and/or filters several times a day your organization often runs campaigns based on customer orders and their order details additionally, there’s a set of standard filters you always need to apply exclude customers without email, customers without email opt in, orders older than 10 years ago, and orders of value less than 1 dollar in this scenario, you will create the following data set in the admin panel (a combination of 3 data extensions) customers with matching orders orders with matching orderitems also, you will create the following filter set “opted in customers with valid orders” (a combination of 4 filters mentioned above) email (customers) is not empty email opt in (customers) = true amount (orders) smaller than 1 order date (orders) in previous 10 years after you have this data set, instead of adding the data extensions one by one, you can just drag & drop the data set, and all the combinations of data extensions will be automatically added, and drag & drop the filter set, and all the filters will be automatically added you have some campaign types that require building a complex data extension combination with a complex set of filters creating these relationships and filters directly in your selection can lead to errors, as not all the users are knowledgeable enough on the structure of your data model as an admin, you can pre build these combinations inside a group of data sets and filter sets we have a campaign type where users need to apply filters on the products purchased in an order, which requires building a relationship between more than two data extensions non tech users are not comfortable building it and often require support from admin users to help them to simplify this campaign, the admin can create a data set in the admin panel called “customers with orders and detailed products” with the necessary data extensions, and create a filter set in the admin panel called “active customers with orders” so the non tech users can use data set and filter set without knowing the structure of the data model master data extensions use case example for some campaigns, you need to run queries over great amounts of data, which can lead to timeouts or very slow performance to prevent it, you can build master data extensions with the aggregations of data you use in your campaigns, so they are pre calculated when you needed (and refreshed nightly, for example) you want to create a selection with all customers who placed more than 3 orders in the last quarter create a master data extension containing the id of the customer and the number of orders in the last quarter whenever you need to filter out customers based on the number of orders, you can use this master data extension to avoid accessing the orders data extension and filter them recurringly you want to simplify the day to day segment generation you always need to add the same base filters over the same fields in every selection (opt ins, email validation, …) you always combine the same data extensions to get fields from them into the target data extension you want to make sure marketers don’t forget to include some important filters as soon as you are repeating the same filter/combination of des daily, you should consider creating a master data extension where you do that filter and scheduling it to run daily after that, you can use your master data extension as the base of your campaigns, knowing that the base filters or combinations are already applied note if you have a use case where real time data is very important, then it is highly recommended to opt for data sets instead of master data extensions since master data extensions are normally scheduled to run daily/twice a day and work with static data between refreshes master data extensions and scheduling of selections are a very powerful way of creating easily accessible data extensions, and refreshing them nightly so they are updated when you need them and they’ll keep a great performance over accessing and filtering raw data