DESelect April ’21 Release: Using fields in dynamic custom values

DESelect April ’21 Release: Using fields in dynamic custom values

Available in: DESelect Plus, DESelect Advanced.

Using fields in dynamic custom values

This month, we’re making it possible to refer to fields in dynamic custom values, the DESelect alternative to CASE WHEN statements in SQL. Please have a look at 2 common use cases below.

Example 1: Taking Phone or Mobile Phone

We have a list of contacts, and for each contact, we have a mobile phone number, a landline phone number, or both. For each contact, we need to take one phone number. In case we do have a mobile phone number, we want to take that one. If we don’t have a mobile phone number but we have a landline phone number, we want to take the landline. If we don’t have any phone number, we want to choose a NULL value.

In DESelect we can easily do this via the creation of a dynamic custom value.

In the Target Definition Screen, click on Add new value under Custom Values and give it a name to create a custom value of type Dynamic Value.

create custom dynamic values in DESelect using drag and drop

For Field Type, we choose Phone. Now we’ll add 2 criteria by clicking the Add Criteria button.

Under the When statement for the first criteria, we build a filter using the Mobile Phone Number field, and choose filter type Is not empty.

 

Create filters in DESelect using drag and drop

Under the Then statement, we click on the grid icon to switch to using fields, and then refer to the Mobile Phone Number field.

create custom values in Salesforce Marketing Cloud using DESelect

Now let’s add the second criteria.

Under the When statement, we build a filter using the Landline Phone Number field, and choose filter type Is not empty.

create advanced filters using drag and drop in DESelect

Under the Then statement, we click on the grid icon to switch to using fields, and then refer to the Landline Phone Number field.

Create custom values using DESelect in Salesforce Marketing Cloud

Now when we map this custom value to a target data extension, we’ll get the mobile or landline phone number in the Phone field depending on what’s available.

 

Example 2: Taking Lead Name or Contact Name of Campaign Member

When pushing CampaignMember data from Salesforce Sales Cloud to Salesforce Marketing Cloud, you’ll notice a CampaignMember can be linked to either a Lead or a Contact.

First, we need to make sure that the Salesforce_Lead and Salesforce_Contact data extensions are linked to Salesforce_CampaignMember in the Selected Data Extensions section.

selected data extensions connections using drag and drop in DESelect

You can now use a dynamic custom value to take the First Name from either the Contact or the Lead.

We can do something very similar to what we did in the example above with the phone number:  if the ContactId on CampaignMember is filled out, we take the First Name from the Contact record.

create advanced filters in Salesforce Marketing Cloud using DESelect

If the LeadId on CampaignMember is filled out, we take the First Name from the Lead record.

create filters using drag and drop in DESelect

When mapping this custom value with our target data extension, we’ll get the First Name of the Campaign Member, no matter if that Campaign Member was a Lead or a Contact.

Create custom values using DESelect in Salesforce Marketing Cloud

Conclusion

Dynamic custom values are an easy way to allow marketers to choose which field to use, depending on the value that’s filled out or relevant.

To try out this feature for yourself, request a demo now.

  • 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.