Articles
Data EngineeringJuly 8, 2026 · 9 min read

Building a Custom Marketing Mix Model (MMM): A Practical Guide

As click tracking degrades, MMM is back as the budget-allocation tool of record. Here is what it takes to build one that your CFO and your media team both believe.

MMMMeasurementBudget allocation
Building a Custom Marketing Mix Model (MMM): A Practical Guide

Marketing mix modeling is a statistical approach to a question attribution can no longer answer honestly: what does each marketing channel actually contribute to revenue? Instead of following individual users through clicks and cookies, MMM analyzes aggregate history weekly spend, impressions, revenue, pricing, promotions, seasonality and estimates each channel's contribution and its diminishing-returns curve. Because it never touches user-level data, it is immune to the forces dismantling attribution: cookie loss, iOS privacy changes, and walled-garden reporting.

MMM and attribution answer different questions

  • Attribution answers tactical questions which keyword, ad, or audience converts and remains the right tool for in-platform optimization
  • MMM answers allocation questions what happens to revenue if a dollar moves from search to retail media including channels attribution cannot see: TV, audio, brand, offline
  • Attribution degrades as tracking degrades; MMM works on aggregate data that no privacy change can take away
  • Mature teams run both, and calibrate MMM against experiments (geo holdouts, incrementality tests) where possible

The open-source shift: Robyn and Meridian

MMM used to mean a six-figure consulting engagement ending in a PDF. Meta's Robyn and Google's Meridian changed the economics: both are open-source frameworks encoding years of methodological work adstock transformations, saturation curves, Bayesian priors, calibration hooks available to any team with the data and the statistical competence to use them. The frameworks are genuinely good. What they don't include is everything around them: the data pipeline, the validation discipline, and the operationalization that turns a model into a decision tool.

The unglamorous truth: MMM is mostly data engineering

A credible MMM needs two to three years of clean weekly data: spend and impressions by channel, revenue or orders, pricing and promo calendars, distribution changes, and known external shocks. Assembling that history across ad platforms that restate data, finance systems that define revenue differently, and promo calendars living in someone's spreadsheet is typically half the project. This is why MMM projects led by statisticians alone stall: the model specification was never the bottleneck; the dataset was.

How a model earns trust

  • Validate against known events the model should retroactively explain what happened when a channel was paused or a price changed
  • Check the curves against common sense saturation curves that imply infinite headroom on a small channel are a specification bug, not an insight
  • Calibrate with experiments where feasible a single geo-holdout test anchors the whole model
  • Report uncertainty honestly a contribution estimate without an interval is marketing, not measurement

Make it a living system, not a report

The failure mode of consulting-grade MMM is staleness: a model built on data through Q4 informs decisions until roughly February, then decorates a slide. Built as a system the input dataset maintained by an automated pipeline, the model retrained on schedule, budget scenarios exposed in a dashboard MMM becomes infrastructure the team consults before every planning cycle. That pipeline-first approach is exactly where a data engineering partner adds more than a statistics vendor.

Frequently asked questions

The working rule is two to three years of weekly observations covering spend by channel, revenue, pricing, promotions, and seasonality. Shorter history widens uncertainty bands; strongly seasonal businesses need at least two full cycles. Daily data can substitute for shorter histories in high-velocity businesses, at the cost of noisier estimates.

The old consulting model priced it that way; open-source frameworks changed that. A mid-size advertiser spending across four or more channels with decent data history can now build a useful MMM for a fraction of legacy cost. Below roughly seven figures of annual spend across few channels, simpler incrementality tests usually answer the same questions more cheaply.

Both are credible. Robyn (Meta) uses evolutionary hyperparameter search and is more automated; Meridian (Google) is Bayesian-first with stronger support for incorporating priors and experiment calibration, and handles reach/frequency data natively. The choice matters less than data quality and validation discipline we pick per engagement based on data shape and the team's statistical comfort.

Quarterly retraining is the common cadence, monthly for high-velocity businesses provided the input pipeline is automated so retraining is cheap. More important than frequency is monitoring: track model fit on incoming data, and retrain early when the business changes structurally (new channel, pricing overhaul, distribution shift).

More articles