Customer Cohorts
Master customer retention with cohort analysis: Track behavior, reduce acquisition costs, and boost sales by understanding your most valuable Shopify customer groups.
| Alex Jost Founder of RetentionX · Jan 28, 2025 · 14-minute read |
At a time when customer acquisition is becoming increasingly expensive, it's even more important to focus on retaining existing customers. By focusing on customer retention, your brand can reduce the cost of customer acquisition and increase sales through repeat purchases and upselling. In addition, customer retention can improve your understanding of customer needs.
RetentionX helps your brand track and understand customer behavior patterns, make informed decisions, and identify valuable group of customers for retention and acquisition.
|
| Part 1 · The guide |
What is a cohort?
A cohort analysis, typically includes a table or chart that displays data for each different group of customers (cohorts) over a specific period of time. |
For example, let's say a brand wants to analyze the behavior of customers who made their first purchase in 2020. They would group customers that bought in their Shopify store into cohorts based on the month they made their first purchase. The cohort analysis table might look something like this:

In this monthly cohort analysis report, the first column represents the cohort (the month the customer made their first purchase), and the following columns represent the percentage of customers who made a repeat purchase in your online store in the following months.
We can see that the cohort of customers who made their first purchase in January have a higher percentage of repeat purchase as time goes by. On the other hand, the cohort of customers who made their first purchase in May have a lower percentage of repeat purchase as time goes by.
By analyzing this table, the brand can see that customers who make their first purchase in January are more likely to make repeat purchases, while customers who make their first purchase in May are less likely to do so.
How to read a cohort analysis report
A cohort table has three reading directions, and each one answers a different question. Here is a simplified example showing cumulative repeat purchase rate (the share of each cohort that has placed a second order by month n):
Rows show how one cohort matures. January climbs from 9% to 22% in three months.
Columns compare cohorts at the same age. Month 1 falls from 9% to 6% just as March brought in the most new customers. That is the classic sign that scaling acquisition is diluting customer quality, and it usually stretches each cohort's CAC payback period.
Diagonals show calendar effects. A sale in April would lift January's month 3, February's month 2 and March's month 1 at the same time. Don't mistake a promotion for a retention improvement.
When the columns show newer cohorts falling behind while customer count climbs, the question is how much weaker each new cohort is than the base it joins. Customer equity dilution shows how to put a number on it and what to do with each cohort.
How to calculate cohort retention rate
Cohort retention rate (month n) = customers in the cohort who placed another order by month n ÷ total customers in the cohort × 100
Worked example: January acquired 1,200 first-time customers. By the end of month 3, 264 of them had ordered again. 264 ÷ 1,200 = 22%. Some reports use a non-cumulative version (the share who ordered in month n). Both are valid, but don't compare one against the other. The cumulative version is the same metric as repeat purchase rate, just measured per cohort and per time window. |
Why is cohort analysis so important for customer retention?

Overall, early detection of discrepancies in customer behavior is important for your brand because it allows you to be proactive in addressing potential issues, rather than reactive. By identifying and addressing potential issues early on, your brand can prevent churn, reduce the number of one time buyers and improve your overall customer retention rate.
For example:
if you notices that a particular customer cohort is beginning to make fewer purchases or has a higher number of customer service interactions, you can take action to address the underlying issues before the customers decide to stop doing business your brand.
if your brand notices that a particular customer cohort is increasingly interested in a new product category, you can take steps to capitalize on that trend by developing new products or features to meet that demand.
– Shopify customer cohorts don't provide all the filters and granularity you need out of the box.
| Part 2 · Do it yourself |
How to work with customer cohorts in Shopify

It's worth noting that the process of creating a cohort analysis may vary depending on the tool or software you are using. The most important thing is to have a clear understanding of what you want to achieve and how the customer data can help you achieve it.
Step1: Define the cohorts
The first step is to define each group of customers that you want to analyze. This can be based on a variety of factors, such as purchase date, product category or demographic data.This can be easily done in RetentionX using the integrated customer segment tool.

One of the most important use cases for cohort analysis is to check if customer quality suffers from marketing scaling. Often brands make assumptions based on the behavior of their oldest cohorts. However, our numbers have shown that the oldest cohorts perform on average 200% better, as they consist mainly of loyal customers from friends and family and early adopters. It is important to understand early on whether the customer behavior of customers acquired through marketing is not significantly different.
Examples for interesting customer segments to analyze would be:
Time cohorts: Analyze how your customer behavior has changed over time and whether your measures to improve customer retention are successful. To do this, group customers by the month of their first purchase.
Product cohorts: Customers who buy certain products on their first purchase (SKU of first purchase). This metric is often also referred to as product LTV, as it indicates the quality of customers who buy a particular product on their first purchase.
Coupon cohorts: Customers redeeming certain coupons with their purchase.
Subscription cohorts: for subscription commerce brands – subscribers vs. non-subscribers
Demographic cohorts: segmentation of customers by city, age and other demographic characteristics, often generated via customer surveys.
Marketing cohorts: Customers acquired through specific marketing channels (influencers, social ads, …)
Adding 'predicted spend tier' as a criterion for segmenting customers can significantly enhance targeting efforts by identifying high-value customers for more focused marketing strategies.
Step 2: Building a cohort analysis report
You can look at cohorts and identify your most loyal customers according to different criteria depending on your goal:
Cohorts by Average
Cohorts on average show how an average customer from a cohort behaved after a certain period of time (e.g. customer lifetime value per customer).

This example is about the average Customer Lifetime Value of a customer acquired in a specific month. Customers acquired in February 2022 have a higher lifetime value (net sales excl. taxes - discounts - shipping - cost of goods) than customers acquired in March or April. Looking at cohorts in this way gives you a good indicator of how the average quality of your customer base is evolving over time.
To fill a cohort table like this with a margin-based number rather than revenue, calculate LTV per customer over a fixed window first. How to calculate customer lifetime value in Shopify walks through the formula and a worked LTV365 example.
Cohorts by Total
Cohort analysis by total shows you how much gross sales & net sales were generated by a particular customer group.

