Hana Kobzová, a fellow member of the list and Google Ads Scripter, recently shared an interesting script.
What it does:
This script monitors the availability and approval status of a list of (best-selling) product IDs in your Merchant Center. If any of the products in the list run out of stock or get disapproved, you will receive an email alert.
Why you’d care:
For most e-commerce shops, over 80% of revenue is generated by less than 10% of the products. When a significant amount of these products runs out of stock or gets disapproved, you will immediately see a drop in conversions. What’s even worse, smart bidding might start spending high CPCs for other products that don’t have sufficient conversion data to reach your tROAS yet -> less conversions, lower ROAS. You want to be in the know when your most important products have issues! This script makes sure you do.
Why I like it:
The script is easy to understand and relatively basic, yet creates a lot of value and can easily be expanded with additional features.
URL: https://ppcnewsfeed.com/blog/product-monitoring-in-google-merchant-center/
PRO TIP:
Ask your favorite LLM to expand the script to dynamically create the list of best-selling product IDs for you. That way, you won’t have to add and update the product IDs in the code yourself.
Happy scripting!
– Nils
PS1: Want to learn how to use LLMs to edit and create a Google Ads Script for you?
Join me for my SMX London workshop ‘Google Ads Scripting with AI for Beginners’ (Sep 17), or SMX Advanced Berlin ‘Advanced Google Ads Scripting & AI’ (Sep 29)
Register by 1 August to save up to £200, and if you use the code ‘Nilshms15’, you get an extra 15% off!
PS2: Want to learn how I use scripts to predictably scale profitable growth in e-commerce accounts?
Join me for my talk at AdworldExperience (Bologna, Oct 3) titled ‘Advanced Google Ads Scripts for e-Commerce’
Register via https://www.adworldexperience.it/en/?affiliates=143 and use promo code ‘cooler10’ to get a 10% discount.