Why an affiliate programme changes the calculator's inputs
The default page pictures a campaign bought by the click or the impression: money goes out first, a platform reports the sales, and the calculator says whether the cost of each sale was affordable. An affiliate programme turns that round. Most of its cost is never spent in advance. It is a commission paid after the sale, set by the business as a rate and owed only once the order has been checked. The question changes with it, from whether a campaign's cost per sale was bearable to how much the business can promise per sale before partners start sending orders.
The guide to commission structures and partner economics treats commission as exactly that kind of price and builds the most a business can pay from its own numbers: what an order contributes, minus the platform's per-order cost and the profit the business wants to keep. The calculator supplies the first term. Multiply order value by margin and the Break-Even CPAHighest cost per acquisition at which a sale still covers its variable costs. that results equals the contribution one order earns, the whole sum available to share between partner, platform and business.
Two habits from the default page would spoil that figure. The sales a network dashboard shows are tracked, not validated, so they include orders later returned, cancelled or rejected. And the everyday margin a business quotes may already have commission taken out, which is where some finance teams book it. Each changes one input. The third input changes because, once commission is a per-order price, the costs left over are the fixed ones: the network or platform fee and any placement or tenancy bought from a publisher.
The inputs for an affiliate programme
| Calculator input | On the default page | For an affiliate programme | Where to find it |
|---|---|---|---|
| Average order value | Average order value of the campaign's sales | Validated order value for one segment, such as new customers from content partners, once the validation period has closed | Approved orders on the affiliate platform matched to the order system |
| Gross margin | Everyday gross margin | Contribution margin before commission: order revenue minus the cost of product, fulfilment, payment and expected returns | Finance margin by product category, with commission kept out |
| Campaign spend | Media spend for the campaign | Fixed programme costs for the period: network or platform fees and placement or tenancy fees | Network invoices and placement contracts, coded apart from commission |
The order-value row rests on the routine in the month-end closing tutorial for affiliate commissions, which matches pending conversions to the order system and approves only those that outlived the returns window. Take the value of approved orders and split it by partner type and by new or returning customer, because the commission guide pays those segments differently and each needs a ceiling of its own.
The margin row is the derivation to get right. Start from revenue per order net of tax, subtract the cost of the product, fulfilment, payment processing and the returns the category usually sees, and divide by revenue. If finance's figure places commission in cost of sales, add it back before entering the margin: the closing-the-month tutorial warns that commission already inside gross margin must not be subtracted a second time. A margin that blends categories hides the low-margin lines where a flat Commission RateThe share of a sale's value paid to the affiliate or partner credited with it. does most harm, so run the calculator per category wherever margins differ.
The spend row holds only what the programme pays whether or not orders follow. Commission belongs in the ceiling, not in spend, and any share the network takes on each order belongs in the platform cost the ceiling subtracts.
Entering the affiliate inputs step by step
Choose one segment and a closed period
Pick the partner type and customer type the rate will apply to, and a period whose Validation PeriodHow long the business has to review an affiliate conversion before approving its commission, long enough to cover returns and cancellations. has ended, so every order in it has been approved, adjusted or rejected.
Take validated order value from the approvals
Add up the approved orders for the segment and divide by how many there are. Leave out conversions still pending; their value is a claim, not yet a sale.
Rebuild the margin with commission left out
Ask finance for contribution margin by category, check where commission is booked, and add it back if it sits inside cost of sales.
Enter the fixed fees as spend, then derive the ceiling
Type the three figures into the calculator. From the break-even CPA it returns, subtract the platform's cost per order and the profit the business requires per order, then divide what is left by validated order value to express the ceiling as a rate.
A worked affiliate programme with illustrative inputs
Vaskerd Cycles prices commission for new customers from content partners
Vaskerd Cycles, an invented online bike-parts shop, is setting its rate for new customers sent by content partners such as cycling blogs and review sites. Once its 35-day validation period has closed, approved orders from that segment average £80. Contribution margin before commission, after parts, packing, delivery, card fees and expected returns, is 35%. Its network charges a fixed monthly fee and it holds one placement on a route-planning site; together these cost £3,000 a month, which goes in as spend.
The calculator returns a break-even CPA of £28, a break-even ROAS of 2.86 and 108 sales needed. The network also takes an assumed £2.40 an order, and Vaskerd requires £8 of profit an order, so the commission ceiling is £28 − £2.40 − £8 = £17.60, which is 22% of the £80 order. At the full 22%, each new-customer order costs £20 in commission and platform share, a return of £80 ÷ £20 = 4.0 on those costs against the floor of 2.86.
The 108 orders are the validated orders whose entire contribution the month's fixed fees would absorb. If the fees are to come out of the £8 kept on each order instead, the segment needs £3,000 ÷ £8 = 375 validated orders a month before the programme adds anything. Vaskerd's finance team has set a six-month payback period for new customers, and cohort records show this segment's later orders adding about £6 of contribution within it, so Vaskerd offers its two strongest content partners 25%, or £20 an order, and records why beside the rate.
Campaign Break-even Calculator
Open the Campaign Break-even Calculator →Prefilled with the example's inputs: Average order value $80 · Gross margin 35% · Campaign spend $3,000 → Break-even CPA $28 · Break-even ROAS 2.86× · Sales needed to break even 108.
Every figure above belongs to the invented shop. Enter the order value and margin of a returning-customer segment in the embedded calculator to see its ceiling, then decide how much of it the business wants to hand to partners for customers who already know the shop.
Interpreting break-even CPA as a commission ceiling
Read break-even CPA first, as the budget an order brings with it rather than a cost target. Everything a validated order costs the programme comes out of it: the partner's commission, the network's per-order share and the profit the business has decided to keep. The commission guide's formula takes platform cost and required profit off the top, and only the remainder can be offered to partners. A ceiling read straight off the calculator, with nothing subtracted, promises partners the business's whole margin.
Then convert the ceiling into a rate. Divided by validated order valueAverage revenue per order., it gives the highest percentage commission the segment can carry, which is the form partners use when they compare programmes. Because order value and margin differ by segment, so does the rate; the commission guide's case for separate new-customer and returning-customer rates, and for category rates where margins differ, shows up here as a different ceiling from each run. What counts inside that order value, from discounts and delivery to part returns, is worked through in the guide to deciding what a commission is paid on.
Break-even ROAS sets the floor for a second check. The diagnosis of affiliate commission costs rising splits cost of sale by partner and customer segment using approved revenue only; dividing each segment's revenue by its commission plus fees gives a return that must clear the Break-even ROASMinimum ROAS to avoid a loss.. A segment below that floor loses money on every order it sends. A segment between the floor and the return the ceiling implies covers its costs but not the profit the business asked for.
New customers can justify more than their first order earns, but only inside limits written down in advance. The guide to LTV and CAC explains how a payback period is set, and a new-customer segment may sit above the first-order ceiling only while the margin from its later orders recovers the difference within that period. The break-even page for subscription businesses applies the same kind of window to recurring payments, and the break-even page for lead generation works out the most a single lead can cost, the figure to start from when partners are paid per lead rather than per order.
Finally, read sales needed against the month's volume. It counts the validated orders whose whole Contribution MarginRevenue left after every cost that varies with each sale. the fixed network and placement fees would use up before any commission is earned back, and the month-end table from the closing tutorial shows whether the programme reached it. Once commission is paid, only the required-profit slice is left to cover those fees, so the volume that truly clears them is higher. The CPA calculator gives the cost per validated order the programme actually achieves, the figure to hold against the ceiling each month. Neither calculator can tell whether those orders would have arrived anyway; the reporting and incrementality guide covers the tests that answer it.
Pitfalls when affiliate numbers go into the calculator
- Entering tracked rather than validated orders. Tracked conversions include orders that will be returned or rejected, so a ceiling built on them is priced for sales the shop never keeps.
- Taking commission out of the margin input and again from the ceiling. A margin with commission already deducted shrinks the room for partners, and subtracting commission again makes every sensible rate look unaffordable.
- One rate for new and returning customers. A blended order value and margin give one ceiling that overpays for customers who would have bought anyway and underpays the partners who find new ones.
- Leaving network and placement fees out of the arithmetic. A ceiling that ignores the platform's share and the fixed fees hands partners money the programme is already spending elsewhere.
- Raising commission for a sale without counting the discount. A promotional rate on discounted orders comes out of a thinner margin; the ROAS page for discount promotions shows how the margin after a discount is worked out, and the ceiling has to be rebuilt from that figure.