Monthly Cohort by Retention Rate
Customer cohorts by retention rate show how many of the customers acquired in a given month placed a second order within a given time period.

In this example, 21.82% of February 2022 customers placed a second order within 2 months. This analysis is particularly important to understand how quickly a second order is completed and how likely a particular customer group is to complete the next order based on the performance of previous cohorts.
Cohorts by Repeat Purchase Rate
Cohort by repurchase rate shows the percentage of customers in a given group who complete a subsequent order.

In February 2022, 44.43% of customers have placed a second order. 18.37% have already placed a fourth order. This analysis shows the performance of the cohort for each subsequent order, regardless of the time between orders.
For the formula, a worked example and why Shopify's returning customer rate is not the same thing, see the guide to repeat purchase rate.
Other potential cohort analysis tables may include:
AOV (Average Order Value) by Cohort
Cohorts by Sales Channels
Product Return Rate by Cohort
RetentionX offers all these analyses out-of-the-box without any manual effort.
Step 3: How to recognize early warning signs of churn
Decrease in purchase frequency: A decrease in the number of purchases made by a customer over time can indicate that they are losing interest in your products or services.
Low lifetime value: A low lifetime value, calculated as the total revenue generated by a customer over their lifetime, can indicate that they are not as engaged with your brand as other customers.
High customer service interactions: A high number of customer service interactions can indicate that a customer is experiencing problems or dissatisfaction with your products or services.
Decrease in purchase value: A decrease in the average purchase value made by a customer over time can indicate that they are becoming less engaged with your brand or that they are experiencing financial difficulties.
Inactivity: Customers who have not made a purchase or interacted with your brand in a long time are at risk of churning.
Step 4: Take action

Based on the results of the analysis, you can take action to improve the customer experience and customer lifetime value, such as creating targeted marketing campaigns, developing new products, or optimizing pricing and promotions. For this, create a segment of customers you want to reactivate and synchronize it to audiences in your favorite marketing & CRM tools:

The same view works for one big acquisition weekend: tag everyone whose first order fell between Black Friday and Cyber Monday and track that cohort separately, as in how to keep BFCM customers.
Reengage customers with targeted a marketing strategy: Reach out to customers who have exhibited early signs of churn risk and offer them incentives to continue doing business with your brand.
Address customer issues: Address any issues that may be causing dissatisfaction, such as poor customer service or product defects.
Personalize the customer experience: Personalize the customer experience by providing tailored recommendations and offers to retain customers longer and increase customer lifetime value.
Monitor and track customer behavior over time: Continuously monitor and track customer behavior over time to identify any changes in behavior that may indicate an increased risk of churn.
What the built-in Shopify cohorts analysis report is missing
Shopify's internal cohort reporting can be found under Analytics > Reports > Customer Cohort Analysis. While Shopify also offers cohort analysis itself, it is unfortunately very limited. Only simple filter conditions are possible for customer segmentation, which cannot be linked with each other. There is also no way to take action on these cohorts and findings.

Unfortunately, the very rigid setting options do not allow detailed evaluation of customer behavior. This is where the use of RetentionX comes into play.
Shopify cohort analysis: step by step
|
Finding cohort patterns on your own
It's also important to keep in mind that interpreting cohort data is an iterative process. As you gain more insights and take action by adapting your marketing strategy, it's important to continue to track and analyze customer behavior to ensure that the actions you're taking are having the desired effect.
Here are a few key steps to take when interpreting cohort data:
Identify key metrics: Identify the metrics that are important for your business, such as customer retention rate, purchase frequency, and purchase value. These metrics can provide important insights into customer behavior and should be analyzed for each cohort.
Look for patterns and trends: Analyze the data to identify patterns and trends that can inform business decisions. For example, you might notice that a particular customer cohort has a higher lifetime value than others, or that a different cohort is at a higher risk of churn.
Compare cohorts: Compare the different cohorts to identify similarities and differences in customer behavior. This can help you understand which cohorts are most valuable to your business and which are at the highest risk of churning.
Look for outliers: Identify any customers or groups of customers that have particularly high or low values for key metrics. These outliers can provide valuable insights into customer behavior and can help you identify potential areas for improvement.
Identify cause and effect: Identify any potential cause and effect relationships between different metrics. For example, if you notice that customers who have a high purchase frequency also have a high lifetime value, you can assume that the high purchase frequency is the cause of the high lifetime value.
Common customer cohort analysis mistakes
What is a good cohort retention rate?
There is no single ecommerce benchmark. Second-order rates depend heavily on category and price point. Replenishable products (supplements, coffee, pet food, skincare) usually retain far better than apparel, furniture or gifts. Treat published averages as directional at best. The benchmark that matters is your own history: is each new cohort at least as good as the last at the same age? From there, the LTV playbook covers how to turn cohort curves into lifetime value, and RFM analysis shows how to segment the customers inside each cohort.
Why you should use RetentionX
In conclusion, while Shopify's built-in cohort analysis capabilities serve as a starting point for businesses, the platform's limitations become apparent when compared to the deeper, more nuanced analysis offered by RetentionX.
Key Takeaways
Shopify Cohort Analysis is an effective tool for grouping customers and tracking their behavior over time. It helps businesses identify valuable customers, optimize marketing campaigns, personalize customer experience, and gain insights to inform business decisions.Alternatives such as RetentionX & Peel Insights offer enhanced cohort analysis capabilities with advanced metrics to maximize customer engagement & increase revenue.
Frequently Asked Questions
|