Business, Marketing & E-commerce Advertising, Email & Channel ROI Marketing Metrics (Farris et al.) funnel arithmetic

Ad Budget Forecast Calculator

Set a conversion goal and this calculator runs the paid-media funnel backwards to the money. It divides your goal by your conversion rate to get the clicks you must buy, multiplies by your average cost per click to get the budget, divides by your click-through rate to get the impressions that budget must earn, and then checks the result against order value and gross margin so you can see whether the campaign pays for itself before you commit a cent. Every intermediate figure is shown, so you can argue with any assumption individually rather than with the total.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Conversions you needSales, leads or signups the campaign must produce in the period — whatever your conversion action is.100
Landing page conversion rateConversions divided by clicks for this traffic source — not by sessions or by users.2.5 %
Average cost per clickWhat you actually pay per click on this campaign, taken from the last full month of delivery.2.5 $
Click-through rateClicks divided by impressions; used only to size the impression volume the plan implies.3 %
Average order valueRevenue per conversion. For lead generation, enter the expected revenue per lead rather than per closed deal.120 $
Gross marginRevenue less cost of goods, as a percentage — this is what the ad spend is actually paid out of.60 %

It returns

  • Ad budget required — Clicks required multiplied by your average cost per click.
  • Clicks required
  • Impressions required
  • Cost per acquisition
  • Break-even cost per acquisition — Order value × gross margin — the most a conversion can cost before the campaign loses money.
  • Projected revenue
  • Projected ROAS
  • Gross profit after ad spend

The formula

B=Nr×CPC
I=N÷rCTR
CPABE=AOV×m

In plain text: Budget = (target conversions ÷ conversion rate) × cost per click

  • BAd budget required for the period ($)
  • NConversions the campaign must deliver (conversions)
  • rClick-to-conversion rate as a decimal (decimal)
  • CPCAverage cost per click on this campaign ($)

The budget depends only on the goal, the conversion rate and the click price. Click-through rate affects how many impressions must be bought to deliver those clicks, not what they cost.

Updated Category Advertising, Email & Channel ROI Verified against published test cases Reading time 11 min

Why you plan a budget backwards

A budget set forwards — "we can afford $10,000 a month" — tells you nothing about whether the campaign will work. A budget set backwards starts from the number the business actually needs and asks what has to be true for the media to deliver it. That reframing is the whole value of this calculator: it converts a vague affordability question into a list of specific, arguable assumptions.

The paid funnel is a chain of multiplications. Impressions become clicks at your click-through rate. Clicks become conversions at your landing page conversion rate. Conversions become revenue at your average order value. Run that chain forwards and you get a forecast; run it backwards and you get a requirement. Because every link is a multiplication, the requirement is a division at each step, and the arithmetic never gets harder than dividing by a decimal.

The output most people came for is the budget, but the output that most often changes a decision is the cost per acquisition compared with break-even. A plan can be perfectly executable — the impressions exist, the clicks are buyable — and still lose money on every sale. Seeing $150 of media against $60 of gross profit per order stops a campaign before it starts, which is far cheaper than discovering it in month two.

Note what the model deliberately excludes: creative production, agency fees, platform management time, and any lift the campaign gives to organic or direct traffic. It prices media only. Add the non-media costs separately when you present the number, or the total will be understated by whatever your agency charges.

The chain, one link at a time

Clicks required = conversions ÷ conversion rate. If you need 100 sales and 2% of clicks buy, you need 5,000 clicks. The rate must be measured click-to-conversion for the same traffic source. A site-wide conversion rate that mixes branded direct traffic with cold paid traffic will overstate paid performance, sometimes by several multiples, because branded visitors were already going to buy.

Budget = clicks required × cost per click. The click price is an auction outcome, not a constant, and it drifts with competition, quality score and match type. Use the last full month for the same campaign, and re-check it after any large budget increase — buying more volume usually means bidding on less efficient inventory. The cost per click calculator converts between CPC, CPM and click-through rate if your platform quotes you an impression price instead.

Impressions required = clicks required ÷ click-through rate. This link does not affect the budget on a click-priced buy — you pay per click regardless of how many impressions it took. It matters because it is a feasibility test: if the plan needs 4,000,000 impressions and the available inventory for your targeting is 1,000,000 a month, no budget makes the plan work and you need to widen the audience or lengthen the flight.

Break-even CPA = average order value × gross margin. This is the ceiling. Media is paid out of gross profit, not out of revenue, so a $120 order at a 60% margin can support at most $72 of acquisition cost before the sale contributes nothing. Comparing your planned CPA against this figure is the single most useful check in the model. If you acquire customers who buy repeatedly, the honest version of the ceiling uses customer lifetime value rather than a single order — but then you are funding acquisition out of future cash, which is a financing decision as much as a marketing one.

