Cohort Analysis 101: How to Read a Retention Table

A retention cohort table groups customers by a shared starting event, such as a first order. Each column shows activity at the same time since that event. Start by reading one row, then compare the same column across rows.
Read a cohort table in three steps
A January cohort has 100 first-time buyers, and 25 buy again within 60 days. A February cohort has 80 first-time buyers, and 24 buy again within 60 days. Their 60-day rates are 25% and 30%. Wait for both cohorts to reach day 60 before comparing them.
What Is Cohort Analysis?
Cohort analysis is a method of grouping customers who share a common characteristic and tracking their behavior over time.
A cohort is simply a group of people with something in common.
In ecommerce, a cohort can include:
- Customers who made their first purchase in January
- Customers who came from Google Ads
- Customers who bought a specific product
- Customers who started a subscription
For example, a Shopify store can create a January customer cohort and track how many of those customers purchase again in February, March, and April.
A simple definition:
Cohort analysis helps businesses understand how different customer groups behave after a specific event.
Why Is Cohort Analysis Important?
Traditional reports show totals.
Cohort analysis shows patterns.
A sales report may tell you that your store made $50,000 last month.
A cohort report can tell you:
- Which customers created that revenue
- When they purchased again
- Which channel brought them
- How valuable they became over time
This helps Shopify merchants:
- Improve customer retention
- Reduce wasted marketing spend
- Increase customer lifetime value
- Create better customer experiences
- Make smarter growth decisions
How Does Cohort Analysis Work?
Cohort analysis follows a simple process.
Step 1: Choose a Cohort
First, decide how you want to group customers.
Common cohort types include:
- First purchase date
- Marketing channel
- Product purchased
- Customer location
- Subscription date
The best cohort depends on the question you want to answer.
Step 2: Select a Time Period
Next, choose how long you want to track customer behavior.
Common time periods include:
- 30 days
- 60 days
- 90 days
- Six months
- One year
A subscription business may track customers for a year.
A fashion store may focus on shorter buying cycles.
Step 3: Choose Your Metrics
The next step is deciding what you want to measure.
Common cohort analysis metrics include:
| Metric | What It Shows |
|---|---|
| Retention Rate | How many customers continue buying |
| Repeat Purchase Rate | How often customers return |
| Customer Lifetime Value | Long-term customer value |
| Average Order Value | Customer spending per order |
| Revenue Per Customer | Customer contribution |
Step 4: Compare Customer Groups
After collecting data, compare different cohorts.
For example:
- January customers vs February customers
- Email customers vs paid ad customers
- Bundle buyers vs single-product buyers
The goal is to find patterns that improve business decisions.
Types of Cohort Analysis
There are several ways Shopify merchants can create customer cohorts.
Customer Acquisition Cohorts
Acquisition cohorts group customers based on when or where they became customers.
Examples:
- Customers acquired in January
- Customers from Meta Ads
- Customers from Google Search
- Customers from influencer campaigns
This helps merchants understand which channels bring valuable customers.
A channel that brings cheaper customers may not always create better results.
Retention Cohorts
Retention cohorts measure how many customers continue buying after their first purchase.
Example:
| Customer Cohort | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| January Buyers | 100% | 45% | 30% |
| February Buyers | 100% | 50% | 35% |
This data shows whether customer loyalty improves or declines.
If customers stop buying after 60 days, merchants can create campaigns to bring them back.
Product Cohorts
Product cohorts group customers based on their first purchase.
Example:
A skincare brand compares:
- Customers who bought starter kits
- Customers who bought single products
- Customers who bought premium products
The merchant may discover that starter kit buyers return more often.
This can help improve:
- Product bundles
- Upsells
- Marketing messages
Revenue Cohorts
Revenue cohorts focus on customer spending over time.
They help merchants understand which customer groups create the most value.
Example:
| Cohort | Month 1 Revenue | Month 6 Revenue |
|---|---|---|
| January Customers | $20,000 | $60,000 |
| February Customers | $25,000 | $85,000 |
The February cohort creates stronger long-term revenue.
Cohort Analysis Example for Shopify Stores
Imagine a Shopify clothing store wants to understand whether customers from different channels have different buying habits.
The store creates three customer cohorts.
| Customer Source | New Customers | 90-Day Repeat Purchase Rate |
|---|---|---|
| Meta Ads | 800 | 22% |
| Google Ads | 500 | 35% |
| Referral Program | 300 | 45% |
The store learns that referral customers buy again more often.
Although referrals bring fewer customers, they create stronger customer relationships.
The merchant can invest more effort into referral programs.
Cohort Analysis vs Regular Analytics
Regular analytics and cohort analysis answer different questions.
| Analytics Type | Main Question |
|---|---|
| Sales Report | How much did we sell? |
| Traffic Report | How many visitors came? |
| Conversion Report | How many visitors purchased? |
| Cohort Analysis | Which customers create long-term value? |
Regular reports explain business performance.
Cohort analysis explains customer behavior.
How Shopify Merchants Use Cohort Analysis
Improve Customer Retention
Retention is one of the biggest benefits of cohort analysis.
Merchants can find:
- When customers stop buying
- Which customers return
- Which groups need better engagement
For example, if most customers disappear after 90 days, the store can create a win-back campaign before that point.
Improve Marketing Decisions
Cohort analysis helps merchants look beyond first purchases.
A campaign may bring many customers but low repeat purchases.
Another campaign may bring fewer customers but higher lifetime value.
The second campaign may create better long-term growth.
Improve Product Decisions
Product cohorts show which items create loyal customers.
A store can discover:
- Which products lead to repeat purchases
- Which products create larger baskets
- Which products attract one-time buyers
This information improves product planning.
Increase Customer Lifetime Value
Customer lifetime value shows how much revenue a customer creates over time.
Cohort analysis helps merchants understand which customer groups have higher lifetime value.
This helps answer:
“How much should we spend to acquire a customer?”
How to Create Your First Cohort Analysis
Starting with cohort analysis does not need to be complicated.
Follow these steps.
1. Choose a Business Question
Start with a problem.
Examples:
- Why are repeat purchases decreasing?
- Which channel creates better customers?
- Which products create loyal buyers?
2. Select Your Cohort
Choose how customers should be grouped.
Examples:
- First purchase month
- Acquisition channel
- Product category
3. Pick Your Metrics
Choose metrics connected to your goal.
Examples:
- Retention rate
- Revenue
- Repeat orders
- Customer lifetime value
4. Analyze the Results
Look for patterns.
Ask:
- Which groups perform better?
- When do customers stop buying?
- What changed between strong and weak cohorts?
5. Take Action
Use the insights to improve:
- Marketing campaigns
- Customer experience
- Product offers
- Retention strategies
Common Cohort Analysis Mistakes
Looking Only at Revenue
Revenue does not show customer quality.
A customer group with lower first-month sales may create more value later.
Creating Too Many Cohorts
Too many groups can make reports confusing.
Start with simple cohorts connected to clear business goals.
Ignoring Retention
The biggest value of cohort analysis comes from understanding customer behavior over time.
Do not focus only on first purchases.
Not Acting on Insights
Data is useful only when it changes decisions.
Every analysis should lead to an action.
A Simple 90-Day Cohort Analysis Plan
First 30 Days
Focus on:
- Create your first customer cohorts
- Track repeat purchases
- Review customer behavior
Days 31 to 60
Focus on:
- Compare marketing channels
- Analyze product performance
- Improve retention campaigns
Days 61 to 90
Focus on:
- Scale successful strategies
- Improve customer lifetime value
- Build better customer experiences
Frequently Asked Questions
What is cohort analysis?
Cohort analysis is a method of grouping customers with shared characteristics and tracking their behavior over time.
Why is cohort analysis useful?
Cohort analysis helps businesses understand retention, customer value, and the reasons behind growth patterns.
What are examples of cohorts?
Examples include customers who purchased in the same month, customers from the same marketing channel, or customers who bought the same product.
How do Shopify stores use cohort analysis?
Shopify stores use cohort analysis to improve retention, compare marketing channels, understand customer behavior, and increase customer lifetime value.
What metrics should businesses track in cohort analysis?
Common metrics include retention rate, repeat purchase rate, average order value, revenue per customer, and customer lifetime value.
Final Thoughts
Cohort analysis gives Shopify merchants a clearer view of customer behavior.
Instead of looking only at sales totals, merchants can understand which customers return, which channels create valuable buyers, and which products support long-term growth.
For growing ecommerce brands, cohort analysis is not just a reporting method. It is a way to make better decisions using real customer data.











