Offer

3 months of free support on every e-commerce package

See Details
GROWTH

Customer Segmentation with Cohort Analysis: An E-Commerce Guide

How do you segment customers with cohort analysis? A guide to reading retention tables, analysing churn patterns and cohort reporting in GA4.

GROWTH 24 September 2026 6 min read Toserof Tech.
Contents

Customer segmentation with cohort analysis is the most powerful way to examine how customers acquired in the same period behave over time by grouping them. For e-commerce businesses, it shows with concrete data which campaigns bring long-term valuable customers, in which periods customer loss accelerates and how retention changes. In this guide we cover every step of applying cohort analysis from scratch.

What Is a Cohort and Why Does It Matter?

A cohort is a group of customers who share a common characteristic and are defined within the same time frame. In the most common usage, a cohort consists of customers who made their first purchase in a given month. Without cohort analysis you look at the average of all customers, which causes well-performing and poorly performing groups to mask one another. With cohort analysis, you can see what percentage of the customers you acquired in January 2025 are still active in month 3, compared with the May cohort. This comparison lets you separate out the impact of product, campaign or seasonal factors.

Acquisition Cohort vs Behavioural Cohort

Cohort analysis is applied in two basic types. An acquisition cohort groups customers by their first purchase or registration date; it is the most widely used type for e-commerce retention analysis. A behavioural cohort, on the other hand, groups customers by a specific behaviour (those who bought from a particular product category, joined the loyalty programme or used a particular campaign). The two approaches complement each other: an acquisition cohort measures long-term retention, while a behavioural cohort helps you understand the value of specific customer segments.

  • Acquisition Cohort: Customers grouped by month of first purchase; used to track monthly retention rates.
  • Behavioural Cohort: Customers who exhibit a particular behaviour; for example, those who shop a second time within the first 30 days may be the most valuable segment.
  • Revenue Cohort: Grouping by the value of the first order; customers who start with a high AOV generally have a higher long-term LTV.

How Do You Read a Retention Cohort Table?

A retention cohort table shows the cohort groups in the rows (for example Jan 2025, Feb 2025) and the following months in the columns (month 0, month 1, month 2...). Each cell contains the percentage of customers in that cohort who are still active in the given month. Month 0 is always 100% because we count all customers as active in their first month. What matters is the speed of the decline in the following months. Dropping below 30% in month 1 indicates a typical e-commerce churn rate; 40% and above is a sign of strong retention. If the table shows a sudden drop in a particular month, you can infer that churn accelerated because of a product change, price increase or customer service problem in that period.

Churn Pattern Analysis

The churn patterns in a cohort table can be assessed in three basic categories. The first is early churn: the vast majority of customers leave in the first 1-2 months; this is usually because the first purchase experience did not meet expectations. The second is gradual churn: between 5% and 10% of customers leave each month; this is a sustainable loss curve and can be slowed with retention campaigns. The third is sudden churn: a simultaneous drop across all cohorts in a particular month; for the period in which this signal appears, you should investigate any platform-specific problem (a shipping crisis, a payment issue).

Calculating LTV by Cohort

Combining cohort analysis with LTV lets you identify your highest-value customer groups early. For each cohort, you can build the cohort LTV curve by summing cumulative revenue month by month. Dividing the cumulative revenue at month 6 by the initial cohort size gives that cohort's 6-month LTV. Comparing this value across different cohorts shows which acquisition period or channel brings in the most valuable customers. By identifying the common characteristics of cohorts with high LTV (campaign, channel, category of the first product purchased), you can shape your future acquisition strategy.

Cohort Reporting in GA4

Google Analytics 4 offers built-in cohort analysis in the user segmentation and Explore section. In GA4 Explore, create a new exploration, select Cohort exploration as the technique and define the cohort criteria and the retention metric. By default, cohorts are created by user acquisition date; event-based or conversion-based cohorts can also be defined. GA4's cohort tool supports two different metrics for e-commerce businesses: user retention and revenue retention. Revenue retention can be more meaningful than user retention because it better reflects low-volume but high-value customers.

Cohort Analysis with a Spreadsheet

It is possible to run cohort analysis in a spreadsheet (Excel or Google Sheets) without GA4 or a BI tool. For this you need a raw data table in which each row is an order and the columns contain the customer ID, order date and first order date. With the COUNTIFS and MONTH functions you can calculate the number of active customers for each cohort-month combination. You can then use conditional formatting to create a heat map view that visually highlights areas of high and low retention in the table.

Developing a Strategy Based on Segment Characteristics

The findings you obtain from cohort analysis should be translated directly into an action plan. If you have an early churn problem, strengthen your post-purchase onboarding email series and review delivery and product quality. If retention is low in a particular cohort, analyse customer feedback specific to that period. Identify the acquisition channel of cohorts with high LTV and shift budget to that channel. For the most valuable segment, design privileged experiences such as a VIP loyalty programme or early access. The lowest-cost intervention for increasing retention is usually email and SMS automation; reaching customers with the right message at the right time slows churn meaningfully.

Frequently Asked Questions

How much data is needed to run a cohort analysis?

For a meaningful cohort analysis, at least 6-12 months of sales data and at least 50-100 customers per cohort are recommended. Cohort analysis based on fewer customers does not give statistically reliable results; small sample sizes are highly sensitive to random fluctuations. Businesses at an early stage can start with a simple segment-based RFM analysis instead of cohorts.

What should my retention rate be?

In the e-commerce sector, a retention rate of between 25% and 30% at month 3 is regarded as the industry average. 40% and above is strong performance. For subscription models or frequently purchased consumer goods (food, personal care), this rate can be much higher; you need to compare by category.

How often should cohort analysis be carried out?

Monthly cohort tracking is sufficient for strategic decision-making. At the end of each month, add the new cohort row to the table and update the current retention values for all cohorts. Examining a cohort specifically 30, 60 and 90 days after major campaigns or product launches is valuable for measuring the campaign's long-term impact.

Which tools should I use for cohort analysis?

For getting started, Google Sheets or Excel is sufficient; the learning curve is low. For mid-sized businesses, GA4 Cohort Exploration or Mixpanel offers a user-friendly interface. For large data volumes and customised analyses, Python (pandas, the lifetimes library) or SQL-based cohort queries provide the most flexible solution.

Conclusion

Customer segmentation with cohort analysis is the most effective way for e-commerce businesses to understand their retention problems, valuable customer profiles and churn patterns on the basis of data. When applied correctly, it lets you direct your marketing budget to the most profitable segments and prevent churn proactively. Get in touch with Toserof Tech. for analytics and growth consulting.

Share