An Official Salesforce Marketing Cloud Partner

[wpml_language_selector_widget]
[wpml_language_selector_widget]

Building Efficiencies and Testing Data at Scale

THE CHALLENGE:

One of the biggest car dealers in Europe needed to create control groups and sub-control groups as a percentage of the same audience, and assign dynamic values per each group in order to do testing. This is challenging as it takes a significant amount of time to create many control and sub-control groups with a query; and even more time to create personalized (dynamic) values per each control group. What’s worse, after all that query writing this marketing team's only option before running these queries in Marketing Cloud was to simply pray they didn't receive any errors.

Continue reading below to find out how they solved this using DESelect.

Book a Demo Take a Tour
  • Automotive

How to solve with DESelect Segment:

  • They used DESelect's Sort and Limit and Dynamic Custom Values features to make this process significantly more efficient.

  • First, they created an initial Selection and took a percentage of it with the Sort and Limit feature. Then, they created a Dynamic Custom Value to label this specific control group and added this Dynamic Custom Value to the Target Data Extension.

  • Next, they made a second Selection and excluded the rest of the values (or some percentage sorting it via a specific field) from the Target Data Extension used in the first Selection.

  • Last, they built Dynamic Custom Values to populate each specific sub-control group and they added them to the Target Data Extension.

  • To create other control groups, they simply had to copy Selection's #1 and #2 and update sorting and dynamic values. They creating even better efficiencies by creating templates to make it easier for future colleagues who might do testing with new groups.

Marketers are getting big results with DESelect.
Find out how:

  • Industrie – Télécommunications
    Créez facilement des segments d'audience performants... sans code. DESelect offre aux responsables marketing toutes les capacités de segmentation de SQL et AMPscript avec une interface simple de type "glisser-déposer".
    View
  • Industry – Telecommunications
    Easily create high performing audience segments…without code. DESelect offers marketers all the segmentation capabilities of SQL and AMPscript with a simple drag-and-drop interface.
    View
  • DESelect Retail and Consumer Goods Customer Use Cases
    Industrie – Commerce de détail et biens de consommation
    Créez facilement des segments d'audience performants... sans code. DESelect offre aux responsables marketing toutes les capacités de segmentation de SQL et AMPscript avec une interface simple de type "glisser-déposer".
    View