Monitors Shopping products against custom performance rules (clicks, conversions, ROAS, CTR) and delivers email alerts and Google Sheet reports on the ones that breach them.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/product-performance-alerts
Audits the product titles behind your actual Shopping spend: too-short titles wasting the character budget, identical titles on multiple products, and policy-risky all-caps titles.
Finds products served by multiple Shopping campaigns at the same priority — the internal competition that silently breaks brand/non-brand splits and hands control of bids to Ad Rank instead of you.
Triggers a Merchant Center feed fetch every hour via the Merchant API — fresher prices and availability than the standard daily feed schedule allows.
Finds products that are eligible in your Shopping campaigns but got zero impressions — inventory paying rent in the feed while Google never shows it.
Builds account-level search-term reports with custom filters across six configurable date ranges so you can compare how queries trend over time.
Compares search terms against your ad group keywords using fuzzy matching to flag mismatches for review or exclusion, with an optional fully-automated negation mode.
Applies up to six custom rules to product-level Shopping performance and reports products that cross your thresholds — high spend with no conversions, falling ROAS, weak CTR — via email and a Google Sheet. Use it to catch problem SKUs before they drain budget.
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INPUT_TAB_NAME | Settings |
NUMBER_OF_FILTERS | 6 |
DEBUG | false |
Evaluated 1,240 products against 4 rules. 17 products flagged (e.g. SKU-9981: $86 spend, 0 conv). Report written to sheet; alert email sent.
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template that drives all rule configuration. Rules live in the sheet, not the code.