🔥 FREE Google Ads Script: Dynamic Ecommerce Product Categorisation
Case Studies: https://www.marketlead.com.au/case-st...
Free Google Ads script for ecommerce product categorisation: pulls every product's performance into a Google Sheet, scores it against five thresholds, and writes a custom label back into Merchant Center. Used internally at Market Lead for 18 months.
What's covered:
The five thresholds: impressions, clicks, sales count, ROAS, sales volume
Why ROAS alone is the wrong starting point
Pulling data live from the Google Ads API into a sheet
Setting your ROAS goal and high seller cutoff per client
Buckets: more delivery needed, more clicks needed, winners, losers, red flags
Red flags: high volume sellers with poor ROAS that need work
Linking the sheet back to Merchant Center as a supplemental feed
Why this self-categorises your catalogue and frees up campaign structure
Chapters:
0:00 What this script does
1:00 The five categorisation thresholds
2:30 Running the script in a client account
3:30 Setting ROAS goal and high seller threshold
5:00 Clicks and impressions thresholds explained
6:30 The output buckets and red flags
8:00 Linking the sheet to Merchant Center
8:50 What's coming in version 2
Subscribe if you want more PMax and Shopping tooling.
More videos: / @marketlead
Market Lead: https://www.marketlead.com.au/
#GoogleAds #PerformanceMax #Ecommerce