You are spending more to acquire new customers every quarter. The ad account brings in first orders, but the repeat purchase rate barely moves, and most customers buy once and disappear. This article shows how to find your second-order window in your own order data, which products to lead with, when to send the reminder, and how to report it all monthly.
Key takeaways
-
Repeat purchases start with the second order. For replenishable products it usually happens inside 30 to 90 days, and once that window closes most one-time buyers never return.
-
You can measure your repeat purchase rate and your second-order window from an order export in a spreadsheet. No special tools required.
-
Tactics should be timed and targeted from data: which product to lead with, when to remind customers, who is late. Generic loyalty advice does not move the number.
-
Agencies need the same three figures in every monthly report: repeat purchase rate, median days to second order, and the share of recent first-time buyers who have already come back.
Why your first-time buyers are not coming back
Your ads are working. You are generating first orders. But when you count how many customers come back for a second order, the picture changes. In most stores selling consumables the majority of the customer base buys once.
The reasons are specific, not mysterious. Ad creative that promised something the product did not deliver. A reorder path that takes six clicks. No follow-up message arriving in the week the product actually ran out. And a catalogue where the product that brings people in is not the product that brings them back.
Coffee, supplements and pet food all have a natural reorder cycle, and it is tempting to assume customers will return on their own. They rarely do without a plan. Understanding what happens around the second order is more useful than copying a loyalty program from a competitor. Stores with a working customer retention strategy stabilise their revenue. Stores that rely only on acquisition stay on the treadmill.

Why the second order decides your repeat purchase rate
The second order is the moment a one-time buyer becomes a repeat customer. It is where customer lifetime value starts to compound instead of flatline.
-
The hardest conversion is first order to second. In most order histories the share of customers who go from order two to order three is much higher than the share who go from one to two. Get the second order and the rest of the curve takes care of itself.
-
The gap between the first and second order is usually shorter than the gaps between later orders. For consumables the median is often somewhere between 25 and 45 days, which makes the first six weeks after purchase the period that matters.
-
A higher share of customers reaching order two lifts your repeat customer rate, makes revenue predictable, and lowers your dependency on acquisition spend.
Find your second-order window in your own order data
Before you can increase repeat purchases you need to know when they happen. Here is how to find that from an order export.
Columns you need: order id, customer id or email, order date, and line items with a product id or SKU. Shopify's order export has all four. On WooCommerce, the order exporter plugin gives you the same shape.
Steps:
-
Filter to customers whose first order falls in a chosen period, for example every first order in the last twelve months.
-
Sort by customer id, then order date. Tag each customer's earliest order as the first order.
-
For each customer with more than one order, find the next order date after the first. That is the second order.
-
Calculate the day gap: second order date minus first order date.
-
Count how many first-time buyers placed a second order within 30, 60 and 90 days. Divide each count by the total number of first-time buyers.
-
List every day gap for customers with two or more orders and take the middle value. That is your median days to second order.
Illustration, with round numbers: suppose you have 10,000 first-time buyers in the period. 2,000 buy again within 30 days (20%), 3,000 within 60 days (30%), and 3,800 within 90 days (38%). The median gap among those who reorder is 32 days.
This tells you two things. Your first reorder reminder should go out around day 24 to 26. And a customer who has not reordered by day 60 to 75 is late and should be treated as at risk.
Affinsy computes the second-order window, the repeat rate by acquisition month and the per-product reorder cadence from a CSV of orders, but you can start in a spreadsheet with one product category this afternoon.
Measure your repeat purchase rate properly
Repeat purchase rate is the percentage of customers in a period who placed two or more orders. It is not total orders divided by total customers.
-
The formula in plain terms: customers with two or more orders in the last twelve months, divided by all customers in the last twelve months, multiplied by 100.
-
Example: 2,400 repeat customers out of 12,000 customers in the past year is a 20% repeat purchase rate.
-
Repeat purchase rate versus purchase frequency: the rate tells you the share of customers who came back. Frequency tells you how often they come back. Both matter, but the rate is where you start. There is a longer walkthrough in our repeat purchase rate guide.
-
What good looks like: compare product families inside your own catalogue before you compare yourself to anyone else. A supplement line at 18% and a gift line at 4% is normal. A supplement line at 8% is a problem.
Keep a simple monthly sheet: repeat purchase rate, number of new customers, revenue from repeat orders, and median days to second order. That is the minimum needed to see whether anything you change is working.
Use product data to pick your second-order heroes
Not every product drives repeat business equally. Some pull in many first-time buyers and produce one-time customers. Others quietly build a base that reorders again and again.
-
Find your retainers: for each product that appears in a first order, count how many of those first-time buyers came back within 60 or 90 days. Build a table with the SKU, the number of first-time buyers, the number who reordered, and the share.
-
An opener brings in a large share of new customers but may convert few of them to a second order. A retainer has a high second-order share among the people who started with it. Most catalogues have one or two of each, and they are rarely the same product.
-
Use this in acquisition: feature the retainer in ads, in the welcome flow and in first-order bundles, and measure the change in second-order rate for the cohort that saw it.
-
Market Basket Analysis over the order history surfaces these roles directly, along with which products follow which across orders.
Time reorder reminders to real behaviour, not to a template
Your second-order window calculation already told you when repeat orders happen. Now use it.
-
For replenishable products, the median days between first and second order should anchor the post-purchase flow. If the median gap is 32 days, send a gentle reorder prompt around day 24 to 26 and a firmer one around day 32 to 35.
-
Segment by product where you can. A 30-day supplement and a 60-day shampoo have different cadences, and one flow timed to the store-wide average is wrong for both.
-
Check your suppression rules. A flow that mutes customers for 30 to 60 days after purchase will miss the reorder moment entirely when the real window is shorter.
-
Keep the reminder simple: one product, one button, no discount on the first touch. A discount trains customers who would have reordered anyway to wait for it.
-
Measure the lift by comparing 60-day repeat rate and median days to second order for cohorts before and after the change.

