My Journey with DESelect: Review by an SFMC Solution Architect

My Journey with DESelect: Review by an SFMC Solution Architect

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.

How DESelect works?

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:

  • Equals/not equal to
  • In/not in
  • Contains/doesn’t contain
  • Begins with/ends with
  • Is empty/is not empty
  • In results/not in results

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:

  • Left Inclusive/Exclusive Join
  • Right Inclusive/Exclusive Join
  • Inner Join
  • Full Outer Join

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:

  • Exclude Contacts in a DE from a Campaign (Taking out Bounced Emails out of All Subscribers List)
  • Select Customers who haven’t Engaged with our Emails in the past 14 days (based on Email Opens and Clicks)
  • Select Orders for certain product categories with the prices
  • Select Accounts that don’t have any Orders in the last 30 days
  • Get Accounts with the highest value of Order or without any Order at all
  • Select Contacts who are known Subscribers in SFMC

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.

Interested to see DESelect in action yourself?

6x Salesforce certified Marketing Cloud Solution Architect and Developer, named Salesforce Marketing Champion 2020 working and delivering in Isobar Switzerland. Ekaterina is recognized as a tech-savvy leader and a real-time optimization expert (Evergage, Thunderhead). Her knowledge and hands-on experience with Salesforce products (SFDC, Pardot, SFMC, Einstein) enables her to support smart digital transformation and improvements of marketing processes for a large number of international companies. She is also a long-time Trailblazer and Salesforce enthusiast who participates in and supports various Ohana events.
Ekaterina Obolenskaya
SFMC Solution & Technical Architect

Latest Articles

  • Unveiling New Reporting Features in DESelect Engage

    Webinar Transcript Time-Smart Marketing: Import Journey & Automate Retries with Engage Don’t miss the next one Read the release notes from this feature: here Written transcript from this webinar will be available soon. In the meantime, please watch a recording of the webinar on Youtube (above).     Don’t miss an update       […]
  • Harnessing the Power of Relative Dates in Salesforce Marketing Cloud (SFMC)

    The ability to adapt and react with timely precision is key in the marketing world. Marketing Cloud Engagement (MCE), also often referred to as Salesforce Marketing Cloud (SFMC), offers robust tools to facilitate such agility, particularly through the use of relative dates. This feature enables marketers and SFMC admins to automate campaigns with a precision […]
  • 14 Data & AI Challenges Collected from 57 Leaders in MOPs (Transcript)

    Webinar Transcript 14 Data & AI Challenges Collected from 57 Leaders in MOPs Don’t miss the next one Download the report mentioned in this webinar: here Anthony Lamot: Hello! And welcome to a brand new webinar by DESelect. I’m here today, joined by my co-founder, Jonathan, and I’m Anthony, and we are DESelect for Salesforce. […]
  • Kyra Constam, Creative & Web Manager

    Company Culture Meet Our Team: Creative & Web Manager, Kyra Constam In the dynamic world of design, Kyra Constam stands as a definition of talent and innovation. Get her take on her DESelect journey →   Her journey at DESelect began with the title of Senior Graphic Designer, where her talent and hard work shined […]

Join our newsletter to receive updates and helpful SFMC guides.

Reach the most targeted<br/> audiences in half the time

Reach the most targeted
audiences in half the time

Deselect icon
Subscribe to the Newsletter
Receive Salesforce Marketing Cloud tips,
tricks, and DESelect updates

By clicking the “Subscribe now” button, you agree to the DESelect Terms of Use and Privacy Policy.