Understand which customer cohorts are most valuable. Learn cohort analysis: slice your data by acquisition date, channel, or segment to spot retention trends and identify your best audiences.
StoreWiz Team
Jan 8, 2026 · 12 min read
TL;DR
Cohort analysis groups customers by when they first purchased and tracks their behavior over time. It reveals retention trends, CLV patterns, and which acquisition channels bring the best long-term customers. A typical ecommerce store retains 25–35% of customers to a second purchase. If your month-2 retention is below 15%, you have a retention problem that no amount of acquisition spending can fix. This guide walks through cohort analysis step by step with real examples.
Overall averages lie. A store with a 30% repeat purchase rate might have January customers at 45% and July customers at 15%. Without cohort analysis, you would never know that your summer acquisition campaigns are attracting low-quality buyers, or that a product change in June caused retention to drop.
Cohort analysis is the lens that turns blurry averages into sharp, actionable insights. Here is how to do it.
A cohort is a group of customers who share a common characteristic within a defined time period. The most common cohort is based on first purchase date: all customers who made their first order in January 2026 form the January 2026 cohort.
Cohort analysis tracks how each group behaves over subsequent time periods. You can measure:
You need an order export with these fields for every order in your history:
For each unique customer, find the date of their first order. This determines their cohort assignment. A customer who first purchased on January 15 belongs to the January cohort.
For every order, calculate how many months (or weeks) have elapsed since that customer's first purchase. Their first order is Month 0. An order 45 days later is Month 1. An order 75 days later is Month 2.
Create a table where rows are cohorts (first purchase month) and columns are the time periods (Month 0, Month 1, Month 2, etc.). Each cell contains the percentage of the cohort that made a purchase in that period.
Example Retention Cohort Table
| Cohort | Size | M0 | M1 | M2 | M3 | M4 | M5 |
|---|---|---|---|---|---|---|---|
| Jan 26 | 820 | 100% | 28% | 18% | 14% | 12% | 11% |
| Feb 26 | 745 | 100% | 31% | 20% | 16% | 13% | — |
| Mar 26 | 910 | 100% | 35% | 24% | 17% | — | — |
In this example, the March cohort shows higher retention (35% in M1 vs. 28% for January). This might indicate a product improvement, a better acquisition campaign, or a seasonal effect. Without cohort analysis, this improvement would be invisible in your overall metrics.
Retention curves always start at 100% (Month 0) and decline. The shape of the decline tells you critical information about your business.
| Curve Shape | What It Means | Action Required |
|---|---|---|
| Flattening (levels off at 15–25%) | Healthy — you have a loyal core | Grow the core with loyalty programs and subscriptions |
| Steep drop (below 10% by M2) | Product or experience problem | Fix post-purchase experience, investigate product quality |
| Slow decline (never flattens) | Gradual disengagement | Implement winback campaigns, improve email flows |
| Uptick after dip | Seasonal or campaign-driven repurchase | Lean into the trigger — schedule more campaigns at that cadence |
Group customers by how they found you (Meta Ads, Google, organic, email, referral). This reveals which channels bring customers who stick around vs. one-time buyers. Often, the cheapest acquisition channel has the worst retention.
Group customers by which product they purchased first. Gateway products that lead to high retention and CLV should be promoted heavily in acquisition campaigns. Products that attract one-time buyers should be deprioritized in ads.
Compare the retention of customers acquired with a discount vs. those who paid full price. Many sellers discover that discount-acquired customers have 30–50% lower CLV because they wait for the next sale instead of buying at full price.
Group customers by their first order value (e.g., under $30, $30–$60, $60+). Higher first-order values often correlate with higher retention because the customer has demonstrated stronger purchase intent and commitment.
Cohort analysis is only valuable if it leads to action. Here are the most common findings and what to do about them:
Automation Tip
Manually building cohort tables in spreadsheets is time-consuming and error-prone. StoreWiz auto-generates cohort reports across multiple dimensions (time, channel, product, discount) and flags when retention trends change, with AI explanations of likely causes and recommended actions.
At minimum, you need 6 months of order history with at least 100 customers per monthly cohort. Twelve months is ideal because it captures seasonal patterns. If your monthly cohorts are smaller than 50 customers, use weekly or quarterly cohorts instead to get statistically meaningful groups.
Monthly cohorts work for most ecommerce businesses. Use weekly cohorts if you have high order volume (1,000+ orders per week) and want to detect changes faster, or if you are running frequent campaigns and need to isolate the impact of each one. Weekly cohorts require more data but give faster feedback.
For ecommerce, 25–35% of customers making a second purchase within the first two months is good. Above 35% is excellent (common for consumables and subscriptions). Below 20% indicates a retention problem that should be investigated. Note that purchase frequency varies by category — a supplement brand should have higher Month 1 retention than a furniture store.
Yes, using a spreadsheet. Export your orders, identify each customer's first purchase date, calculate the month offset for each subsequent order, and build a pivot table. It takes 2–3 hours for the initial setup and 30 minutes to update monthly. However, a dedicated analytics tool automates this process, adds visualizations, and can slice by multiple dimensions simultaneously.
Written by StoreWiz Team
Data Analytics
The StoreWiz team writes about ecommerce automation, AI operations, and growth strategies for modern online sellers. Our insights come from building technology that helps brands scale without scaling headcount.
Mar 29, 2026 · 18 min read
Mar 27, 2026 · 20 min read
Mar 25, 2026 · 18 min read
Join 2,000+ ecommerce operators getting weekly insights on autonomous commerce, pricing tactics, and AI growth.
No spam. Unsubscribe anytime.