Bundle from actual baskets, not guesswork
Most second orders for consumables are reorders of the same product. But the right bundle can pull the next purchase forward and spread the second order across more of the catalogue.
-
Inspect the order data for products bought together on the same order: dog food and treats, cleanser and moisturiser, beans and filters.
-
Build three to five bundles from the top pairs, with a small incentive to move customers into a larger first or second order.
-
Know the difference between complementary pairs that grow the basket and substitute pairs that cannibalise each other. Do not bundle two flavours of the same product if the data shows customers buy one or the other and never both. The product bundling glossary entry covers the distinction.
-
Use bundles in first-order offers to pre-sell part of the next cycle: "two bags, 45 days of coffee" anticipates the reorder window instead of waiting for it.
Segment by recency so the message matches the moment
A recent first-time buyer needs different treatment than an active repeat customer or a lapsed buyer who is overdue.
-
Group customers from the export: recent first-time buyers (first order inside the last 45 days if your median is near 30), active customers with two or more orders in the last 90 days, and lapsed buyers who are past the second-order window with no repeat order.
-
Recent first-time buyers get education and the reorder reminder. Active repeat customers get replenishment prompts and cross-sell. Lapsed buyers get a short win-back sequence with product-specific messaging.
-
Even this three-way split beats sending the whole list the same campaign. Formal RFM segmentation refines it into Champions, At-Risk and Hibernating groups when you are ready for it.
Fix what blocks the second purchase
Order data tells you when the second purchase does not happen. Customers tell you why.
-
Send a short survey 7 to 10 days after delivery: product satisfaction, shipping experience, and one open question, "What would need to be better for you to order again next month?"
-
Tag the answers monthly and set them next to the second-order rate. Leaky packaging, confusing dosage instructions and slow shipping show up here long before they show up in revenue.
-
Fix the top two issues, then measure the second-order rate for the cohort that bought after the fix. That is the only proof that the fix worked.

