Google Ads Spend Tracker

Task

Use @Google Ads/List CampaignsName it "Google Ads/List Campaigns" and call it with @Google Ads/List Campaigns to pull all campaigns with their budget and spend data. Calculate budget pacing (how much has been spent vs. how much should have been spent by this point in the month). Log the results to a Google Sheet using @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row for historical tracking.

Input

The user provides their Google Ads customer ID, the monthly budget target, and a Google Sheet URL for logging.

Example: "Track spend for account 123-456-7890. Our monthly budget is $15,000. Log to this sheet: [sheet URL]"

Context

What to Track

Budget pacing:

• Total spend so far this month
• Daily average spend rate
• Projected month-end spend at current rate
• Whether we are on pace, underspending, or overspending

Campaign-level breakdown:

• Which campaigns are consuming the most budget
• Which campaigns have the best and worst efficiency (cost per conversion)
• Any campaigns that have hit their daily budget caps

Analysis Strategy

1. Pull all campaigns with THIS_MONTH date range for current period data
2. Calculate days elapsed vs. days remaining in the month
3. Compute daily run rate and project month-end spend
4. Flag campaigns that are pacing more than 20% over or under target
5. Log a row to Google Sheets with date, total spend, projected spend, and flags

Output

Budget Pacing Report:

• Days into month / total days
• Total spend to date
• Daily average
• Projected month-end spend
• Pacing status (on track, over, under)

Top Spenders: List the top 5 campaigns by spend with their conversion metrics

Alerts:

• Campaigns pacing significantly over budget
• Campaigns with spend but zero conversions
• Any campaigns that hit daily budget caps

Logged to Sheet: Confirmation that data was appended to the tracking spreadsheet