What is media planning?
Media planning is the discipline of turning a budget into a defensible commercial plan: how much to invest in each channel, against which audiences, over what period, and what performance to expect in return. A good media plan is not a list of channels - it is a forecast. It states, for a given level of spend, the revenue, leads, or return the business should anticipate, and it makes the trade-offs between channels explicit so that money flows to where it works hardest.
The hard part has never been listing the channels. It is predicting what each one will do as the numbers move. That is precisely where the traditional toolkit falls down, because the instrument most teams reach for - the spreadsheet - was never built to model how advertising actually behaves. ElenIQ approaches the same problem as a forecasting exercise; you can build a media plan from forecasted response rather than from assumed averages.
Why do spreadsheets fail at scale?
A spreadsheet plan encodes performance as a constant. You enter a budget, multiply it by an assumed ROAS or divide it by an assumed CPL, and the cell returns a result. That works for a single, static snapshot - but it embeds a hidden and dangerous assumption: that the next pound performs exactly like the last one. It does not. The moment you scale a channel, add a new one, or build three competing scenarios, the static multipliers begin to lie, and the error compounds the further you stray from the spend level the assumption was derived at.
At scale the problems multiply. A serious plan involves many channels, several spend levels, and multiple what-if scenarios - a combinatorial space that spreadsheets handle by copying formulas, not by modelling behaviour. There is no representation of diminishing returns, no carryover between periods, and no concept of a saturation point. Worse, the formulas are brittle and invisible: a single mis-keyed reference can quietly distort an entire quarter's plan, and nobody notices until the spend has already gone out the door. A spreadsheet is a calculator dressed up as a forecast.
Why is paid media performance non-linear?
Every channel spends its budget on its most responsive audiences first. The early pounds reach the people most likely to convert; as spend rises, each additional pound competes for less responsive impressions, so the return on that marginal spend steadily declines and eventually flattens. This is the behaviour described by saturation curves - modelled mathematically with the Hill function - and it is the single most important reason a fixed ROAS in a cell cannot be trusted.
Performance is also non-linear in time. Advertising bought today keeps working tomorrow: brand exposure, consideration, and delayed conversions create a carryover effect known as adstock. A spreadsheet attributes all of a period's results to that period's spend, missing the lift that bleeds across weeks. Between saturation and carryover, the relationship between spend and outcome is a curve with memory - not the straight line a static multiplier assumes.
Marginal returns vs average ROAS
This is the distinction that decides whether a plan is sound. Average ROAS is total revenue divided by total spend - a single blended, backward-looking ratio. Marginal ROAS is the return on the next pound, and it is the only number that should govern whether to scale a channel. Because response curves flatten, marginal ROAS is almost always lower than average ROAS at scale. A channel showing a healthy blended 5.0 might be returning a marginal 1.5 on its last tranche of spend - meaning the next pound is barely breaking even even though the average still looks excellent.
Spreadsheets only ever express the average, so they consistently overstate the value of scaling and push budget into channels that are already near their ceiling. Forecast-led planning works the other way round, allocating against marginal return so spend moves to wherever the next pound is most productive. If you want the mechanics in full, see the explainer on marginal ROAS versus average ROAS, or model it directly with the marginal ROAS calculator.
How does ElenIQ forecast spend movement?
ElenIQ replaces the static cell with a trained model. Its forecasting engine, Dex, learns each channel's response curve from your historical data - capturing diminishing returns, adstock, and seasonality rather than assuming them away. When you change a budget, it does not multiply by a constant; it predicts the outcome at that specific spend level, complete with confidence intervals, so you can see not just the expected result but the range of plausible ones. You can put this to work in the ad spend forecasting tool.
Because the model understands the curve, scenario planning becomes the core workflow rather than an afterthought. Shift budget between Meta, Google, and TikTok and watch the forecast respond; push a channel past its saturation point and the diminishing return shows up immediately instead of being hidden behind an optimistic average. The budget allocation simulator lets you compare allocations side by side and settle on the mix that maximises return for the budget you actually have. This is what “forecast before you spend” means in practice.
Use cases for ecommerce and lead generation
For ecommerce teams, the question is usually how far a profitable channel can be scaled before returns collapse. ElenIQ forecasts revenue and ROAS at every spend level and surfaces each channel's saturation point, so you can pour budget into a winner right up to - but not past - the point where marginal return falls below target. That is far more precise than applying last quarter's blended ROAS to a bigger number and hoping it holds. The ecommerce solution covers this in depth.
For lead generation, the governing metric is cost per lead, and the trap is assuming CPL stays flat as volume grows. In reality CPL rises as you exhaust the cheapest audiences, so ElenIQ forecasts lead volume and CPL together - with guardrails that prevent implausibly low projections - to keep plans honest about what extra spend will really cost. The lead generation solution shows how this works end to end. Agencies running both models across many clients can standardise on a single forecast-led process with paid media forecasting for agencies.
Frequently asked questions
What is media planning?
Media planning is the process of deciding how to allocate an advertising budget across channels, audiences, and time periods to achieve a commercial goal such as revenue, leads, or return on ad spend. A media plan sets out how much to invest in each channel and what performance to expect in return.
Why do spreadsheets fail for media planning at scale?
Spreadsheets encode performance as fixed multipliers - a single ROAS or CPL applied uniformly to every pound of spend. That assumption is linear, but paid media is not: doubling spend rarely doubles results. As budgets, channels, and scenarios multiply, static spreadsheets cannot model diminishing returns, carryover effects, or the point at which a channel saturates, so the plan systematically overstates what extra spend will deliver.
Why is paid media performance non-linear?
Each channel reaches its most responsive audiences first. As spend rises, every additional pound competes for less responsive impressions, so marginal return declines and eventually flattens. This relationship is described by saturation (Hill) curves and is further shaped by adstock, the carryover effect where advertising impact persists beyond the period it was bought in. A single fixed ROAS in a spreadsheet cannot capture either dynamic.
What is the difference between marginal ROAS and average ROAS?
Average ROAS is total revenue divided by total spend - a blended, backward-looking number. Marginal ROAS is the return on the next pound of spend, which is what actually governs whether scaling a channel is worthwhile. Because performance is non-linear, marginal ROAS is almost always lower than average ROAS at scale, and planning on the average leads teams to over-invest in channels that are already near saturation.
How does ElenIQ forecast spend movement instead of using a spreadsheet?
ElenIQ trains models on your historical channel data to learn each channel’s response curve, then forecasts how outcomes change as you move budget up or down. Instead of multiplying spend by a fixed ratio, it predicts results at each spend level with confidence intervals, so you can compare scenarios and see where the next pound works hardest before committing it.
Does this work for ecommerce and lead generation?
Yes. For ecommerce, ElenIQ forecasts revenue, ROAS, and the saturation point of each channel. For lead generation, it forecasts lead volume and cost per lead, with guardrails that prevent unrealistic CPL projections. In both cases the plan is built from forecasted response rather than a static assumed efficiency.