Worked example: 100 sales at a 2% conversion rate

You need 100 sales next month. Paid search converts at 2% of clicks, your average cost per click is $2.00, the campaign's click-through rate is 4%, your average order value is $100 and your gross margin is 100% because you sell a digital product with no unit cost.

  1. Clicks. 100 ÷ 0.02 = 5,000 clicks.
  2. Budget. 5,000 × $2.00 = $10,000.
  3. Impressions. 5,000 ÷ 0.04 = 125,000 impressions.
  4. Cost per acquisition. $10,000 ÷ 100 = $100. You can also get this directly: $2.00 ÷ 0.02 = $100, since CPA is always CPC ÷ conversion rate.
  5. Break-even CPA. $100 × 100% = $100.
  6. Verdict. Revenue is 100 × $100 = $10,000, so ROAS is $10,000 ÷ $10,000 = 1.0× and gross profit after media is $10,000 − $10,000 = $0. The plan exactly breaks even.

Now vary the assumption most likely to be wrong. If the conversion rate is 2.5% rather than 2%, clicks fall to 100 ÷ 0.025 = 4,000 and the budget falls to $8,000 — a 20% reduction from a half-point improvement, because 2.5 ÷ 2 = 1.25 and the budget scales with the reciprocal. If the rate is 1.5% instead, clicks rise to 6,667 and the budget rises to $13,333, which is 33% more than the plan. That asymmetry — the downside is larger than the upside for an equal-sized move in the rate — is the reciprocal at work, and it is the main reason to plan with a rate you have measured rather than one you hope for.

Reading the plan before you fund it

Start with cost per acquisition against break-even. If planned CPA sits above break-even, the campaign destroys gross profit on every sale and no amount of scale fixes it; the fixes are a higher conversion rate, a lower click price, a higher order value or a better margin, and you should name which one you are betting on. If planned CPA sits below break-even, the difference is the gross profit each conversion contributes towards fixed costs.

Then check ROAS against your own required threshold rather than against a generic target. The break-even ROAS is 1 ÷ gross margin: at a 60% margin you need 1 ÷ 0.6 = 1.67× just to cover the cost of goods and the media, and at a 25% margin you need 4.0×. A campaign running at 3× is excellent in the first business and loss-making in the second. The ROAS calculator works this threshold out for whatever margin you carry.

Then test feasibility on impressions. Compare the impression requirement against what the platform's forecasting tool says is available for your targeting and geography. A plan that needs more impressions than exist is not a budget problem — it is a targeting problem, and the answer is usually a second channel rather than a bigger bid.

Finally, treat every input as a range rather than a point. The sensitivity table on this page varies the conversion rate because that is the assumption with the widest error bars and the largest leverage, but you should run the same exercise on click price before a quarter-scale commitment. Present the budget as a band with the assumptions attached, and the conversation with finance becomes about which assumption to test first rather than about whether the number is trustworthy.

Budget needed for 100 conversions, by conversion rate and click price

Clicks needed = 100 ÷ conversion rate. Budget = clicks × CPC. Read down a column to see how much a conversion-rate improvement is worth at a fixed click price.
Conversion rateClicks neededCPC $0.50CPC $1.00CPC $2.00CPC $5.00
0.5%20,000$10,000$20,000$40,000$100,000
1%10,000$5,000$10,000$20,000$50,000
2%5,000$2,500$5,000$10,000$25,000
3%3,333$1,667$3,333$6,667$16,667
5%2,000$1,000$2,000$4,000$10,000
10%1,000$500$1,000$2,000$5,000

Cost per acquisition is the budget divided by 100 in every cell — for example $10,000 ÷ 100 = $100 at 2% and $2.00 a click, which equals CPC ÷ conversion rate.

Assumptions that break this model

  • Using a site-wide conversion rate for paid traffic. Branded and direct visitors convert far better than cold paid clicks. Segment the rate by source or the budget will be understated.
  • Assuming the click price holds as you scale. Extra budget buys progressively less efficient inventory. A large increase usually raises average CPC, so re-forecast after each material step up.
  • Pricing media out of revenue instead of gross profit. Break-even CPA is order value × margin. Comparing CPA to order value alone will approve campaigns that lose money on every sale.
  • Forgetting the non-media costs. Creative, agency retainer, landing page work and tooling sit outside this budget. Add them before presenting a total, or your true cost per acquisition is higher than the model says.
  • Ignoring the lag between click and conversion. If your sales cycle is 30 days, a month's spend produces conversions that land in the following month. The budget is right; the timing of the return is not.
  • Treating the impression figure as a cost. On a click-priced buy, impressions are a feasibility check only. On an impression-priced buy the budget is impressions ÷ 1,000 × CPM instead, which is a different calculation.

