Compares Search Partner network ROAS against Google Search ROAS per campaign and alerts by email + Google Sheet when partners underperform beyond your threshold.
by Nils Rooijmans·nilsrooijmans.com/google-ads-script-search-partner-alerts
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.
Search Partner traffic hides inside your Search campaigns and its quality varies wildly. For every campaign with enough Search Partner clicks, this script compares Search Partner ROAS to Google Search ROAS over the chosen period; when partners are worse by more than your threshold, the campaign is logged to a Google Sheet and you get an email. Label a campaign 'Ignore Search Partner Performance Alerts' to exclude it.
| Variable | Default |
|---|---|
SPREADSHEET_URL | (required) |
EMAIL | (required) |
CLICK_THRESHOLD | 50 |
PERIOD | LAST_30_DAYS |
ROAS_DIFF_THRESHOLD | 0.2 |
Sheet rows per flagged campaign: clicks, conversion value and ROAS on each network, plus the relative ROAS difference — and an email when new alerts appear.
Search Partners can only be toggled per campaign, so the action on an alert is a conscious keep/exclude decision per campaign. Uses the AWQL reporting interface, which the current Scripts runtime still supports.