Building an MER Dashboard: The One Number That Steers Your Growth

In many companies, two truths about marketing exist side by side: the one from the ad accounts, in which every platform shines, and the one from the accounts department, in which growth looks distinctly more sober. In between lie attribution logics, gut feeling and opinions. A dashboard built around MER – the Marketing Efficiency Ratio – closes this gap: one number that puts total revenue and total ad spend across all channels into proportion and shows marketing and management the same reality. This guide shows what belongs in the dashboard, where the data comes from, how you derive your target MER – and which interpretation traps you need to know.

What MER measures – and why it should lead

MER puts your entire revenue in relation to your entire ad spend – across all platforms, without any attribution logic:

MER = total revenue / total ad spend

The difference to ROAS is fundamental. ROAS measures what a single platform attributes to itself; MER measures what actually arrives in the shop, divided by what was actually spent. It is deliberately rough – and precisely for that reason robust: no channel can talk it up, no attribution change shifts it. Why platform ROAS has had its day as the sole north star, we explain in detail in the article MER instead of ROAS. Here we take the next step: turning this metric from a concept into a working process.

Why a dashboard instead of gut feeling

As long as MER is a number someone occasionally estimates in their head, it remains ineffective. It only unfolds its power as a regularly maintained, shared truth – for three reasons:

One source instead of five opinions. Marketing argues with platform reports, management with the bank balance – and both are right from their own perspective. A dashboard whose definitions both sides have agreed on shifts the discussion from “which number is correct” to “what do we do now”.

Decisions become verifiable. When budget increases, new channels or big promotions become visible in the dashboard, you can check afterwards what they achieved – instead of relying on impressions and memory.

Trends instead of daily noise. Individual days fluctuate strongly and invite hectic reactions. A dashboard with weekly values shows developments that remain invisible in the daily glance at the ad accounts.

On top of that comes a psychological effect: what is regularly looked at together gains weight. A short, fixed appointment each week in which the dashboard is read and discussed anchors MER as the steering number in everyday work – instead of making it one number among many that only gets pulled out when problems arise.

What belongs in the dashboard

Less is more here: an MER dashboard that fits on one screen gets read – one with thirty metrics gets ignored. The core:

Total MER. Total revenue divided by total ad spend, per week. This is the steering number everything else is oriented around.

aMER, if measurable. The aMER (acquisition MER) only looks at revenue from new customers in relation to total spend. It answers the growth question more precisely: existing-customer revenue would partly come even without advertising, new-customer revenue is the real effect of acquisition. The prerequisite is that your shop system cleanly separates new and existing customers.

Spend per channel. Total spend, broken down by Meta, Google, TikTok and everything else that runs. This lets you see which shift in the channel mix coincides with which MER development.

Revenue from the shop backend – not from the platforms. The most important principle of the entire dashboard: what counts as revenue is what your shop system records. Platform revenues are self-reports with generous attribution; added up, they regularly exceed your real revenue. The shop backend counts every order exactly once.

A contribution-margin view. Revenue is not profit. Whoever keeps an eye on the contribution margin alongside the revenue MER – meaning what remains after cost of goods, shipping and variable costs – recognises whether the growth is profitable or merely big.

Target corridors instead of point targets. Pinning MER to one exact value is unrealistic, because the number fluctuates naturally. Instead, define a corridor: a lower bound below which you take corrective action, and an upper bound above which you are probably investing too little – because a very high MER can also mean you are leaving growth on the table.

Data sources and setup: pragmatic instead of perfect

The good news: for a working MER dashboard, you need neither a data pipeline nor a BI project. Four pragmatic building blocks suffice:

The shop backend is the source of truth for revenue. Shopify, Shopware or your ERP – what matters is that you determine a single, consistent source and stick with it. Clarify once and cleanly whether you use gross or net revenue and how you handle returns and vouchers, and document that decision.

The ad accounts deliver the spend. The amount spent is the one number you can trust the platforms on completely. Pull the values together weekly from all active accounts – including the small channels that tend to get forgotten.

Weekly granularity is often enough. Daily values create noise and maintenance effort, monthly values delay reactions. For most shops, the week is the right rhythm: fine enough to take corrective action, coarse enough for stable values.

A well-maintained spreadsheet beats any dashboard tool that nobody maintains. A spreadsheet with weeks as rows and the metrics as columns, filled in on a fixed day of the week, is a fully fledged MER dashboard. Automation and BI tools only pay off once the process is established and manual upkeep becomes the bottleneck – not before. The bottleneck is never the tool, it is the consistency.

Deriving the target MER: from margin, not from benchmarks

The most common question on the topic: so what is a good MER? The honest answer: you cannot copy it from others. An MER at which a high-margin brand grows comfortably would be ruinous for a low-margin retailer. Benchmarks from other shops mix foreign margins, foreign return rates and foreign growth targets – as a target value for you, they are worthless.

The reliable path leads backwards through your own calculation. The starting point is your contribution margin: how much of one euro of revenue remains after cost of goods, shipping, payment fees and returns? From that follows how much advertising cost one euro of revenue can bear at most before you make a loss – and thus the minimum MER at which your marketing operates profitably. Above this threshold begins the room in which you deliberately decide how much profitability you want to trade for growth.

Whoever additionally knows their CAC and the value of a customer over time can use this room more deliberately – for instance consciously accepting a lower MER when new customers demonstrably buy again. And how you get from such target figures backwards to a concrete monthly budget, the article Meta Ads Costs and Ad Budget shows.

It is also important not to treat this derivation as a one-off exercise. If purchase prices, shipping costs or return rates change, your target corridor shifts too – so review the calculation at regular intervals and whenever something substantial changes in your cost structure.

Interpretation traps

A dashboard is only as good as its interpretation. Three traps we see regularly:

MER reacts sluggishly. It contains everything – including revenue from contacts and promotions from weeks ago. A budget change today often only shows up in the MER with a delay. Whoever draws conclusions after a few days steers along the noise. Give changes time to show up in the number.

Mix effects distort. If MER drops, that does not automatically mean your ads have got worse. Perhaps the channel mix has shifted towards new-customer acquisition – which is more expensive, but strategically intended. Perhaps a strong existing-customer promotion ended. Therefore always read MER together with spend per channel and, if available, the aMER.

Sale phases flatter. In discount periods, revenue rises and MER shines – while the contribution margin per order shrinks. Without the profit view alongside, the dashboard rewards precisely the phases in which the least is earned.

And a fourth limit no dashboard resolves: MER shows efficiency, not causation. Whether the revenue would have come even without advertising, only an experiment can answer – how to do that pragmatically, the article Incrementality testing shows.

Conclusion

An MER dashboard is unspectacular: a handful of numbers, maintained weekly, from sources everyone trusts. That is exactly where its power lies. It replaces attribution debates with a shared truth, makes budget decisions verifiable and asks the most honest question of all: is the business growing – or just the platform reports? Start with a spreadsheet, revenue from the shop backend and a target corridor derived from your own margin. And if you want to know where your account and your measurement stand today, our free account check is the fastest way to an honest assessment.