Shopping Product Labelizer
Segments Shopping products into performance buckets (over-index, index, near-index, under-index, no-index) based on ROAS relative to a breakeven target and exports the results to a Google Sheet.
by Flowboost (Arjan)·florisdeschrijver.com/flowboost-labelizer-google-ads-script
Overview
Shopping Product Labelizer analyzes your Shopping campaign product performance over a configurable lookback window, categorizing each product by its ROAS relative to your breakeven target. Results are exported to a Google Sheet for use in feed-based segmentation or custom label strategies — ideal for identifying winners and underperformers.
Setup
- 1Copy the template spreadsheet linked in the script and get your new sheet 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.
- 4Set SPREADSHEET_URL to your copied Google Sheet URL.
- 5Set breakevenRoas to your target ROAS (10-20% below account target recommended).
- 6Set AverageCvr to your average Shopping conversion rate.
- 7Adjust impressionThreshold and daysAgo if needed.
- 8Schedule the script to run daily.
- 9Preview the script once to verify it reads your products correctly, then save and enable.
Configuration Variables
| Variable | Default |
|---|---|
SPREADSHEET_URL | template URL |
breakevenRoas | 6.5 |
AverageCvr | 5 |
impressionThreshold | 50 |
daysAgo | 90 |
Expected Output
Script finished
---->
Upgrade to premium script at library.flowboost.com.Notes
Products with zero impressions in the lookback period will not appear in the output — use a separate campaign or ad group for those items. The script categorizes into five buckets: over-index, index, near-index, under-index, and no-index. The template spreadsheet tab must be named "Flowbelizer".