Daily Budget Overdelivery Alerts
Compares actual spend against your daily budget settings over 1, 7 and 28 days and alerts by email + Google Sheet when Google overdelivers beyond your thresholds.
by Nils Rooijmans·nilsrooijmans.com/daily-budget-overdelivery-alerts-script
Overview
Google is allowed to spend up to 2x your daily budget on any given day. This script keeps that honest: for every campaign not labeled 'noBudgetAlert' it compares anticipated spend (from the daily budget) against actual spend over the last day, 7 days and 28 days, and raises an alert when overdelivery exceeds your thresholds. Alerts are logged to a Google Sheet and emailed to you.
Setup
- 1Create a new blank Google Sheet and copy its URL.
- 2Open your Google Ads account and go to Tools → Bulk Actions → Scripts.
- 3Click the + button to create a new script and paste the code below.
- 4Set SPREADSHEET_URL and EMAIL. Keep firstRun = true for the first run, then set it to false and schedule daily.
- 5Optionally add the 'noBudgetAlert' label to campaigns you want the script to skip.
Configuration Variables
| Variable | Default |
|---|---|
SPREADSHEET_URL | (required) |
EMAIL | (required) |
CAMPAIGNLABEL | noBudgetAlert |
firstRun | true |
dailySpendAlertThreshold | 0.2 |
Expected Output
Rows appended to the alert sheet per overdelivering campaign, plus an email: Campaign X — daily budget 50.00, spend yesterday 68.40 (+37%)
Notes
Licensed Apache-2.0 by the author. Lightly updated by chiliad for the current AdsApp runtime (the original targeted the legacy AdWordsApp API). An MCC version is available from the author.