In this article, we would like to present three examples of customer segmentation in the retail industry using Salesforce Marketing Cloud (SFMC). We got our inspiration from best practices in the industry and tried to incorporate the latest trends in customer segmentation for retail in our article.
The retail data model in Salesforce Marketing Cloud
Before we jump into actual scenarios, we will make a quick stop at your data model in Salesforce Marketing Cloud (SFMC). Data models vary from business to business and from industry to industry, so it is quite hard to find a one-size-fits-all ultimate solution. However, to make this article as hands-on as possible, below you can find a common retail data model for Salesforce Marketing Cloud that can be used as an inspiration to develop your own data model.
This data model is presented by different data extensions for SFMC:
- Addresses (for storing different shipping & invoicing addresses)
- Product Line Items (stock)
- Basket (eCommerce)
- Store visit
- Subscriptions (for different kind of newsletter subscriptions)
Your data extensions might look like this within Email Studio:
Once your data is set up, we can move on to the actual segmentation scenarios that can be done using this data model.
It is possible to segment the data in SFMC in multiple ways. For instance, using filters, SQL, or add-ons like DESelect. In our examples below, we show you both how to segment in Salesforce Marketing Cloud by either writing SQL queries or using drag-and-drop segmentation in DESelect.
If you would like to learn more about segmentation in SFMC using SQL check out our introductory guide to SQL here.
Segmentation strategy 1 - Notify subscribers about a new product
Our first segmentation scenario breaks down how to notify a subscriber about a new product.
For instance, a contact receives a newsletter for a certain type of product. Let’s imagine that he is subscribed to updates for a certain brand of sneakers. So how can he be notified that a new pair has just dropped?
For this segmentation scenario, you need three data extensions (DEs) in SFMC. You need to use Contacts DE, Subscriptions DE and Products DE.
Here you can see an example of the segmentation process done in DESelect. The app allows you to preview the result of the segmentation which gives you an opportunity to check if the segment was done correctly.
Now, we are going to recreate this segmentation scenario using SQL in SFMC, following the steps below (an example of the SQL query can be found lower):
- First off, you create a relationship between the Contacts DE and Subscriptions DE based on ContactId using INNER JOIN. In this way, you would link only those contacts that have a subscription.
- Then, you need to set the filtering criteria, WHERE the subscription’s name matches the Product category field of the Products DE, where a new product has been added.
- After that, you need to create a subquery, where you query on a new product that you would like to notify your subscribers about. In our scenario, it is ‘Classic 80’.
- Then, you select the date when this product was added. In our example, it is 06/04/2020.
Below you can find an example of an SQL query, where we used the Contacts DE, Subscriptions DE, and Products DE. You may use this as a reference while creating your own segment in Salesforce Marketing Cloud.
Segmentation strategy 2 - Notify subscribers about a new store opening in their neighborhood
Using this scenario, we would like to notify contacts who are subscribers about a new store that is opening in their area. In order to do this, you would need to use three data extensions: Contacts, Stores and Subscribers.
In the example below, you can observe how to create a segment using DESelect, where you can already preview your segment:
Now we are going to break down the segmentation process using SQL in Salesforce Marketing Cloud (SFMC) for this scenario:
- Firstly, you need to create a relationship between the Contacts DE and Subscribers DE based on Contact Id. You would like to choose here INNER JOIN, similarly to the example above.
- Then create an IN RESULTS logic, where the Contacts DE is connected with the Stores DE via Zip Code/Postal Code.
- After that, you would like to choose a concrete Zip Code/Postal Code using the WHERE criteria. In our example, it is 85017.
As a result, you will receive a list of contacts who are subscribers that have opted in for your communication and live in the same neighborhood where a new store is going to open.
Below you can find an example of a SQL query, where the Contacts DE, Subscriptions DE, and Stores DE were used. This query can be used as a point of reference while creating a segment in SFMC.
Segmentation strategy 3 - Re-engage customers who are inactive
Here is the SQL reference to recreate this scenario in SFMC:
- You would like to start with filtering on the Contact Id field from the Contacts DE that is NO IN of Contact Id field that is stored in the Orders DE. By choosing the IN RESULTS function you indicate the contacts whose Id does not appear in the Orders data extension.
- Then, you need to filter on the date, which is 90 days in our example.
Below, you can find an SQL query example of that segment that you can use as a reference for your selection in SFMC.
So what are the best segmentation strategies for retail using Salesforce Marketing Cloud?
It is essential to understand your customers and be able to suggest the correct product at the right time. Consequently, it is important to segment your audience in order to execute targeted campaigns that can improve your conversions. In this article, we laid out 3 effective segmentation strategies for retail that can be used in Salesforce Marketing Cloud (SFMC). We tried to make them as practical as possible, so you can easily apply them in your own SFMC environment using either DESelect or SQL.
What is Salesforce Connections? Connections is the biggest Salesforce Marketing Cloud event that brings marketing, commerce, and digital professionals together — to inspire, educate, and connect. The event creates an excellent opportunity for Salesforce professionals to network and learn together. Salesforce Connections 2022 was happening live for the first time since the COVID-19 pandemic and […]June 16, 2022What to choose when it comes to segmentation in SFMC? When it comes to Salesforce Marketing Cloud, it’s not uncommon for marketers to find themselves unsure of what decisions to make that best suit technology to their business needs. Many users facing audience segmentation problems are offered native addons like Audience Builder or a novel […]June 14, 2022This year, Salesforce fans can look forward to an incredible line-up of talks and presentations at Salesforce’s Connections 2022. The event promises to be so packed that we’ll have to plan carefully to ensure we don’t miss out. Trailblazers visiting Chicago will have the ability to create their schedules based on the sessions calendar. Online […]May 30, 2022In 2022, Salesforce Marketing Cloud releases will be synced with Salesforce releases, making it easier to follow the market updates and better promote an omnichannel approach to using Salesforce products. With this article, we took the liberty to predict the development trends for Salesforce Marketing Cloud. AI advances AI has played a part in marketing […]March 18, 2022
Join the companies and partners using
DESelect Marketing Data Enablement Solutions