Pacing Console docs

Forecast

Available onNot on First month freeProEnterprise

The Forecast page projects spend and conversions to month end or quarter end with a P10 to P90 range, run-out dates and forecasts by campaign and channel. Enterprise adds pipeline and revenue forecasts, what-if scenarios and the budget needed to hit a target.

Pro and Enterprise. In the free month the page shows what Pro adds. Pipeline, revenue, scenarios and targets show a preview until the workspace has Enterprise.

Use the page

Open Forecast in the main menu and pick Month end or Quarter end. The top shows the headline numbers; below are Forecast by campaign, Forecast by channel, the Spend against plan chart and Daily spend by channel. Every section ends with How this is calculated, so you can explain each number to finance.

Spend forecast (Pro)

NumberHow it is worked out
Spend forecast (P50)Each campaign's month-to-date run rate to the end of its flight. The same number as Projected on the Pacing page.
P10 to P90P50 plus or minus 1.28 times the standard deviation of the campaign's daily spend this month (last 14 complete days) times the square root of the active days left. About 1 in 10 chance of landing below P10 and 1 in 10 above P90. Channel and total ranges treat campaigns as independent. With fewer than 3 days of history, the range assumes 30% day-to-day variation.
Projected over or under budgetForecast minus budget for the workspace, each channel and each campaign.
Budget runs outThe date a campaign uses up its budget at its month-to-date daily rate on its schedule. Lasts means it reaches the end of the month or flight.
Quarter endClosed months count as actual spend, this month as the P50, and months still to come at each campaign's daily rate today on its schedule and flight. The by-month table shows which is which.

Results forecast (Pro)

Conversions to period end use each campaign's conversions per dollar this month; closed months use what the platforms reported. Cost per conversion is forecast spend divided by forecast conversions. Clicks are not collected by the scripts, so the results forecast covers conversions and cost per conversion.

Pipeline and revenue forecasts (Enterprise)

  • Pipeline: pipeline already created in the period, plus the spend still forecast for each campaign times its pipeline per dollar over the last 6 complete months. A campaign with fewer than 3 opportunities in that window uses its channel's rate. The range uses the P10 and P90 spend forecast.
  • Win rate: from paid deals closed in the last 12 months, by channel when a channel has at least 8 closed deals. Customers use the share of deals won; revenue uses the share of the amount won (win rate by value).
  • Sales cycle: how many months won deals took from created to closed, from won deals in the last 18 months.
  • Expected won revenue by month for the next 6 months: open paid deals close at the win rate by value along the usual cycle, and spend still to come is won at the last 6 months' rate.
  • Projected ROAS is that revenue per dollar of spend; Projected CAC is spend divided by expected customers.

What-if scenarios and targets (Enterprise)

  • What-if: move each channel's budget for next month from minus 50% to plus 100% and see spend, conversions, opportunities, pipeline, expected won revenue, customers, cost per opportunity, CAC and ROAS change against the plan. Outcomes grow with spend to the power 0.85, so each extra dollar returns a little less. Scenarios are not saved.
  • Budget needed to hit a target: choose pipeline value, won revenue, opportunities, customers or conversions, an amount and Next month or Next 3 months. You get the budget at today's efficiency with the same diminishing returns, the change against plan and a split by channel. Beyond twice today's budget the result is flagged as less certain.

Forecasts refresh with every data update (daily by sign-in, hourly by script). Revenue forecasts are expected values, not commitments. Amounts in a currency other than the workspace's are left out.

Budget calendar

The Budget calendar tab lists every active campaign by month, for this month and the next five, grouped by client with totals. A cell shows that month's plan, or in grey the monthly budget (or the platform daily budget times the days) used when no plan is set. Owners and editors type an amount and press Enter to save it as that month's plan; clearing a cell goes back to the monthly budget. Months outside a campaign's flight dates show a dash. This month also shows the spend so far.

To pace a flight or insertion-order budget that spans months, open the campaign, choose Budget plan by month, type the Total budget for the whole flight and press Spread by month. The total is split by the active days in each month of the flight (set the end date first), then Save.

Was this page helpful? If something is missing, unclear or wrong, tell our support team.

Last updated