How to Calculate Blended ROAS Across Meta, Google & Shopify

Meta says your campaigns returned 3.5x. Google says its campaigns returned 3.0x. Add those up in your head and you'd expect a great month. Then you check Shopify and net revenue doesn't match either story, because neither platform can see what the other one did, and both are claiming credit for some of the same customer.

That gap is why blended ROAS, also called MER (marketing efficiency ratio), exists: one number, anchored to what you actually spent against what you actually sold, that doesn't care which platform wants credit. If you're searching for the top platforms for cross-channel e-commerce analytics and reporting, or looking for a tool to track blended ROAS across platforms, this guide gives you the actual math first. Once you know how the number is built, you can calculate it by hand in a spreadsheet, or sanity-check any tool's output in about thirty seconds.

I'm Sumit Bansal, co-founder of Datadrew and formerly Head of Growth at AdYogi, where this exact reconciliation problem was my day job across hundreds of client brands. Here's the step-by-step process.

Key Takeaways

• Blended ROAS (MER) = Total revenue ÷ Total ad spend across every platform, not the sum of each platform's self-reported ROAS (HubSpot).
• Google Ads defaults to data-driven attribution, and Meta's pixel counts view-through and click conversions independently. Neither platform knows what the other is claiming (Google Ads Help, retrieved 2026).
• In 2022, Meta itself disclosed a $10 billion revenue hit tied to Apple's tracking changes, a useful reminder of how much platform-reported numbers can move without your sales actually moving (CNBC, 2022).
• Reconcile against Shopify orders, not platform pixels, and recalculate weekly rather than daily to avoid chasing noise.

What You'll Need Before You Start

This calculation takes about ten minutes once you know where to look. You'll need:

• Total ad spend for the period, pulled from Meta Ads Manager and Google Ads (and any other paid channel you run: TikTok, Pinterest, affiliate).
• Total revenue for the same date range, pulled from Shopify, not from a platform's conversion dashboard.
• A decision on gross vs. net revenue (more on this in Step 1).
• A spreadsheet, or five minutes with Shopify's order export.

Difficulty: beginner. No SQL, no data warehouse, no dashboard subscription required to run this once by hand.

Step 1: Decide Your Revenue Basis, Gross or Net

By the end of this step, you'll have picked one revenue definition and you'll use it every time you calculate blended ROAS, so the number stays comparable month over month.

Gross revenue is total order value before returns, refunds, and discounts. Net revenue subtracts those out. Neither is "wrong," but mixing them between periods makes your blended ROAS trend meaningless. A brand with a 12% return rate will show a materially different MER on gross versus net.

Pick net revenue if: you want a number that survives a finance review, since it's closer to what actually lands in the bank.

Pick gross revenue if: you're comparing purely against ad-platform data, which usually reports gross order value at the moment of purchase.

Write your choice down somewhere visible. This single decision causes more "why did our MER suddenly change" confusion than anything else in this guide.

Step 2: Pull Total Ad Spend From Every Platform You Run

One number comes out of this step: total dollars spent on paid acquisition in the period, summed across every platform, not just your two biggest.

Open each ad platform and export spend for the exact same date range you'll use for revenue. Don't round, and don't estimate from a "budget" figure, since actual spend and planned budget routinely diverge depending on pacing and auction dynamics.

• Meta Ads Manager: Ads Manager > Reports > filter by date, sum "Amount Spent" across all active campaigns.
• Google Ads: Campaigns > date range filter, sum "Cost" across Search, Shopping, and Performance Max.
• Any additional channel: TikTok, Pinterest, Snapchat, affiliate platforms, whatever else is live.

If you're already inside a cross-channel acquisition dashboard, this step is usually a single filtered view rather than three separate exports. If you're doing this manually, the Meta Ads integration page walks through exactly which spend field to pull if your account has multiple ad sets running concurrent tests.

Add every platform together. That total, not any single platform's number, is your denominator.

Step 3: Pull Total Revenue From Shopify, Not From Ad Platform Pixels

By the end of this step, you'll have a revenue figure that reconciles with what your business actually recorded, rather than what a pixel guessed.

This is the step people skip, and it's the one that actually matters. Meta and Google both self-report conversions through their own pixels, and both routinely overcount, especially since Apple's App Tracking Transparency (ATT) began limiting what third-party pixels can see on iOS devices. Meta itself has acknowledged the scale of this: in 2022, the company disclosed a projected $10 billion revenue impact tied directly to Apple's tracking changes (CNBC, 2022). That's not a stat about your store specifically, but it's a useful reminder of how much a platform's own reported numbers can swing for reasons that have nothing to do with your actual sales.

