Most Shopify store owners check their daily revenue, maybe glance at conversion rates, and move on. They miss the most powerful analytical lens available to e-commerce businesses: cohort analysis.
Cohort analysis groups customers by when they first purchased (or by another shared characteristic) and tracks their behavior over time. It answers questions that aggregate metrics cannot: Are the customers you acquired last quarter more valuable than the ones from the quarter before? Is your retention improving or declining? Which acquisition channels bring back repeat buyers versus one-time purchasers?
This guide teaches you to build, read, and act on cohort analysis for your Shopify store.
What Is Cohort Analysis and Why Should You Care?
A cohort is a group of customers who share a common characteristic within a defined time period. The most common type is an acquisition cohort—customers grouped by the month (or week) they made their first purchase.
Here is why this matters more than looking at aggregate numbers:
Your overall repeat purchase rate might be 22%. That sounds stable. But cohort analysis might reveal that customers acquired in January have a 30% repeat rate while customers acquired in June have only 14%. Without cohort analysis, the 22% average masks a serious retention problem that started mid-year—possibly from a traffic source change, product quality issue, or audience shift.
Cohort analysis turns a single misleading number into an actionable trend.
How Do You Build a Basic Cohort Retention Table?
Step 1: Export Your Order Data
In Shopify admin, go to Orders > Export. Select all orders for the time period you want to analyze (at least 12 months). Export as CSV. The key fields you need are:
- Customer email (unique identifier)
- Order date
- Order total
- Order number (to identify first vs. repeat orders)
Step 2: Identify First Purchase Month
For each customer, find their earliest order date. This is their acquisition month. In a spreadsheet, create a column called "Cohort" with the format YYYY-MM (e.g., 2025-07 for customers who first purchased in July 2025).
Step 3: Calculate Months Since Acquisition
For each subsequent order, calculate how many months after their first purchase it occurred. Month 0 is the acquisition month, Month 1 is the following month, and so on.
Step 4: Build the Retention Table
Count how many customers from each cohort made a purchase in each subsequent month. Divide by the total cohort size to get the retention percentage.
Here is what a sample cohort retention table looks like:
| Cohort | Size | Month 0 | Month 1 | Month 2 | Month 3 | Month 6 | Month 12 |
|---|---|---|---|---|---|---|---|
| 2025-07 | 450 | 100% | 12% | 8% | 7% | 15% | 11% |
| 2025-08 | 520 | 100% | 14% | 9% | 8% | 16% | 10% |
| 2025-09 | 480 | 100% | 11% | 7% | 6% | 12% | — |
| 2025-10 | 610 | 100% | 15% | 10% | 9% | — | — |
| 2025-11 | 890 | 100% | 9% | 6% | — | — | — |
| 2025-12 | 1,100 | 100% | 8% | — | — | — | — |
Reading This Table
Several patterns jump out immediately:
November and December cohorts are large but less loyal. The 890 and 1,100 customer cohorts (holiday shoppers) have Month 1 retention of only 8-9%, compared to 12-15% for other months. These customers came for holiday deals and are unlikely to return without specific retention campaigns.
October's cohort shows unusually high retention. At 15% Month 1 retention, something went right—perhaps a product launch, a better ad audience, or improved post-purchase emails. Investigate what changed and replicate it.
Month 6 spikes in the July and August cohorts suggest seasonal repurchasing behavior. If you sell consumable products, this could indicate a natural reorder cycle.
How Do You Calculate LTV by Cohort?
Customer lifetime value (LTV) by cohort is even more revealing than retention rates. Instead of counting whether customers returned, you measure how much total revenue each cohort generates over time.
Building a Revenue Cohort Table
Use the same export data but sum the order values instead of counting orders:
| Cohort | Customers | Avg First Order | Cumulative Revenue per Customer |
|---|---|---|---|
| Month 3 / Month 6 / Month 12 | |||
| 2025-07 | 450 | $68 | $82 / $98 / $118 |
| 2025-08 | 520 | $72 | $88 / $105 / $124 |
| 2025-09 | 480 | $65 | $76 / $88 / — |
| 2025-10 | 610 | $74 | $92 / — / — |
| 2025-11 | 890 | $55 | $60 / — / — |
| 2025-12 | 1,100 | $48 | — / — / — |
Key Insights from Revenue Cohorts
Holiday cohorts have lower first order values. The November ($55) and December ($48) averages are significantly below the $65-74 range of other months. These customers buy discounted products and have lower average order values even when they return.
October's cohort is the most valuable. A $74 first order that grows to $92 by Month 3 represents the highest revenue trajectory. This cohort likely came from a specific campaign or product launch worth replicating.
Revenue compounds in a predictable curve. For non-holiday cohorts, customers generate roughly 1.5-1.7x their first order value within 12 months. This multiplier is your LTV-to-AOV ratio and directly informs how much you can spend to acquire a customer.
How Do You Segment Cohorts by Acquisition Channel?
Basic time-based cohorts are powerful, but channel-based cohorts unlock your most actionable insights. When you know that customers from Google Shopping have a 12-month LTV of $140 while Facebook ad customers have an LTV of $95, you can set acquisition cost targets accordingly.
Building Channel Cohorts
- Export orders with UTM parameters or use GA4's acquisition data
- Tag each customer's first order with its traffic source
- Build separate retention and revenue tables for each channel
Common channel segments to analyze:
- Google Shopping / Google Ads
- Meta (Facebook/Instagram) Ads
- Organic search
- Email marketing
- Direct / brand search
- Influencer / affiliate referrals
What to Look For
High-AOV but low-retention channels (common with Google Shopping) suggest customers find exactly what they searched for but have no brand loyalty. They need aggressive post-purchase retention campaigns.
Low-AOV but high-retention channels (common with social media) suggest customers discover your brand and form a connection, but start with smaller test purchases. Patient nurturing builds these into your most valuable customers over time.
Channels with flat retention curves (no Month 6 or Month 12 improvement) indicate fundamental product-market fit issues for that audience segment, not just a marketing problem.
How Do Seasonal Patterns Affect Cohort Analysis?
Seasonality creates two types of distortion in cohort data:
Cohort Size Distortion
Holiday months produce larger cohorts of lower-quality customers. A store that acquires 1,100 customers in December versus 450 in July will see its overall metrics heavily weighted toward holiday shoppers—masking the fact that non-holiday customers are actually more valuable.
Solution: Always compare cohorts of similar seasons year-over-year (December 2025 vs. December 2024) rather than sequential months.
Retention Timing Distortion
A customer acquired in October who repurchases in December might be buying holiday gifts, not demonstrating genuine product loyalty. The "Month 2 retention" spike for October cohorts could be seasonal, not behavioral.
Solution: Look at retention at the 6-month and 12-month marks rather than drawing conclusions from the first 1-3 months. True retention patterns emerge after seasonal noise settles.
What Tools Make Cohort Analysis Easier on Shopify?
While spreadsheets work for basic analysis, dedicated tools save significant time:
Lifetimely ($49-149/month): Built specifically for Shopify cohort analysis. Automatically calculates LTV by cohort, channel, product, and custom segments. Excellent for stores under $5M in annual revenue.
RetentionX ($99-299/month): Advanced cohort analytics with predictive modeling. Forecasts future LTV based on early cohort behavior patterns.
Polar Analytics ($100-400/month): Multi-channel analytics platform with built-in cohort reporting. Combines data from Shopify, Meta, Google, and Klaviyo in one dashboard.
Google Sheets + Shopify CSV Exports (Free): Completely functional for stores willing to spend 2-3 hours per month on manual analysis. Use pivot tables to build retention matrices.
Actionable Next Steps
- Today: Export your last 12 months of order data from Shopify as a CSV file
- This week: Build a basic monthly acquisition cohort retention table in a spreadsheet—even a rough version reveals patterns you have never seen
- Within 14 days: Calculate cumulative revenue per customer by cohort to understand your true LTV curve, not just a single average number
- Within 30 days: Segment your top 3 acquisition channels into separate cohort tables and compare retention rates and LTV
- Within 60 days: Identify your highest-LTV cohort and reverse-engineer what made those customers different—acquisition source, first product purchased, or seasonal timing
- Quarterly: Update your cohort tables and track whether retention trends are improving or declining over time
Cohort analysis is not a one-time exercise. The stores that update and review cohort data monthly build a compounding understanding of their customer base that translates directly into smarter acquisition spending, better retention programs, and higher lifetime revenue per customer.