MER vs. ROAS: How One Can Rise While the Other Falls

Start With the Formula, Not the Label

This article uses two explicit MER conventions because “marketing spend” is not standardized:

These are reporting conventions, not universal definitions. A current Shopify guide defines MER as total revenue divided by total marketing spend, advises teams to choose and retain one revenue definition, and includes costs such as creative, tools, and agency fees in marketing spend. Some operators instead use ad spend alone. In this article, a higher MER means more defined revenue per dollar of the stated cost base.

Other systems reverse the ratio. The formula box in Triple Whale’s current MER documentation labels ad spend divided by order revenue as MER and calls the inverse—order revenue divided by ad spend—Blended ROAS. Under that convention, a lower MER is better. Its Blended Stats data dictionary also says that table’s spend field includes connected-channel ad spend plus custom expenses marked as ad spend. When querying that field, adding those marked expenses again would double-count them.

That is why “MER improved from 4 to 5” is incomplete. The statement needs a formula, a revenue field, a cost list, and a date basis. Otherwise two dashboards can use the same label for opposite arithmetic.

ROAS also needs a scope statement. Shopify’s marketing performance documentation defines campaign ROAS as campaign revenue divided by campaign spend and describes the adjacent Sales field as attributed sales after discounts and reversals, excluding tax and shipping. Google Ads reports conversion value per cost, but the value can depend on the selected conversion actions, attribution settings, modeled conversions, and reporting date. A platform ROAS is therefore not automatically comparable with a store-level revenue ratio.

Reconcile the Revenue Dollar Before Reading the Trend

A plausible-looking comparison can put checkout value in one numerator, product value in another, and refund-adjusted revenue in a third. Consider this fictional order:

All four highlighted numbers can be correct, but they describe different things:

• $118 is the original checkout charge.
• $100 is the discounted product value before tax and shipping.
• $74.80 is the cash retained after the product and tax refund, assuming shipping was not refunded.
• $60 is the remaining net product revenue under this article’s MER and reconciled-ROAS convention.

Shopify’s current Sales reports documentation distinguishes gross sales, discounts, sales reversals, shipping, tax, and total sales. It defines net sales as gross sales minus discounts and reversals, while total sales adds tax, duties, shipping, and fees. It also cautions that sales reports are not payment reports. Google Analytics’ ecommerce collection guide similarly places item value, tax, and shipping in separate purchase and refund parameters.

Suppose the ad platform initially received $100 as the conversion value. After the $40 product refund, a reconciled product-value report should carry $60, not $100, $40, or −$40. Google Ads’ conversion-adjustment instructions describe a RESTATE adjustment as the new conversion value, rather than the amount of the change. That capability does not prove that any particular store has implemented refund adjustments correctly; the order ID, upload logic, and resulting report still need inspection.

Dates can separate the same order again. Imagine an ad click on January 31, the purchase on February 2, and the refund on February 10. A click-date report can place the conversion back in January, while a purchase-date store report places the sale in February and a refund-date field records the reversal later. Google Ads explains that its primary conversion columns use click time and offers “by conv. time” columns for conversion-date reporting in its conversion tracking documentation. Northbeam’s Accounting Modes make the same distinction explicit: one mode assigns credit to the transaction date, while another assigns it to the interaction date.

If the January click cohort ultimately carries $60 of value against $20 of spend, its reconciled ROAS moves from 5.00x before the refund to 3.00x after the refund. A February-only report showing $60 of product revenue and no focal-channel spend does not have an infinite ROAS. It has a zero denominator and should be labeled not applicable.

Before comparing periods, freeze these fields:

1. Store, selling surface, geography, currency, and time zone.
2. Inclusive and exclusive date boundaries, plus equal data-maturity dates.
3. Revenue components: gross product sales, discounts, product reversals, tax, duties, fees, and customer shipping.
4. Refund treatment: original-order date, processing date, or cohort restatement.
5. Attribution model, conversion actions, click and view rules, and window.
6. Reporting date basis: click, interaction, order, conversion, or refund date.
7. Campaign and spend scope, including credits, taxes, and custom ad costs.
8. Nonmedia marketing categories and their service-period allocation.

Conversion windows deserve versioning, not a footnote. Google Ads says in its conversion-window documentation that a changed window applies going forward and can leave an earlier conversion uncounted rather than retroactively restoring it. Comparing two periods across an undocumented settings change can manufacture a ROAS trend even when customer behavior did not change in the same way.

Three Same-Store Cases That Produce Opposite Movements

The following cases are original, fictional calculations for one US online store in USD. Each compares two 28-day periods in the same time zone. Period 1 is a shared baseline; A, B, and C are alternative Period 2 worlds, not three consecutive observed months. Net product revenue excludes tax and customer shipping. The focal-channel value uses a fixed seven-day last-eligible-paid-click rule, purchase-date reporting, no view-through credit, and refund-adjusted product value.

The common baseline is:

