Skip to content
Marketing Calc Hub

Campaign ROI tracker

Track up to 10 campaigns' spend, revenue, and ROAS side-by-side with CSV-ready PDF export.

Total spend
$57,000
Total revenue
$225,000
Blended MER
3.95x

Q2 Meta Prospect

Brand Search

TikTok UGC

LinkedIn ABM

Email / Klaviyo

ROAS by campaign

Spend mix by channel

Why campaign-level ROI tracking fails in most marketing teams

The single most common reporting mistake I've seen in 2025–26 client audits: teams report platform-reported ROAS (Meta says 4.2x, Google says 3.8x) and treat those numbers as truth. They are not truth. Platform ROAS double-counts conversions that multiple platforms claim credit for, ignores the cost of creative / agency / tooling, and in most cases overstates contribution by 25–60% versus true incrementality. The result: budgets inflate on "winning" campaigns that, in reality, are producing less profit than the dashboard shows. This tracker uses MER (Media Efficiency Ratio) — total revenue divided by total spend — as the primary truth metric, with platform ROAS as secondary context.

MER has three advantages over platform ROAS: (1) it cannot double-count conversions because the numerator is all revenue, not platform-attributed revenue, (2) it includes fixed costs (creative, agency, tooling) that platform ROAS ignores, (3) it aligns with finance's view of the business. Finance doesn't care what Meta says its ROAS was. Finance cares whether total marketing spend produced more revenue than it cost, including all overhead. MER is the shared truth metric.

MER benchmarks by business type (2026)

DTC ecommerce mature ($5M+ revenue)3.0–4.5x MERAt steady-state spend
DTC ecommerce scaling ($2–5M)2.2–3.2x MERInvestment mode tolerated
B2B SaaS mature ($10M+ ARR)3.5–5.0x MEROver 12-month LTV window
B2B SaaS early stage ($1–5M ARR)1.8–2.8x MERPayback over 18–24 months
High-ticket coaching / services4.0–8.0x MERHigher margins justify higher MER
Marketplace / platform2.5–4.0x MERAccount for take rate
Subscription media / content2.0–3.0x MERPayback 4–8 months

The target MER question: what should yours be?

Target MER is a function of gross margin, customer repurchase rate, and cash runway. A DTC brand with 60% gross margin and 35% 90-day repeat rate can operate at 2.5x MER indefinitely. The same brand with 30% gross margin and 15% repeat rate needs 4.0x+ MER to be profitable. The formula is: Target MER = 1 / (gross margin × (1 + LTV multiplier)) where LTV multiplier is your expected repeat value as a fraction of first purchase. Most teams set target MER based on gut or comparison to "what we did last year," which drifts further from profitable as unit economics shift.

Tracking campaigns at three levels of granularity

Campaign-level tracking should happen at three levels: (1) blended MER across all channels weekly — the finance truth, (2) channel-level MER monthly — Meta MER vs Google MER vs TikTok MER, (3) campaign-level platform ROAS daily for operational optimization. Most teams invert this — they report platform ROAS daily, channel MER quarterly, and blended MER never. Fix that inversion and reporting quality jumps dramatically.

Blended MERWeekly, leadership reviewTotal revenue / total spend
Channel MERMonthlyIncludes platform-specific costs
Campaign platform ROASDailyOperational optimization
Creative-level platform ROASWeeklyFatigue + scaling decisions
Cohort LTV vs CACMonthlyTrue profitability measure

What belongs in spend: all of it, or you're lying to yourself

MER accuracy depends on including all costs. A common understatement: teams include only paid media spend in the denominator, excluding creative production ($15–40k/month for a scaling DTC brand), agency fees ($5–30k/month), platform tools ($2–10k/month Klaviyo, Triple Whale, Northbeam, etc.), and internal marketing salaries ($20–100k/month fully loaded). Including all of it is the honest view. At $200k/month in ad spend plus $60k/month in creative + agency + tools, your true MER denominator is $260k, not $200k. The 4.5x MER on ad spend drops to 3.5x MER on total marketing cost. The lower number is the right one.

Campaign lifecycle: launch, scale, plateau, kill

Most campaigns follow a predictable lifecycle: (1) Launch week — data is noisy, hold judgment; optimize budget allocation minimally. (2) Week 2–3 — signal emerges; campaigns either hit target MER or fall 30%+ below. (3) Week 4–6 — scaling window; if MER is at or above target, raise budget 15–30% per week. (4) Week 7–12 — plateau; MER drift downward is normal as the campaign saturates its best audience. (5) Week 13+ — decay; MER typically falls below target. Kill and replace. The teams that get in trouble are the ones that ignore the plateau-to-decay transition and keep spending. A campaign that hit 4.2x MER in week 5 and drifts to 2.1x MER in week 14 needs to be killed, not saved.

The weekly campaign review ritual

  1. Pull blended MER last 7 days vs previous 7 days vs target.
  2. List top 5 spending campaigns with platform ROAS, CPA, and trend (up / flat / down).
  3. Flag campaigns below kill criteria for 3+ consecutive days. Kill or pause immediately.
  4. Flag campaigns above target for 7+ consecutive days. Scale budget 20–30%.
  5. Review creative performance on top campaigns — hook/hold/CTR/CVR scorecard.
  6. Plan next-week spend with shifted budget. Document changes in shared doc.
  7. End-of-month reconcile channel MER vs finance-reported revenue to catch tracking drift.

