Segmentation processes can take up a lot of time when you want to create a targeted campaign. In the previous articles, we outlined different options on how to segment in Salesforce Marketing Cloud SFMC) using data filters and SQL queries.
However, neither of these methods can be called the ultimate solution for segmentation in SFMC. Why? Because these methods either don’t provide advanced methods or require technical skills that you may lack. What would be the solution? For instance, DESelect – an addon that runs inside SFMC and intuitively combines data on the fly. There is no more need to learn SQL or ask your colleagues to create queries for you. DESelect is an exceptional solution for a top-notch segmentation.
A 3-step guide: How to filter on Data Extensions with DESelect
In order to create a targeted campaign with information from various data extensions in DESelect, you should start with creating a new selection (think of this as a “segment”).
Step 1. Selection Criteria
Firstly, you have to choose which DEs you want to filter. For instance, you want to create a new segment of prospect contacts linked to their companies. Normally, in order to do that, you would rely on SQL to do this type of segmentation but with the drag-and-drop interface of DESelect, there is no need to write a SQL query for that.
- Choose the DEs from the available ones from SFMC through drag-and-drop
- Repeat the same action with the next DE
- Choose the relationship between DEs: with/without matching, with matching, with all matching
At the bottom, you can see that all the fields from both of your DEs are extracted and placed in the ‘available fields’ section. Now, you can choose to filter on as many fields as you want to.
- Drag-and-drop available fields to the right (e.g. for our campaign we need accounts which field ‘Type’ matches the ‘prospect’ criteria, and are coming from the US)
Step 2. Target Definition
In this step, we need to choose our target DE. There are a few options at this point: we can create a DE on the fly or choose an existing DE to populate with data from our new selection.
If you want to create a DE in the DESelect environment, you need to choose the fields that you want to have in your target segment.
- Drag-and-drop from the available fields on the left to your desired DE on the right (e.g. for this future campaign we need: Account Id, the Name of the Company, Type which equals Prospect, and Email Address)
- Hit Create a Target DE
Step 3. Preview
Before saving your new selection, you can preview the resulting data extension and how many records it would contain, to see if you want to add any changes.
- Hit Run Preview
- Check if the fields are populated correctly
Once you are happy with the preview, you can run your selection and it will automatically populate the target DE in your SFMC.
No need to learn SQL anymore, enjoy a convenient drag-and-drop interface and save precious time on segmentation using DESelect, book a demo here.
The Greatest Debates in Email Marketing History: Prioritizing Campaigns Without the Email FatigueMarketers rely on subscriber communications as the lifeblood of revenue generation, yet over a quarter of consumers indicate extreme email fatigue from increased campaign exchanges. Add in modern omnichannel experiences and separate marketing teams naturally prioritizing their own campaigns, and it becomes easy for end recipients to drown in an overwhelming flood of communications. Each […]March 23, 2023
It is your birthday. How to Ensure Marketing Cloud Doesn’t Skip Leap Day Birthdays from OffersHow would you feel if your birthday was forgotten for multiple years in a row and you feel left out on your special day? That’s exactly the feeling most companies give their customers who were born on the infamous Leap Day – February 29th. Companies often overlook Leap Day birthdays due to its rarity. February […]March 16, 2023
Field Experts: Why Technical Marketing Cloud Users Love DESelect, Part 2Salesforce Marketing Cloud’s nearly infinite data storage makes the novice marketer’s head spin. Such highly technical, complicated processes take time to complete and leave users anxious over the effects of potential mistakes. Marketing Cloud expert Markus Dang previously demoed some of his favorite admin features in DESelect Segment to reduce the risk and time requirements […]February 21, 2023
Field Experts: Why Technical Marketing Cloud Users Love DESelect, Part 1Audience personalization in Salesforce Marketing Cloud heavily relies on the UNION SQL (Structured Query Language) clause for data manipulation, analysis, and segmentation. This complex code has been a language many creative marketers struggle to master, making it the “French” of marketing ops. What better way to understand how DESelect solves this problem other than demo […]February 21, 2023