The Repeat Rate Shopify Doesn't Show You (and How to Find It)

The Repeat Rate Shopify Doesn't Show You (and How to Find It)

Your Shopify dashboard says forty percent of your customers come back. You're above average, you feel good, you move on with your day.

Except that forty percent is quietly answering a different question than the one you think you asked. It's blending three completely different behaviours into one number: subscriptions that just recharged, one-time buyers who resurfaced after two years, and people who actually chose to reorder on purpose. Only that last group tells you whether you've built something that lasts. So this episode is about pulling them apart and finding the number Shopify doesn't show you on any dashboard.

The short version

Shopify's "returning customer rate" isn't wrong, it just measures your customer mix, not your loyalty. It counts anyone who ever ordered before, including subscription renewals, so it can look healthy while your real repeat business quietly leaks. The fix is to build one honest number I'm calling your elective second-purchase rate: of the customers whose first order was a one-time purchase and who've had a full twelve months to come back, how many chose to buy again. On our whiteboard store a proud 40% turned into a 25% elective rate and 6,000 one-and-done customers hiding in plain sight. Pull yours with Sidekick, drop your store on a four-profile grid, and you'll know whether to protect, build, leave alone, or investigate.

Why isn't revenue enough to tell me if I'm healthy?

Because revenue and ROAS both look backward. Revenue tells you money came in. ROAS tells you an ad worked last week, before costs shifted again. Neither tells you the thing that actually matters, which is whether this keeps happening without you paying to make it happen.

You can post a record month and be in real trouble. I broke down exactly how in episode two: if that revenue came from first-time buyers you paid to acquire, the chart looks like a party while the P&L is having a very different night.

I want to be careful here, because repeat rate is also calculated from past behaviour. It's historical too, and anyone who tells you it's a crystal ball is overselling it. But here's the difference. Revenue measures the result. Repeat behaviour tells you whether that result has a chance to compound, whether last year's customers are quietly becoming next year's demand, or whether you start every January back at zero, renting all of it from Meta again. Revenue tells you what happened. Repeat rate tells you whether you have to go buy it all over again.

Is Shopify's returning customer rate wrong?

No, and I want to correct myself here, because I've caught myself calling it misleading and that's not fair. It calculates exactly what it says: of all the customers who ordered in the period you selected, how many had ordered at some point before. That's a real, correctly computed number.

The problem is what people think it means. Most merchants read it as "what percentage of my customers come back," a loyalty number. It isn't. It's a customer-mix number, the blend of new versus previously-seen buyers in a window. Two different questions:

Shopify's number asks: of everyone who ordered this period, how many had ordered before?

The question you actually care about asks: of the customers I acquired, how many came back within a meaningful window and deliberately chose to buy again?

That second one is what predicts anything. Two things muddy the first number and keep it from answering the second. One, it reaches all the way back and counts a one-time buyer from three years ago who happened to resurface. Two, and this is the big one, subscriptions.

Don't subscriptions count as repeat customers?

Technically yes, and I don't want to be cynical about this, because a subscription renewal is real revenue and real retention. The customer signed up on purpose, hasn't cancelled, and keeps accepting the product. That's genuinely good. You want subscribers.

But it measures a different kind of retention. It tells you the customer hasn't left. It doesn't tell you they made a fresh decision to buy you again. A renewal is a continuation. An elective second purchase is a new yes. Those are both worth knowing, and they are not the same thing.

Here's the insight I most want you to take away: a strong subscription program can completely coexist with a weak repeat business everywhere else. The subscriptions hum along while the rest of your customer file leaks, and if you only look at the blended dashboard number, you will never see it. The healthy program hides the weak one. That's the same theme Ron Shah and Paul Chambers and I got into on the Repeat Commerce Playbook episode, where we talked about why customers really cancel and how brands grow reorders without leaning on subscriptions at all.

How do I calculate my real repeat rate? (the whiteboard cohort)

Back to the whiteboard, coffee brand again. I'm building this as a proper cohort, because if you get sloppy with the populations the whole number falls apart.

Start with the dashboard view: our store's returning customer rate reads 40%. Renewals, resurfacing buyers, and real reorders are all mixed into that. Not wrong, just a blend.

Now build the honest number separately. Don't subtract one dashboard figure from another, they measure different things. Instead, pull a group of customers whose very first order was a one-time purchase, not a subscription, and only include customers who've had a full twelve months to come back, so nobody's in there who bought last week and hasn't had a fair chance. Say that's a clean cohort of 8,000 one-time-first customers.

One question of that group: within twelve months of their first order, how many placed another one-time order? Say 2,000. That's 2,000 out of 8,000, a 25% elective second-purchase rate.

