Where can you see repeat purchase rate over time?
You can usually start in four places: your ecommerce platform, your CRM, an ecommerce analytics dashboard, or an order-based reporting layer like SignalOps. But the most useful repeat purchase rate over time view is usually a cohort report built from order data, because it shows not just whether customers came back, but which customers came back, when they came back, and what they bought first.
If the question is, “Where can I generate a report showing customers who placed more than one order and compare repeat customer performance over time?” the direct answer is: use a report that groups customers by their first order date, then checks whether each customer placed another order within a defined window such as 30, 60, 90, 180, or 365 days.
A simple dashboard metric can tell you that repeat purchase rate moved. It usually will not explain why it moved. For that, you need cuts by cohort, first product, acquisition source, reorder window, discount behavior, refunds, and subscription status.
Operator answer: If you only need the number, check your ecommerce or CRM analytics dashboard. If you need to diagnose retention leaks, build a cohort repeat purchase report from order data and break it down by first order month, first product purchased, acquisition source, and reorder timing.
Repeat purchase rate is the share of customers in a defined group who place another order during a defined measurement window. For example, you might measure the percentage of customers who placed their first order in January and then placed a second order within 180 days.
Do not confuse it with adjacent metrics. Customer-level repeat purchase rate measures customers who bought again. Order-level repeat order share measures how many orders came from returning customers. Retention rate often tracks whether a customer remains active across a period. Reorder rate is usually tied to whether customers repurchase a replenishable product within an expected buying cycle. These are related, but they answer different operating questions.
Why the blended repeat purchase rate is not enough
A blended repeat purchase rate is useful as an alarm. It is weak as a diagnostic tool.
Before diagnosis, the operator sees one number: repeat purchase rate is down. After diagnosis, the operator knows whether the drop came from weaker new customer cohorts, a poor first-product experience, a channel mix shift, longer reorder timing, stockouts, discount-led acquisition, subscription changes, or lifecycle gaps.
The issue is that repeat purchase behavior is not evenly distributed across your business. One acquisition source may bring customers who buy once and disappear. One first product may create strong second-order behavior. One SKU may sell well but generate refunds and support tickets. One lifecycle flow may be timed too early for the actual reorder cycle.
| Report type | What it shows | Where it falls short |
|---|---|---|
| Blended dashboard | Overall repeat purchase rate for a selected period | Does not explain which customers, products, or sources changed |
| Cohort report | Repeat rate by first order month or quarter | Needs enough time for cohorts to mature |
| Product-entry report | Repeat behavior by the first product purchased | Requires clean product and SKU history |
| Source report | Repeat rate by channel, campaign, or acquisition source | Depends on attribution and source-data quality |
| Reorder-window report | When repeat orders happen after first purchase | Needs customer-level order sequencing |
The best repeat purchase report does not stop at the formula. It helps you decide whether to fix acquisition, merchandising, lifecycle timing, product education, replenishment, or customer experience.
Minimum data needed to build the report
You do not need a full BI stack to build a first version of a repeat purchase report. You need reliable order-level and customer-level fields. A Shopify, WooCommerce, or commerce-platform order export can often get you started, especially if you can join it with CRM or attribution fields later.
| Field | Why it matters |
|---|---|
| Customer ID or email hash | Groups orders to the same customer without relying only on name or address |
| Order ID | Prevents duplicate counting and supports order-level audits |
| Order date | Creates calendar, cohort, and reorder-window views |
| Order number or order sequence | Identifies first order, second order, third order, and later purchases |
| Gross sales | Shows demand before discounts, refunds, and adjustments |
| Discounts | Reveals whether repeat behavior is being purchased through promotions |
| Refunds | Separates retained customers from profitable retained customers |
| Net revenue | Shows revenue after discounts and refunds |
| Product or SKU | Connects retention behavior to what customers bought |
| Quantity | Helps identify bulk purchases, bundles, and replenishment patterns |
| First product purchased | Shows which entry products create or weaken repeat behavior |
| Acquisition source or campaign | Connects repeat behavior to channel quality and CAC decisions |
| Country or region | Helps diagnose shipping, market, pricing, and fulfillment differences |
| Subscription flag | Separates subscription-driven repeat orders from voluntary repurchase behavior |
The first pass does not have to be perfect. Start with order date, customer ID, order sequence, revenue, product, and source if available. Then improve the report by reconciling refunds, subscription orders, campaign naming, product variants, and customer identity matching.
Data caution: If your CRM, ecommerce platform, ad platform, and analytics tool disagree, do not average the numbers. Pick the source of truth for each question. Order data should usually anchor purchase behavior. CRM data can enrich lifecycle engagement. Attribution data can enrich source quality, but may need reconciliation.
Repeat purchase report map: the views operators need
Instead of one repeat purchase dashboard, build a report map. Each view should answer a different operating question and point to a different decision.
| View | Question it answers | Metric to use | Decision it supports |
|---|---|---|---|
| Repeat purchase rate over calendar time | Is repeat customer performance improving or declining by month, quarter, or year? | Customers with 2+ orders divided by eligible customers in the period | Whether retention needs deeper investigation |
| Cohort repeat purchase rate by first order month | Are newer customers coming back at the same rate as older cohorts? | Percentage of first-time buyers who place another order within a fixed window | Whether retention changed because cohort quality changed |
| First-product repeat purchase rate | Which entry products create the strongest second-order behavior? | Repeat rate by first product or first SKU purchased | Which products to feature, bundle, educate around, or avoid as entry offers |
| Acquisition-source repeat purchase rate | Which channels bring customers who come back? | Repeat rate and second-order revenue by source, campaign, or offer | How to adjust CAC targets, prospecting offers, and budget allocation |
| Reorder-window distribution | When do customers usually place their next order? | Share of second orders placed within 30, 60, 90, 180, and 365 days | When to send replenishment, education, cross-sell, and winback messages |
These views work together. Calendar time shows the symptom. Cohorts show whether newer customers changed. First-product analysis shows whether entry merchandising changed. Source analysis shows whether acquisition quality changed. Reorder-window analysis shows whether customers are still coming back, just later than expected.
Build the repeat purchase view without stitching exports
Want the cohort, first-product, source, and reorder-window cuts without manually joining order exports? Create a SignalOps account and see where repeat purchase rate is leaking across products, cohorts, and lifecycle timing.
Analyze your order exportHow to diagnose why repeat purchase rate changed
When repeat purchase rate moves, do not start by rewriting every lifecycle flow. First isolate where the change happened.
If all cohorts are down
If most cohorts declined at the same time, the cause is probably not just acquisition quality. Look for business-wide changes that affected many customers at once.
- Lifecycle messages paused, delayed, or changed
- Replenishment reminders sent outside the actual reorder window
- Product quality issues or review deterioration
- Fulfillment delays, shipping problems, or stockouts
- Pricing changes that made the second order less attractive
- Customer experience issues that increased support burden
The operating move is to inspect the customer journey after first order: delivery experience, product education, replenishment timing, cross-sell logic, and post-purchase support.
If only new cohorts are down
If older cohorts still repeat normally but recent first-time buyers do not, inspect who you acquired and what they bought first.
- Did acquisition shift toward a lower-intent channel?
- Did a discount-heavy offer bring one-time bargain buyers?
- Did the first purchase mix shift toward a low-retention product?
- Did campaign messaging overpromise the product experience?
- Did CAC targets assume repeat behavior that is no longer happening?
The operating move is to compare new customer cohorts by source, offer, first product, discount level, and second-order rate.
If repeat rate is stable but revenue is down
A stable repeat purchase rate can hide weaker economics. Customers may still come back, but spend less, buy lower-margin items, or refund more often.
- Check second-order AOV versus previous periods
- Compare discount rate on repeat orders
- Inspect refunds by SKU and first product
- Review product mix on second and third orders
- Separate subscription repeat orders from non-subscription behavior
The operating move is to shift from “Did they come back?” to “What did they buy when they came back, and was it profitable?”
If repeat rate is up but profit is down
Higher repeat purchase rate is not automatically good. You can increase repeat behavior through discounting, low-margin bundles, or subscription mechanics that do not improve profit.
- Compare net revenue, not just order count
- Review repeat-order gross margin by product or bundle
- Look for refund-heavy SKUs that drive apparent revenue but poor retention economics
- Inspect whether winback offers are too aggressive
- Check whether free shipping thresholds are improving AOV or compressing margin
The operating move is to pair repeat purchase rate with net revenue, refunds, discount rate, and margin signals before scaling the tactic.
How to compare repeat purchase rate year over year
Year-over-year repeat purchase analysis is useful, but only if the comparison is fair. The wrong method is to divide this year’s total repeat customers by last year’s total customers and treat that as a clean retention trend. That mixes different customer ages, different maturity windows, and different acquisition periods.
The better method is to compare equivalent cohorts over equivalent measurement windows. For example, compare customers whose first order happened from January through June 2025 measured through 180 days against customers whose first order happened from January through June 2026 measured through 180 days, but only if the 2026 cohort has had enough time to reach the full 180-day window.
| Bad comparison | Better comparison | Why it is better |
|---|---|---|
| All repeat customers in 2026 vs all repeat customers in 2025 | January 2026 first-time buyers through 180 days vs January 2025 first-time buyers through 180 days | Controls for customer age and cohort maturity |
| Current-year repeat rate through today vs full prior-year repeat rate | Same date cutoff or same maturity window for both years | Avoids penalizing immature current-year cohorts |
| Total repeat revenue by year | Repeat rate, second-order AOV, refunds, and net revenue by cohort | Separates customer behavior from revenue quality |
| Blended channel repeat rate | Repeat rate by source and first product within each year | Shows whether the mix of customers changed |
Use 30-day and 60-day views for early signal. Use 90-day and 180-day views for stronger lifecycle decisions. Use 365-day views when the category has a long purchase cycle or when annual seasonality matters.
YoY rule: Never compare an immature current-year cohort to a fully mature prior-year cohort. Match the first-order period and the measurement window before deciding whether repeat purchase rate actually improved or declined.
Turn repeat purchase insights into lifecycle actions
A repeat purchase report is only useful if it changes what the team does next. Tie each finding to a specific lifecycle, product, or acquisition action.
| Finding | Likely issue | Operator action |
|---|---|---|
| First-product repeat rate is weak | The entry product does not create a strong second-order path | Improve product education, change entry offers, test bundles, or route customers into a better follow-up sequence |
| Reorder timing slipped from 60 days to 90 days | Lifecycle messages may be too early or customer need has changed | Revise replenishment reminders, delay winback timing, and test education between orders |
| Paid acquisition cohorts repeat less than organic cohorts | Prospecting is bringing lower-intent or discount-dependent buyers | Adjust CAC targets, campaign promises, landing pages, and first-purchase offers |
| A product drives high revenue but low repeat behavior | The product may be good for acquisition but weak for retention | Separate merchandising decisions from retention decisions and build a specific second-order path |
| Repeat rate improved but refunds rose | Customers may be repurchasing products that create dissatisfaction or fit issues | Audit refund-heavy SKUs, support reasons, product pages, and post-purchase education |
| Subscription customers dominate repeat orders | Voluntary repeat behavior may be weaker than the blended metric suggests | Report subscription and non-subscription repeat behavior separately |
If first-product retention is weak, work on merchandising, welcome flows, onboarding content, bundles, and second-order recommendations. If reorder timing slipped, update replenishment windows and winback timing. If paid cohorts repeat less, lower your allowable CAC or change the offer that brings those customers in. If a product sells well but creates poor repeat behavior or high refunds, do not let top-line revenue hide retention damage.
The best repeat purchase report is not the one that only shows the formula. It is the one that points to the next action: which segment to email, which product to reposition, which campaign to constrain, which offer to stop scaling, and which customer experience issue to fix.
Repeat purchase reporting FAQ
How do I measure customers who placed more than one order?
Group orders by customer ID or email hash, sort each customer’s orders by order date, and flag customers with at least a second order. Then divide the number of customers with a second order by the eligible customer group you are measuring.
Should repeat purchase rate be measured by order date or first order date?
Use first order date when you want a cohort view. Use order date when you want a calendar view of how much business came from returning customers during a period. For retention diagnosis, first order date is usually more useful.
What is the best window for repeat purchase rate?
It depends on your buying cycle. Consumables may need 30-, 60-, or 90-day views. Durable goods may need 180- or 365-day views. The important part is to use the same window when comparing cohorts or years.
What is the difference between repeat purchase rate and retention rate?
Repeat purchase rate asks whether customers bought again. Retention rate usually asks whether customers remained active or continued a relationship during a period. In ecommerce, repeat purchase rate is often the more direct purchase-behavior metric, while retention can include broader activity definitions depending on the business.
Should I measure repeat purchase rate by cohort, first product, or acquisition source?
Use all three if possible. Cohorts show when retention changed. First-product cuts show whether the entry purchase affects future buying. Acquisition-source cuts show whether channels and campaigns are bringing customers who come back.
Why does my repeat purchase dashboard not explain what changed?
Most blended dashboards collapse many customer groups into one number. If the number changed, you still need to split it by cohort, product, source, reorder window, discounts, refunds, and subscription status to identify the cause.
What should I do when repeat purchase rate is down?
First determine whether the decline affects all cohorts or only recent cohorts. Then inspect lifecycle timing, product quality, first-product mix, acquisition source, discount dependency, stockouts, fulfillment issues, refunds, and second-order value. Do not change every flow until you know where the leak is.