By Nico Brooks & Maggie Castle
It doesn’t take much to upend a Google Merchant Center (GMC) account. A single recalled product in a feed of thousands could suspend an entire feed. Discrepancies in shipping costs, lost site verification, or expired feeds are also common culprits. GMC requirements are always in flux and manual attention is typically required to monitor feeds. If a single person manages multiple GMC accounts, or conversely, if multiple people manage a single account, this can become overwhelming. GMC’s email alerts don’t always reach the right person and don’t always flag small issues. We created several safeguards to make GMC account management more programmatic and GMC suspensions and product disapprovals more foreseeable. Below, we have outlined two ways to stay in front of GMC issues in order to keep your shopping campaigns running unencumbered.
This process involves configuring a Google Apps Script (GAS) to run in a Google Sheet. We have provided sample code, but you should have some familiarity with GAS and Javascript before trying this on your own. See our post on advanced optimizations that don’t require a developer for some tips on getting up to speed with GAS.
With Google Sheets, Google Scripts, and the Content API for Shopping, we can track the feed status, its last upload date, the number of total products, the number of valid products, and more in one place from any number of GMC accounts. These types of values, pulled on a daily and rolling basis, can quickly answer questions like “when will my feed next expire” or “I wonder if my drop in impressions is related to a decrease in products in the feed.” While this information is accessible in GMC, pulling it into Google Sheets opens opportunities for enhanced reporting, alerts, and cross-account data consolidation. It also saves time.
To replicate this system, follow the steps below. Here is Google’s guide to the Content API for Shopping for additional context. To get you started, we created a Google Sheet with the correct script for easy replication.
If you work with multiple GMC logins, you will need to create a separate sheet for each login to collect data, since the script needs to execute under the same login as the GMC. We have multiple sheets collecting data, then aggregate the data into a single sheet using Google Apps Script. You could use the IMPORTRANGE spreadsheet function to do this as well, if you are not comfortable doing it in script.
There is other feed data you can fetch via the API. For other data feed status properties, see Google’s API documentation on Datafeedstatuses. You will need to customize the getDatafeedStatus() function in the script if you want to change the properties it is fetching.
While the Content API for Shopping extracts valuable information from your GMC account, we also recommend a second report that monitors your Shopping metrics based on AdWords and Bing Ads data. We use Supermetrics to aggregate campaign-level data and send an alert if day-over-day spending has changed significantly. This report and its accompanying alerts, in most instances, can inform you the next morning of suspicious campaign trends. Then, after referencing the report you set up in Google Sheets with the Content API for Shopping, you will have a comprehensive understanding of the issue at hand.
We produce this report using the paid version of the Supermetrics add-in for Google Drive. With the free version, you can pull up to 100 rows of data from Google Analytics and schedule it to refresh daily, but you won’t be able to fetch data directly from Bing and AdWords.
We hope you find these tactics helpful for keeping your shopping campaigns running strong. We’d love to hear your feedback in the comments. And if you’d like help optimizing a shopping campaign, drop us a line!
Maggie Castle manages a variety of shopping campaigns at Two Octobers and provides guidance and best practices for ecommerce marketing to our team. Prior to joining Two Octobers, Maggie managed shopping campaigns for IT giant CDW.
Nico Brooks oversees tools and analytics at Two Octobers, and loves nothing more than solving a real business problem with a few lines of code.
Nico loves marketing analytics, running, and analytics about running. He's Two Octobers' Head of Analytics, and loves teaching. Learn more about Nico or read more blogs he has written.
The latest developments in digital marketing include Meta feature updates, Google downgrading ranking on vastly…
ChatGPT traffic in the GA house! Plus new features in GA4 and understanding GTM first-party…
This article details the process of building two BigQuery tables for path analysis, with a…