Offer subscriptions only when the reorder pattern is stable
Subscriptions fit when the reorder cadence is predictable. Not every product qualifies.
-
Look at the distribution of days between same-product orders for your top replenishable items. A tight cluster, most reorders between 25 and 40 days for example, is a subscription candidate. A wide spread is not.
-
Set the subscription intervals to the observed cadence, 30, 45 or 60 days, rather than a generic monthly default.
-
Offer the subscription after the first or second successful order, when the customer has confirmed the product works for them. Offering it on the first visit, before they have tried it, usually backfires.
-
Customers who skip or delay shipments are an early churn signal. Send a check-in, not more product.
Prioritise win-back on customers who are late for the second order
"Late" means something specific: a first-time buyer whose first order is older than the 90th percentile of your second-order window, with no second order yet.
-
If your median gap is 32 days and the 90th percentile is 75 days, mark every first-time buyer past day 75 with no reorder. These are the priority win-back targets.
-
They are worth more than customers who lapsed a year ago, because the product experience is recent and the relationship is fresh.
-
Run a dedicated sequence: two or three messages over two weeks, referencing the original product, offering help before offering a discount.
-
Track this cohort's conversion into repeat customers as its own metric. Otherwise you cannot tell whether win-back is working or just spending budget on people who were never coming back.
How agencies can report repeat purchases to clients monthly
If you manage retention for several accounts, you need a repeatable format that ties each experiment to a measurable outcome.
-
Add a "repeat health" block to every monthly report: repeat purchase rate on a rolling twelve months, median days to second order, and the revenue share from repeat customers versus new ones.
-
Include a small cohort table: first-time buyers from each of the last three months and the share who have already placed a second order, in 30, 60 and 90-day bands.
-
Tie every campaign to one lever: raise the second-order rate for a named product, shorten time to second order, or revive late first-timers. Never report activity without the connected number.
-
End with one data-based next step: "extend the coffee reorder flow to day 60", "lead new-buyer ads with the retainer product in October".
Affinsy turns an order export into these figures, including product roles, per-product reorder timing and exportable customer lists, so the monthly report starts from the data rather than from a blank slide.
Next steps
-
Export the last twelve months of orders. Calculate the 30, 60 and 90-day repeat purchase rates. Find your median days to second order.
-
Identify your opener and retainer products. Which SKUs bring in the most first-time buyers, and which ones actually produce returning customers?
-
Change the post-purchase flow, the bundles and the win-back targeting for one product category first. Measure the change in second-order rate. Then expand.
If you would rather have the numbers worked out for you, the Shopify bundle finder and segmentation tool runs on a CSV in the browser, and the 48-hour analysis delivers the full second-order picture for your store with a walkthrough call.
FAQ
How often should I recalculate my repeat purchase rate?
Monthly, on a rolling twelve-month window, is enough for most stores. During a peak season like Black Friday, check the 30-day second-order rate of the new cohort weekly, since that cohort is larger and behaves differently. The underlying second-order window for a product category changes slowly.
What is a good repeat purchase rate for replenishable products?
There is no single benchmark, because it depends on price point, category and how fast the product is used up. Compare product families inside your own catalogue first. A consumable line should sit well above a gift or durable line in the same store, and the gap between them tells you more than an industry average would.
How do I handle products customers buy only once?
Shift the focus from reorders of the same product to what customers buy next. Map the products that most often follow the one-time item, such as refills, accessories or an adjacent category, and build the follow-up around those. A one-time product can still be a strong opener if the second order lands elsewhere in the catalogue.
Do I need advanced tools to start?
No. A spreadsheet with order id, customer id, order date and product is enough to compute the repeat purchase rate and the time to second order. Tools add speed, product-level patterns and audience building, which matters most when the store has many SKUs or you run several stores. Starting by hand with one category beats waiting for a full analytics setup.
How long should I keep trying to win back lapsed customers?
The best return comes from customers just beyond their expected second-order window, roughly 30 to 120 days overdue. Set a cut-off, such as twelve months with no orders, after which customers receive occasional brand content rather than a win-back sequence. Response rate by lapse length will show you where extra attempts stop paying off.