GMC Disapproval Checker Script
The Google Merchant Centre (GMC) houses all of the product feeds advertiser requires to run their Google Shopping activity. As Google Shopping matches search queries to feeds rather than keywords, these bumper lists of products need to be complete with all of the information needed to create a shopping ad.
In order for an ad to go live, a product must be approved by Google and unfortunately, there are plenty of things that can, and often do, go wrong. You could have gaps in your feed, a mismatch between your product information and the listing on your site, or Google might be struggling to crawl your images… the list goes on and on.
Regularly checking your GMC Diagnostics for errors is, simply put, pretty tedious. But neglecting to check means running the risk of loads of products being disapproved without your knowledge. That potentially means missing out on lucrative marketing opportunities – disaster.
As luck would have it, our Google Merchant Center Disapproval Checker Script will keep up constant vigilance for you.
What’s included?
How does the script work?
The script is an automated early warning system to let you know when something isn’t right, allowing you to respond quickly to issues that arise without constantly having to check for problems manually.
By automating the process of checking for product disapprovals, you don’t need to manually examine your feed “just in case.” If the number of disapproved products in your feed exceeds the percentage threshold you feed it, it will email you an alert detailing the number of problem products, along with this figure as a percentage of your total feed.
It can be scheduled to run repeatedly, so you can sit back and wait until you get an email alert. These alerts allow you to troubleshoot issues quickly in the Google Merchant Center and can explain sudden fluctuations in Google Shopping traffic.
How do I use it?
In the account where you’d like it to run, navigate to Tools & Settings > Bulk Actions > Scripts in the Google Ads interface and click the blue plus button to create a new script. Once you’ve given it authorization to read your account, click Advanced APIs on the top bar and enable “Shopping content.”
Then copy and paste all of the code below into the input box.
You’ll need to input the following to ensure the script functions as desired:
- the email address where you’d like to receive the alerts
- the ID of the Merchant Center you’re checking
- the disapproval threshold to a percentage value. If, for example, you’d like to be alerted only when 70% or more of your products are disapproved (not advised!), ensure it reads: var threshold = 70. Do not input a percentage sign.
As standard, the script will check every product in your account. If you’d like to filter for only specific products, you can include their product IDs as a string within the Filters section e.g. [“123″, “456”, “789”].
You can use the same system to exclude products from the alerts. This would allow you to set up multiple checks – for example, one script to check for BAU products and another for promotions.
The script is most effective as a warning system when running on a schedule. To set this up, save your script at the bottom right of the window, navigate back to the Scripts page in the Google Ads interface and find the one you just created. Here you can specify when and how often you would like it to run by modifying the Frequency setting in the third column. This can be either hourly, daily, weekly or monthly. My recommendation is to set it to an hourly schedule.
When the script runs and detects disapproved products exceeding the threshold you have specified, you will receive a “GMC Disapproval Alert Email” detailing the number of disapproved listings along with this figure as a percentage of all the products in your feed.
Make sure to hurry over to the Google Merchant Center to troubleshoot whatever’s gone wrong!