How Do You Calculate and Increase Repeat Purchase Rate? A Guide to Customer Group (Cohort) Analysis, Time to Second Order, Reminder Timing and Campaign Measurement
How do you calculate and increase the repeat purchase rate? Cohort analysis, time to second order, reminder timing and campaign measurement: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: How do you calculate the repeat purchase rate?
- Lesson 2: How do you read a customer group (cohort) table?
- Lesson 3: When does the second order come?
- Lesson 4: How much value does a returning customer carry?
- Lesson 5: How do you measure a reminder campaign with a control group?
- Lesson 6: When should a reminder be sent?
- Lesson 7: What affects the repeat purchase rate?
- Lesson 8: How do you track the repeat purchase rate?
- What are the most common mistakes when calculating the repeat purchase rate?
- How does NetKasam make repeat purchase tracking easier?
- Mini quiz: Test what you have learned
- Conclusion: Group last month's first-time customers together
- Frequently Asked Questions About the Repeat Purchase Rate
You spend on ads, campaigns and effort to get a customer to place a first order; the second order, however, is often left to chance. Yet the second order is the most critical threshold in a customer relationship: the first order covers the acquisition cost, and every order after that generates contribution without requiring new advertising spend. As long as you don't measure how many customers cross this threshold, you cannot know what you need to do to retain them.
This article is not a narrative but an 8-lesson practical training. We will answer the question how to calculate and increase the repeat purchase rate using 400 customers who placed their first order in one month: the correct formula for the rate, the customer group (cohort) table, when the second order comes, the value of a returning customer, measuring a reminder campaign with a control group, timing, the effect of the delivery experience and monitoring indicators. At the end there is a mini quiz with an answer key. All figures are example values chosen to illustrate the method; follow the same steps with your own data.
What will you be able to do by the end of this training?
In short: You will calculate the repeat purchase rate correctly, read how your customer group behaves over time, measure a reminder campaign with a control group and find out what increases repeat orders.
- 01CountSeparate first-time buyers as a customer group.
- 02TrackWrite down how many of the group came back month by month.
- 03TimeFind when the second order comes.
- 04ValueCalculate the contribution a returning customer brings.
- 05TestMeasure reminders with a control group.
- 06AdjustRead the delivery and product experience together with the repeat rate.
The 8 lessons of the training: (1) how the rate is calculated, (2) the customer group table, (3) when the second order comes, (4) the value of a returning customer, (5) how to measure a reminder campaign, (6) reminder timing, (7) factors affecting the repeat rate, (8) monitoring indicators.
Lesson 1: How do you calculate the repeat purchase rate?
In short: Repeat purchase rate = Customers who order at least once more in a given period ÷ First-time customers. Dividing the number of orders by the number of customers does not give this rate.
- Repeat purchase rate = Customers who ordered again ÷ First-time customers
- Period = The time over which the rate is measured (e.g. 3, 6 or 12 months)
- Repeat customer = A person who places at least a 2nd order within the period
In the example business, 400 people placed their first order in January. Over the following 12 months, 180 of them ordered at least once more. The 12-month repeat purchase rate is 180 ÷ 400 = 45%. The same 180 customers placed a total of 300 additional orders in 12 months; in other words, repeat customers placed an average of 300 ÷ 180 = 1.67 additional orders. The two answer different questions: the rate shows what share of customers came back, while the number of additional orders shows how often those who came back ordered.
A common mistake is dividing total orders by total customers: (400 + 300) ÷ 400 = 1.75 orders per customer. This figure is the "average order frequency," not the repeat rate; one customer ordering 10 times can hide nine customers never coming back. To calculate the rate, you group customers by first order date, and for the records on the account card you can use the solution on the customer and supplier account tracking page.
Lesson 2: How do you read a customer group (cohort) table?
In short: A cohort is a group of customers who placed their first order in the same month. Writing down how many of the group came back month by month shows the shape of repeat behavior over time.
The cumulative number of repeat customers in the January group, by months elapsed since the first order, is as follows:
| After the first order | Cumulative repeat customers | Repeat purchase rate |
|---|---|---|
| End of month 1 | 48 | %12 |
| End of month 2 | 84 | %21 |
| End of month 3 | 112 | %28 |
| End of month 6 | 148 | %37 |
| End of month 12 | 180 | %45 |
- End of month 112%
- End of month 221%
- End of month 328%
- End of month 637%
- End of month 1245%
Prepared with example values. Each rate: cumulative repeat customers ÷ 400.
The curve rises quickly in the first three months, then slows; it reaches 45% in month 12. When you place each month's group side by side as a separate row, you see two things: whether new customer groups come back better or worse than older ones, and whether a campaign or process change actually changed repeat behavior. Taking a monthly average hides this information. We explained tracking customer numbers and reading them together with acquisition cost in the article how to calculate customer acquisition cost.
Lesson 3: When does the second order come?
In short: Most repeat customers come back in the first few months. Knowing this window determines when you send a reminder.
Of the 180 customers who came back over 12 months, 112, or 62.2%, returned within the first three months (112 ÷ 180). Those who returned within six months make up 82.2% (148 ÷ 180). So roughly five-sixths of repeat customers come back within the first six months; only 32 customers (180 − 148) came in the last six months. By the end of the second month, 46.7% of repeat customers had come back (84 ÷ 180), and by the end of the third month 62.2%; in other words, the median time to second order is between two and three months.
| Period | Customers returning in that period | Share of repeat customers |
|---|---|---|
| First 3 months | 112 | %62,2 |
| Months 4 – 6 | 36 | %20,0 |
| Months 7 – 12 | 32 | %17,8 |
| Total | 180 | %100 |
This table drives two decisions. First: reminder and retention efforts should concentrate on the first three months, because that is where most repeat customers are decided. Second: a call made three months later to a customer who did not return in the first 3 months yields a much weaker return. If your product has a natural consumption period (for example, a product used up in 60 days), it is more accurate to set your own periods around that duration. To set up post-order communication correctly, see how to send order notifications to customers.
Lesson 4: How much value does a returning customer carry?
In short: A returning customer generates additional contribution beyond the first order, and this contribution matters more than their share of the customer count.
In the example business, the average basket is ₺500 and the contribution margin is 30% (after deducting product, commission, shipping and packaging); contribution per order is ₺150. The contribution of the first 400 orders is 400 × 150 = ₺60,000. The contribution of the 300 additional orders placed by repeat customers over 12 months is 300 × 150 = ₺45,000. The group's total 12-month contribution is ₺105,000.
- Contribution of first orders₺60,00057.1%
- Contribution of repeat orders₺45,00042.9%
Prepared with example values. First: 400 × 150; repeat: 300 × 150.
Repeat orders bring in 45,000 ÷ 105,000 = 42.9% of the contribution, while 45% of customers take part in this contribution. More importantly, you earn this contribution without new advertising spend: the acquisition cost of a customer who orders again was already covered by the first order. That is why raising the repeat rate from 45% to 50%, that is, bringing back 20 more customers (roughly 33 more orders on average, if the number of additional orders stays the same), usually costs less than finding new customers. To calculate a customer's total value over a longer window, see how to calculate customer lifetime value.
Lesson 5: How do you measure a reminder campaign with a control group?
In short: The real effect of a coupon reminder is the difference between the group that received the coupon and the group that didn't. Not everyone who used the coupon ordered because of the campaign.
In the example business, the number of customers who did not order again within the first two months is 400 − 84 = 316. These customers were randomly split into two groups: 158 were sent a 10% discount coupon, and 158 received no message at all as a control group. Over the next three months, 26 customers in the coupon group and 10 customers in the control group placed an order.
| Group | Customer | Ordered | Return rate |
|---|---|---|---|
| With coupon | 158 | 26 | %16,5 |
| Control | 158 | 10 | %6,3 |
| Difference | 16 | 10.1 points |
Of those who ordered in the coupon group, 10 would have ordered even without the coupon (the control group shows this); the campaign brought in only 16 additional customers. The contribution of a coupon order after the discount is 150 − 50 = ₺100 (a 10% discount on a ₺500 basket is ₺50). The control group's 10 orders generated ₺1,500 at full contribution.
- Contribution of the control group (10 orders × ₺150)₺1,500
- 16 additional customers brought by the coupon (16 × ₺100)₺1,600
- Discount given to 10 customers who would have bought anyway (10 × ₺50)−₺500
- Contribution of the coupon group (26 orders × ₺100)₺2,600
Prepared with example values. Total: 1,500 + 1,600 − 500 = ₺2,600. The coupon group contributed ₺1,100 more than the control group.
The coupon turned out profitable: in the 158-person group it earned a net ₺1,100. Sent to all 316 people, it would have been about ₺2,200. Without a control group, the coupon group's 26 orders would look like ₺2,600 in contribution, but you would not notice that the 10% discount was also given to 10 orders that would have happened anyway. To calculate a discount's profit impact before a campaign starts, see how to offer discounts without losing money; for setting up campaigns on the store side, see how to set up a store campaign.
Recommended readingHow Do You Offer Discounts Without Losing Money?Lesson 6: When should a reminder be sent?
In short: A reminder should be sent just before the customer would naturally order again; a message sent too early turns into an unnecessary discount, and one sent too late into a missed opportunity.
Three rules work:
- Based on the product's usage period. If the product runs out in 60 days, send the reminder around day 50; the customer reorders before running out.
- Based on the cohort table. In the example, 62.2% of repeat customers come back within the first three months; that is why a coupon reminder sent to customers who have not returned by the end of the second month makes sense.
- Based on complementary products. Recommending a product bought alongside the item (consumables, accessories) after the first order can increase returns even without a discount.
Instead of setting the reminder timing once and forgetting it, test two messages sent on different days side by side with a control group: for example, one group receives it on day 45 and the other on day 60. Use the same measure from lesson 5 to pick the winner.
Lesson 7: What affects the repeat purchase rate?
In short: The delivery experience of the first order is one of the factors affecting the repeat rate. See the difference in your own data by splitting the customer group by delivery time.
In the example business, the 400 customers were split in two by delivery time: 240 received their order within 2 days, and 160 in 3 days or later.
| Delivery time | Customer | Repeat within 12 months | Repeat rate |
|---|---|---|---|
| Within 2 days | 240 | 126 | %52,5 |
| 3 days or more | 160 | 54 | %33,8 |
| Total | 400 | 180 | %45,0 |
- Delivered within 2 days52.5%
- Delivered in 3 days or later33.8%
- Entire group45.0%
Prepared with example values. 126 ÷ 240 and 54 ÷ 160.
The difference is 18.75 points; this is a correlation, not proof of cause and effect on its own. Customers who received faster delivery may be in different regions, buy different products or come from a different channel. But the difference is so large that shortening the time to ship and monitoring the delivery experience is one of the first steps to try for the repeat rate. To measure and shorten the time to ship, see how to measure and shorten time to ship. Returns also sharply lower the repeat rate; for the method, the article how to reduce the return rate is helpful.
Lesson 8: How do you track the repeat purchase rate?
In short: Track three indicators in the same table every month: the cohort repeat rate, the time to second order and the contribution share of repeat orders.
| Indicator | How it is calculated | Sample value |
|---|---|---|
| 12-month repeat rate | Repeat customers ÷ First-time customers | %45 |
| 3-month repeat rate | Returned in first 3 months ÷ First-time customers | %28 |
| First-3-month share | Returned in first 3 months ÷ Repeat customers | %62,2 |
| Contribution share of repeat orders | Contribution of repeat orders ÷ Total contribution | %42,9 |
| Net effect of the coupon | Contribution of coupon group − Contribution of control group | 1.100 ₺ |
- 45%share of customers who ordered again within 12 months
- 62.2%share of repeat customers who came back in the first three months
- 42.9%share of repeat orders in the 12-month contribution
- ₺1,100net gain of the 158-person coupon group
If the 3-month rate is falling, the first experience is weakening: delivery, product or communication. If the 12-month rate is falling while the first 3 months are stable, your retention campaigns are weakening. To add the number of repeat orders to your weekly summary, see how to prepare a weekly management report.
Recommended readingHow Do You Calculate Staff Costs? Training on Salary, Bonuses, Overtime, Advances, Staff-to-Revenue Ratio and Cost per OrderWhat are the most common mistakes when calculating the repeat purchase rate?
- Dividing orders by customers and calling it the "repeat rate." Order frequency and the repeat rate are different things.
- Averaging without separating groups. When new and old customers are mixed, changes in behavior are hidden.
- Evaluating a coupon without a control group. You don't notice that the discount also went to customers who would have bought anyway.
- Sending the reminder to everyone on the same day. Product usage periods and return timing are ignored.
- Not tracking the delivery and return experience. The cause of a falling repeat rate is sought on the sales side, while it may lie in shipping or returns.
- Measuring repeat orders by revenue. Orders that come with a discount reduce contribution; measure by profit share.
How does NetKasam make repeat purchase tracking easier?
- Customer accounts and statements. You manage customer balances and generate and share statements (customer account tracking).
- Customer groups. You classify customers and suppliers into groups and run special promotions and announcements.
- Orders on one screen. You see orders in a single dashboard and filter them by customer (order management).
- Saved reports. You save the customer sales report with criteria and export it to Excel (reports).
- Invoice tracking. You track issued invoices and returns (invoice tracking).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If 180 of 400 first-time buyers ordered again within 12 months, what is the repeat purchase rate?
- If 112 of the 180 repeat customers came back within the first 3 months, what is their share as a percentage (one decimal)?
- If contribution per order is ₺150 and repeat customers placed a total of 300 additional orders, what is the contribution of repeat orders?
- If 26 customers ordered in the coupon group and 10 in the control group, how many additional customers did the coupon bring?
- If the contribution of a coupon order is ₺100 and of a control order ₺150, what is the total contribution difference between the 26 and 10 orders?
Answer key:
- 180 ÷ 400 = %45.
- 112 ÷ 180 = %62,2.
- 300 × 150 = 45.000 ₺.
- 26 − 10 = 16 additional customers.
- 26 × 100 = 2,600; 10 × 150 = 1,500; difference ₺1,100.
Frequently Asked Questions About the Repeat Purchase Rate
How do you calculate the repeat purchase rate?
The number of customers who order at least once more in a given period is divided by the number of customers who placed their first order at the start of that period. For example, if 180 out of 400 customers come back, the rate is 45%.
Are the repeat purchase rate and order frequency the same thing?
No. The repeat rate shows what share of customers come back, while order frequency shows the average number of orders per customer. One customer ordering very often can hide the fact that others never come back.
What is cohort analysis?
It is a method of grouping customers who placed their first order in the same month and tracking how many of that group order again in the following months.
When does the second order usually come?
It varies by business and product. In the example, 62.2% of repeat customers come back within the first three months; extracting this window from your own cohort table determines the timing of reminders.
How do you increase the repeat purchase rate?
It is increased by improving the delivery and return experience of the first order, sending reminders at the right time, recommending complementary products and measuring campaigns with a control group.
Does a coupon campaign increase repeat orders?
It can, but its effect should be measured with a control group. Some customers who use the coupon would have ordered even without it; the real effect is the difference between the coupon group and the group without a coupon.
Why is a repeat order cheaper than finding a new customer?
The acquisition cost of a returning customer has already been covered by the first order; additional orders generate contribution without new advertising spend.
How often should the repeat purchase rate be tracked?
Add a new cohort row every month and compare it with older groups. Tracking 3-, 6- and 12-month rates separately shows in which period the process breaks down.
Conclusion: Group last month's first-time customers together
The most useful thing you can do today is gather the customers who placed their first order three months ago into a single list and count how many of them placed a second order. The resulting rate is the first real measure of your repeat purchase performance. The next step is to send a reminder to those who have not ordered again and to leave a control group out of the message.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.