Where this sits among the other planning tools

This calculator prices a channel against a conversion goal. Two adjacent questions need different tools. If your goal is revenue rather than conversions and you want to know how much traffic — paid or otherwise — is required, use the traffic needed for revenue goal calculator, which starts from the revenue number and works through order value first. If you already have spend and results and want to grade what happened rather than plan what should, use marketing ROI or cost per acquisition.

Platform forecasting tools answer a narrower question well: Google's Performance Planner and the equivalent tools in other platforms model the auction, so they can tell you how conversions respond to bid and budget changes on inventory they can see. What they cannot do is apply your gross margin, your non-media costs or your repeat-purchase economics. Use the platform for the auction and this model for the business case; they are complements, not substitutes.

Once a campaign is live, the assumption to update first is always the conversion rate, because it is the one you measure fastest and the one with the largest leverage on budget. Update the click price second and the click-through rate last, since the last of the three does not move the money on a click-priced buy at all. For a subscription business, replace order value with first-period revenue and check the result against the CAC payback period calculator, because the relevant question there is not whether the first order pays for the click but how many months of margin it takes to get the cash back.

Frequently asked questions

How much should I spend on ads?

Enough to buy the clicks your conversion goal requires, provided the resulting cost per acquisition stays below your break-even figure of order value × gross margin. That is the only defensible answer, because a percentage-of-revenue rule ignores whether the media actually pays. Work out the required budget from the goal, compare CPA to break-even, and if the plan is loss-making, fix the conversion rate, the click price or the order value before increasing the spend.

How do I calculate the ad budget for a sales target by hand?

Divide the sales target by your conversion rate as a decimal to get clicks, then multiply by your average cost per click. For 100 sales at a 2% rate and $2.00 a click: 100 ÷ 0.02 = 5,000 clicks, and 5,000 × $2.00 = $10,000. A useful shortcut for the unit economics is that cost per acquisition equals CPC ÷ conversion rate, so $2.00 ÷ 0.02 = $100 per sale without computing the total at all.

What conversion rate should I use if I have no data?

Use a range rather than a point, and treat the plan as a test rather than a forecast. Run the calculator at a pessimistic rate and an optimistic one — the sensitivity table on this page is built for exactly this — and fund the first month at the pessimistic budget with the explicit goal of measuring the real rate. Borrowing a published average for your industry imports a number whose underlying sample you cannot inspect, and the leverage of this assumption on the budget is too high for that.

Does the click-through rate change the budget?

Not on a click-priced buy. You pay per click, so the budget is clicks × CPC regardless of how many impressions those clicks took. Click-through rate determines the impression volume required, which is a feasibility test against available inventory, and it influences quality-score-based pricing on some platforms indirectly. On an impression-priced buy the relationship reverses: there the budget is impressions ÷ 1,000 × CPM, and CTR sets your effective cost per click.

What is break-even CPA and why does it use gross margin?

Break-even CPA is the most a conversion can cost before it stops contributing anything, and it equals average order value × gross margin. Media is paid out of gross profit, not out of revenue: if a $120 order costs $48 in goods, only $72 is available to buy the customer. Comparing acquisition cost against the full $120 would approve campaigns that lose $48 on every sale while appearing to be well inside budget.

What ROAS do I need to break even?

1 ÷ gross margin. At a 60% margin you need 1.67× to cover goods and media; at 25% you need 4.0×; at a 100% margin you break even at 1.0×. This is why a headline ROAS target copied from another company is unusable — the same 3× is comfortably profitable for a software business and a loss for a low-margin retailer. Compute your own threshold first, then judge the campaign against it.

Should I plan against lifetime value instead of first order value?

You can, and for subscription or high-repeat businesses you should, but understand what changes. Using lifetime value raises the break-even ceiling and permits a much higher acquisition cost, which is correct economically and demanding financially: you are paying cash today for margin that arrives over months or years. Check the cash consequence separately with a payback-period calculation, and use a gross-margin lifetime value rather than a revenue one so the two sides of the comparison are consistent.

Why does my actual cost per click rise when I increase the budget?

Because the cheapest inventory is bought first. Additional budget is spent on broader keywords, wider audiences, worse placements and more competitive auctions, all of which clear at higher prices. The effect is real enough that a budget doubling rarely doubles conversions. Re-measure the average click price after each material increase and re-run the plan rather than extrapolating from the rate you saw at the smaller spend.

Does this include agency fees and creative costs?

No — the budget it returns is working media only. Production, agency retainers, management fees, landing page development and tooling all sit outside the model and can add a substantial amount to the true cost per acquisition. Add them as a separate line when you present the plan, and if you want a fully-loaded acquisition cost, include them in a customer acquisition cost calculation rather than in this one.

References