How-to
How to Calculate Customer Lifetime Value for Ads in 2026
Last Updated: November 8, 2026
Quick Summary
To calculate customer lifetime value for ads, use the formula: (average order value × purchase frequency × customer lifespan) minus customer acquisition cost. Pull each input from a full year of your own sales records, then divide ad spend by new customers won to get acquisition cost.
- Average order value equals total revenue divided by the number of orders in the same period.
- Purchase frequency is total orders divided by the number of unique customers.
- Customer lifespan is the years between first and last purchase, averaged across customers.
- A CLV to CAC ratio of 3 or higher gives healthy room to scale ad spend.
- Counting leads as customers makes acquisition cost look artificially low and skews your ratio.
Table of Contents
- Why Customer Lifetime Value Decides Which Ads You Should Keep
- The Customer Lifetime Value Formula, Step by Step
- Customer Lifetime Value Examples for Service and Subscription Businesses
- When to Use a Customer Lifetime Value Calculator Instead of a Spreadsheet
- Using the CLV to CAC Ratio to Set Your Ad Budget
- Common Mistakes That Skew Your CLV Numbers
- Book a Free Consultation to Review Your Ad ROI
- Frequently Asked Questions
Why Customer Lifetime Value Decides Which Ads You Should Keep
Customer lifetime value is the total profit a customer brings your business over the whole time they buy from you.
Most owners judge ads by the first sale. That is the wrong scoreboard.
A plumbing company that wins a repeat maintenance customer gets years of work from one click. A one-time buyer gets a single invoice.
The math is simple once you see it.
The Customer Lifetime Value Formula, Step by Step
The customer lifetime value formula is: customer lifetime value = (average order value × purchase frequency × customer lifespan) - customer acquisition cost. Each input comes from your own sales records, not from industry guesses.