Incrementality testing: the truth-check every team should run

Platform ROAS is modeled; incrementality is measured. Run a geo holdout or PSA test at least once per year on each major paid channel to validate that platform-reported ROAS reflects real incrementality. The methodology: pause the channel in a matched-pair test geography for 4 weeks; measure the revenue delta vs the control geography; divide by the spend in the control to get true incremental ROAS. Most tests reveal platform ROAS overstates incrementality by 25–60%. That haircut gets applied to budget allocation decisions — if Meta overstates by 40%, your 4.2x platform ROAS is really 2.5x incremental. Plan accordingly.

Meta incrementality haircut30–45%Average across 12 tests I ran
Google Search incrementality haircut10–20%Brand-term queries inflate self-report
TikTok incrementality haircut40–60%Self-report least reliable
LinkedIn incrementality haircut15–25%B2B sales cycle lag masks signal

Real-world example: how MER tracking saved $140k in a quarter

A DTC home goods brand ($4.8M annual revenue, $55 AOV, 42% gross margin) was reporting a healthy 3.8x blended ROAS in their weekly platform dashboard. But when we installed MER tracking — pulling total revenue from Shopify, total marketing spend from the category ledger (including $22k/month in creative + agency + tools they had been excluding) — the actual MER was 2.4x. Against their 40% gross margin, a 2.4x MER was barely covering variable costs. The team had been increasing ad spend based on the 3.8x platform ROAS for 6 months.

The fix: installed weekly MER reconciliation, discovered Meta was double-counting 38% of conversions that Google also claimed, killed two underperforming Meta ad sets representing $35,000/month of spend, reallocated to Google Shopping where true incremental ROAS was 4.2x. Over the next 90 days, true MER improved from 2.4x to 3.1x while ad spend dropped from $140k to $105k/month. Contribution margin improvement: $38,500/month, or $140k over the quarter — generated entirely from fixing the reporting layer, not from new creative or audiences.

Frequently asked questions

Q1.What's the difference between MER and ROAS?
ROAS is platform-reported (Meta says 4x; Google says 3.5x). MER is total revenue divided by total spend across all channels, including non-platform costs (creative, agency, tools). MER cannot double-count conversions and aligns with finance's view. Use MER as the primary truth metric; use platform ROAS for operational decisions only.
Q2.How often should I reconcile MER with finance?
Monthly minimum. Pull total revenue from finance (not from platform attribution), total marketing spend from your category ledger, and divide. Compare to what you've been reporting weekly. Any gap above 5% indicates tracking drift — investigate before the gap compounds.
Q3.What if my blended MER is healthy but one channel is failing?
The healthy blended number can mask a dying channel. If Meta is at 1.8x while Google is at 6.5x, the 4x blended average is hiding that Meta is unprofitable. Run channel-level MER monthly — don't let blended cover up channel-level problems.
Q4.How do I handle lagged revenue in SaaS or high-ticket services?
Use LTV-based MER instead of 0-day revenue MER. Attribute projected 12-month LTV to each new customer, not first-purchase revenue. For a B2B SaaS with $2k monthly ACV and 24-month average retention, a new customer is worth $48k for MER purposes, not the $2k of first-month revenue.
Q5.Should I include organic-driven revenue in MER?
Use two views. 'Paid MER' = paid revenue / paid spend. 'Blended MER' = total revenue (paid + organic) / total paid spend. Blended MER is always higher; don't use blended MER to justify paid spend decisions because organic revenue isn't caused by paid spend.
Q6.What's the kill criteria I should use per campaign?
Blended daily campaign ROAS below 0.6x your target MER for 3 consecutive days → pause. Campaign ROAS below 0.4x target for any single day with meaningful spend ($500+) → pause immediately. Platform ROAS declines 30%+ in 7 days → pause and investigate. Document kill criteria in shared doc so nobody debates during the moment.
Q7.How do I track campaigns across multiple platforms in one place?
For DTC teams spending $50k+/month: Triple Whale ($400–$800/month) pulls Meta, Google, TikTok, Klaviyo, and Shopify into one dashboard with MER calculation. Northbeam ($800–$2,500/month) adds multi-touch attribution modeling. For teams under $50k/month: a manual Google Sheets MER tracker (weekly pull from each platform API or export) plus GA4 for traffic source reconciliation covers 90% of the need at near-zero cost.
Q8.What's a good MER target for a DTC brand with 40% gross margin?
Break-even MER = 1 / gross margin = 1 / 0.40 = 2.5x. That's the floor where you cover ad cost with gross margin. Target MER should include overhead: if fixed costs are 20% of revenue, target MER needs to be 1 / (0.40 − 0.20) = 5x to be profitable. Most DTC brands in 2026 target 3.5–4.5x MER against 40–55% gross margins, accepting some operating loss in high-growth quarters while maintaining profitability discipline in steady-state.

Digital Dashboard Hub

Track marketing ROI, CAC, LTV, and revenue per channel

DDH has 162 business calculators including full marketing analytics — from ROAS to content ROI to email list revenue projections. Free 14-day trial.

Track your marketing ROI free →

More free tools

Part of the Digital Dashboard Hub network
Powered byDigital Dashboard Hub— 250+ free tools

Calculators, trackers, and planners for creators, business, and wellness.

Explore all 250+ tools →