The Media Forecast function provides a consolidated, real-time view of your media spending by combining planned amounts and actualized amounts.
It helps both agencies and internal teams understand how much of the allocated budget is expected to be spent, ensuring alignment with Authorized Spend (Targets) and supporting future decisions on media planning and approvals.
In this article, we will cover:
How to use the Media Forecast function
How to fetch and read Media Forecast analysis
How to export Media Forecast data
How to interpret Media Forecast scenarios
How to Use the Media Forecast Function
The Media Forecast compares three key figures:
Planned Costs - what was initially budgeted in your Media Plan.
Actualized Costs - what has been spent so far and validated in the Results section.
Forecast Costs - the most current value for each media entry and period, automatically updated when actuals are approved.
This eliminates the need to manually adjust planned costs as campaigns progress.
Accessing Media Forecast
Hover over Timeline in the left-hand menu.
Select Forecast from the dropdown.
You’ll see three timelines: Planning, Results, and Forecast. Forecast is shown by default.
A standard Forecast view with three hierarchy levels (Organization, Division, Signature) has been set globally. However, you can customize your view.
Customizing your view
Click the cogwheel icon and choose Modify Settings. Options include:
View type - hierarchical or flat.
Sorting - chronologically or alphabetically.
Granularity - by month, quarter, or semester.
Measures - define what appears in totals and on bars.
Semester totals - toggle to show first-half and second-half totals.
Show Targets - compare forecast values against Authorized Spend.
Validation filter - restrict Authorized Spend to validated amounts only.
Custom hierarchy - add, modify, or delete levels.
Once adjusted, click Save view settings, give your template a name, and decide whether to keep it private or share it with others. All templates can be managed via the cogwheel menu.
How to Fetch and Read Media Forecast Analysis
There are two ways to open the detailed analysis view:
Click on a bar for the specific period you want to review.
Click the histogram icon to analyze the full year.
What you’ll see
The analysis window displays both a chart and a table:
Chart – compares Authorized Spend (green) with Forecast (yellow).
Table – breaks down values by period (e.g., quarter) and includes:
Year-to-date (YTD)
Year-to-go (YTG)
Total
Understanding the data sources
The table rows show values from different sources:
Costs from Planning – original planned budget.
Costs from Results – actualized and approved spend.
Forecast – the most recent checkpoint, using Actual if approved, otherwise Planned.
This comparison lets you see if spending is on track, under, or over the Authorized Spend across periods.
How to Export Media Forecast Data
Exports are only available from the Media Forecast Analysis view (not the flowchart).
Open the analysis window.
Click Export.
Choose a reporting template if available, or use the standard one.
Select file format (Excel or CSV).
Open the exported file.
What’s included in the export
Media Forecast data, combined with Planning details (product, customer, media owner, media type).
To see only Forecast data, filter the Entry Type column.
Column Source Entry Type indicates whether data is from:
MediaEntry (Planning)
MediaResult (Results/Actuals)
This distinction helps identify how much of your forecast comes from planned versus actualized spend.
How to Interpret Media Forecast Scenarios
When reviewing data, you may encounter two common scenarios:
Forecast equals Planning Cost
Either no media entries have been actualized yet,
Or actuals have been approved and match what was originally planned.
Forecast lower than Plannning Cost
One or more media entries have been actualized and approved with values lower than the initial plan.
By comparing Forecast with Authorized Spend, you can quickly see if you’re on track, under, or over budget.
Keep Growing with Camphouse
🎓 Melody Academy – tutorials & courses
💬 Support – send us a message, we’ll reply as soon as possible