Say this part slowly: the 40 did not become 25. Those two numbers were never the same number. Forty percent describes the mix of who was ordering during a period. Twenty-five percent describes whether a specific cohort of first-time buyers made a deliberate second purchase within a year. One is a snapshot of a crowd; the other is the behaviour of a cohort over time. Both are true, they just answer different questions.

And the number that stings, clean because it comes from the same cohort: of those 8,000, only 2,000 came back, which means 6,000 had a full year to return and didn't. That's your mature one-and-done count. Not "they vanished last week." They had every chance and chose not to.

Quick honesty note on benchmarks: is 25% good? I can't give you a clean one, and I won't make one up. The 20 to 40% ranges quoted online are mostly blended dashboard figures measuring something different. Almost nobody publishes a repeat rate with subscriptions stripped out over a fixed cohort window, which is kind of the whole point. Compare this cohort to your last one, and to how often someone should naturally rebuy what you sell. Coffee should be high. Mattresses low, and that's fine.

What's the fastest way to pull this in Shopify?

Ask Sidekick. It's Shopify's built-in AI assistant, the purple glasses icon in your admin, free on every plan, and it can build this cohort report from a plain-English request. You describe the report, it writes the query and runs it. The exact prompt is in the show notes and on the scorecard PDF, word for word.

One rule that matters more than the prompt: don't just accept the number Sidekick hands you. Inspect the filters. Make sure it grouped by customer, not by order or subscription contract. Make sure first-order type is actually one-time. Make sure the window is fixed. I've had Sidekick nail this and I've had it quietly answer a slightly different question than I asked. Treat its first answer as a smart draft you verify, not a final number you screenshot. That habit will serve you with any AI tool, not just this one.

If you'd rather save it as a report you rerun each quarter, you can build the same cohort by hand in the ShopifyQL editor. The fields flag a customer's first-order type and whether an order is subscription or one-time. Heads up: Shopify renames those fields from time to time, so if a query errors, ninety percent of the time that's all it is. Paste the broken query back into Sidekick and ask it to fix it. The plain-English path and the power-user path are collapsing into each other fast.

I have my number. Now what?

A number alone doesn't tell you what to do, so put your store on a simple two-by-two grid: subscription strength on one axis, elective second-purchase rate on the other. Four profiles.

High subscription, high elective is the dream. People auto-replenish and your one-time buyers come back on their own. Don't break it.

High subscription, low elective is the sneaky one, and the whole reason for this episode. Your subscription engine looks great, but strip it away and the rest barely repeats. This is the gym-membership trap: people aren't choosing to show up and pay every month, they just haven't gotten around to cancelling. Some brands are so afraid of it they won't even email their subscribers in case it triggers a cancel. The work here is building elective repeat outside the subscription so the whole business isn't standing on one leg.

Low subscription, high elective is genuinely healthy: customers come back on their own without being locked in. There might be a subscription opportunity, but be careful, forcing one on people who happily rebuy can annoy your best customers. I watched this with a brand whose one-click reorders were running four times their new subscriptions every month, with higher lifetime value on the customers who chose to come back on their own. They didn't need a subscription mandate. They needed to make choosing easy.

Low subscription, low elective needs real attention, and no shame if that's you, because now you actually know. It's a true repeat-commerce problem, usually one of four things: product experience, replenishment timing, reorder friction, or product-market fit. Conveniently, those are the next several episodes of this series.

Your 1% win

Grab the Repeat Commerce Scorecard, open Sidekick, paste the prompt, inspect the filters, and read your two numbers: your elective second-purchase rate and your mature one-and-done count. Write them on lines six and seven, under the numbers from episode one and two. Then mark your quadrant.

I'll be straight with you, this is the first scorecard number designed to make you a little uncomfortable. The earlier ones were mostly neutral. This one might sting. Good. I've seen too many stores that thought they were crushing it, busy, growing, healthy, right up until one month they weren't, because the repeat revenue underneath was never really there. You can't fix a leak you don't know about.

That's the whole point of the number. Next episode we stop measuring and start fixing, right where the leverage is highest: the second order. There is no order more important than the second one. Follow Shopify1Percent wherever you listen so you don't miss it.

SPECIAL NOTE: 

This post is from our Repeat Commerce series. 20 episodes designed to help you master turning your Shopify store into the ultimate repeat customer machine! Make sure to catch all the episodes: 

Episode 03 - https://www.shopify1percent.com/rc-03/ 
Episode 02 - https://www.shopify1percent.com/rc-02/ 
Episode 01 - https://www.shopify1percent.com/rc-01/ 

GET YOUR SCORECARD - https://www.shopify1percent.com/downloads/repeat-scorecard/ 
Each episode of the Repeat Commerce Series we'll be adding a new section to the scorecard. Follow along and listen to all episodes, and by the time you're done, you'll have a full Repeat Commerce audit done on your store!