Meta says this month's ROAS is 4.2x. Google Ads says 3.8x. Add the two together in your head and spend looks like it is working beautifully. Then someone pulls the bank statement, weighs every dollar of ad, agency, and tool spend against every dollar of actual revenue instead of the revenue each platform claims on its own, and blended return comes out closer to 1.9x.
That gap is not a rounding error, and it is not the number most marketing dashboard metrics guides help a reader find. Search the phrase and the results are the same article rewritten a dozen times: 20 to 30 KPIs grouped into sales, marketing, customer, and operations, with a sentence on each. Revenue, AOV, conversion rate, CTR, CPC, email open rate, CLV, retention rate, NPS. None of them says which number to believe once the platforms disagree with each other, which they always do.
In a delivered reporting audit, we found summed platform-attributed revenue exceeding a brand's actual store revenue by roughly 40% in the same reconciliation window, because the same order IDs were showing up in more than one platform's conversion export. Every metric on that team's old dashboard was individually defensible and collectively misleading. A dashboard with 30 metrics like that answers zero questions decisively. The ones that do real work for ecommerce teams carry a short list, reconciled against actual revenue, with everything else demoted to a platform's native reporting where it belongs.
The metric that cannot be gamed: MER
Marketing efficiency ratio, or MER, is total revenue divided by total marketing spend across every channel, paid, organic, retention, agency fees, and tools, not just ad platforms. Shopify's own breakdown of the metric frames it as the number that cuts through attribution disputes precisely because it is not calculated by any single platform's tracking pixel.
That is the entire point of putting MER at the top of a marketing dashboard instead of channel ROAS. ROAS is reported by the channel that spent the money, using that channel's own attribution model and lookback window. MER is calculated from your bank account and your ad invoices. One of those two numbers has an incentive to look good. The other one does not.
Why platform numbers were never going to match
This is not a bug in your tracking, or at least not only that. Google's own documentation on data discrepancies explains that different systems count conversions at different times, apply different attribution windows, and have visibility into different sets of events leading up to a purchase. Google Ads and Meta can both legitimately claim the same order under their own last-touch or view-through rules, and neither is technically lying. They are answering a narrower question than the dashboard implies they are answering.
That is why our comparison of Triple Whale and native GA4 reporting keeps landing on the same conclusion: third-party attribution tools disagree with each other and with GA4 for the same structural reason platforms disagree with the bank statement, different methodology, applied honestly, producing different totals from the same underlying events. No dashboard tool fixes that by itself. Reconciliation does.
The short list that actually belongs on the dashboard
Once MER sits at the top, the rest of a working ecommerce marketing dashboard gets short fast:
- MER (total revenue / total marketing spend). The one number that survives an argument about attribution.
- Blended new-customer CAC (total spend / new customers acquired). Total spend against first-time buyers, since returning-customer revenue shows little incremental lift from ad spend and will flatter a blended ROAS number that includes it.
- Contribution margin after ad spend (CM2). Revenue minus cost of delivery minus ad spend. This is the number that tells you growth is profitable, not just large.
- Channel-level ROAS, underneath the three above, used only to decide how to shift budget between channels once MER has already told you spend is working overall.
Everything else, CTR, CPC, email open rate, landing page bounce rate, belongs in the platform that generates it. Pull it onto the executive dashboard only when a specific, named decision depends on it that week. "It might be useful someday" is how a dashboard grows back to 30 metrics within a quarter.
Match the update cadence to the decision, not the platform
A second, quieter way dashboards mislead is cadence. Ad spend and daily revenue genuinely need near-real-time visibility, since budget decisions happen daily. MER and blended CAC are better read weekly; day-to-day swings in a ratio built from a handful of large orders are mostly noise, and treating a Tuesday dip as signal leads to budget whiplash that costs more than it saves. Contribution margin, cohort retention, and CLV belong on a monthly cadence, because refunds, returns, and enough order volume to be stable all take weeks to settle.
Checking a monthly-cadence metric daily does not make it more accurate. It just adds a source of anxiety that has nothing to do with whether the business is actually healthy that week.
Building the reconciled version, not just a prettier one
None of this requires exotic tooling. A Looker Studio dashboard built on the GA4 BigQuery export rather than native connectors gets you unsampled, unthresholded event data as the base layer, which is what makes a genuinely reconciled MER calculation possible instead of an approximation stitched together from platform exports that were never going to agree.
The harder part is not the visualization, it is deciding, once, what "revenue" and "spend" mean across every source feeding the dashboard, and holding that definition constant. Does revenue mean gross sales, or net of discounts and returns. Does spend include agency retainers and the tools stack, or only ad platform invoices. Pick an answer, document it next to the dashboard, and apply it everywhere, because a MER calculated on gross revenue one month and net revenue the next will move for reasons that have nothing to do with marketing performance.
That decision work is exactly what a proper ecommerce reporting build exists to do, and it pairs naturally with a marketing analytics engagement once the blended number needs to reconcile against GA4 and ad-platform attribution specifically, not just the bank statement.
If the dashboard can only carry one number
Make it MER. Every other metric on this list, blended CAC, contribution margin, channel ROAS, exists to explain why MER moved, not to replace it as the headline. A dashboard that leads with channel ROAS and buries the blended number is answering "how did each platform do" when the question that actually matters is "is marketing working." Those are not the same question, and only one of them survives a reconciliation against the bank statement.
Before adding a metric back onto the dashboard, it has to earn that spot: what decision changes if this number moves. If nothing does, it belongs in the platform that generated it, not on the page a founder opens before a budget call.
