RunMags journal
How to Forecast Advertising Sales for Publishers
A forecast is a view of expected commitments under stated assumptions. It should help a publisher decide what can run in an issue without presenting likely business as collected cash.
Build the forecast worksheet
Record advertiser, opportunity owner, issue or flight, available product, value, stage, expected decision date and expected billing date. Separate approved bookings from open opportunities. Show each opportunity once even when a package spans channels; allocate its deliverables without counting its entire value repeatedly.
Make assumptions visible
Define how stage probabilities are estimated and when they are reviewed. If there is too little history, label the weights as planning assumptions. Compare a committed baseline with plausible upside and downside. Include expiring holds and production cutoffs so a likely sale does not assume inventory that is already unavailable.
Review changes before issue close
Review the forecast on a cadence appropriate to your sales cycle. Ask owners to explain changed dates, values and stages. Compare expected commitments with available pages and production capacity before increasing an issue's size. Keep invoice timing and expected receipts in separate financial planning views.
Check forecast accuracy
Retain dated snapshots and compare them with the commitments actually won for that issue. Investigate optimism, slips and duplicate packages. A useful review changes the underlying stage definition or follow-up process rather than simply asking sellers for a more confident number.
A practical worksheet
Illustrative forecast worksheet: a 10,000 opportunity with a planning weight of 50 percent contributes 5,000 to a weighted opportunity view. That amount is neither an approved booking nor cash. Keep the unweighted amount, assumed probability, decision date and issue cutoff visible. Present confirmed commitments separately and avoid using the weighted figure to reserve half a placement. After the period closes, compare the snapshot with actual bookings and record why opportunities slipped or were lost. Replace assumptions with observed history only when comparable data is available.
Review checklist
- Separate booked, likely, invoiced and paid amounts.
- Record assumptions and snapshot dates.
- Check inventory and production cutoffs before counting upside.
