Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.
Decisions the marketing mix model must inform
A mix model built without a named decision tends to become a handsome chart of channel contributions that nobody acts on. Writing down the two or three decisions it must support, such as next year's channel split, whether to cut a channel or how much to spend in the fourth quarter, fixes the KPI, the time horizon and the level of detail before a single row of data is pulled.
First tasks
- List the budget decisions taken in the last twelve months and who took them
- Ask the marketing lead which decision next year would change most with better evidence
- Write the questions the model will not answer as a short out-of-scope list
- Get the brief signed off by marketing and finance
MMM readiness and data sufficiency check
Mix models need enough history and enough movement in spend to separate one channel from another: as a rough guide, two to three years of weekly data, channels whose spend actually varied, and a sales series not swamped by price and distribution changes. Checking this honestly in a fortnight saves months spent on a model that cannot identify anything.
First tasks
- Count the weeks of clean sales history available at weekly grain
- Plot weekly spend for every channel on a single page
- Flag channels with flat always-on spend or fewer than ten active weeks
- Write the go, wait or alternative recommendation for the sponsor
Choosing the KPI and time grain for the model
Revenue, units, new customers, store visits and qualified leads each give a different answer about which channel works, and weekly data behaves very differently from daily. Choosing the target variable and grain deliberately, with finance agreeing that the series matches what they report, prevents a later argument that the model explained the wrong number.
First tasks
- List every candidate KPI with its source system and months of history
- Pick the week-start day that matches finance and media reporting
- Compare a year of the chosen KPI against finance totals
- Record the KPI decision and the reasons in the model brief