When working with Marketing Cloud marketers require deeper technical skills to have success in this challenging digital marketing world. There is a variety of supportive tools that could help marketers when they have some struggles. One of these tools is DESelect. Do you remember writing SQLs to transform data into segmented audiences and forgetting some of the needed functions or operators? Or maybe, you urgently needed segmented data list with some SQL functions, but the process of SQL creation took you long? Here it comes. DESelect is a tool that can help marketers avoid writing massive SQL queries and use a drag-and-drop functionality to easily build the required targeted and segmented result.
It’s very easy to navigate yourself inside the platform, which you can find under AppExchange tab in the main Marketing Cloud Menu.
On the right side there is a selection of preferred Data Extension and its fields which you want to filter. The following filter operators are available:
The last operator, marked in bold, is used for another Data Extension selection and replaces an SQL function ‘in’ and ‘not in’.
DESelect allows you to join different data extensions in an easy manner. When one Data Extension is selected, it’s possible to drag and drop another Data Extension to it and select the relationship, based on different types of Joins. These are supported:
I find it very cool, that the result could be firstly previewed, changed in case needed and only then published. The tool lets you come back to the previous stage and make all needed amendments in your filter selection.
Once created the queried data could be saved either to a new or existent Data Extension.
With DESelect it’s possible to:
You can also play around with the dates: transform date fields, calculate the date difference, add a timestamp. More explained scenarios you can find here.
The whole processing and data preparation will take you up to a few seconds. The time of processing varies based on the number of records in the DE and the complexity of filtering. But DESelect could handle any type of even big data queries.
DESelect robust segmentation capabilities were missed in SFMC before. It makes Salesforce Marketing Cloud routine work quick and easy now.
Salesforce Marketing Cloud best practices
and DESelect updates