Shopping Product Labelizer

Name: Shopping Product Labelizer
Author: Flowboost (Arjan)

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.

Shopping

shopping

products

labelizer

roas

segmentation

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 & Settings → 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).
6

Ready to Use This Script?

Configuration Variables

Variable	Default	Description
`SPREADSHEET_URL`	template URL	URL of the Google Sheet for output.
`breakevenRoas`	6.5	Breakeven ROAS threshold for product categorization.
`AverageCvr`	5	Average conversion rate in Shopping (used for click thresholds).
`impressionThreshold`	50	Impressions below this mark products as 'no-index'.
`daysAgo`	90	Lookback window in days.

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".