Shopify · Analytics · Growth

Most stores obsess over new customers. The stores that actually grow rich obsess over the ones they already have.

The Metric Most Store Owners Are Sleeping On

LTV — lifetime value — is the total revenue a single customer generates for your business across every purchase they ever make with you. It sounds simple. But the implications of truly understanding it are enormous.

Here's the short version: if you have to keep hunting for new customers to stay alive, you're going to spend most of your potential profit on marketing. The stores that become genuinely profitable are the ones that get a customer once — and then get them to come back again and again, without spending much to make that happen.

Watch the full walkthrough — then grab the free tool below to run the analysis on your own store.

That kind of multiplier is where the real money in e-commerce lives. And most businesses never measure it.

Why Most Stores Leave Money on the Table

The typical Shopify store optimizes its ads for the first purchase. Which product gets the click. Which audience converts. Which campaign has the lowest cost-per-acquisition. All of that matters — but it's only half the picture.

The other half: what happens after that first purchase? Does the customer come back? If so, how quickly, and for how much? The answers change which products you should be pushing, which channels you should be spending on, and how much a new customer is actually worth to you.

The problem is that without an LTV analysis, you can't see this. You might be pouring budget into a product or channel that brings in first-time buyers who never return — and unknowingly underfunding the products that drive your most loyal customers.

The Shopify LTV Curve: What It Is and What It Shows You

An LTV curve is a cohort-based visualization. It groups customers by the month they first purchased, then tracks how much cumulative revenue each cohort generates over time. The result is a series of lines on a chart — one per cohort — that flatten out as customers stop buying, or keep climbing as they come back.

A healthy LTV curve rises steadily after month zero. A flat curve means customers are buying once and not returning. The difference between those two scenarios can be the difference between a business that scales and one that's constantly running to stay in place.

Filtering by product reveals even more. A product with a rising LTV curve is pulling customers back into your ecosystem. A product with a flat one — even a bestseller — might be a one-and-done purchase that's quietly hurting your retention metrics without you realizing it.

How to Build Your Own Shopify LTV Curve

We've built a free Google Sheets tool that calculates your LTV curves automatically. Get access to the free tool here → Then follow these steps:

1. Duplicate the Google Sheet

   Make your own copy. Only edit the two yellow tabs: Shopify Raw and LTV Dashboard. Everything else contains formulas — don't touch those.

2. Export your raw data from Shopify

   In Shopify Analytics, open a New Exploration and switch to the ShopQL query editor (use the arrow, not the AI chat box). Paste in the provided query, run it, then export as a CSV.

3. Paste your data into the Shopify Raw tab

   Use Paste Special → Values Only to avoid formula conflicts. Check that columns align with the headers in the sheet. Watch for scientific notation on long ID numbers — reformat those as plain numbers before pasting.

4. Wait for the formulas to calculate

   You'll see a "Calculating formulas" bar in Google Sheets. Let it finish — this can take a minute depending on the size of your data.

5. Check the Control Panel

   Confirm your products, channels, and months of data are showing up correctly. This is your sanity check before reading the charts.

6. Explore the LTV Dashboard

   You'll see cohort curves, gross margin LTV by quarter, and cumulative curves. Filter by product or channel to find what's actually driving retention — and what's not.

A Note on Shopify Plan Compatibility

The tool includes two different ShopQL queries: one for newer or higher-tier Shopify accounts, and a simpler fallback for older or lower-tier plans. If the first query throws an error — which often happens around attribution columns or return types — try the second. Shopify's data schema varies more than you'd expect across versions and plans.

For larger accounts, add a date range to your query or the export will be unwieldy. And remember: the bigger your data, the more meaningful your curves will be. If you only have a handful of orders, month cohorts may be too small — use the quarterly cohort view instead for more reliable sample sizes.

How to Actually Use This Information

Once your curves are built, the analysis starts. Here's where to focus:

Compare products side by side. Which ones have rising LTV curves? Those are your real growth drivers — the products that pull customers back. Make sure your ads are pushing those, not just your highest-volume SKUs.

Look at your acquisition channels. Filter the dashboard by traffic source. An organic Google customer who comes back twice is worth more than a paid social customer who churns after one order — even if the initial purchase values are identical. LTV changes the math on channel ROI completely.

Realign your optimization targets. If you're currently optimizing campaigns for first-purchase conversions, consider shifting toward the products and channels that produce your highest-LTV customers. The short-term CPA might look slightly worse. The long-term profit will not.