Pull revenue straight from Shopify: Analytics > Reports > Sales, filtered to your chosen date range and revenue basis (gross or net, from Step 1). For the traffic-quality side of the same question, cross-check against GA4 sessions and conversions, since a shift in session mix (more new vs. returning, a device split moving mobile) can move blended MER even when raw session counts look flat. This Shopify figure is your true numerator, and it's the number that should match what finance sees.

Step 4: Calculate Blended MER With One Formula

Here's the formula, and it's simpler than most dashboards make it look:

Blended MER = Total Revenue ÷ Total Ad Spend

That's it. HubSpot's breakdown of the metric describes it the same way: total revenue divided by total marketing spend, giving a single ratio that reflects overall efficiency rather than any one channel's performance (HubSpot). A MER of 4.0 means every dollar of ad spend is associated with four dollars of total store revenue, blended across every channel, every campaign, and every customer touchpoint you didn't individually track.

Notice what's missing from that formula: any reference to which platform gets credit. That's deliberate. Blended MER doesn't attempt to answer "which ad drove this sale," because no tool can answer that honestly without checkout-level click-ID capture, which almost nothing on the market actually has. What blended MER answers instead is a simpler, more durable question: is total ad spend producing total revenue at a rate that's improving or breaking down?

Step 5: Check Platform-Level ROAS, Then See Why It Doesn't Add Up

Why bother checking individual platforms at all if blended MER is the number that matters? Because platform-level ROAS tells you which channel moved when blended MER changes, and that's the diagnostic step, not the reporting step.

Pull ROAS separately from Meta and Google. Multiply each platform's spend by its self-reported ROAS to see the revenue figure it's implicitly claiming. Then add those two claimed-revenue numbers together and compare the sum to your actual Shopify revenue from Step 3.

They won't match. Google Ads defaults to data-driven attribution, which distributes credit across the conversion path based on historical account data, while Meta's pixel counts view-through and click conversions using its own separate window and logic (Google Ads Help, retrieved 2026). Each platform is optimizing for how much credit it can defensibly claim, not for reconciling with the other. Industry coverage of this exact problem describes an ongoing pattern of self-attributed sales, where a single conversion gets claimed by more than one platform simultaneously with no visibility into what the other reported (AdExchanger). This is the same structural problem behind last-click attribution more broadly; for the full breakdown of why attributed ROAS misleads and what to use instead, see Marketing ROAS Decoded: Beyond Last-Click Attribution for Shopify.

The chart below shows what this looks like with real numbers.

Platform ROAS still has a job: when blended MER drops, splitting it by platform tells you which channel to investigate first. Think of it as a diagnostic tool, not a reporting tool.

Step 6: Run the Full Worked Example

Let's put every step together with one clean set of numbers, matching the chart above.

1. Total ad spend: Meta $18,000 + Google $12,000 = $30,000
2. Total Shopify net revenue for the same 30-day window: $135,000
3. Blended MER = $135,000 ÷ $30,000 = 4.5x
4. Meta's self-reported ROAS of 3.5x implies $63,000 in claimed revenue.
5. Google's self-reported ROAS of 3.0x implies $36,000 in claimed revenue.
6. Sum of platform claims: $99,000, or 73% of actual net revenue.

The blended MER of 4.5x is the number to track and set targets against. The 27-point gap between platform claims and real revenue isn't a scandal (some of it is legitimately organic, email, and direct traffic that ads assist without directly closing), but it's exactly why you shouldn't add platform ROAS numbers together and call it your total marketing efficiency.

Step 7: Set a Blended MER Target and Track It Weekly

This last step tells you whether your blended MER is actually healthy for your business, not just whether it went up or down.

A "good" MER depends entirely on gross margin, not on an industry average. As a rough starting rule: divide 1 by your gross margin percentage to find your breakeven MER, then decide how much cushion above breakeven you need to cover fixed costs and profit. A brand with 60% gross margin breaks even around 1.67x MER; anything meaningfully below that is losing money on paid growth even if individual campaigns look "profitable" in-platform.

Recalculate weekly, not daily. Ad performance has a natural day-of-week rhythm, weekends and paydays skew differently for most Shopify brands, so daily blended MER swings are usually noise, not signal. A week-over-week comparison against the same weekday range filters most of that out.

Common Mistakes That Break a Blended ROAS Calculation

Mixing gross and net revenue between periods. This is the single most common cause of a blended MER chart that looks erratic for no real reason. Pick one basis in Step 1 and never switch it mid-comparison.

