How Do I Calculate Purchase Frequency for My Online Store?
The Purchase Frequency Formula
The formula for purchase frequency in ecommerce is total number of orders divided by total number of unique customers in the same time period.
Write it like this:
Purchase frequency = total orders ÷ unique customers
The part that trips people up is not the math. The part that trips people up is counting the right things. You want completed orders, not canceled orders, and you want unique customers, not customer records that accidentally split the same person into two profiles.
Here is a plain example. Say your OpoShop store had 75 completed orders in June from 60 unique customers. Your purchase frequency for June is 75 ÷ 60 = 1.25. That means the average customer placed 1.25 orders during that month.
If you are tracking repeat orders, it also helps to understand which loyalty metrics belong on your monthly dashboard.
What Is Purchase Frequency?
Purchase frequency is the average number of orders each customer places during a chosen period.
That makes it a behavior metric. It tells you whether customers are coming back and buying again, not just whether your store got more orders overall. A store can have rising order count and still have weak repeat behavior if most of those orders come from brand new buyers.
That is why purchase frequency is useful, but not enough on its own. If 100 customers place 100 orders, purchase frequency is 1.0. If 100 customers place 140 orders, purchase frequency is 1.4. The second store is getting more repeat activity per customer in that window.
Purchase frequency is also narrower than broader retention reporting. It does not tell you how many customers bought twice. It does not tell you how much a customer is worth over six months or a year. It tells you one thing clearly: how often customers bought during the period you measured.
For small stores on OpoShop, that clarity matters. You do not need a giant analytics stack to calculate it. You just need clean order data and a consistent date range.
Why Purchase Frequency Matters for Small OpoShop Stores
Purchase frequency matters because it shows whether your store is getting more value from the customers you already paid to acquire.
That is a big deal for small DTC brands, boutiques, and maker businesses. Paid acquisition gets expensive fast. If each first order has to do all the work, growth gets fragile. If more customers come back for a second or third order, the business gets steadier.
Here is a simple picture:
- Store A: 200 orders, 200 customers, purchase frequency = 1.0.
- Store B: 200 orders, 140 customers, purchase frequency = 1.43.
Both stores booked 200 orders. Store B did it with more repeat behavior. That usually means better retention and a stronger base for future sales.
This is also where buying cycle matters. A candle shop, boutique, or handmade jewelry brand on OpoShop may not see meaningful repeat behavior week to week. Monthly or quarterly windows often make more sense than weekly ones. If a customer buys a seasonal dress every 90 days, a seven-day report will make the store look worse than it really is.
And here is the part a lot of merchants miss. A decent purchase frequency can still hide a second-order problem. Say 300 first-time buyers come in during a holiday push, but only 20 of them come back. Total orders may still keep the average from looking terrible. Repeat purchase rate will expose that weakness faster. We will get to that in a minute.
How Do You Calculate Purchase Frequency for Your Online Store?
You calculate purchase frequency by picking a date range, counting completed orders, counting unique customers, dividing orders by customers, and then checking whether the result passes a common-sense test.
That sounds simple because it is. Simple is good. The only real danger is messy store data.
1. Pick a date range that matches your buying cycle
Your date range should match how people actually buy from your store. A snack brand may review this monthly. A boutique with slower reorder behavior may get a cleaner read from a 90-day window.
Weak and stronger measurement windows make the difference clear:
Weak: Measuring a handmade furniture store every 7 days and concluding repeat behavior is poor. Stronger: Measuring the same store every quarter because customers rarely buy a second piece within one week.
The goal is not to make the number look better. The goal is to make the number mean something.
2. Count completed orders and unique customers the same way every time
Use the same rules every month. If you count completed orders in March but include pending or canceled orders in April, the comparison is broken before it starts.
Guest checkout is another practical issue. One shopper can appear as two customers if one order used sara@example.com and the next used sara+gift@example.com, or if a customer checked out once as a guest and once through an account. Small OpoShop merchants do not always have an analyst cleaning this up, so it is worth spot-checking your customer list before you trust the number.
A quick example helps. Say your store shows 92 orders in May. After removing 4 canceled orders and 3 test orders, you have 85 completed orders. Your customer export shows 70 unique customers after merging a few duplicates. Purchase frequency is 85 ÷ 70 = 1.21.
If purchase frequency is low, a points-based rewards program can give customers a reason to come back without training them to wait for blanket discounts.
Purchase Frequency vs Repeat Purchase Rate vs Customer Lifetime Value
Purchase frequency, repeat purchase rate, and customer lifetime value answer three different questions, and mixing them up leads to bad reporting.
Purchase frequency asks, "How often did customers order during this period?" Repeat purchase rate asks, "What share of customers bought more than once?" Customer lifetime value asks, "How much revenue or margin does a customer generate over time?" Those are related, but they are not interchangeable.
| Metric | What it tells you | Best use | Example |
|---|---|---|---|
| Purchase frequency | Average number of orders per customer in a period | Spotting changes in repeat ordering behavior | 150 orders ÷ 120 customers = 1.25 |
| Repeat purchase rate | Percentage of customers who placed 2 or more orders | Checking second-order behavior | 24 repeat customers ÷ 120 total customers = 20% |
| Customer lifetime value | Total value a customer brings over time | Setting acquisition and retention budgets | A customer spends $45 three times over 12 months = $135 |
Here is why that difference matters. Imagine a store on OpoShop gets 400 orders from 350 customers in a quarter. Purchase frequency is 1.14. That sounds fine at first glance. But if only 35 of those 350 customers placed a second order, repeat purchase rate is just 10%. The average is being helped by a small group of loyal buyers.
Customer lifetime value adds another layer. If repeat buyers come back often but only spend $12 each time, that tells a different story than buyers who come back twice a year and spend $140 per order.
If you want a cleaner monthly dashboard in your OpoShop store, keep all three metrics visible. They answer different questions, and you need all three if your goal is more repeat customers.
What Mistakes Should You Avoid When Measuring Purchase Frequency?
Most purchase frequency mistakes come from inconsistent counting, not hard math.
A very common one is changing the date range whenever the number looks bad. If January is monthly, February should also be monthly. If your store has a slow buying cycle and you choose quarterly reporting, stay with quarterly reporting long enough to see a pattern.
A second mistake is counting the wrong orders. Purchase frequency should usually include completed orders only. Refunded orders are a judgment call based on how your reporting system logs them, but canceled orders should not count as purchases. Subscription renewals also need a decision up front. If subscriptions are a real part of how customers buy from your store, include them consistently. If you are trying to measure discretionary repeat buying separate from auto-renewals, track them in a separate view.
Here are the practical errors we see most often:
- Inconsistent date ranges: Comparing one week in April to one month in May tells you almost nothing.
- Guest checkout issues: One person can look like two customers if guest orders and account orders are not matched well.
- Duplicate customer records: Duplicate emails, spelling differences, or family-shared inboxes can distort the denominator.
- Canceled or test orders included: These inflate order count and make the metric look healthier than it is.
- Cross-store comparisons with different buying cycles: A coffee subscription brand and a custom furniture maker should not be judged on the same cadence.
One more thing. Do not calculate purchase frequency using only repeat customers. Use all customers in the chosen period. If you remove first-time buyers, you are no longer measuring average order frequency across the whole customer base. You are measuring a filtered subset, which answers a different question.
What We Recommend for Perkly Merchants
For Perkly merchants, the best use of purchase frequency is as a monthly or quarterly retention check paired with loyalty behavior inside the dashboard.
By itself, the number tells you how often customers are ordering. Next to Perkly signals, the picture gets sharper. You can see whether more members are joining, whether redemptions are happening, whether top members are carrying too much of the repeat revenue, and whether points outstanding are growing faster than customers are redeeming.
A simple monthly review can look like this:
- Purchase frequency: Did average orders per customer rise from 1.12 to 1.26 over the last 90 days?
- Members: Did loyalty signups increase after adding signup points?
- Redemption activity: Are customers actually using money-off rewards at checkout, or just collecting points?
- Top members: Is repeat behavior broadening across the customer base, or coming from the same 15 buyers?
- Points outstanding: Is the points balance staying manageable as a liability, or piling up without redemptions?
That pairing matters because not every improvement shows up in the same place first. A customer may sign up, earn birthday points, and redeem on the next order. Purchase frequency may improve a month later. Another customer may join the program but never redeem, which tells you the reward structure needs work.
If your store has plenty of first orders but weak second-order behavior, start with simple retention levers:
- Signup points: Give a clear reason to join right after the first purchase.
- Birthday points: Create a natural reactivation moment that does not depend on a sitewide sale.
- Money-off redemption at checkout: Let customers use points in a way that feels immediate and easy.
- Post-purchase reminders: Nudge shoppers before points sit untouched for months.
For merchants on OpoShop, this is a practical way to make the metric useful. You are not just measuring repeat behavior. You are giving customers a reason to repeat it.
Best answer: Calculate purchase frequency with one clean formula, review it on a schedule that matches your buying cycle, and never read it alone. For Perkly merchants, the next step is pairing purchase frequency with repeat purchase rate, loyalty membership, redemption activity, and top-member behavior so you can see whether customers are actually coming back for the right reasons.
FAQs
What is the formula for purchase frequency?
The formula for purchase frequency is total number of orders divided by total number of unique customers in the same time period. If your store had 90 orders from 75 customers, purchase frequency is 1.2.
Is purchase frequency the same as repeat purchase rate?
No. Purchase frequency measures the average number of orders per customer, while repeat purchase rate measures the percentage of customers who bought more than once. Both matter, and they answer different questions.
Should I include first-time buyers in purchase frequency?
Yes. Purchase frequency should use all unique customers in the chosen period, including first-time buyers. If you only include repeat buyers, you are measuring a narrower group and the result will be misleading.
What date range should I use to calculate purchase frequency?
Use a date range that matches how customers buy from your store. Many small ecommerce stores use monthly reporting, while slower-cycle boutiques or maker brands often get a better read from a quarterly window.
How do refunds or canceled orders affect the calculation?
Canceled orders should usually be excluded because they were not real purchases. Refunds depend on how your system records them, but the cleanest approach is to use completed orders consistently and document your rule so each reporting period is comparable.
How can I improve purchase frequency for my online store?
Improve purchase frequency by giving customers a reason to come back soon after the first order. For many stores on OpoShop, that means better post-purchase follow-up, a points program, signup rewards, birthday rewards, and easy money-off redemption at checkout instead of constant blanket discounts.
Want a simpler way to turn first-time buyers into repeat customers? See how Perkly helps OpoShop merchants reward orders, signups, birthdays, and redemptions from one dashboard.
