• Search Engine Land
  • Sections
    • SEO
    • SEM
    • Local
    • Retail
    • Google
    • Bing
    • Social
    • Resources
    • More
    • Home
  • Follow Us
    • Follow
  • Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • Live
  • More
  • Events
    • Follow
  • SUBSCRIBE

Search Engine Land

Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • More
  • Newsletters
  • Home
SEM

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.

Daniel Gilbert on November 14, 2019 at 8:44 am
  • More

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

Related Topics

Channel: SEMGoogle: Ads ScriptsPaid Search Column

We're listening.

Have something to say about this article? Share it with us on Facebook, Twitter or our LinkedIn Group.

Get the daily newsletter search marketers rely on.
See terms.

ATTEND OUR EVENTS

Lorem ipsum doler this is promo text about SMX events.

February 23, 2021: SMX Report

April 13, 2021: SMX Create

May 18-19, 2021: SMX London

June 8-9, 2021: SMX Paris

June 15-16, 2021: SMX Advanced

August 17, 2021: SMX Convert

November 9-10, 2021: SMX Next

October 2021: SMX Advanced Europe

December 17, 2021: SMX Code

Available On-Demand: SMX

×


Learn More About Our SMX Events

Discover actionable tactics that can help you overcome crucial marketing challenges. Our next conference will be held:

MarTech 2021: March 16-17

MarTech 2021: Sept. 14-15

MarTech 2020: Watch On-Demand

×

Attend MarTech - Click Here


Learn More About Our MarTech Events

White Papers

  • Digital Marketing Report Q4 2020: Benchmarks and Insights for 2021
  • Data SEO – The Next Big Adventure
  • Getting Started with Email Marketing Automation
  • The State of Local Marketing Report 2020-2021
  • Quality CRM Data: The Key to Delivering Great Customer Experiences
See More Whitepapers

Webinars

  • How to Avoid the Digital Transformation Trap
  • How to Build a Marketing System of Record
  • Meet BIMI: The brand-boosting email security marketers must have for 2021
See More Webinars

Research Reports

  • Local Marketing Solutions for Multi-Location Businesses
  • Enterprise Digital Asset Management Platforms
  • Identity Resolution Platforms
  • Customer Data Platforms
  • B2B Marketing Automation Platforms
  • Call Analytics Platforms
See More Research

h
Receive daily search news and analysis.
Search Engine Land
Download the Search Engine Land App on iTunes Download the Search Engine Land App on Google Play

Channels

  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social

Our Events

  • SMX
  • MarTech

Resources

  • White Papers
  • Research
  • Webinars
  • Search Marketing Expo
  • MarTech Conference

About

  • About Us
  • Contact
  • Privacy
  • Marketing Opportunities
  • Staff
  • Connect With Us

Follow Us

  • Facebook
  • Twitter
  • LinkedIn
  • Newsletters
  • Instagram
  • RSS
  • Youtube
  • iOS App
  • Google Play

© 2021 Third Door Media, Inc. All rights reserved.

Your privacy means the world to us. We share your personal information only when you give us explicit permission to do so, and confirm we have your permission each time. Learn more by viewing our privacy policy.Ok