Marketing & Advertising
Shopping Campaign Break-Even Calculator
Use this break-even calculator when a shopping team needs a contribution threshold rather than a revenue ROAS. It converts auction cost into media CPA, reduces order economics for margin, fulfillment, and return-value loss, then solves the approved-order volume that repays fixed campaign setup. Merchandising, performance marketing, and finance teams can use the sensitivity ledger to decide whether the crossing is economically positive and operationally reachable.
Input evidence: match CPC, conversion, approval, margin, fulfillment, and return loss to one product group and measurement window. Use backend-approved orders and matured returns; do not mix platform conversions with finance margin.
Contribution crossing
Find the approved-order volume where shopping contribution repays campaign setup
The curve keeps product value, fulfillment, returns, auction cost, and fixed feed work visible instead of hiding them inside a revenue ROAS.
| Approved orders | Gross merchandise value | Purchased clicks | Media spend | Order value after loss and fulfillment | Net contribution | Position |
|---|
How to use the shopping break-even model
Build the crossing from approved orders, not platform revenue
- Enter launch, feed, and measurement costs that do not change with order volume.
- Use CPC and click-to-order conversion from the same product group, market, and recent auction window.
- Reconcile approval rate to backend accepted orders rather than platform conversions.
- Enter order value, gross margin, fulfillment, and expected return-value loss on consistent order definitions.
- Review net value per approved order before reading the break-even volume; a nonpositive value means no finite crossing.
- Use the sensitivity ledger to test whether inventory, cash, and fulfillment capacity can support the required orders.
Shopping break-even fundamentals
Six layers determine whether a sale repays campaign cost
Fixed campaign cost
Feed setup, creative, and measurement obligations incurred before marginal orders.
Approved order
A conversion retained after rejection, cancellation, or payment screening.
Merchandise margin
Order value remaining after product cost, before fulfillment and media.
Return-value loss
Expected erosion of merchandise margin from returns or credits.
Media CPA
CPC divided by click conversion and approval.
Unit contribution
Net order value after fulfillment and media CPA.
Result interpretation
Read the crossing as a chain of commercial obligations
Approved orders
The primary hurdle: accepted orders needed for contribution to repay fixed setup.
Purchased clicks
Traffic required after conversion and backend approval loss are both recognized.
Media spend
Auction cash needed at the entered CPC; it excludes fixed feed work.
Net order value
Merchandise margin remaining after expected return loss and fulfillment.
Media CPA
Advertising cost per approved order, not per platform conversion.
Unit contribution
The amount available to repay setup; zero or less means no finite break-even.
Calculation method
Solve one linear contribution equation after normalizing the funnel
The method converts CPC into media cost per approved order, converts order value into post-loss merchandise margin, subtracts fulfillment, and solves the remaining unit contribution against fixed campaign cost.
Auction boundary
CPC and conversion jointly determine media cost per approved order
A cheaper click is not automatically better if its approval-adjusted conversion is weaker. Freeze the click and order populations before comparing products or periods.
Commercial boundary
Revenue ROAS can cross while contribution remains negative
Revenue ignores cost of goods, return loss, and fulfillment. The chart therefore uses contribution after those obligations and after advertising, not reported order revenue.
Capacity boundary
A mathematical crossing may still be operationally unreachable
Compare required approved orders with sellable inventory, pick-pack capacity, campaign duration, and available media cash. Break-even arithmetic does not create supply.
How to read the visualization
Use the contribution curve to test both crossing and capacity
- Meaning and axes
- The horizontal axis is approved-order volume and the vertical axis is cumulative net contribution after media and fixed setup.
- Inputs that move it
- CPC, conversion, approval, order economics, and return loss change the slope; campaign setup moves the starting deficit.
- Decision pattern
- A steeper positive line and earlier orange crossing indicate more economic room; the ledger exposes the traffic and cash required at each volume.
- Misleading boundary
- The crossing is not attainable evidence when sellable inventory, campaign duration, cash timing, or fulfillment capacity cannot support the displayed order count.
Detailed calculation process
Derive approved-order contribution and solve the fixed-cost crossing
In plain language: first find what one approved order contributes after merchandise, returns, fulfillment, and advertising; then divide fixed setup by that remaining contribution and translate the order hurdle back into clicks and media cash.
Percentages are divided by 100 before use; CPC is currency/click, order values are currency/order, and order and click counts are unit counts.
- F
- fixed campaign setup cost; currency
- A
- average approved-order value; currency/order
- m
- gross margin rate; decimal
- r
- return-value loss rate; decimal
- f
- fulfillment cost; currency/order
- CPC
- cost per purchased click; currency/click
- c
- click-to-order conversion; decimal
- a
- order approval rate; decimal
- V
- net merchandise value before media; currency/order
- U
- unit contribution after media; currency/order
- O*
- break-even approved orders; orders
- K*
- required purchased clicks; clicks
Default substitution and intermediate results
m = 54% ÷ 100 = 0.54; r = 7% ÷ 100 = 0.07; c = 3.4% ÷ 100 = 0.034; a = 91% ÷ 100 = 0.91.
V = $116 × 0.54 × (1 − 0.07) − $8.40 = $49.86 per approved order.
CPA = $1.24 ÷ (0.034 × 0.91) = $40.08; therefore U = $49.86 − $40.08 = $9.78.
O* = $18,000 ÷ $9.78 ≈ 1,841 approved orders; K* ≈ 59,500 clicks and M* ≈ $73,780.
Reconciliation: at the unrounded O*, O* × V − K* × CPC − F = $0. Rounding the displayed order count upward produces a small positive amount, as expected.
Evidence discipline
Match auction, order, and margin populations
- Use billed clicks and spend from the ad platform.
- Use approved order counts from commerce records.
- Calculate margin and fulfillment on the same product mix and tax convention.
- Estimate return loss from a matured cohort, not early gross orders.
Model limitations
The crossing is deterministic and single-period
It excludes inventory replenishment timing, cash collection lag, tax, discount changes, heterogeneous SKU margin, auction response to scale, organic cannibalization, incrementality uncertainty, and lifetime repeat value. Use causal lift evidence before claiming the campaign created every modeled order.
Key terminology
Shopping break-even glossary
- Approved order
- An order that survives the defined acceptance process.
- Gross margin
- Order value after product cost but before fulfillment and media.
- Return-value loss
- Expected margin erosion from returns and credits.
- Media CPA
- Advertising spend required per approved order.
- Unit contribution
- Net merchandise value after fulfillment and media CPA.
- Fixed cost
- Campaign cost unaffected by marginal order count.
- Break-even crossing
- Volume where cumulative contribution equals fixed cost.
Practical decision cases
Three different reasons a campaign can miss the crossing
High-volume, low-margin catalog
A retailer sees strong conversion but returns and fulfillment leave little unit contribution. The decision is to repair assortment economics before buying more traffic.
Premium products with expensive clicks
Order value and margin are healthy, yet auction cost pushes approved-order CPA close to net value. The team tests narrower queries and feed relevance instead of treating revenue ROAS as proof.
Early crossing beyond stock
The model breaks even at a plausible contribution slope, but required approved orders exceed sellable units. The decision shifts to replenishment, duration, or a smaller fixed launch scope.
Important note
Before relying on this result
This planning model excludes SKU-level distributions, auction response to scale, replenishment, tax, payment timing, organic cannibalization, delayed returns, customer lifetime value, and causal incrementality.
Additional Shopping Campaign Break-Even Calculator questions
Why is platform ROAS not the break-even measure?
Platform ROAS uses attributed revenue and normally omits product cost, return-value loss, fulfillment, fixed setup, and approval reconciliation.
What if contribution per approved order is zero or negative?
There is no finite order-volume crossing under the entered assumptions because every incremental approved order fails to repay its full marginal cost.
Should returns reduce order value or approval?
Use approval for orders rejected before retaining value and return-value loss for expected margin erosion after an order initially qualifies.
Does the result prove the campaign creates these orders?
No. It is a deterministic economic threshold; causal incrementality requires a suitable experiment or credible counterfactual.