Product Performance Alerts & Reports
2 installs
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.
shopping
products
alerts
roas
reporting
monitoring
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/product-performance-alerts
Overview
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.
Setup
- 1Copy the Google Sheet template linked on the source page and set your rules in the settings tab.
- 2In Google Ads, go to Tools → Bulk Actions → Scripts.
- 3Click + to create a new script and paste the code below.
- 4Set INPUT_SHEET_URL and confirm INPUT_TAB_NAME matches your settings tab.
- 5Authorize, preview, review the output, then schedule daily.
Configuration Variables
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INPUT_TAB_NAME | Settings |
NUMBER_OF_FILTERS | 6 |
DEBUG | false |
Expected Output
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.
Notes
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template that drives all rule configuration. Rules live in the sheet, not the code.