Advertising Profitability Calculator Guide
Complete definitions for all four modes, Ad-only vs. Contribution ROI, unit economics, break-even and Goal Planner ceilings, N/A reasons, GST/VAT accounting treatment, and attribution limitations.
Four calculation modes
1. E-commerce / orders
Needs ad spend, attributed revenue (or orders × AOV), optional fixed campaign costs, and either contribution margin % or per-order variable costs. Outputs ROAS, Ad-only ROI, Contribution ROI, CPA, break-even CPA, and break-even ROAS.
2. Lead generation
Needs spend, leads, closed customers (observed) or lead-to-customer close rate %, net revenue per customer, and optional cost/customer. Exposes CPL, CAC, fully-loaded CAC, max viable CPL, and explicitly marks projected customer/revenue outputs as estimates.
3. Quick ROAS & ROI
Fast sanity check requiring only spend and attributed revenue, with optional non-ad variable costs. Explicitly separates Ad-only ROI from Contribution ROI and never calls ROAS profit.
4. Goal planner
Forward planning with contribution margin %, AOV, fixed overhead, and a target profit per order, target profit margin %, or target ROAS/CPA. Computes max CPA, max CPL, and required target ROAS.
Core formulas & ROI conventions
- ROAS
Attributed revenue ÷ cost (x). Zero cost leaves ROAS unavailable. Never interpret ROAS as net profit.
- Ad-only ROI (%)
(Attributed revenue − ad spend) ÷ ad spend × 100. Ignores COGS, fees, fulfilment, and operating costs; shown strictly alongside Contribution ROI.
- Contribution before ads
Net attributed revenue − non-ad variable costs (fulfilment, COGS, payment fees), or attributed revenue × (contribution margin % ÷ 100).
- Contribution ROI on ad spend (%)
Contribution profit after ads ÷ ad spend × 100, where Contribution profit after ads = Contribution before ads − ad spend − entered fixed costs.
- Break-even CPA & ROAS
Break-even CPA = contribution per order − (fixed cost ÷ N). If negative, no positive CPA is viable at that order volume. Break-even ROAS = 1 ÷ m when fixed costs are excluded.
- Target ROAS, Max CPA & Max CPL
Target ROAS = 1 ÷ (m − t) for target profit fraction t (when m > t and fixed costs excluded). Max CPA = contribution/order − F/N − P. Max CPL = Max CPA × lead-to-customer conversion rate.
- CPL, CAC & Fully-loaded CAC
CPL = ad spend ÷ attributed leads. CAC = ad spend ÷ acquired customers. When fixed campaign overhead is entered, Fully-loaded CAC = (ad spend + fixed overhead) ÷ acquired customers.
Tax, incrementality & financial scope disclosures
Consistent GST / VAT treatment
Use one consistent tax basis across ad spend, revenue, and variable costs (INR for India GST or GBP for UK VAT). Recoverable input GST or UK VAT should not be counted as an economic expense when your business reclaims it.
Attributed ≠ incremental revenue
Ad-platform conversions (Google Ads, Meta Ads) reflect platform-claimed attribution and may double-count organic or cross-channel sales. Compare with backend order totals when making budget commitments.
Marketing contribution ROI ≠ company ROI
ROI here measures modelled marketing contribution after entered variable and campaign costs. Company-wide net profit also depends on rent, payroll, corporate tax, refunds not yet netted, and inventory financing.
First-order focus (LTV excluded)
Version 1.0 evaluates first-conversion economics without forecasting future repeat purchases or lifetime value cohorts unless you manually adjust revenue per customer.
Why a result shows N/A
A missing value is never treated as zero. Unavailable metrics carry one of these explicit reason codes:
- MISSING_SPEND
Ad spend (or the rate inputs that derive it) was not entered.
- MISSING_REVENUE
Attributed revenue (or counts × AOV / value per lead) was not entered.
- MISSING_CONVERSIONS
Orders, leads, conversions, or customers were not entered.
- UNKNOWN_COSTS
Contribution margin % or non-ad variable costs are missing, so true contribution profit and break-even thresholds cannot be verified.
- ZERO_DENOMINATOR
An explicit 0 denominator makes that ratio or threshold mathematically undefined.
- MISSING_TARGET / NOT_APPLICABLE
Target goals are unselected or a margin-only goal exceeds available contribution margin.
Worked canonical vectors
E-commerce (INR)
Spend ₹20,000 · Revenue ₹1,00,000 · 100 orders · 40% contribution margin
- ROAS / CPA
- 5.00x / ₹200
- Contribution before ads
- ₹40,000
- Contribution profit
- ₹20,000 (100% ROI)
- Break-even CPA / ROAS
- ₹400 / 2.50x
Lead generation (GBP)
Spend £600 · 60 leads · 12 customers · £200/cust · £100/cust cost
- CPL / CAC
- £10 / £50
- Revenue / ROAS
- £2,400 / 4.00x
- Contribution / Profit
- £1,200 / £600
- Max viable CPL
- £20 (at 20% close)