Know by the 17th whether the month will land on budget
A free Google Ads budget pacing calculator for Excel and Google Sheets: campaign-by-campaign pace, projected month-end, the daily budget that lands each campaign on target, and an AI prompt that writes the client update for you. From DetectivePPC.
By DetectivePPC · Formulas checked against an independent recalculation of the fictional sample; works in Excel and Google Sheets. No connection to your Google Ads account.
Get the calculator
We'll email you the spreadsheet, the PDF guide, and the AI prompt as a zip.
Why it matters
Google Ads Help: a campaign “might spend up to twice your average daily budget” on a given day, and by month end won't have spent more than 30.4 times it. After a mid-month change, spend for the rest of the month won't exceed the new daily budget times the calendar days left.
Sources: support.google.com/google-ads/answer/2375423 · support.google.com/google-ads/answer/10487143
How each number is calculated
- Expected by nowMonthly target x days elapsed / days in month (straight-line plan).
- Pace vs planSpend MTD / expected by now. Inside the band = On track.
- Projected month-endSpend MTD + (spend MTD / days elapsed) x days left.
- Daily budget to land on target(Target - spend MTD) / days left. Because Google may spend up to 2x on a single day, re-check after 2-3 days.
- Google monthly limit30.4 x the current average daily budget (if the budget wasn't changed this month).
- Max charge if changed todaySpend MTD + new daily budget x calendar days left, following How budget changes take effect.
Fictional sample
What it looks like
Fictional sample: "Harbor & Pine Home Goods" is made up. Data through Nov 17 (day 17 of 30), client budget 18,000. The account is on plan overall, but the mix is off.
- Brand Search608701,80085%1,53572Under
- Non-brand Search - Cookware2103,5605,400116%6,282142Over
- PMax - All products2504,3107,500101%7,606245On track
- Shopping - Clearance (limited)386402,10054%1,129112Under
- Demand Gen - Gift guide559051,200133%1,59723Over
- Total61310,28518,000101%18,150593
Pacing tells you where the money goes, not whether it worked.
DetectivePPC runs a read-only Google Ads audit, gives you a scored case file with prioritized findings, and then monitors the account between audits, alerting you to anomalies like a CPA spike or a sharp spend drop.
7-day trial · 1 free audit · Read-only access
