An ad can attract interested people and still cost more than the resulting orders contribute. According to Eurostat, 77% of EU internet users bought or ordered goods or services online for personal use in the 12 months before the 2024 survey. That shows how common online shopping is, but it does not predict whether someone who clicks your ad will buy.
Your maximum cost per click, or CPC, is the most you can afford to spend on an ad click while meeting a financial target. A click is a person's choice to follow an ad; CPC measures the advertising spend for that action. This guide calculates break-even and target CPC from order contribution, tests three conversion assumptions, and provides a CSV worksheet.
Start with contribution, not order value
A store can report an order worth USD 300 without having that amount available for advertising. Suppose product costs are USD 150, delivery costs are USD 25, payment costs are USD 12, and the expected refund reserve is USD 18. This hypothetical order contributes USD 95 before advertising, not USD 300.
Contribution per order means net sales minus costs that rise with that order. It is the amount available to cover advertising, fixed overhead and your profit target. Yale University's primer on break-even analysis explains this distinction between sales, variable costs and contribution.
You can calculate contribution for the products your ad actually promotes rather than use a store-wide average. A discounted item with expensive delivery may leave less than a higher-margin item, even when both sell at the same price. Matching the contribution figure to the advertised offer prevents a profitable product from hiding losses on another.
Set a maximum CPC from your own numbers
A campaign rate can look reasonable until you compare it with your conversion assumptions. Suppose your hypothetical order contribution is USD 95 and one in every 100 ad clicks leads to an order. The expected contribution is USD 0.95 per click before advertising costs, so a higher CPC would consume more than the orders contribute.
FastVisits is a Dubai-based pay-per-click ad network operated by Nomad Minds FZCO. Advertisers run ads on partner publisher websites and newsletters, and pay per click on their ads. The destination page starts loading with a source label. You can compare the per-click pricing information with your own calculated ceiling; rates depend on format, market and device, and are available on request. Billing terms are shown in your account before you pay.
Your affordable ceiling is a financial guardrail, not necessarily an account bidding setting. A maximum CPC bid, where a service offers bidding, limits what you offer for a click. A daily budget limits spending each day, but it cannot make an unprofitable click rate affordable.
For the hypothetical worksheet, all monetary values are in US dollars (USD). Net sales exclude tax collected for a tax authority, variable costs include a refund reserve, and fixed overhead is excluded from order contribution. The calculation follows these steps:
- Net sales per order: USD 300.
- Variable costs per order: USD 150 + 25 + 12 + 18 = USD 205.
- Contribution per order: USD 300 - 205 = USD 95.
- Click-to-order conversion rate: attributed orders divided by ad clicks, written as a decimal.
- Break-even CPC: contribution per order multiplied by click-to-order conversion rate.
- Target CPC: break-even CPC minus the amount you want to retain per click.
If you want to retain USD 0.20 per click before fixed overhead, the formulas are:
break-even CPC = contribution per order × click-to-order conversion rate
target CPC = break-even CPC - desired retained amount per click
A negative target means your desired retained amount exceeds expected contribution. It is not a usable spending rate. You can review the offer, conversion assumption or retained amount before committing a budget.
Test low, middle and high conversion assumptions
The main risk is treating an uncertain conversion rate as a fact. Suppose your low case is 0.5%, your middle case is 1.0%, and your high case is 2.0%. These hypothetical planning assumptions are not industry benchmarks, FastVisits rates or promised outcomes.
The table keeps contribution at USD 95 per order and the desired retained amount at USD 0.20 per click. The monetary columns use USD, with three decimal places where needed to show the arithmetic.
| Scenario | Conversion rate | Contribution per order | Expected contribution per click | Break-even CPC | Retained per click | Target CPC |
|---|---|---|---|---|---|---|
| Hypothetical low | 0.5% | 95.00 | 0.475 | 0.475 | 0.20 | 0.275 |
| Hypothetical middle | 1.0% | 95.00 | 0.950 | 0.950 | 0.20 | 0.750 |
| Hypothetical high | 2.0% | 95.00 | 1.900 | 1.900 | 0.20 | 1.700 |
At a hypothetical CPC of USD 0.60, 2,000 ad clicks cost USD 1,200. The low case implies 10 orders contributing USD 950, leaving a USD 250 shortfall after ad spend. The middle case implies 20 orders and leaves USD 700, while the high case implies 40 orders and leaves USD 2,600, all before fixed overhead.
You can choose a guardrail before ads run instead of choosing whichever case makes the campaign look attractive. A cautious decision uses the lowest credible case and pauses spending if the rate exceeds its target. Relevance matters because people respond to the offer and page, not to your spreadsheet's preferred outcome.
Build the worksheet with explicit cost treatment
A worksheet can produce a precise answer from inconsistent inputs. For example, entering a conversion rate of 1 instead of 0.01 changes a 1% assumption to 100%. The maximum CPC CSV worksheet separates inputs and formulas so you can review that risk.
The file contains low, middle and high hypothetical cases plus a blank row for your figures. Its input columns use one currency throughout, and the example CPC is not a FastVisits rate. These are the main fields:
| Column | What to enter or check |
|---|---|
| Net sales per order | Sales after discounts, excluding tax collected for remittance |
| Product, delivery, payment and refund costs | Costs that rise when an order occurs |
| Contribution per order | Net sales minus those variable costs |
| Click-to-order conversion rate | Attributed orders divided by ad clicks, as a decimal |
| Desired retained per click | Amount left after advertising, before fixed overhead |
| Break-even CPC | Contribution per order multiplied by conversion rate |
| Target CPC | Break-even CPC minus desired retained amount |
| Planned ad clicks and CPC to evaluate | Scenario inputs, not a promised number of clicks |
| Expected orders, spend and remainder | Formulas testing the scenario over a campaign |
The CSV uses standard spreadsheet formulas. If your spreadsheet imports formulas as text, you can enter those formulas in the corresponding cells. It helps to keep salaries, rent and recurring software outside order contribution unless they vary with each order, because counting them twice understates your ceiling.
Separate break-even from a responsible target
A campaign can reach its advertising break-even point while leaving nothing for rent or salaries. In the hypothetical middle case, a CPC of USD 0.95 consumes all expected contribution. Here, break-even means zero contribution after variable order costs and ad spend, before fixed overhead and income tax.
A lower target leaves room for delayed orders, measurement uncertainty and refunds above the reserve. With the hypothetical USD 0.20 retained amount, the middle-case target is USD 0.75. A measured CPC of USD 0.70 would leave USD 0.25 per click under that conversion assumption, while USD 1.00 would exceed break-even.
Fixed overhead still needs a separate allowance. Suppose the campaign must help cover USD 600 of monthly overhead and you expect 2,000 ad clicks: the allowance is USD 0.30 per click. Adding a USD 0.20 profit reserve makes the operating target USD 0.95 - 0.30 - 0.20 = USD 0.45, without changing the advertising break-even ceiling.
Check the estimate against measured clicks
A cost estimate can be misleading when clicks and orders cover different periods. Suppose a hypothetical campaign records 600 billed clicks and USD 420 in spend, but several orders arrive after your first report. A same-day order count would make the conversion estimate lower than one measured after the agreed order window.
FastVisits reports impressions, clicks, click-through rate and spend. Impressions count ad displays; click-through rate means clicks divided by impressions. You can compare the campaign with sessions in your analytics using the source label, a UTM tag added to the destination link for attribution.
A session is an analytics record, not the billing unit. Consent choices, ad blockers, slow pages and redirects can cause differences between sessions and reported clicks. You can document those differences while keeping billed clicks as the denominator for CPC and the worksheet's click-to-order conversion rate.
observed CPC = campaign spend / billed ad clicks
observed conversion rate = attributed orders / billed ad clicks
observed contribution per click = contribution per order × observed conversion rate
In the hypothetical 600-click example, six attributed orders give a 1% conversion rate. CPC is USD 420 / 600 = USD 0.70, and six orders at USD 95 contribution leave USD 150 after advertising. That checks the worksheet against campaign economics without treating every order as caused solely by one ad.
The guide to weekly campaign contribution reporting connects these measures over a reporting period. When comparing services, the ad network offer comparison helps you review placement relevance and billing definitions alongside price.
Update assumptions without hiding the uncertainty
An affordable CPC can change even when the ad rate stays the same. A discount reduces order contribution, while a new landing page may change how many interested readers order. If either changes, last month's ceiling may no longer support this month's budget.
You can keep a dated copy of each assumption set and recalculate after changes to pricing, fulfilment costs or refunds. Comparing like-for-like campaigns helps you separate a stronger offer from a different audience or device mix. A few additional orders are useful observations, but they do not establish a stable conversion rate.
A responsible summary gives the range rather than presenting the high case as expected performance. In this hypothetical example, break-even CPC ranges from USD 0.475 to USD 1.900, and target CPC ranges from USD 0.275 to USD 1.700 after retaining USD 0.20. You can use the lowest credible case until measured results justify a different guardrail.