Your Meta dashboard says you are printing money. Shopify says revenue is up. Your bank account tells a less exciting story.
That gap is exactly why founders need to know how to calculate Shopify MER. It is one of the few numbers that cuts through platform attribution, agency slide decks and conveniently selected date ranges. It tells you how efficiently your total advertising spend is turning into Shopify revenue.
Not how good one campaign looks. Not how cleverly Meta claims credit. The whole commercial picture.
What Shopify MER actually measures
MER stands for Marketing Efficiency Ratio. In practical ecommerce terms, it measures the revenue your store generates for every dollar spent on advertising.
The core formula is simple:
Shopify MER = Total Shopify revenue ÷ Total ad spend
If your Shopify store made $100,000 in revenue last month and you spent $20,000 on paid advertising, your MER was 5.0.
That means every $1 in advertising produced $5 in Shopify revenue.
A higher MER is generally better, but do not get carried away. A 7.0 MER is not automatically healthier than a 4.0 MER. If you are sitting at 7.0 because you have stopped acquiring new customers, cut spend and are relying on repeat buyers, you may be protecting efficiency while starving future growth.
MER is a decision-making metric, not a trophy.
How to calculate Shopify MER properly
The maths takes 30 seconds. Getting clean inputs takes more discipline.
Start by selecting a fixed period. For most founder-led brands, a trailing 30-day view is the most useful operating window. It smooths out weekend swings, payday behaviour, creative launches and short-term attribution lag without hiding a serious performance problem for an entire quarter.
Take total sales revenue from Shopify for that exact period. Then divide it by every paid media dollar spent to generate demand in that period.
For example, say your last 30 days look like this:
- Shopify total sales: $150,000
- Meta spend: $24,000
- Google Ads spend: $9,000
- TikTok spend: $2,000
Your total ad spend is $35,000.
$150,000 ÷ $35,000 = 4.29 MER
Your Shopify MER is 4.29. Put another way, you generated $4.29 in store revenue per $1 spent on paid media.
That number is more useful than looking at Meta’s reported 6.5 ROAS in isolation, particularly when Meta is only one part of the acquisition system. Meta may influence a customer who later searches your brand on Google, returns through an email campaign, or purchases directly three days later. Shopify revenue captures the outcome. Platform reporting mostly captures the argument over credit.
Use the same rules every time
The quickest way to turn MER into rubbish is to change what counts whenever the number becomes uncomfortable.
If you include Meta, Google and TikTok spend this month, include them next month. If you use Shopify gross sales, use gross sales consistently. If you exclude GST, refunds or shipping from revenue, document it and keep the treatment unchanged.
For most Australian Shopify brands, a sensible management view is to use Shopify sales excluding GST where possible, then make a deliberate choice on refunds. Brands with meaningful returns should look at net sales or monitor a second, refund-adjusted MER. A fashion brand with a 20% return rate can look far healthier on gross revenue than it is in reality.
There is no magical universal setup. There is only a consistent setup that reflects how your business actually earns money.
What should count as ad spend?
For a standard blended Shopify MER, include all media spend that is intended to drive sales: Meta, Google, TikTok, Pinterest, YouTube, affiliates paid on media-like placements and any other acquisition channel you use.
Do not quietly leave out the channels that make the calculation look worse. That is not optimisation. It is reporting theatre.
Agency fees, creative production and software costs are usually excluded from the headline MER because they are not media spend. But excluding them does not mean ignoring them. A brand spending $30,000 on ads and $12,000 on agency and creative costs has a different commercial reality to a brand spending the same $30,000 with a lean in-house setup.
Use a second measure when you need that fuller picture:
Fully loaded marketing efficiency = Shopify revenue ÷ (ad spend + agency fees + creative costs + relevant marketing overheads)
Keep this separate from your core MER. Otherwise, you will compare two different calculations and call it a performance trend.
MER is not your break-even point
This is where plenty of brands get sloppy. A positive MER does not mean profitable growth.
Your break-even MER depends on gross margin, shipping, fulfilment, payment fees, discounts, returns and the variable costs that rise with every additional order. If your contribution margin before advertising is 30%, you need roughly a 3.33 MER just to cover ad spend. If your contribution margin is 20%, you need a 5.0 MER.
A simplified calculation looks like this:
Break-even MER = 1 ÷ contribution margin before ad spend
So if you retain $0.25 from each revenue dollar before paid media, your break-even MER is 4.0. Below that, paid acquisition is likely destroying cash on first purchase. Above it, you have room to cover fixed costs and generate profit.
The word “likely” matters. Repeat purchase rate changes the equation. A brand with strong 90-day repeat revenue may deliberately acquire a first order below immediate break-even. That can be commercially smart, but only if the retention data is real and cash flow can carry the acquisition period. Hope is not an LTV model.
Why Meta ROAS and Shopify MER rarely match
Meta reports attributed revenue based on its tracking rules, attribution settings and view-through assumptions. Shopify reports orders that occurred in your store. Neither number is useless. They answer different questions.
Meta ROAS helps you decide what creative, audience and campaign structure deserves more budget. Shopify MER tells you whether the total marketing machine is moving the business forward.
If Meta ROAS drops slightly while Shopify MER rises, you may be getting broader demand creation that the platform cannot claim cleanly. If Meta ROAS looks brilliant while Shopify MER falls, something is wrong. You could be over-attributing existing demand, cannibalising brand search, discounting too aggressively or spending more to get revenue that was already coming.
The founder mistake is choosing the prettier number. The operator move is investigating the discrepancy.
Read Shopify MER alongside the numbers that explain it
MER tells you whether the machine is efficient. It does not tell you why. For that, look at new customer revenue, customer acquisition cost, conversion rate, average order value, gross margin and repeat purchase behaviour.
A falling MER with rising new customer volume may be acceptable if your margin and retention support it. A rising MER with declining new customer volume can signal that you are harvesting existing demand. Neither scenario is automatically good or bad. Context decides it.
Watch the trend rather than reacting to one ugly day. Review 7-day MER for pace, 30-day MER for decisions and 90-day MER for strategic direction. If all three are deteriorating, do not wait for the next monthly report to act.
The common ways brands manipulate their own MER
Most MER mistakes are not calculation errors. They are incentives wearing a spreadsheet costume.
Some brands use a sale period to celebrate a temporary MER spike while ignoring the discount that stripped margin out of every order. Others exclude Google brand spend, even though those ads are catching customers who were pushed into search by Meta. Some use total Shopify revenue during a wholesale-heavy month, then credit paid social for sales it had nothing to do with.
Keep separate revenue sources separate. If wholesale, retail, subscriptions or offline sales sit inside your reporting, build a clear ecommerce revenue view before calculating MER. The aim is not to produce the largest number. It is to produce the number you can make hard decisions from.
A better way to use MER in your weekly operating rhythm
Every week, record Shopify revenue, total paid spend, MER, new customer revenue and spend by channel. Add a brief note explaining anything unusual: stockouts, a major promotion, an email launch, a creative test, a site issue or a change in tracking.
Then ask three blunt questions. Is MER above our break-even threshold? Is new customer acquisition growing at a cost the business can afford? Are we seeing a temporary wobble or a sustained decline?
That is enough to force better conversations with your team or agency. “ROAS went down” is vague. “Blended MER has fallen from 4.6 to 3.8 for three consecutive 30-day periods while new customer revenue is flat” is a commercial problem with nowhere to hide.
The point of calculating Shopify MER is not to find a comforting benchmark. It is to know, early and honestly, whether more ad spend is building a larger business or simply making the same revenue more expensive.