Free download · ZIP kit

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

Number
  • 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.

CampaignDaily budgetSpend MTDTargetPaceProjectedTo landStatus
  • 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

    Free Google Ads Budget Pacing Calculator — DetectivePPC