Comparing against yesterday instead of the same weekday last week. A Tuesday isn't comparable to a Sunday for most e-commerce brands. Comparing "down vs. yesterday" flags false alarms constantly.

Treating platform ROAS as additive. As Step 5 showed, Meta's 3.5x and Google's 3.0x don't sum into your true return. They're each answering a different, narrower question.

Ignoring the discount and return lag. A big discount code or a return spike from an earlier order lands in your revenue figure late, distorting the current period's MER without any actual ad performance change.

Recalculating from platform dashboards instead of Shopify. Every step above depends on Step 3 being right. If revenue comes from a pixel instead of your order ledger, the whole calculation inherits the pixel's blind spots.

What Success Looks Like

If you've followed every step, you should now have one blended MER figure for the period, a breakeven target based on your margin, and a platform-level breakdown you can use to investigate when the blended number moves. That's the full loop: calculate, compare to target, diagnose by platform when it drifts.

Once you're comfortable running this by hand, the natural next question is whether to automate it. Tools built for this job pull spend and revenue automatically and recalculate on a schedule rather than requiring a manual pull every week. See which analytics tools actually integrate with Meta and Google Ads for an honest comparison of six options, including Datadrew, which calculates blended MER by reconciling Meta and Google spend against actual Shopify revenue rather than platform pixels, the same Step 3 discipline this guide walks through by hand. Worth being direct about scope here: Datadrew doesn't claim campaign-level LTV or checkout-level ad-to-order attribution (nothing honestly can without deterministic click-ID capture), and it covers Meta and Google today, not TikTok. What it does calculate is exactly the blended MER math above, plus product-level LTV and first-touch UTM cohorts, automatically, rather than as a monthly spreadsheet exercise.

And once your blended MER is stable, the next layer of the same discipline is knowing what the customers behind that revenue are worth over time. That's where the complete guide to customer LTV for Shopify brands picks up: MER tells you whether this month's spend paid for itself, and LTV tells you whether the customers it bought will keep paying you back.

Frequently Asked Questions

What are the top platforms for cross-channel e-commerce analytics and reporting?

Cross-channel platforms generally fall into two categories: broad BI tools that pull Meta, Google, Shopify, and more into unified dashboards, and dedicated attribution engines built for large ad budgets (typically brands spending $50,000+/month). The right choice depends on whether you need blended reporting alongside finance and ops data, or attribution precision at scale. This guide's formula works regardless of which platform, or none, you use to run it.

Is there a tool to track blended ROAS across platforms automatically?

Yes. Purpose-built analytics platforms for Shopify brands automate the pull-and-reconcile process in Steps 2 and 3, refreshing blended MER daily or weekly instead of requiring a manual export. The underlying math is identical to what's in this guide: total revenue divided by total ad spend, reconciled against your store's actual order data rather than platform-reported conversions.

How is blended ROAS different from MER?

The terms are often used interchangeably, and the core formula (revenue over spend) is the same. Some teams scope "blended ROAS" strictly to paid ad spend, while "MER" sometimes broadens the denominator to include agency fees, tools, and other marketing costs. Confirm which definition your team is using before comparing numbers across sources.

Why did my Meta ROAS drop even though nothing changed on my end?

Apple's App Tracking Transparency limits what Meta's pixel can see on iOS devices, so Ads Manager can under-report real conversions, sometimes substantially, especially outside its default attribution window. Your ads may not have gotten worse. The measurement did. Compare blended MER against actual Shopify orders to see the real picture. See how the Meta ad auction and learning phase actually work for the mechanics behind that gap.

Do I need real-time cross-channel reporting, or is weekly enough?

For most $1M to $20M GMV Shopify brands, weekly is enough. Ad performance doesn't meaningfully shift hour to hour, and reacting to every fluctuation burns more budget chasing noise than it saves. What matters more than real-time data is a reliable, repeatable calculation you actually run, on schedule, using the same revenue basis every time.

Sources

• Google Ads Help, "About the data-driven attribution model," retrieved 2026-07-10, support.google.com/google-ads/answer/6259715
• CNBC, "Facebook says Apple iOS privacy change will result in $10 billion revenue hit this year," February 2, 2022, retrieved 2026-07-10, cnbc.com
• HubSpot, "Marketing efficiency ratio: How to calculate and improve yours," retrieved 2026-07-10, blog.hubspot.com/marketing/marketing-efficiency-ratio
• AdExchanger, "Walled Garden Platforms Are Drowning Marketers In Self-Attributed Sales," retrieved 2026-07-10, adexchanger.com