Sends customized Slack and email alerts when metric anomalies are detected across your account, with thresholds and rules defined in a Google Sheet. Supports MCC.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/advanced-anomaly-detector
Monitors your account for unexpected performance deviations by comparing today's stats against historical averages for the same weekday. Sends an alert email when impressions, clicks, conversions, or cost deviate beyond configurable thresholds.
One 0-100 score for the whole account, built from seven objective checks — tracking flatlines, disapprovals, serving status, budget losses, negative coverage and query hygiene — with the deduction breakdown as your fix list.
Finds the structural gaps that stop ad groups from serving: ad groups without active ads, without an RSA, without keywords, keyword-stuffed themes, and multi-RSA ad groups.
Generates a daily at-a-glance performance overview of your entire Google Ads account. Writes prior-day stats to a Google Sheet with running history and optionally emails a formatted comparison of yesterday vs. two days ago vs. one week ago.
Generates a Google Spreadsheet with ad performance stats segmented by headline and final URL, including distribution charts. Covers all ad types and optionally emails the report link weekly.
Maps every campaign's ad schedule and flags forgotten narrow serving windows, stale schedule bid modifiers that Smart Bidding ignores, and (optionally) campaigns running 24/7.
Watches account and campaign metrics against rules you set in a spreadsheet (e.g. spend spikes, zero-conversion drift, CTR drops) and fires Slack and/or email alerts when a rule trips. Runs on a single account or across an MCC. Use it as an early-warning system so problems surface in minutes, not at month-end.
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
SLACK_TEAM_WEBHOOK_URL | (empty) |
INPUT_TAB_NAME | Anomaly Detector |
FOLDER_ID | (empty) |
ANYONE_CAN_EDIT_SHEETS | false |
DEBUG | false |
Evaluated 14 anomaly rules against last-hour data. ALERT: Campaign "Brand" spend up 210% vs baseline — posted to Slack + emailed. No other rules tripped.
THIRD-PARTY DEPENDENCY: requires a copied shabba.io settings sheet that drives all rules; the script self-reports run info to shabba by default. Slack alerts need an incoming-webhook URL. Detects MCC vs single-account automatically.