From the conversion glossary
Concepts referenced in this article, defined.
Cohort Analysis for Ecommerce Brands
Start lifting conversions today.
Run rigorous A/B tests and personalize every visit on Shopify or any storefront — no engineers required.
Concepts referenced in this article, defined.
Run rigorous A/B tests and personalize every visit on Shopify or any storefront — no engineers required.
Cohort analysis groups customers by when they first bought from you, then tracks what they do next. It answers the question most ecommerce dashboards ignore: are the customers you acquired last quarter actually coming back? Without cohort analysis, you can grow revenue while losing the business—new customers masking high churn. With it, you can spot retention problems in month two before they compound into a crisis.
A basic acquisition cohort report looks like this:
| Cohort (First Purchase Month) | Month 0 | Month 1 | Month 2 | Month 3 |
|---|---|---|---|---|
| October (Diwali) | 100% | 22% | 14% | 10% |
| November | 100% | 18% | 11% | 8% |
| December | 100% | 20% | 13% | — |
Each row is a group of customers who first bought in that month. Each column shows what percentage came back in subsequent months.
This immediately reveals:
Without this view, your overall repeat purchase rate might look stable while individual cohorts are deteriorating.
Indian D2C brands face two compounding challenges: high customer acquisition costs on Meta/Google, and COD (cash on delivery) return rates that inflate first-order counts. Cohort analysis cuts through both.
Problem 1: Festive-season cohorts inflate your metrics. Brands acquire thousands of customers during Diwali, Big Billion Days equivalents, and Republic Day sales. These customers often buy because of discounts, not brand affinity. Their retention is typically 30–40% lower than regular-month cohorts. If you blend them into your overall retention number, your metrics look better than they are.
Problem 2: CAC is rising but LTV isn't. Meta CPMs increased 40%+ over 2023–2024 for many D2C categories. If your customer acquisition cost is going up but your cohort retention is flat, you have a profitability problem that revenue growth alone won't fix.
Cohort analysis makes both problems visible before they become irreversible.
GA4's cohort tool shows behavior retention (users who return to the site), not necessarily purchase retention. It's a leading indicator, not revenue truth.
Shopify's built-in analytics (under Analytics → Reports → Customers over time) shows:
For deeper cohort analysis, export customer data and build a pivot table in Google Sheets. Column A: Customer ID. Column B: First order date. Column C: All subsequent order dates. Group by first order month and count returns.
If you're using Snowflake, BigQuery, or a similar data warehouse:
WITH first_orders AS (
SELECT customer_id, MIN(order_date) AS first_order_month
FROM orders
GROUP BY customer_id
),
cohort_data AS (
SELECT
f.first_order_month,
DATE_DIFF(o.order_date, f.first_order_month, MONTH) AS months_since_first,
COUNT(DISTINCT o.customer_id) AS customers
FROM orders o
JOIN first_orders f ON o.customer_id = f.customer_id
GROUP BY 1, 2
)
SELECT * FROM cohort_data ORDER BY first_order_month, months_since_firstThis gives you raw cohort data you can pivot into a retention grid.
Sharp drop-off at Month 1: If only 5–10% of customers return after the first purchase, your post-purchase experience is broken. Check: order confirmation emails, delivery experience, product quality issues, and whether you're sending any retention communication at all.
Good Month 1, collapse at Month 3: You're doing the basics right but not building a habit. This often means your product isn't naturally replenishable (fashion vs. nutrition) or you're not creating reasons to return. Consider subscription nudges, loyalty points, or personalized reorder reminders.
Festive cohorts underperform regular cohorts: Your discounting strategy is attracting price-sensitive customers who don't have real brand affinity. Test acquiring fewer, higher-quality customers during festive periods by tightening targeting rather than maximizing volume.
Recent cohorts performing worse: A deterioration trend in the last 2–3 cohorts is a red flag. Something changed—product quality, delivery times, customer service, or competition. Dig into reviews and NPS scores for those cohorts.
Acquisition-based cohorts are the starting point. Behavioral cohorts are more powerful.
High-value behavioral cohorts:
Mamaearth-style brands often find that customers acquired via brand content (YouTube tutorials, blog content) have 2–3x higher LTV than those acquired via direct-response ads. Cohort analysis proves or disproves this hypothesis for your specific brand.
Data without action is just wallpaper. Here's how to turn cohort insights into revenue:
If Month 1 retention is low: Launch a 3-email post-purchase sequence. Email 1: Usage tips (Day 3). Email 2: Reorder reminder with social proof (Day 20). Email 3: Discount to trigger second purchase (Day 35). Browse abandonment emails and post-purchase flows work together here.
If festive cohorts churn fast: Don't offer deep discounts to festive buyers again. Instead, send them content that builds brand affinity—ingredient stories for D2C wellness brands, styling guides for fashion, usage tutorials for beauty. Convert the discount buyer into a brand loyalist.
If retention is strong but spend isn't growing: Focus on Average Order Value (AOV), not just repeat rate. Customers who return are receptive—this is when to show bundle recommendations, subscriptions, or premium variants.
Personalize the returning experience: Use a tool like CustomFit.ai to show returning visitors different homepage content than first-time visitors. Highlight loyalty benefits, remind them of past purchases, and show complementary products. This kind of on-site personalization consistently lifts repeat purchase revenue. Bellavita saw 11% conversion lift using CustomFit.ai by personalizing experiences based on visitor behavior.
See how personalization improves retention →