DESelect May ’21 Release: Predefined Relations

DESelect May '21 Release: Predefined Relations

Available for: DESelect Enable, DESelect Plus, DESelect Advanced.

This month we’re very proud to be releasing a feature that is going to be a game changer for marketers.

DESelect already made it very easy for marketers to do campaign segmentation without writing SQL, but a remark we sometimes got was that the marketer still needs to have some understanding of the data model. Specifically, how data extensions are related to each other.

Predefined relations now solves that completely.

And thanks to predefined relations, we’re able to make certain existing functionalities within DESelect much easier to use. Let’s dive in.

Step 1: Predefining Relations

In the admin panel in DESelect, accessible through the gear icon on the lower right corner, admins will now find the Relations tab, where one can define how different data extensions and data views are related to each other.

In the screenshot below, you can see how an admin can easily define how the Orders data extension relates to the Customers data extension.

admin panel in DESelect app

Step 2: Easy joining of data extensions

When you add 2 data extensions that have a predefined relation to the Selected Data Extensions section, DESelect will automatically set the fields based on the predefined relation.

For example, if first we add DESelect_Demo_Customers to the Selected Data Extensions, and then DESelect_Demo_Orders, the Relation modal will pop up and it will already have the fields set automatically. So, the marketer does not need to think about which field on the Contacts data extension matches with the Orders data extension.

JOIN representation for predefined relations in DESelect

The text ‘Fields are set according to a predefined relation.’ indicates these fields were set automatically. The user remains free to select other fields should (s)he wishes too though.

Step 3: Easy In Results Filter

As soon as you select a data extension or data view for which a relation is predefined, a new section Related Records appears under the Available Fields section. The Related Records section shows all data extensions / data views that are related to the Selected Data Extensions.

In our example, it shows that DESelect_Demo_Orders is related to our Customers Data Extension.

related records in DESelect

This now makes it super easy to filter on related data extensions. We can drag and drop the related data extension from the Related Records section to the filter section to start filtering on it.

Through the Count filter, we can now easily filter for:

  • Customers that have at least 1 order
count at least aggregations in DESelect
  • Customers that have more than 3 orders
count more than aggregations in DESelect
  • Customers that have no orders
count no using aggregations in DESelect
  • Customers that have less than 2 orders
count less than using aggregations in Salesforce Marketing Cloud
  • Customers that have exactly 5 orders
count exactly using aggregations in DESelect

Note you can also click on the funnel icon to determine which Orders to take into consideration; eg. you may want to only look at Orders from the last 30 days.

related records filter down in DESelect

Besides filtering on a count of the number of records, one can also filter on calculations on number fields of the related records. Supported calculations are minimum, maximum, average or sum.

  • To filter customers for which the average of the amount of all orders for this customer is at least 200:
average value used in aggregations in DESelect
  • To filter customers for which the sum of the amounts of the orders for this customer is less than 1000:
sum value used in aggregations in DESelect
  • To filter customers for which the lowest amount of the orders for this customer is more than 200:
minimum value used in aggregations in DESelect
  • To filter customer for which the highest amount of the orders for this customer is less than 100:
Maximum value used in aggregations in DESelect

Step 4: Easy Aggregations

For data extensions / data views for which a relation is predefined, one will now see a Basic and an Advanced mode when creating a custom value of type Aggregation.

This Basic view is very straightforward and makes it super easy to create an aggregation for data extensions / data views with predefined relationships. In case you need to aggregate for data extensions without a predefined relationship, the Advanced screen remains available.

Let’s say we want to count the number of orders per customer and store this number in our target data extension. We go to the Target Definition screen, click on New Custom Value, and choose type Aggregation.

The first question we need to answer on this screen is: ‘What do you want to aggregate?’. Here we choose: “DESelect_Demo_Orders per Customers”.

The next question is ‘What do you want to calculate?’.

Here we choose: “Count number of records”.

If we do not want to take all orders into consideration, we can click on Edit Filters, for example to filter out orders outside of a time range or a certain amount. If we just want to consider all orders, we’re done here.

Create aggregations in Salesforce Marketing Cloud using DESelect


Predefined relations allows admins with a good understanding of the data model to predefine how different data extensions / data views in the data model are related, so DESelect does not have to ask marketers about this information while they’re building selections.

This strongly reduces the need for marketers to understand the data model, makes several functionalities in DESelect much easier to use, and reduces the chance for mistakes and need for support.

We strongly recommend our customers take full advantage of this functionality.

Do you want to give it a try as well? Book a demo here.

  • DESelect Launches ‘Engage’ Platform to Combat Marketing Fatigue

    AUSTIN, Texas, March 28, 2023 — Amid a macro environment where marketing teams must increasingly scrutinize spend, DESelect, the leading Salesforce Marketing Cloud partner, announced the launch of its Engage platform, designed to maximize the impact of every communication sent to each individual contact and defend against marketing fatigue. DESelect Engage gives marketers the tools to control […]
  • DESelect Segment – February ’23 Release

    It’s already February and it’s already time for our next Segment release! You asked, and we listened. In response to some of our customers’ most upvoted feature requests, today we’re releasing brand new capabilities, workflow upgrades, and UI/UX design enhancements for DESelect Segment. Cross Joins A new join type to combine Data Extensions with DESelect […]
  • What’s new in DESelect: December 2022

    Happy Holidays! It’s time to reveal what’s inside the last DESelect release of 2022. Our December release is packed with upgrades like access to more data, serious workflow enhancements, and helpful improvements that admin users will love.   Shared Custom Values Expedite your process and remove redundant tasks. *Available for: the Advanced plan. Previously, when […]
  • What’s new in DESelect: October 2022

    Happy October! We’re excited to announce a bunch of new features focused on increasing your efficiency and effectiveness as marketers. Many of the new features in this release have been highly requested and eagerly awaited by our customers so let’s jump right in. Introducing: Filter Sets Drive efficiency with Filter Sets*Available for: Plus and Advanced […]

Stay Connected

Join our newsletter to receive updates and helpful SFMC guides

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.