Archive for the category

Scenario Simulation

Running the plan you are considering against the measured effects before committing money, and knowing where a simulation stops being evidence. How to read it, and where it misleads.

A step of the Pricing & Promo Story and the Planning Story.

Reading a scenario simulation result inside its confidence interval

Two bars. Google ads up 25% gains 209 installs a week. Meta ads down 25% loses 149. Net, +60.

That is the whole scenario, and stated that way it sounds like an easy yes.

Continue reading →

Filed under Scenario Simulation  |  Permalink

Doubling media spend in a scenario: what a simulator cannot know

German online furniture retailer, 156 weeks of orders and three media channels, asked what doubling media spend next year would deliver.

A composite case, built from the kind of file we see most weeks. An online furniture retailer in Germany, about 9,000 orders a week, with three paid channels: online video, paid social and search. Over three years, total media spend moved between €40k and €118k a week, around an average of €85k.

Continue reading →

Filed under Scenario Simulation  |  Planning Story  |  Permalink

Scenario simulation for a promo calendar: the wave worth dropping

Household-goods maker, washing-up liquid in Italian grocery, testing next season's five-wave promo calendar before signing it with the retailer.

A composite case, built from the kind of file we see most weeks. It is the same household-goods maker as in the price post, a year later: the one-litre washing-up liquid, now at €3.66 after the 5% rise, about 42,000 bottles in an ordinary week, a unit cost of €2.20.

Continue reading →

Filed under Scenario Simulation  |  Pricing & Promo Story  |  Permalink

Sensitivity analysis with a tornado chart: which levers matter

Before running scenarios, run this. It is a tornado chart, and it tells you which levers the answer actually depends on.

Each row is a driver moved down and up on its own, with everything else held. The bar is what that does to the horizon.

Continue reading →

Filed under Scenario Simulation  |  Permalink

Scenario simulation: testing a budget shift before you commit

Move a quarter of the budget from Meta to Google. Same total spend. What happens?

This is the answer, and the answer is almost nothing.

Continue reading →

Filed under Scenario Simulation  |  Permalink