AUTONEWS · ADOPS

Forecast Report Builder

Historical delivery → monthly & weekly forecast

2027 FORECAST
1 Upload report
2 Map columns
3 Set forecast
4 Export

1. Upload historical Excel report

Supported formats: .xlsx and .csv. Fully offline — no internet connection required.

Choose GAM Excel reportRecommended columns: Date, Position, Impressions
No file has been uploaded.

2. Map columns

The app attempts to identify the columns automatically. Review the mapping before generating the forecast.

Each row should represent delivery for a date and position. If your report contains separate year/month columns or pre-aggregated periods, prepare it in that format before uploading.

3. Forecast settings

Adjust the forecast period, tolerance and projection method.

0%50%
%
Used only for “Seasonal average + trend”. For example, 5 means 5% growth over the historical baseline.
Upload a report to generate a forecast.

How is the forecast calculated?

Transparent methodology — change the method and recalculate at any time.

  • Seasonal average: average delivery for the same calendar month across the available historical years.
  • Trend: seasonal baseline adjusted by the manually entered growth rate.
  • Tolerance: shows the lower and upper range around the baseline forecast.
  • Weekly level: the monthly forecast is allocated using historical weekday patterns or proportionally by calendar days.

4. Forecast results

Monthly and weekly forecast by position.

Results will appear here after you upload an Excel report and generate the forecast.

Note: this is a forecasting tool, not a replacement for GAM. Results depend on the quality and volume of historical data. Tolerance represents a planning range, not a statistical confidence interval.