Ecommerce marketers have too many efficiency metrics fighting for attention, and half of them contradict each other by Friday. If your Meta ROAS looks great but your bank balance doesn't agree, MER is probably the metric you're missing. Here's how to calculate MER for ecommerce, why it matters more than most platform dashboards, and where it still leaves gaps you need to fill with other numbers.
What MER Is and Why Ecommerce Teams Track It
MER stands for Marketing Efficiency Ratio. It's total revenue divided by total marketing spend, full stop. No channel breakdowns, no attribution windows, no click models.
That simplicity is the point. Platform-level ROAS from Meta or Google gets inflated constantly because both platforms want credit for the same sale. Someone sees a TikTok ad, clicks a Google search ad two days later, then converts from an email. Three channels, one sale, and if you add up the "attributed revenue" from each platform's dashboard, you'll double or triple count that single purchase.
MER doesn't care which channel gets the credit. It just asks: how much did we spend, and how much did we make? That's why more ecommerce teams are learning how to calculate MER for their business instead of trusting whatever number Ads Manager shows them.
One thing to get straight up front: MER is a blended, account-level number. It's not something you calculate per campaign or per ad set. If you're trying to diagnose why one specific campaign underperformed, MER won't tell you. It's a top-line health check, not a microscope.
The MER Formula
The formula is about as simple as ecommerce math gets:
MER = Total Revenue / Total Ad Spend
Two words in that formula do a lot of work, though: "total" and "total."
Total revenue means store-wide revenue for the period you're measuring, full stop. Not paid-attributed revenue, not "revenue we think came from ads." Every dollar that hit your Shopify or Amazon account counts, including organic, email, direct traffic, and referral sales.
Total ad spend means every paid channel combined: Meta, Google, TikTok, affiliate payouts, influencer fees, retargeting, all of it. If you're only plugging in your Meta spend because that's the tab you have open, you're not calculating MER, you're calculating a weird half-version of ROAS with a different name.
This is where a lot of DIY spreadsheets fall apart. Pulling spend from three or four platforms and reconciling it against store revenue by hand is tedious, and it's the exact kind of pooled-data problem a BI reporting setup is built to solve instead of a manual export routine.
Step-by-Step: Calculating MER With Real Numbers
Let's run actual numbers so this isn't abstract.
Say your store did $250,000 in revenue last month. Across Meta, Google, and TikTok combined, you spent $50,000 on ads. Divide the two:
$250,000 / $50,000 = 5.0 MER
That's a strong blended ratio, five dollars back for every dollar spent across the board.
Now a leaner example. A different brand pulls in $120,000 in monthly revenue on $40,000 of total ad spend:
$120,000 / $40,000 = 3.0 MER
Still profitable for a lot of business models, just a much tighter margin for error.
On cadence: check MER weekly for pacing, so you catch a spend spike or a revenue dip before it snowballs. Run the monthly view for trend analysis, since a single week can get skewed by a promo, a restock delay, or a platform outage.
The most common mistake here isn't the math, it's the inputs. Teams calculate what they think is MER using only their Meta spend, get a number that looks amazing, and then wonder why cash flow doesn't match. If you're skipping TikTok spend or affiliate payouts from the denominator, you're not looking at MER. You're looking at a single-channel ROAS wearing a MER costume.
MER vs ROAS vs CAC: How They're Different
These three get lumped together constantly, but they answer different questions.
MER
- What it measures: Blended marketing efficiency across the entire business
- Formula: Total Revenue / Total Ad Spend
- Attribution model: None, it ignores channel-level credit entirely
Platform ROAS
- What it measures: Efficiency of one specific channel or campaign
- Formula: Attributed Revenue / Spend on that channel
- Attribution model: Depends on the platform's click/view window, which varies by platform and inflates easily
CAC
- What it measures: Cost to acquire one new customer
- Formula: Total Spend / New Customers Acquired
- Attribution model: None for spend, but relies on accurate new-vs-returning customer data
Here's why the gap matters. A brand can post a 6.0 ROAS on Meta and still have a mediocre 2.5 MER, because the rest of the budget is scattered across TikTok and affiliate placements that barely break even. Meta looks like the hero. The full picture says otherwise.
MER is also just harder to game. Platform ROAS numbers move depending on which attribution window you pick, last-click versus 7-day-click versus data-driven modeling, and marketers (sometimes unintentionally) pick the model that flatters them. MER strips all of that out. Revenue is revenue, spend is spend. Check your ROAS calculator against your MER regularly, because a widening gap between the two is usually the first sign attribution is lying to you.
What's a Good MER? Benchmarks by Business Stage
There's no universal "good" MER, but here are rough, directional ranges worth knowing.
A MER between 2.0x and 3.0x can be perfectly sustainable, especially for high-margin brands with strong AOV. A MER of 4.0x or higher often means there's room to scale spend further before efficiency starts to erode.
But margin changes everything. A supplement brand at 70% gross margin can run profitably at a 2.5 MER. A brand selling low-margin hardware at 25% margin needs a much higher MER just to break even after fulfillment and COGS. If you're benchmarking against another brand's MER without knowing their margin structure, you're comparing two different sports.
The bigger point: don't obsess over one week's number. A single MER reading is a snapshot, and snapshots lie. What actually matters is the trend. If MER slips steadily over 4 to 6 weeks, even by small amounts, that's the real signal something's off, whether it's rising CPMs, creative fatigue, or a channel quietly bleeding budget. Marketing leaders who track this weekly catch it early. Those checking monthly usually catch it after the damage is done, which is exactly the kind of gap marketing leaders tell us they're trying to close.
Where MER Falls Short (and What to Pair It With)
MER is a great top-line check. It's a bad diagnostic tool on its own.
Here's the limitation nobody mentions enough: MER hides which channel or campaign is actually responsible for the result. A 4.0 MER could mean everything is humming, or it could mean Google is carrying the whole account while TikTok quietly loses money every day. You won't know from the blended number alone.
It also has a blind spot around organic and brand-driven revenue. If your total revenue includes a large chunk of direct and organic traffic (because your brand has real word-of-mouth pull), your MER can look healthy even while your actual paid channels are inefficient. The organic sales are propping up the ratio and masking the problem.
So pair it. Use MER to spot a shift, then drop into channel-level ROAS to find where it's coming from, and check contribution margin to confirm the sales you're getting are actually profitable after COGS and fulfillment, not just top-line revenue. Our data dictionary breaks down how each of these metrics is defined and calculated if you want the full set side by side.
Tracking MER Without the Manual Spreadsheet Work
Most teams calculate MER the hard way: export Meta spend, export Google spend, export TikTok spend, pull revenue from Shopify (and Amazon if you sell there too), then stitch it all into a spreadsheet, once a week if you're disciplined, once a month if you're not.
It works, technically. It's also slow, error-prone, and almost always a lagging indicator by the time someone actually looks at it.
Trivas runs this differently. Ad spend and revenue data get pooled into a Redshift-based warehouse, and MER (along with ROAS, CAC, and contribution margin) calculates automatically, daily, not just when someone remembers to update the tab. The practical difference: a MER drop shows up within a few days instead of surfacing at next month's marketing review, by which point you've already burned through a few weeks of inefficient spend.
Get MER (and Every Other Metric) in One Dashboard
MER comes down to one formula: Total Revenue divided by Total Ad Spend, tracked over time, and read alongside channel-level ROAS and contribution margin rather than in isolation.
If you're still piecing this together by hand every Monday morning, it might be worth seeing what it looks like automated. You can start a free trial and watch blended MER calculate itself across Shopify, Amazon, and your ad platforms, no spreadsheet required.
.d53b12e5.png&w=3840&q=75)