Work through the three steps below in order. Use one year of sales data to start.
Step 1: Pull Average Order Value From Your Sales Data
Average order value is total revenue divided by the number of orders in the same period. Use a full year if you have it, because seasonal swings distort short windows.
- Total revenue: everything invoiced in the period
- Order count: number of separate purchases or jobs
- The math: revenue ÷ orders = average order value
Step 2: Measure Purchase Frequency and Customer Lifespan
Purchase frequency is orders per customer per year. Customer lifespan is how many years a typical customer stays.
- Frequency: total orders ÷ number of unique customers
- Lifespan: years between first and last purchase, averaged across customers
If those 400 jobs came from 200 customers, frequency is 2.0. If customers stay about three years, lifespan is 3.
Step 3: Subtract Acquisition Cost From Ads
Customer acquisition cost from ads is total ad spend divided by the customers those ads produced. This is where most spreadsheets go wrong, because owners count leads instead of closed customers.
- Ad spend: platform spend plus management fees
- New customers won: closed deals traced to ads
- The math: spend ÷ new customers = acquisition cost
Now put it together. Average order value $600 × frequency 2.0 × lifespan 3 = $3,600 in revenue per customer.
Here are the three inputs the formula uses, where each one comes from, and how to calculate it.
| Input | Where it comes from | How to calculate it |
|---|---|---|
| Average order value | One full year of sales data | Total revenue ÷ number of orders |
| Purchase frequency | Orders per customer per year | Total orders ÷ number of unique customers |
| Customer lifespan | Years between first and last purchase | Averaged across customers |
| Acquisition cost | Platform spend plus management fees | Ad spend ÷ new customers won |
Customer Lifetime Value Examples for Service and Subscription Businesses
Customer lifetime value examples look very different by business model. The formula is the same; the inputs behave differently.
A residential cleaning service. Average order value $150, frequency 12 visits a year, lifespan 4 years. Revenue per customer is $7,200. Even a high acquisition cost leaves room to bid aggressively on repeat-clean keywords.
A subscription software company. Average order value $80 a month, frequency 12, lifespan 30 months. Revenue per customer is $2,400.
A construction contractor. Average job value $12,000, frequency 0.2 jobs a year, lifespan 5 years. Revenue per customer is $12,000. One referral from that customer may double it.
For small businesses wanting practical ways to raise these numbers, our guide on how to improve customer lifetime value for small businesses covers retention and repeat-purchase tactics.
When to Use a Customer Lifetime Value Calculator Instead of a Spreadsheet
A customer lifetime value calculator is a simple tool that runs the formula for you once you enter average order value, frequency, lifespan, and acquisition cost.
Most guides stop there. The gap they miss is a beginner-friendly workflow with free tools, a way to prioritize which inputs matter most, and a before-and-after example so you can see what a good answer looks like.
A Free-Tool Workflow You Can Finish in One Sitting
You do not need paid software to get a defensible CLV number. A common pattern among small operators is to use three free tools in sequence:
- Export your sales data. Pull a full year of orders from your accounting or point-of-sale system into a CSV. If you use a free spreadsheet app, open the CSV there so you can sort and filter.
- Build the four inputs in one sheet. Create columns for order date, customer ID, order total, and source (ad vs. organic vs. referral). Add two formula columns: one that counts orders per customer and one that flags the first and last order date per customer.
- Run the formula in a calculator for a quick check. Enter average order value, frequency, lifespan, and acquisition cost into any free CLV calculator to get a single number. This is your sanity check, not your final answer.
- Cross-check against the spreadsheet. If the calculator and the spreadsheet disagree by more than a small margin, the difference is almost always in how customers are counted, duplicate customer IDs, guest checkouts, or refunds not netted out.
Watch out: most free calculators ship with sample inputs (often a subscription-style default) that have nothing to do with your business. Overwrite every field before you trust the output.
Prioritize the Inputs by Impact
Not all four inputs move the answer equally. A tiered approach keeps beginners from over-engineering the wrong number:
- Essential first: average order value and acquisition cost. These two are the easiest to pull from records and they swing the CLV-to-CAC ratio the most.
- Next: purchase frequency. This requires clean customer IDs, so it is worth the extra sorting step.
- Advanced: customer lifespan and gross margin. Lifespan needs enough history to average, and margin needs delivery-cost data. Add these once the first three are solid.
Before-and-After Example
Suppose a home-services company starts with a calculator default of $100 average order value, frequency 1, lifespan 1, and acquisition cost $50.
After replacing the defaults with real inputs, average order value $600, frequency 2.0, lifespan 3, acquisition cost $900, the same calculator returns $3,600 in revenue per customer and a ratio of 4.0. Same tool, same formula, completely different decision.
A Simple Way to Verify the Result
Once you have a number, connect it back to observable outcomes. Pick one campaign, record the CLV and ratio you calculated, then check after 30 and 60 days whether the campaign's closed-customer count and average order value match what you assumed. If they drift, update the inputs rather than the formula. This measurement loop is what separates a number you can defend from a number you guessed.
Using the CLV to CAC Ratio to Set Your Ad Budget
The CLV to CAC ratio compares customer lifetime value to acquisition cost.
- Ratio below 1: you lose money on every customer
- Ratio around 2: workable, but thin
- Ratio of 3 or higher: healthy room to scale
Say lifetime value is $3,600 and acquisition cost is $900. The ratio is 4.0. You can afford to bid more, expand to broader keywords, or test new channels.
If the ratio is 1.2, do not scale. Fix retention or tighten targeting first. Scaling a weak ratio just loses money faster.
For a full walkthrough of the math behind agency spend, see our guide on calculating ROI for agency services. And if you want a team to run the Google Ads side with this analysis built in, our Google Ads management service is where we apply it.
Common Mistakes That Skew Your CLV Numbers
Most bad CLV numbers come from a handful of repeatable errors. Watch for these before you make any budget decision, and fix them in the order below, the first two distort the answer the most.
The High-Impact Errors
- Counting leads as customers. Leads are not revenue. Only closed deals belong in acquisition cost. If you divide ad spend by leads instead of closed customers, acquisition cost looks artificially low and the CLV-to-CAC ratio looks artificially healthy.
- Using one month of data. Seasonality swings average order value badly. A single strong month can double the average order value and make every campaign look profitable. Use a full year, or at minimum four full quarters, before you set a budget.
- Ignoring gross margin. Revenue per customer is not profit per customer. Subtract delivery costs, materials, labor, hosting, fulfillment, before you compare CLV to acquisition cost. A $3,600 revenue figure can be a $1,200 margin figure, and that changes which campaigns survive.
The Subtler Errors
- Forgetting referrals. A happy customer who refers two more is worth far more than the formula shows. If you track referral source, add referred revenue to the customer's value; if you do not, at least note that your CLV is a floor, not a ceiling.
- Mixing customer types. A one-time buyer and a repeat client should never share one average. Segment by service line or plan tier before you average, or the blended number will mislead you on both ends.
- Trusting default calculator inputs. Sample inputs are the most common source of a wrong first answer. Overwrite every field with your own records.
The Sneakiest One: Attribution
Attribution is the error that hides best. If your ads get credit for sales they did not cause, a branded search click after an organic visit, a retargeting touch after an email, acquisition cost looks better than it is and CLV looks higher than it is. The fix is to compare ad-attributed customers against a control group or a holdout, and to check whether the same customer appears in more than one channel's report. Our guide on PPC attribution models explains how to check that.
A Before-and-After Check
Run your numbers twice: once with leads counted as customers and one month of data, and once with closed deals, a full year, and gross margin applied. If the two ratios differ by more than a small margin, you have found your error. The corrected number is the one you should use to set bids and budgets, and the one you should re-check every quarter as your data changes.
Book a Free Consultation to Review Your Ad ROI
You now have the formula, the worked examples, and the mistakes to avoid. The next step is applying it to your own numbers with someone who reads them every week.
That is what we do at Real Web Marketing Inc. Whether the fix is tightening your Pay Per Click Ad Management or improving the landing pages those clicks land on through Web Design, the goal is the same: a CLV number you can defend and campaigns that earn their budget.
If you are spending on ads and cannot say what a customer is worth, start there. Find out what is holding back your leads and sales with a free consultation.
Running ads without knowing your customer lifetime value is guessing with real money.
Frequently Asked Questions
Should customer lifetime value be calculated using revenue or profit?
Use profit when you can. Revenue-based customer lifetime value looks bigger, but profit tells you what an ad campaign actually earns after delivery costs, materials, and service time. A job with a $4,000 average value might keep only part of that as gross profit, so a $600 acquisition cost looks very different against profit than against revenue. If you only have revenue figures handy, run the calculation that way first, then redo it with margin once your bookkeeper provides it. The profit version is the number that should drive your ad budget.
What is a good CLV to CAC ratio for advertising?
A CLV to CAC ratio of 3:1 is the common benchmark: every dollar spent acquiring a customer returns about three dollars in lifetime value. Below 1:1, ads lose money. Between 1:1 and 3:1, campaigns work but leave little room for error. Above 3:1, you may be underspending and could scale. These are general guideposts, not rules. A business with very tight cash flow may need a higher ratio, while a subscription company with low churn can accept lower. Track your ratio monthly and compare it against your own history before chasing an outside number.
How long should the customer lifetime value measurement period be?
Match the period to how often customers actually return. A plumbing company with emergency calls every few years should measure over three to five years. A monthly subscription should use the average subscription length, often 12 to 24 months. A retail or e-commerce business might use 12 months. Pick one period, apply it consistently, and note it next to the number so you can compare quarters fairly. Changing the period between reports is one of the fastest ways to make a weak campaign look strong.
How do you calculate customer lifetime value for a subscription business?
For subscriptions, start with monthly recurring revenue per customer, then divide by your monthly churn rate. If a customer pays $150 a month and 5% cancel each month, average lifespan is 20 months, giving $3,000 in lifetime revenue before costs. Subtract acquisition cost from ads to get the net figure. Use a calculator or spreadsheet to rerun this each month as churn shifts. A small churn change moves lifetime value a lot, which is why retention work often beats raising ad spend.