
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:
- Contacts
- Addresses (for storing different shipping & invoicing addresses)
- Products
- Product Line Items (stock)
- Orders
- Basket (eCommerce)
- Store visit
- Stores
- 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.
Latest Articles
-
The Greatest Debates in Email Marketing History: Prioritizing Campaigns Without the Email Fatigue
Marketers rely on subscriber communications as the lifeblood of revenue generation, yet over a quarter of consumers indicate extreme email fatigue from increased campaign exchanges. Add in modern omnichannel experiences and separate marketing teams naturally prioritizing their own campaigns, and it becomes easy for end recipients to drown in an overwhelming flood of communications. Each […]March 23, 2023It is your birthday. How to Ensure Marketing Cloud Doesn’t Skip Leap Day Birthdays from Offers
How would you feel if your birthday was forgotten for multiple years in a row and you feel left out on your special day? That’s exactly the feeling most companies give their customers who were born on the infamous Leap Day – February 29th. Companies often overlook Leap Day birthdays due to its rarity. February […]March 16, 2023Field Experts: Why Technical Marketing Cloud Users Love DESelect, Part 2
Salesforce Marketing Cloud’s nearly infinite data storage makes the novice marketer’s head spin. Such highly technical, complicated processes take time to complete and leave users anxious over the effects of potential mistakes. Marketing Cloud expert Markus Dang previously demoed some of his favorite admin features in DESelect Segment to reduce the risk and time requirements […]February 21, 2023Field Experts: Why Technical Marketing Cloud Users Love DESelect, Part 1
Audience personalization in Salesforce Marketing Cloud heavily relies on the UNION SQL (Structured Query Language) clause for data manipulation, analysis, and segmentation. This complex code has been a language many creative marketers struggle to master, making it the “French” of marketing ops. What better way to understand how DESelect solves this problem other than demo […]February 21, 2023Join our newsletter to receive updates and helpful SFMC guides.