What does customer lifetime value tell you?

Customer lifetime value, shortened to CLV or LTV, estimates customer spending across the relationship. It helps you consider the benefits of acquiring and retaining customers together. Shopify describes both the definition and its business use.

Label revenue and profit separately

The calculation in this guide uses revenue. Some businesses use margin or profit in their LTV calculation instead, so the label matters when comparing reports. Shopify explicitly distinguishes these approaches.

Write “revenue-based CLV” above your worksheet. Add separate lines for product costs and acquisition spending before deciding what you can afford. Ask anyone presenting a benchmark which definition they used.

Separate observed spending from a forecast

Historical CLV uses past purchases. Predictive CLV estimates future value using previous activity and other signals. HubSpot explains this distinction.

Keep two columns: what customers have already spent and what you expect them to spend later. Label the assumptions behind the second column. When you share the report, show both rather than presenting the forecast as money already earned.

How do you build the CLV formula from your orders?

Choose a reporting period, then gather revenue, orders and unique customers for that period. Calculate the inputs below before estimating lifespan. The definitions and formulas follow Shopify's CLV guide.

Follow a worked example

Shopify gives an illustrative clothing store example: an average purchase of $50, three purchases a year and a two-year relationship. The calculation is $50 × 3 × 2 = $300. These are teaching figures, not a promise about your store. See the original example.

Replace every input with your own records or a clearly marked assumption. Do not borrow the example's lifespan simply because the final number looks reasonable. Write a short explanation beside any input you cannot yet verify.

Make the worksheet easy to check

• Use one customer identifier across orders.
• Keep the purchase date beside each transaction.
• Document how cancellations and refunds are handled.
• Keep the source data separate from calculation cells.
• Record the reporting period above the table.

For the first version, use an Excel or Google Sheets worksheet. Shopify Analytics and customer relationship management systems, commonly called CRMs, are also options for calculating these inputs. Shopify names those options in its guide.

Before automating anything, select a customer and check their orders against the report manually. If you cannot explain the calculation from the underlying records, resolve that first. Save automation for a repeatable process.

What counts as a good LTV to CAC ratio?

Around 3:1 is a common reference point. Customer acquisition cost, or CAC, is acquisition-related sales and marketing spending divided by new customers acquired. Divide LTV by CAC to calculate the ratio. Shopify provides these formulas and the benchmark.

Include the spending behind the acquisition

CAC can include advertising, sales expenses, salaries and marketing tools. Counting only advertising gives you a narrower measure than the full calculation described by Shopify.

Ask your marketing team to list the included costs before discussing performance. Use new paying customers as the denominator, and document how you assign shared costs. Keep that method consistent between channel reports.

Check margin before increasing the budget

In Shopify's illustrative example, $300 in lifetime revenue at a 50% gross margin leaves $150 before acquisition and other costs. Gross margin is the share remaining after product costs. With CAC of $50, the revenue-based ratio is 3:1, but other expenses still need coverage. See the margin example.

Use your report to ask when customer payments arrive as well as how much you expect. Keep a separate spending limit based on available cash. The companion guide to managing small business cash flow helps structure that review.

For ecommerce, Shopify's article gives different ranges in different places: its introduction says 2:1 to 4:1, while the main discussion says 3:1 to 4:1. Treat these as rough guidance, not a universal industry target. Check the source's wording before citing a range in your own presentation.

How should subscriptions and limited history be handled?

Match the calculation to how customers pay. For a monthly subscription, apply the basic formula using average monthly customer revenue and an estimated number of paid months. This is a monthly version of the standard CLV formula.

Keep billing status visible

In a hypothetical cleaning subscription, record paid months, pauses and cancellations separately. Do not count a free trial as a paid month in this version of the calculation. Check the billing records before estimating the relationship length.

Include churn among your subscription business metrics. Churn means customers stopping their subscription or purchases over time, as described by Shopify. Review the reasons behind departures alongside the total.

To organise the payment process itself, use the guide to automating recurring billing. Keep the calculation's definition of a paid customer consistent with the billing records.

Use assumptions openly when history is short

For a new business, Shopify suggests a conservative lifespan assumption based on early patterns, refined as evidence grows. Its guidance for new businesses is a starting point, not permission to invent certainty.

Prepare a cautious case and a more optimistic case without presenting either as a measured result. Ask whether your proposed acquisition spending still makes sense under the cautious case. If the answer changes completely, gather more history before making a larger commitment.

Which customer retention strategy should you test first?

Choose the problem customers actually experience. Product quality, service, loyalty offers and timely messages are among the retention approaches described by Shopify. Start with one relevant intervention.

For a hypothetical online coffee shop, inspect why first-time buyers have not reordered. Review complaints and product questions before drafting a discount email. Use a customer journey map to lay out the steps from delivery to the next purchase.

Match the action to the obstacle

• Unclear usage instructions: rewrite the after-purchase guidance.
• Unresolved service issue: resolve it before making another offer.
• Relevant replenishment need: test a timely reminder.
• Useful complementary product: test an appropriate recommendation.

For reminders, separate recipients by their previous purchase and timing. The guide to segmenting an email list provides the next planning step. For customers who have stopped buying, build a focused customer win-back plan.

Define your repeat purchase rate before the test: specify which customers enter the group and how long you will observe them. Count those who purchase again within that window. Keep the same rule for both the starting report and the follow-up review.

What should your first weekly review include?

Bring one calculation, one uncertainty and one proposed action. Keep the first review focused enough that someone can leave with a clear task.

1. Reconcile the records. Check orders, customers and revenue against the source.
2. Inspect the assumptions. Highlight estimated lifespan and incomplete information.
3. Compare acquisition costs. Confirm which expenses were included.
4. Choose an experiment. Assign an owner and write the intended customer benefit.
5. Set the review rule. Record when you will check repeat purchases and costs again.

Compare groups over equivalent observation periods. Avoid judging a newly acquired group against customers with a much longer purchase history. Put the observation window in the report title so the comparison stays visible.