A marketing mix model is only as good as the data under it. Most MMM projects that stall do so on data, not on statistics: TV spend sitting in an agency spreadsheet, channel names that change every quarter, sales figures that arrive by email. This guide covers what data marketing mix modelling needs, where to get it, how to structure it and which problems ruin a model before it starts.
You need four things, over the same period and at the same time grain:
Two years of weekly history is a comfortable floor, because the model needs to see each season at least twice. Three years is better. Six months can work if strong priors do more of the work, with wider uncertainty as the price.
Search, social, video, display, programmatic and affiliate platforms all have APIs. The reliable way to get their data is a direct, read-only connection that pulls the full history once and then refreshes every day. Spreadsheet exports work for a pilot, but they break the moment someone changes a column or forgets a month.
Pull more detail than you think you need. With campaign and ad-level data you can split a large channel later, for example Meta awareness versus Meta conversion, without going back to the source. The model then decides how granular it can be based on how much was spent in each part.
Odins maintains connections to Google Ads, Meta, TikTok, Snapchat, LinkedIn, Microsoft Ads, programmatic platforms and affiliate networks, among 600+ integrations, and builds a new connector when a customer uses a platform with an API that is not covered yet. See the connector overview.
TV, radio, outdoor, print, influencers and podcasts have no API. This is where most teams get stuck, and it is also where MMM adds the most, because these channels are invisible to click-based attribution.
The data you need usually exists already, in your media agency's systems. Ask for two things per channel: the invoice, which gives you the cost, and the spot or airing report, which gives you the timing. For TV, a spot report with the time each spot aired and the cost per spot is ideal. For radio, outdoor and print, a weekly or monthly spend breakdown is enough.
When you send the request, be specific, or you will get a summary that cannot be modelled:
Send the request yourself. Agencies answer to their client, not to your vendor. With a cooperative agency, the history can be in place within a day. Odins then sets up a pipeline for the recurring files, so offline spend lands in the same structure as digital without a monthly chore on your side. More on this in offline media data.
The outcome feed is the one teams most often leave manual. Automate it from day one. Daily is best, weekly works, and monthly is the minimum. Fresher data means the model can be checked against reality sooner, and forecasts can be followed up as the month unfolds.
Choose the outcome that matters to the business, not the one that is easiest to count. A lender should model paid-out loan volume, not application clicks. A subscription business should model new subscriptions, not site visits. If the outcome happens days or weeks after the marketing, the delay can be set in the model so cause and effect line up. We go through the choices for retail, banking, subscriptions and more in MMM for different business models.
Remember that the model only sees what is in the outcome data. If a large share of sales happens in stores, through wholesale or through advisers, that data has to be included, or the model will understate what marketing does.
Raw data from twenty sources uses twenty naming conventions. Before anything can be compared, it has to land in one structure. A practical order is market first, then product, then segment, and then a media hierarchy that goes as deep as the data allows: search, then Google, then Performance Max; TV, then TV 2, then the individual spot.
The point is that everything lands in the right place in one detailed hierarchy, online and offline together. Once that exists, cross-channel reporting is a by-product, and the model reads from the same dataset the marketing team looks at. There is one version of the numbers instead of three.
Once marketing data is collected and structured, it is useful well beyond the model. Ask your vendor to deliver the cleaned dataset into your own warehouse, such as BigQuery or Snowflake, so your BI tools read from the same numbers. Some Odins customers use the platform for this alone: one structured dataset of all marketing spend and results, digital and offline side by side, in their own hierarchy. The model can then be added when budget and volume justify it.
Yes. Two years of weekly data is the comfortable floor for most businesses, because the model sees each season twice. With less history, priors carry more of the result and the uncertainty ranges are wider.
Ask for the invoice and the spot or airing report per channel, as raw exports, at least three years back, with gross or net, fees, booked or invoiced, and market stated explicitly. Send the request yourself, then have your vendor set up a recurring pipeline.
Managed platforms, where the vendor connects the sources, handles offline files and structures the data. With Odins, the work on your side is mainly granting read access to ad accounts, asking your agency for offline data and connecting the sales feed. See how to choose an MMM vendor for the other questions to ask.
With Odins, yes. The structured dataset can flow to your own warehouse and you own it.
For how the data is used once it is in place, read our complete guide to marketing mix modelling, or see how Odins handles data integration.