Google Ads Skript: Hourly updates of Merchant Center feeds

Google Merchant Center	Tool
The script requires access to the Google Merchant Center.	The script can be executed if required.

This script is ideal for anyone who lets download the feeds in the Google Merchant Centre once a day from the server or from a Google Spreadsheet. Updates in the feed are then not only transferred to Google Ads the next day, but at most one hour later.

 Advantages of hourly feed updates

• Product price changes go online quickly. If higher prices appear in the shop than in the shopping advert, this is a conversion killer. And if the prices have been lowered, you miss out on valuable visitors and possibly conversions until the update the next day.
• Products that are no longer available are no longer advertised. Pointless costs are avoided.
• New products in the feed can be advertised.
• Product feed optimisations such as title, description etc. appear quickly in Google Ads ad copies.

 Script developer

This script is based on a script from Webmasterei Prange. Bernhard Prange from Webmasterei Prange has released it for publication here so that it can be used free of charge by anyone here in the Google Ads Scripts Store.

 Configuration

• The Google account used to execute the script must also have access to the Merchant Center! Unfortunately, the Google Ads interface only shows who created the script - but this is irrelevant and may differ from the Google account with which the script is executed hourly.
• In the "accountSettings" sheet, you must specify the merchant ID(s) for each Google Ads account. If a Google Ads account uses multiple Merchant Centers, please specify the Merchant Center IDs as an array.
  For example: 123456789,2222222
  If one or more merchant centers are contained in an advanced account (a different merchant center ID is shown in the top right-hand corner than in the top left-hand corner), then both numbers must be entered with > in between. The actual merchant center ID is on the right and the ID of the managing merchant center is on the left.
  For example: 1111111111>123456789,1111111111>2222222

 Configuration parameters

Usually, #execute only needs to be set to TRUE for the accounts for which the script is to be executed.

Note: Feeds that cannot be updated are automatically skipped.

Parameters that apply to all scripts

 Download Google Ads script Hourly updates of Merchant Center feeds

Please log in or register in the Ads Scripts Store first to download the script (why is this necessary?).