Search Partner ROAS Alerts
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
Overview
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.
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, preview, then schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
SPREADSHEET_URL | (required) |
EMAIL | (required) |
CLICK_THRESHOLD | 50 |
PERIOD | LAST_30_DAYS |
ROAS_DIFF_THRESHOLD | 0.2 |
Expected Output
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.
Notes
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.