MER Explained, With the SQL
The 60-second version
Marketing Efficiency Ratio sidesteps attribution disagreements entirely. Here's the formula, a worked example, and the query that computes it from a warehouse.
- Why MER exists — the attribution problem it avoids
- The formula, worked example
- MER vs. blended ROAS: same idea, different denominator
Three dashboards, three ROAS numbers, three owners each insisting theirs is right. Meta claims 4.2x on its spend. Google claims 3.8x on its spend. Your warehouse says 2.6x overall. The meeting spends forty minutes on whose attribution is broken and zero minutes on whether marketing made money.
MER — Marketing Efficiency Ratio — exists to end that meeting. It ignores attribution entirely. Total revenue from your own books, over total marketing spend from your own books. No platform windows, no shared credit, no modelled conversions. One fraction that answers the only portfolio-level question: for every rupee marketing consumed, how many rupees of business came back?
Why MER exists
Attribution is a credit-allocation argument disguised as measurement. Every platform observes only itself, so every platform rationally claims every customer it touched — and a customer touched by two platforms is counted twice. Add different click windows, different view-through rules, different modelled-conversion uplifts, and the sum of platform revenues routinely exceeds your actual revenue by 30–80%. Arguing about which platform is "right" misses the structure: they are all right about what they saw, and none of them saw the whole.
What MER Refuses to Argue About
Data JourneyWho touched the customer
Meta says Meta caused it, Google says Google caused it. MER does not adjudicate — it measures the portfolio total both channels produced together.
Which window is correct
1-day click or 7-day view changes platform revenue without changing your revenue by a rupee. MER is invariant to every window setting.
What the business kept
Total revenue over total marketing cost. If it clears your breakeven, the portfolio paid for itself regardless of which channel deserves the credit.
MER = Total revenue (your books) ÷ Total marketing spend (your books)
That is the whole formula. The numerator is net revenue — after discounts, refunds and taxes — from your orders table, not from any ad account. The denominator is all marketing spend: platform costs plus agency, creative, tools and incentives. Because both sides come from systems you control, MER reconciles to the P&L in a way no platform ROAS ever can.
MER is a portfolio metric, not a steering metric. It tells you whether the whole machine is efficient. It cannot tell you which channel to scale, which creative to kill, or where the next rupee goes — for that you still need channel numbers, held with appropriate suspicion. MER is the envelope; channel ROAS is the allocation inside it.
The formula, worked
A D2C apparel brand closes September with these books:
September MER, line by line
Interpretation needs one more number: breakeven. At a 34% contribution margin, every rupee of revenue carries ₹0.34 of gross profit, so marketing breaks even when MER = 1 ÷ 0.34 = 2.94x. September's 3.12x clears it — the portfolio generated roughly ₹2,95,000 of surplus after marketing (₹51,20,000 × 0.34 − ₹16,40,000). Without the margin context, 3.12x is trivia; with it, MER becomes a pass/fail grade.
Two subtleties. First, use net revenue, not gross — a brand running 15% discounts on gross revenue flatters MER by exactly the discount rate. Second, decide your revenue basis (order date vs delivery date) and hold it. For COD-heavy catalogues, order-date revenue includes orders that will RTO; delivery-date revenue lags spend by a week. Either is defensible, but switching mid-year manufactures a trend that never happened.
MER vs blended ROAS: same idea, different denominator
Teams often treat MER and blended ROAS as synonyms. They differ in exactly one place — what sits in the denominator — and the difference decides which conversation each belongs in.
| Blended ROAS | MER | |
|---|---|---|
| Numerator | Net revenue (your books) | Net revenue (your books) — identical |
| Denominator | Platform ad spend only | All marketing spend incl. agency, creative, tools |
| Typical value | Higher (smaller denominator) | Lower by 10–25% |
| Answers | How hard is media working? | How hard is marketing working? |
| Moves when | Media efficiency changes | Media, overheads, or fee structure changes |
| Owner | Media buyer | CMO / finance |
In the September example, blended ROAS is ₹51,20,000 ÷ ₹14,00,000 = 3.66x while MER is 3.12x. The 0.54x gap is the overhead load — and it is exactly the gap across which marketing and finance usually argue. The buyer improved media efficiency; the CMO added an agency retainer. Both statements are true, and only the two numbers together show it.
Never optimise channels against MER. Because MER moves with overheads and fee changes, a channel can look worse month over month while its own efficiency improved — the agency raised its retainer, not the CPC. Judge channels on channel numbers (carefully), allocate across channels on warehouse-attributed numbers, and judge the portfolio on MER.
The SQL
Show query
Run it monthly and plot three lines: MER, blended ROAS, and breakeven. The gap between the first two is your overhead load — it should drift slowly. A sudden widening means fees or creative costs jumped without revenue following. MER crossing below breakeven is the portfolio-level kill signal: no channel-level success story overrules it.
Reading MER at Three Altitudes
Reporting HierarchyAbove breakeven with headroom
Portfolio pays for itself with surplus. Question shifts to scaling: which channels still show marginal headroom at current CAC.
Near breakeven
No surplus, no disaster. Hold budgets, fix margin or mix — cutting spend here shrinks revenue without creating profit.
Below breakeven
Marketing consumed more gross profit than it created. Cut or fix within the quarter; no attribution debate changes this verdict.
Frequently asked questions
Does MER include retention spend?
Yes — all of it. Email tools, SMS, loyalty rewards, retargeting: everything marketing consumes sits in the denominator. That is what makes MER a portfolio truth rather than an acquisition metric. If you want an acquisition-only view, compute a second ratio (net new-customer revenue over acquisition spend), but do not call it MER.
Should revenue be gross or net?
Net, always: after discounts, refunds, taxes and — for COD businesses — after RTO provisions. Gross-revenue MER flatters exactly by the discount-plus-return rate, which for sale-heavy months can be 25% or more. The platforms already report on generous definitions; your metric should not.
What is a good MER?
There is no universal good — only above or below your breakeven, which is 1 ÷ contribution margin rate. A 30%-margin brand breaks even at 3.33x; a 60%-margin brand at 1.67x. Importing someone else's 4x target without your margin is the superstition this metric exists to replace.
How is MER different from ROI or ROAS?
Platform ROAS uses platform revenue over platform spend — optimistic on both sides. Blended ROAS fixes the numerator (your revenue) but keeps the narrow denominator. MER fixes both. Marketing ROI is usually (revenue − spend) ÷ spend, which is just MER minus one — same information, different shape.
Can MER hide a failing channel?
Easily, and that is its known limitation. A dying prospecting channel can hide inside a healthy MER carried by returning-customer revenue and brand search. MER is the smoke alarm, not the fire investigation — when it moves, drill into channel and new-vs-returning splits to find where.
The summary
- MER is total net revenue over total marketing spend — both sides from your books, so it reconciles and no attribution argument touches it.
- Platform ROAS sums routinely exceed reality by 30–80% through double-claiming, windows and modelled conversions. MER sidesteps all of it by refusing to split credit.
- Worked: ₹51,20,000 net revenue over ₹16,40,000 all-in marketing = 3.12x, against a 2.94x breakeven at 34% contribution margin.
- Blended ROAS and MER share a numerator; the denominator (media-only vs all-in) is the whole difference. Report both so the overhead load stays visible.
- MER judges the portfolio, never the channel. Below breakeven is a kill signal no channel story overrules.
MER Calculator
Total revenue divided by total marketing spend — the attribution-agnostic efficiency number, plus its contribution-margin-adjusted variant.
Chinmay Raibagkar
About author →Founder of DataLens AI. He helps non-technical teams read their ad and database numbers with confidence — which number to trust, what to do next, and what to ignore.