• Net product revenue: $110,000 gross − $5,000 discounts − $5,000 refunds = $100,000.
• Focal media: $12,000; other media: $8,000; all media: $20,000.
• Attributed net product value: $41,000 gross − $2,000 discounts − $3,000 refunds = $36,000.
• Nonmedia marketing: $3,000 agency + $1,500 creative + $500 tools = $5,000.
• Product and fulfillment costs: ($47,000 COGS − $2,000 recovered COGS) + $10,000 fulfillment + $5,000 payment fees = $60,000.

The baseline therefore produces a 5.00x media-only MER, a 4.00x all-marketing MER, a 3.00x focal-channel ROAS, and $15,000 in defined contribution.

Case 1: MER Rises While ROAS Falls

In Period 2A, net revenue is $90,000 gross − $6,000 discounts − $4,000 refunds = $80,000. Focal spend is $6,000, other media is $4,000, and attributed value is $18,500 − $1,500 − $2,000 = $15,000. Nonmedia marketing remains $5,000. Product and fulfillment costs are ($41,500 − $1,500) + $8,000 + $4,000 = $52,000.

MER rises because media spend falls faster than store revenue. ROAS falls because attributed value falls faster than focal-channel spend. Both statements are arithmetic descriptions of their own inputs.

The dangerous conclusion would be “marketing became better, so the lower revenue is fine.” The store kept a larger percentage of each revenue dollar, yet produced $2,000 fewer contribution dollars. It may prefer that tradeoff, or it may have cut too deeply for its growth and cash goals. The ratios cannot make that choice.

Nor do they establish why revenue or attributed value fell. Spend cuts, weaker demand, inventory gaps, pricing changes, a promotion ending, customer-mix changes, attribution lag, or a tracking change could all fit the same ratios. The next action is to inspect those records and the business’s volume objective—not automatically restore spend and not celebrate MER in isolation.

Case 2: ROAS Rises While MER Falls

In Period 2B, net product revenue remains $100,000 from $115,000 gross − $10,000 discounts − $5,000 refunds. Focal spend falls to $10,000, but other media rises to $15,000. Focal attributed value becomes $46,000 − $3,000 − $3,000 = $40,000. Nonmedia marketing and product/fulfillment costs remain $5,000 and $60,000.

The focal channel receives more credited value on less spend, so its ROAS improves. Store revenue is flat while total media rises, so MER declines. The extra spend sits outside the focal-channel ROAS denominator.

There is no universal conversion between the two ratios. With aligned revenue components:

Channel ROAS = media-only MER × (channel-attributed value ÷ store revenue) ÷ (channel spend ÷ all media spend)

In this case, the focal channel’s attributed share of store revenue rises from 36% to 40%, while its share of media spend falls from 60% to 40%. Those shares explain the arithmetic, but “attributed share” is not the channel’s causal share of revenue.

It would also be wrong to compute the period difference as $4,000 more attributed value ÷ $2,000 less spend = −2.00x and call that incremental ROAS. Two period averages, with other media changing by $7,000, do not identify the counterfactual outcome without the focal spend change.

Case 3: A Cost-Scope Change Creates a False Improvement

Period 2C looks larger: net product revenue is $125,000 gross − $10,000 discounts − $5,000 refunds = $110,000. Focal spend is $15,000, other media is $10,000, and attributed value is $49,000 − $4,000 − $3,000 = $42,000. Product and fulfillment costs are ($51,500 − $2,000) + $11,000 + $5,500 = $66,000.

The crucial change is nonmedia marketing. It rises from $5,000 to $15,000 because creative production rises by $10,000.

The Period 1 denominator includes media and nonmedia marketing. The Period 2 denominator includes only media. The improvement is not comparable.

The contribution bridge is transparent: revenue rises $10,000, while product/fulfillment costs rise $6,000, media rises $5,000, and nonmedia marketing rises $10,000. The net change is +$10,000 − $6,000 − $5,000 − $10,000 = −$11,000.

Separate a real cost increase from a classification change. If the store simply reclassifies $2,000 of existing creative cost from nonmedia marketing into ad spend, total marketing cost stays $25,000 and contribution stays $15,000. Media-only MER changes from 5.00x to 4.55x, while all-marketing MER remains 4.00x. The business did not become less profitable; the label moved.

Timing can create another false comparison. A $2,800 creative project serving 28 days contributes $100 per service day, so a 14-day report would receive $1,400 under straight-line allocation. A payment-date report might show $0 or all $2,800. Triple Whale’s Custom Spend table is one documented example of a system that spreads multi-day custom expenses evenly across days. That is a vendor reporting rule, not a universal accounting standard, but it shows why the allocation method must be recorded.

Divergence Is an Investigation Prompt, Not a Diagnosis

When ROAS and MER disagree, operators often assign a story immediately: “organic grew,” “retention saved us,” “paid social is stealing credit,” or “brand search is doing all the work.” The ratios alone do not establish any of those explanations.

Platform totals are especially easy to misuse. Consider four fictional orders:

