ROAS and Media Budget Forecasting for an Agency
Advertising & Media — Planners had no way to predict how shifting budgets across Google, Meta and marketplaces would change revenue for their clients.…
Client: Performance Marketing Firm. Sector: Advertising & Media.
The challenge: Planners had no way to predict how shifting budgets across Google, Meta and marketplaces would change revenue for their clients.
What we built: A ROAS and marketing-mix forecasting model trained on two years of campaign history, plus a budget-scenario tool that recommends how to split spend across channels.
Tech used: Python, Bayesian MMM, BigQuery, Airflow, Looker Studio.
- Return on Ad Spend: +17%
- Planning Time: Days → hours
- Clients Added: 40+
- Forecast Error: <10%
