Recalculate remaining daily pace without rewriting past spend
A revised plan should preserve what has already been spent. A reproducible illustrative example with editable inputs and explicit limits.
A revised plan should preserve what has already been spent. This worksheet spreads only the remaining approved envelope across the days left in the period. It gives an arithmetic pace, not an instruction to force delivery regardless of the quality of available acquisition opportunities.
Define the calculation before using it
Subtract actual spend at the review cutoff from the approved budget, then divide by remaining days. If the envelope is already exceeded, show the negative remainder separately and return zero spendable pace. Do not obscure an overrun by changing the original plan retrospectively or treating committed but unpaid costs as absent.
Work through the synthetic example
A 30,000-unit plan with 18,000 spent and ten days remaining has 12,000 left, equivalent to 1,200 per day. Campaigns may not absorb that pace at acceptable economics. Leaving part unspent can therefore be the recorded decision rather than a failure to make a spreadsheet reach its original target.
| Output | Worked-example result |
|---|---|
| Remaining amount | 12000.0000 |
| Non-negative daily pace | 1200.0000 |
Use the artifact and preserve its assumptions
Open the editable calculator to change the inputs and inspect the sensitivity view. The CSV records synthetic inputs and expected outputs; the JSON fixture keeps the equations available for reproduction. These calculations have been checked against the stated example. No measured campaign data is included.
The sensitivity rows vary only days by 20% below and above the entered value. They are scenarios, not confidence limits or a forecast distribution. A row outside the model’s constraints is labelled rather than turned into a plausible-looking result. Save the chosen inputs with the decision so another reader can distinguish a changed assumption from a changed formula.
Evidence and limits
Google distinguishes average daily budgets from campaign total budgets. This planning worksheet does not itself set a platform limit; verify the campaign’s actual budget mechanism before translating a plan into account settings. See Budgets overview, especially “Average daily budgets and spending limits; Other types of budgets”.
This planning pace is not a platform spending limit. It excludes unrecorded commitments and cannot predict uneven auction delivery or future cost changes.
Background: Annual and quarterly UA budget planning and A Q4 UA Budget Planning Checklist Before the Rush. These existing articles provide context; the present calculation does not verify every archived claim.