The two platforms report $400 in combined credit, less than the store’s $500 revenue. Yet O1 is counted twice. Unique credited revenue is $300, and revenue with no credit is $200. Subtracting the platform sum from store revenue gives $100—neither the uncredited amount nor “organic revenue.” Summing platform-attributed revenue can overlap even when the sum does not exceed store sales.

The reverse mistake is to treat total store revenue as advertising’s contribution. MER includes revenue from whatever is in the store total: customers exposed to ads, customers reached by other channels, returning customers, direct visits, promotions, seasonality, and demand that may have occurred without current-period media. MER supplies no no-ad counterfactual.

Use divergent ratios to order the investigation:

1. Scope: Did store, currency, date boundary, time zone, or campaign coverage change?
2. Revenue: Did gross-versus-net treatment, discounts, refunds, tax, or shipping change?
3. Attribution: Did the model, window, view credit, conversion actions, value rules, or reporting date change?
4. Maturity: Are the periods equally complete for conversion lag and refunds?
5. Spend: Are credits, custom ad expenses, agency fees, creative, and tools included once and allocated consistently?
6. Mix: Did branded demand, new-versus-returning customers, product availability, discounting, or channel mix change?
7. Economics: What happened to gross margin, fulfillment cost, payment fees, contribution dollars, and cash needs?
8. Causality: Does the proposed budget move require an experiment, a credible holdout, or an explicit forecast with sensitivity ranges?

This order prevents a configuration change from being misread as customer behavior and prevents an attribution change from being treated as incremental revenue.

Build a Same-Store Reconciliation Sheet

A useful worksheet keeps source fields intact and calculates reconciled fields beside them. Do not overwrite the platform’s native value to make it match finance. Preserve the original number, then show the adjustments that produce the comparable number.

For each period, enter these raw fields:

• Gross product sales, discounts, and product refunds.
• Tax, customer shipping, duties, and fees, even when the chosen revenue convention excludes them.
• Focal-channel spend, other-media spend, credits, and custom ad costs.
• Agency, creative, tools, and other nonmedia marketing costs not already counted in media.
• Attributed gross product value, attributed discounts, and attributed refunds under the documented rule.
• COGS, recovered COGS, fulfillment expense, and payment fees.

Then calculate:

• Net product revenue = gross product sales − discounts − product refunds
• All media = focal media + other media
• Reconciled attributed value = attributed gross value − attributed discounts − attributed refunds
• Media-only MER = net product revenue ÷ all media
• All-marketing MER = net product revenue ÷ (all media + nonmedia marketing)
• Channel ROAS = reconciled attributed value ÷ focal media
• Defined contribution = net product revenue − product/fulfillment costs − all media − nonmedia marketing

The reconciliation workbook includes the three filled cases, the $118/$100/$60 order bridge, the overlap example, a scope fingerprint, and exception tests. Its status logic treats denominators deliberately:

Finish the review with a one-paragraph decision record. State what the ratios establish, what changed in the raw inputs, which explanations remain plausible, what evidence would separate them, and what action is reversible now. “MER rose, ROAS fell” is not a decision record. “The media denominator fell 50%, store revenue fell 20%, attributed value fell 58%, contribution dollars fell $2,000, and the attribution configuration was unchanged” is the beginning of one.

The Decision Is Not MER Versus ROAS

MER and ROAS are useful because they compress different views of the business. That is also why neither should overrule the other.

Use MER to describe store revenue against a declared aggregate cost base. Use ROAS to describe value credited to a declared campaign or channel against its spend. Add contribution dollars and margin to show what the store kept under an explicit cost definition. Then check whether the periods are genuinely comparable before interpreting movement.

A higher MER can accompany lower revenue and lower contribution. A higher ROAS can accompany worse store-wide efficiency. A ratio can look better after a scope change while the economics deteriorate. And unattributed revenue is not automatically organic revenue.

When the ratios move in opposite directions, the answer is usually visible in one of four places: the revenue bridge, the spend bridge, the attribution configuration, or the reporting calendar. Reconcile those first. Only then decide whether the business needs a measurement fix, a budget change, a margin response, or a real test of incrementality.

Sources

• “Marketing Efficiency Ratio: How To Calculate + Improve MER”, Shopify, updated July 18, 2026.
• “Sales reports”, Shopify Help Center, checked September 8, 2026.
• “Measuring marketing performance”, Shopify Help Center, checked September 8, 2026.
• “MER”, Triple Whale Data Dictionary, checked September 8, 2026.
• “Blended Stats Table”, Triple Whale Data Dictionary, checked September 8, 2026.
• “Custom Spend Table”, Triple Whale Data Dictionary, checked September 8, 2026.
• “Accounting Modes”, Northbeam Technical Guides, checked September 8, 2026.
• “Measure ecommerce”, Google Analytics for Developers, updated August 19, 2026.
• “How to adjust your conversions”, Google Ads Help, checked September 8, 2026.
• “About conversion windows”, Google Ads Help, checked September 8, 2026.
• “Understand your conversion tracking data”, Google Ads Help, checked September 8, 2026.