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.

  • What’s new in DESelect: June 2022

    Summer is finally here along with powerful new features from our team. Happy June! It’s Garrett again with big product updates for you as we start the summer. DESelect proudly opened the door to non-technical marketers by ending the technical dependencies around SQL. We also take pride in equipping technical marketers with tools that increase […]
  • What’s new in DESelect: April 2022

    Get more time back in your day with DESelect. That’s not an April Fools’ joke! Welcome to April! It’s Garrett, from DESelect, here to share this month’s Product updates. It’s no secret that our no-code products already help thousands of marketers unlock the full power of SQL for more effective marketing campaigns. Today we’re excited […]
  • DESelect February ’22 Release: Scheduling of waterfall selections and moving around selected data extensions

    It is the first release of the year so let’s make it interesting! As you may already know, DESelect loves to bring customer’s ideas to life. And so, we are introducing 2 new powerful functionalities that come by popular demand: scheduling of waterfall selections and moving around selected data extensions.   Let’s get started! Scheduling […]
  • DESelect Dec ’21 Release: Folders for available data extensions, selection templates and descriptions, and improved date filters

    It’s that cold snowflakes season and DESelect is introducing some new cool features: folders for Available Data Extensions, selection templates, and descriptions, and improved date filters. Let’s dive in! Folders for Available Data Extensions Available for: DESelect Segment Enable, DESelect Segment Plus, DESelect Segment Advanced Being able to search for the data extensions that you […]

Stay Connected

Join our newsletter to receive updates and helpful SFMC guides

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

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