How to calculate MER for your store, step by step

Usually it is one division with careful inputs. Take a full month of net sales from Shopify. Add up the same month's ad spend from Google Ads, Meta and every other channel you paid. Divide sales by spend. Then hold the result against your break-even line and last month, or it tells you little.

The sum takes a minute. Getting the same dates, the same revenue and every cost into it takes the rest of your coffee.

Step by step

1. Pick one calendar month and use it everywhere. Each tool opens on its own date range, so set the month by hand every time. In Shopify, the Group by drop-down groups sales by month, and you can compare date ranges. Menu path: Analytics > Reports > Total sales over time > Group by > Month.
2. Pull net sales from Shopify. Open the Total sales over time report and read net sales for your month. Shopify defines net sales as gross sales minus discounts minus sales reversals, which cover returns, cancellations and order edits. Menu path: Analytics > Reports > Category filter > Sales > Total sales over time.
3. Note what total sales would add. Total sales puts taxes, duties, shipping charges and fees back on top of net sales. Use net sales for MER, and write that choice next to the number. Menu path: the same report, where total sales sits beside net sales.
4. Total your Google Ads cost. Click the Campaigns icon, then Campaigns in the section menu, and set the date menu to your month. Read Cost in the totals row at the bottom of the table; Google defines Cost as the total spend for all interactions. Menu path: Campaigns icon > Campaigns > date menu > totals row, Cost column.
5. Total your Meta spend. In Meta Ads Manager, the Account Overview section shows the amount spent across all your campaigns for the dates you choose. Meta calls that figure an estimate while results process, so pull it two days after the month ends. Menu path: Ads Manager > Account Overview > amount spent.
6. Add every other channel you paid. TikTok, affiliates, creators and agencies all belong in the sum if they bought attention that month. Take each figure from that channel's own billing page or invoice, for the same dates. Menu path: each platform's billing or invoice page.
7. Cross-check against GA4. The top row of GA4's All channels report shows Ads cost and Return on ad spend. That ratio divides revenue for the selected key events by the ad costs GA4 knows about. Those come from linked Google ad accounts and campaign data you import. Menu path: Advertising > Planning > All channels.
8. Divide, then hold it against your break-even line. MER is net sales divided by total spend. For the line, divide 1 by your gross margin after shipping and payment costs, or let the free blended ROAS calculator do both sums. Menu path: Analytics > Reports > Category filter > Profit Margin > Gross profit by product.

A worked example

For illustration, here is one invented month, in round numbers.

In this worked example, MER on net sales is €80,000 divided by €20,000, or 4.0. On total sales the same month reads 4.8, because taxes and shipping ride along on top. Turned over, spend is 25% of net sales in this worked example. That reading sits well next to a margin. In this worked example, a 40% margin minus a 25% cost share leaves 15% of net sales for everything else.

Next, the line it has to clear. One store's Break-even sheet shows the arithmetic: at a 40% margin, 1 divided by 0.40 is 2.5x. In this worked example, an MER of 4.0 clears a 2.5x line with room to spare.

Now the second month. Say the next month's spend rises to €30,000 and net sales reach €95,000. In the worked example, MER drops to about 3.2, which still looks safe against 2.5x. Yet in this worked example the extra €10,000 of spend came with €15,000 of extra sales: a ratio of 1.5. If your margin is 40%, those extra sales left €6,000 of gross profit to pay for €10,000 of ads.

The average says carry on. The change says the extra spend lost money. That is why step 8 asks for last month as well as the line.

Time is the other input. One store's Journeys sheet shows why a single week is too short: journeys of 10 or more touches took 16.0 days to buy. A month gives slow buyers more room to land in the same window as the spend that found them.

What should I check when the MER looks wrong?

It jumped in a sale month. Discounts come off net sales, but a promotion also pulls orders forward from the weeks around it. Read the sale month together with the month after before you judge either.

Spend looks too low. Meta's figure may still be an estimate if you pulled it within 48 hours of month end. Google Ads may still show its default view of the last 30 days instead of your calendar month. And a channel with no ads manager, such as creators, is easy to leave out.

Revenue looks too high. You may have used total sales, which carries taxes, duties, shipping charges and fees. Gross sales runs high too: Shopify includes pending, canceled and unpaid orders in it.

Last month changed after you closed it. Shopify shows a return as a negative number on the date the return was processed. An order edited after the day it was placed shows up as a separate order on the Total sales over time report. So a late refund lands in the month you process it. Recalculate the past month once, then freeze it.

Meta's billing does not match Ads Manager. The Billing section of Ads Manager lists what you were charged, with a receipt for each payment. Ads Manager shows estimated spend for the dates you pick. Choose one source per channel and stick with it.

Two people get two different MERs. Usually the definitions differ, not the arithmetic. One used total sales and the other net sales, or one counted agency fees and the other did not. Put the definition at the top of the sheet, above the number.

GA4 disagrees with you. GA4's Return on ad spend uses the revenue its tag recorded and only the costs it was given. Shopify's figure comes from the orders themselves. Expect a gap, and use Shopify for the top line.

What to do this week

1. Calculate last month's MER on net sales. Follow steps 1 to 8 above. Pass: one number, with its revenue line, cost list and dates written beside it. Fail: the Google Ads figure covers the default date range, not your calendar month.
2. Repeat it for the two months before. Use the same definition every time. Pass: you can see whether MER moved with spend or against it. Fail: you have one month on its own, which says as much about a trend as one photo says about a film.
3. Price the change, not the level. Divide the change in net sales by the change in total spend between two months. Pass: that ratio stays above your break-even line. Fail: the extra spend returns less than the line while MER still looks fine.

Check the homework. Your GA4 Attribution paths export already holds the evidence. Causality Engine reads that one file and shows what each channel caused next to what last-click gave it, in 1 to 2 minutes, for €99 once (excluding VAT), refundable within 30 days. Check the homework

Sources, 1 October 2026: Sales reports (Shopify Help Center); Profit reports (Shopify Help Center); Account, campaign, and ad group performance (Google Ads Help); About columns in your statistics table (Google Ads Help); Why amount spent is different in ad account spending limit, Meta Ads Manager and billing history (Meta Business Help Center); All channels performance report (Google Analytics Help).

Related answers

• All ROAS & margin questions
• What is MER in ecommerce?
• What does MER tell a home goods store?
• Marketing mix modeling, explained