New vs Returning Revenue Split: A Health Check

The share of your revenue that comes from returning customers is one of the fastest reads on business health, and both extremes are a warning. Too much new-customer revenue means you're a leaky bucket with no retention. Too much returning revenue means acquisition has stalled and you're living off an aging base. You can compute the split by month from a Shopify export in an afternoon, and the trend tells you more than any single month.

This guide shows how to build the monthly split, what a healthy range looks like by store age, and the specific failure modes at each extreme with a worked monthly example.

What the Split Actually Measures

The new vs returning revenue split divides each month's revenue into two buckets: revenue from customers placing their first-ever order, and revenue from customers who've ordered before. It's a balance reading. New-customer revenue shows acquisition is working. Returning-customer revenue shows retention is working. You need both, and the ratio between them tells you which engine is carrying the business right now.

It's different from repeat purchase rate, which counts customers. The revenue split weights by dollars, so a small number of high-spending returning customers can swing it. Read them together. For the customer-count view, see what is a good repeat purchase rate and the repeat purchase rate glossary page.

Build the Monthly Split From a Shopify Export

You need one file: a Shopify orders export covering at least 12 months, with order date, customer email, and order total. The steps below turn it into a month-by-month split you can trend.

Step 1: Find Each Customer's First-Order Date

Sort orders by customer email and date. For each customer, mark the earliest order date as their first-order date. This is the pivot the whole analysis turns on: an order is "new" if its date equals that customer's first-order date, and "returning" otherwise. A customer is new exactly once, on the month of their first purchase, and returning forever after.

Step 2: Tag Every Order New or Returning

Add a column that reads "new" when the order date matches the customer's first-order date and "returning" when it's later. Guest checkouts complicate this. If the same person checks out as a guest twice under one email, it works; if their email varies, they'll look like two new customers. Deduplicate on email as best you can, and know the split slightly overstates new revenue if guest emails are messy.

Step 3: Pivot to a Monthly Split Table

Group by order month and the new/returning tag, summing order totals. Express returning revenue as a percentage of the month's total. Here's a worked example for a store roughly 18 months old.

Month	New revenue	Returning revenue	Total	Returning %
January	$82,000	$28,000	$110,000	25%
February	$79,000	$33,000	$112,000	29%
March	$85,000	$38,000	$123,000	31%
April	$80,000	$41,000	$121,000	34%
May	$78,000	$46,000	$124,000	37%
June	$76,000	$50,000	$126,000	40%

Read the trend, not the level. New revenue is flat around $80k while returning revenue climbs steadily from $28k to $50k, and returning share moves from 25% to 40% over six months. That's a healthy 18-month-old store: acquisition is holding and retention is compounding on top of it. The business is growing because returning revenue is being added to a stable acquisition base, not because either engine is masking a problem in the other.

Directional Benchmarks by Store Age

There's no universal target, because the healthy split moves with how long you've had to accumulate repeat customers. A one-year-old store hasn't had time to build a returning base; a five-year-old one should have a substantial one. Use these as directional bands, not hard rules.

Store age	Typical returning revenue share	What's normal
Under 1 year	10-25%	Mostly new by necessity; base is still forming
1-2 years	25-40%	Returning revenue should be climbing month over month
2-4 years	40-55%	Both engines mature; retention is a real contributor
4+ years	50-65%	Returning base substantial; watch that new isn't starving

A returning share below the band for your age suggests weak retention. Above the top of the band, especially for older stores, suggests acquisition has stalled and you're increasingly dependent on an aging base. The bands widen at the top because a great retention brand can healthily run higher, as long as new-customer revenue is still growing in absolute terms.

The Failure Modes at Both Extremes

The reason to watch this split is that it fails in two opposite directions, and the fix for one makes the other worse. Diagnosing which extreme you're at tells you where to put effort.

Too new: the leaky bucket. If returning share is stuck low and not climbing, especially past your first year, you're acquiring customers who never come back. Every month restarts from near zero, so you have to buy the same revenue again through paid acquisition. This is the more dangerous extreme because it's expensive and it hides behind top-line growth. Revenue can rise while the business gets less healthy, because rising CAC on non-repeating customers eventually caps you. The fix is retention: post-purchase flows, a reason to reorder, and product or category expansion. It is not more ad spend, which just pours faster into the leak. To go deeper, read the D2C retention playbook.

Too returning: stalled acquisition. If returning share keeps climbing while new revenue shrinks in absolute dollars, acquisition has stalled and you're harvesting an aging base. This looks great for a while because returning customers are cheap to sell to, so margins look healthy and the top line holds. Then the base ages out, repeat frequency decays, and there's no new cohort underneath to replace it. The decline, when it comes, is sharp because you stopped feeding the top of the funnel months ago. The fix is acquisition: reopen paid channels, test new creative and audiences, and accept the lower margins that new-customer revenue carries.

The tell that separates healthy from stalled is the absolute dollars. Healthy stores grow returning revenue while holding or growing new revenue. Stalled stores grow returning share only because new revenue is falling. Always read both columns in dollars, not just the percentage.

Frequently Asked Questions

What is a healthy new vs returning revenue split?

It depends on store age. Under one year, 10 to 25 percent returning is normal because the base is still forming. At one to two years, expect 25 to 40 percent and climbing. At two to four years, 40 to 55 percent. Past four years, 50 to 65 percent is common. Read the trend more than the level: healthy stores grow returning revenue in absolute dollars while holding acquisition.

How do I calculate new vs returning revenue in Shopify?

Export your orders, then find each customer's earliest order date. Tag an order new if its date equals that customer's first-order date and returning if it's later. Group by month and tag, sum order totals, and express returning revenue as a percentage of each month's total. Deduplicate on email first, since messy guest-checkout emails inflate new-customer revenue by splitting one person into several.

Is a high returning-customer revenue share good or bad?

It depends on why it's high. If returning revenue is growing in absolute dollars while new revenue holds, a high share is healthy retention. If returning share is high only because new-customer revenue is falling, acquisition has stalled and you're living off an aging base that will eventually decline sharply. Always read both columns in dollars, not just the percentage, to tell the two apart.

What does too much new-customer revenue mean?

It usually means weak retention, a leaky bucket. If returning share stays low and doesn't climb past your first year, you're acquiring customers who never come back, so every month restarts from near zero and you rebuy the same revenue through ads. It's dangerous because rising CAC hides behind top-line growth. The fix is retention flows and reasons to reorder, not more ad spend.

How is the revenue split different from repeat purchase rate?

The revenue split weights by dollars; repeat purchase rate counts customers. A small number of high-spending returning customers can lift the revenue split without moving the customer-count metric much. They answer different questions: repeat purchase rate asks what share of customers come back, while the revenue split asks how much of your money depends on them. Read both together for a complete retention picture.

Conclusion

The new vs returning split is a health check you can run monthly from one export. Build it by tagging each order against the customer's first-order date, compare returning share to the band for your store's age, and watch the absolute dollars in both columns to tell healthy growth from a leaky bucket or stalled acquisition.

For the wider method, see the customer segmentation guide. To act on a weak retention read, work through the D2C retention playbook and check what is a good repeat purchase rate.