Tired of manually checking for Google Merchant Center disapprovals? This script has you covered

This script emails you when the percentage of disapproved products in your feed has exceeded the limit you’ve set it, saving you the time and tediousness of manually vetting the Google Merchant Center.

Chat with SearchBot

If you run Google Shopping activity, you’ll be familiar with the Google Merchant Center. It houses all your product fees, which are bumper lists of all of the products you sell. As Google Shopping matches search queries to your feed rather than keywords, this bumper list should be complete with all of the information that Google needs to create your shopping ads. 

Each product in your feed has to be approved in order to show ads for it. 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. 

These errors and policy violations lead to ad disapprovals, which you can find out about in the Google Merchant Center. But checking your Google Merchant Center Diagnostics on a regular basis is, simply put, pretty tedious. Because it doesn’t do much more than house your feeds, it’s easy to forget to check for problems.

But neglecting to check means running the risk of loads of products being disapproved without your knowledge. That means you’re not running all your Google Shopping ads. Imagine leaving significant gaps in your feed for a Black Friday promotion, for example, and not noticing for hours on end. Not good.

As luck would have it, our Google Merchant Center Disapproval Checker Script will keep up constant vigilance for you. 

What does it do?

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 to 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! 


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.


About the author

Daniel Gilbert
Contributor
Daniel Gilbert is the CEO at Brainlabs, the best paid media agency in the world (self-declared). He has started and invested in a number of big data and technology startups since leaving Google in 2010.

Get the must-read newsletter for search marketers.