Scans manual-bidding campaigns for keyword CPC bids above your limit — fat-finger insurance against the 5.00-that-became-50.00 bid — with Google Sheet logging and email alerts.
by Nils Rooijmans·nilsrooijmans.com/script-to-receive-high-cpc-bid-alerts
One table of every campaign's bidding strategy with the two flags that matter: Manual CPC campaigns with enough volume for Smart Bidding, and target-based campaigns too data-starved to learn.
Finds the reallocation hiding in plain sight: efficient campaigns losing volume to budget caps, idle budgets that could fund them, and full budgets funding poor CPAs.
Runs campaigns only inside their date windows — Black Friday starts at 00:00 without anyone staying up, sales end exactly on time, weekend campaigns run only on weekends.
Compares yesterday's average CPC per campaign against its 30-day baseline and alerts on spikes — the earliest visible symptom of a new competitor, broad-match drift, or a bid change gone wrong.
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.
Compares actual daily spend against the expected pace based on time of day. Logs over- and under-pacing campaigns and can auto-pause overspenders to protect your budget.
One mistyped bid or misfired bulk edit can drain a budget overnight. This script iterates every campaign on Manual CPC (optionally filtered by label), pulls keyword-level CPC bids via the reporting interface, and flags any bid above CPC_THRESHOLD — writing offenders to a Google Sheet and emailing you the list.
| Variable | Default |
|---|---|
SPREADSHEET_URL | (required) |
EMAIL_ADDRESSES | (required) |
CPC_THRESHOLD | 5.00 |
CAMPAIGNLABEL | (empty) |
Sheet rows per offending keyword: Campaign Name, AdGroup Name, Keyword, CPC Bid — and an email '[ALERT] - Google Ads - HIGH CPC Bid Keyword(s)'.
Only Manual CPC campaigns are checked — automated bidding strategies have no keyword bids to audit. Lightly updated by Chiliad for the current AdsApp runtime.