Paid Campaign Break-Even Calculator

What this tool does

CM8-372 answers one question before any money is spent: what would this campaign have to achieve to be worth running? It works backwards from your margin to the most you could pay for a customer, then to the most you could pay for a click, then to the conversion rate that would be required at the click cost you actually expect.

Everything runs inside this single file — no account, no upload, no network request of any kind.

Working backwards from the money

Most campaigns are planned forwards: pick a budget, guess a return, launch, and find out. This works the other way, which produces a much more useful conversation — not "how did it do" but "what has to be true for this to work at all", asked while it is still cheap to change the answer.

The CPA ceiling

The most you can pay for a customer and not lose money. Everything else follows from it, and it is worth knowing for every product you sell even when you are not advertising.

Fees divide into it rather than being ignored: a 12% agency fee reduces what you can afford to pay the platform by 12%, and a campaign that breaks even on media alone loses money once the fee is paid.

The profit target sets a second, lower ceiling. Break-even is where you stop losing money, not where a campaign is worth the effort of running — it still has to cover the overheads that are not in the gross margin, and there is no reason to do the work for nothing.

The click ceiling

This is the number to take into the platform, because it is directly comparable with the cost per click the platform will quote you. If the estimated cost per click is above the ceiling, the campaign cannot work at the conversion rate you assumed, and nothing you do to the bidding will fix that.

It also makes the leverage of conversion rate obvious. Doubling the conversion rate doubles what you can afford to pay for a click — which is why an afternoon on the landing page is often worth more than a month of bid management.

The conversion rate needed

The same question asked from the other end: at the cost per click you expect to pay, what share of clicks must convert for the campaign to break even?

This is the version to use when the click cost is not really under your control — competitor terms, a thin market, a platform with a floor price. It converts an abstract judgement into a concrete one: is 4.4% achievable on this page, for this traffic? Somebody who knows the site can answer that.

Headroom

The margin between what you need and what you expect. This is the number that decides whether a campaign is a plan or a gamble.

Under 30% headroom, a campaign will be decided by things nobody controls: a seasonal dip, a competitor bidding up the auction, a slightly worse landing page than the one the estimate came from. It may still be worth running — but it should be run as a test with a stop date, not as a budget line.

How far ahead to count profit

Three choices, and they produce very different answers:

• First order only — the strictest and the safest. A campaign that clears this pays for itself immediately and costs nothing in working capital.
• First year — reasonable for a business with genuine repeat purchase and the cash to wait.
• Whole life — only defensible with real retention data, and even then the cash question does not go away.

The tool shows the first-order ceiling separately in the stacked chart, and flags any campaign that works only if repeat business arrives. That is not a warning against running it — plenty of good businesses acquire at a first-order loss — but it is a different decision, and it is a finance decision as much as a marketing one.

The sample includes the same campaign judged both ways: on the first order it cannot break even, and over a year it clears the target comfortably.

The haircut on future profit

Profit beyond the first order is discounted before it counts, at the rate you set. Thirty percent by default, for three reasons: repeat rates measured in the past are usually optimistic about the future, customers won on a promotion repeat less than customers won organically, and money in a year is worth less than money now.

The campaign in the sample with no first-order revenue at all — a free first month — is the case where this matters most. Its entire ceiling rests on a figure nobody can verify until much later.

Fixed costs and why small tests fail

Creative, photography, a landing page and setup time are spent whether the campaign works or not. The question is whether the campaign will run at a scale that recovers them.

The sample has a video campaign with nine thousand of production against a twelve thousand media budget: recovering the video needs far more spend than is planned, so the test cannot pay for itself however well it performs. The honest options are to commit more, spend less on production, or not run it.

This is the most common way small tests of expensive campaigns fail, and it is entirely predictable before launch.

Reading the sensitivity table

For every campaign that does not clear the target, the table shows what each of the three levers would have to reach on its own: the conversion rate, the cost per click, or the order value.

Each column assumes the other two hold. That is the point — it turns "this does not work" into three specific, checkable questions. If none of the three is a small change, the campaign should not run, and the table says so.

In practice the levers move together and usually in the wrong direction: pushing for a lower cost per click means broader targeting, which lowers the conversion rate.

Use it before, not after

The value of this tool is entirely in the timing. Run every campaign through it before committing, and record the ones you rejected along with why — a rejected campaign with its numbers written down is worth revisiting when margin improves or the market changes, and it stops the same idea being re-proposed every quarter.

What this cannot tell you

• Whether the conversion rate you expect is achievable. That is a judgement about your site and your audience, and it is the input everything depends on.
• Whether the platform's estimated cost per click will hold. It usually rises once you are actually bidding.
• Anything about volume. A campaign can clear every threshold and reach forty people.
• Whether a campaign helps others. Prospecting that fails on its own numbers may be what makes retargeting work.
• Whether the customers it wins are the ones you want.

Printing and sharing

The Report tab prints the tiles, charts and both tables with a title block you fill in. The thresholds table is a good approval document: it shows what was assumed, so a campaign that later fails can be compared against what it needed rather than argued about.

Saving your work

Campaigns are held in this browser, on this computer, and stay there between visits. Use the backup button to write a JSON file you control.

Accuracy & disclaimer

Every threshold here is arithmetic on figures you supplied. The arithmetic is reliable; the figures are estimates, and the tool takes no view on whether any of them is achievable.