Common MER Mistakes on Shopify

Mistake 1: Including Non-Ad Spend in the Denominator

The most common error: operators calculate MER by dividing revenue by 'marketing spend' that includes content creation, email platform fees, affiliate commissions, and influencer retainers. This inflates the denominator and suppresses MER, making paid channels appear worse than they are.

MER should isolate paid media spend only - Facebook, Google, TikTok, Pinterest, YouTube ads, and programmatic buys. Exclude: email software (Klaviyo, Omnisend), content tools, design, and agency fees unless those fees are directly tied to a specific paid campaign.

Decision rule: If the cost doesn't appear on a platform's invoice or in a media buyer's PO, it doesn't belong in MER. Separate 'total marketing spend' from 'paid media spend.' Track both, but use paid media spend for MER.

Mistake 2: Mixing Attributed and Organic Revenue

Numerator error: counting all revenue (direct, organic, referral, email) as 'attributed' to paid ads. This happens when Shopify's native attribution is not configured, or when operators assume all traffic is paid-driven.

Shopify's default attribution window is 30 days, last-click. If a customer lands on a paid ad, leaves, returns via organic search, and buys - Shopify attributes the sale to organic. If the operator then includes that sale in MER, the ratio becomes meaningless.

Procedure: Audit your Shopify attribution settings. Confirm the attribution model (last-click, first-click, linear, time-decay). Pull revenue reports filtered by 'attributed source' - not all revenue. Cross-check with platform-native reporting (Meta Ads Manager, Google Analytics 4) to spot discrepancies. If discrepancies exceed 10%, investigate pixel setup and consent settings.

Mistake 3: Ignoring Channel Bleed and Cannibalization

Channel bleed: a customer sees a Facebook ad, doesn't click, then searches the brand name on Google and converts. Google attributes the sale; Facebook's MER appears lower than it is. Across multiple channels, this creates a false picture of efficiency.

Cannibalization occurs when a high-MER channel (e.g., branded search) steals credit from a lower-MER channel (e.g., prospecting display). If you cut display spend, branded search volume often drops 15 - 25% within 2 weeks, revealing hidden dependency.

Mitigation: Run incrementality tests quarterly. Pause a channel for 3 - 7 days, measure revenue lift or drop in other channels, then calculate true incremental MER. For smaller budgets, use multi-touch attribution (Littledata, Northbeam) to weight first-click and last-click equally. Accept that MER is a directional signal, not gospel.

Mistake 4: Setting MER Thresholds Without Unit Economics

Operators often adopt a blanket MER target (e.g., 'we need 3.0x') without tying it to COGS, fulfillment, and overhead. A 3.0x MER on a 60% - margin product is profitable; on a 30% - margin product, it's a loss leader.

Correct threshold formula: Minimum MER = 1 ÷ (Gross Margin % - (Fixed Overhead % + CAC Payback Period Cost %)). Example: 60% gross margin, 15% overhead, 5% CAC payback = Minimum MER of 1 ÷ 0.40 = 2.5x.

Checklist: (1) Calculate gross margin per product or category. (2) Estimate fixed overhead as % of revenue (rent, salaries, software). (3) Set minimum MER threshold per channel based on that math. (4) Review quarterly as costs change. (5) Flag any channel below threshold for optimization or pause.

Mistake 5: Not Accounting for Seasonal Variance and Cohort Decay

MER calculated in November (peak season) will be 40 - 60% higher than January. Operators who compare month-to-month MER without seasonality context make false conclusions about channel health.

Cohort decay: customers acquired in month 1 may return and repurchase in months 2 - 6. If MER is calculated on first-purchase revenue only, repeat purchase revenue is invisible, and true customer LTV is underestimated.

Procedure: Calculate MER on a rolling 90 - day basis to smooth seasonal noise. Separately track first-purchase MER and repeat-purchase rate. If repeat rate is above 20%, adjust your minimum MER threshold downward by 10 - 15%, since future revenue is baked in. Cohort analysis: segment customers by acquisition month and track their 6 - month revenue contribution.

Mistake 6: Confusing MER with ROAS

ROAS (Return on Ad Spend) is platform-native and includes platform-attributed revenue only. MER is broader and includes all attributed revenue across channels. A Facebook campaign may show 2.5x ROAS in Ads Manager but contribute to a 3.5x MER when organic and email follow-up are factored in.

Using ROAS to optimize individual campaigns is correct. Using ROAS to evaluate overall channel profitability is incomplete. Operators who rely solely on ROAS miss cross-channel effects and repeat purchase signals.

Rule: Use ROAS for daily campaign optimization. Use MER for monthly channel strategy and budget allocation. If ROAS and MER diverge by more than 20%, audit attribution setup.

Mistake 7: Failing to Segment MER by Customer Acquisition Source and Product

Blended MER hides winners and losers. A brand may have a 3.2x blended MER but Facebook prospecting at 1.8x and Google branded at 5.2x. Cutting Facebook would be a mistake; optimizing it is the play.

Product-level MER is equally critical. A high-AOV product may have a 4.0x MER while a low-AOV product has 2.0x. Allocating budget proportionally to blended MER starves the high-AOV product.

Checklist: (1) Segment MER by channel (Facebook, Google, TikTok, etc.). (2) Segment by campaign type (prospecting, retargeting, branded). (3) Segment by product category or SKU. (4) Identify the top 3 segments by MER and the bottom 3. (5) Allocate 60% of budget to top 3, 30% to middle, 10% to bottom (test and learn). (6) Review weekly.

Questions

FAQ

What's a good MER for a Shopify DTC brand?

Depends on margin. For a 60% gross margin brand, 2.5x - 3.5x is healthy; 2.0x is breakeven. For a 40% margin brand, 3.5x - 4.5x is required. For a 30% margin brand, 5.0x+ is needed. Always calculate your minimum threshold first, then benchmark against it, not against industry averages.

Should I include email and SMS revenue in MER?

No. MER measures paid media efficiency. Email and SMS are owned channels. Track their ROI separately (email revenue ÷ email platform cost). If an email campaign promotes a paid ad offer, attribute that revenue to the paid channel, not email. Keep channels separate to avoid double-counting.

How often should I recalculate MER?

Weekly for individual channels and campaigns (to catch underperformers early). Monthly for blended and segment-level MER (to smooth daily variance). Quarterly for threshold review and unit economics recalibration. Avoid daily MER swings - they're noise.

What's the difference between MER and CAC payback?

MER is a ratio of revenue to spend. CAC payback is the number of months until a customer's lifetime value covers their acquisition cost. MER is a snapshot; CAC payback is a forward-looking metric. Both matter. A 3.0x MER on day 1 is good; if CAC payback is 18 months, cash flow is tight.

Want this on your account?

Thirty minutes. Bring the number that keeps you up.

Book a demo