No matter how smart and automated the new Google Ads campaigns are while using machine learning, a digital marketing agency will still need to take advantage of the scripts if we want to further improve our day-to-day tasks and overall account performance. There are scripts that will help you optimise your bid management, reporting, avoid overspends and overall save you lots of time.
This script can be added either in single Google Ads Account or even better in your MCC Account and check that all of your URLs do not result in error responses. The Script can run in hourly/daily/weekly basis and send you an email when a thorough check of keywords, ads, sitelinks is complete to inform you of any error responses found. The email will include the total number of broken links as well as a link to a Google sheet that will show details of where you can find each of the broken links. As a tip it is recommended to run the script in an hourly basis especially if the script is added in MCC level as there is a huge amount of data to analyse and there needs to be a full day between two subsequent analysis. When you have an hourly run as soon as the first analysis finishes the next one will start after 24 hours.
When running display activity in your Google Ads Account, this script is a must have. We have all faced a client that complained for receiving low quality leads and it tends to be difficult to manually check all of the thousands of placements your GDN ads appear in. This script does most of the work for you. Every time this script runs it checks two things:
Depending on the time period you are checking you can choose how often to run this script.
An especially helpful script when running international campaigns in multiple languages. This script pulls the search terms in two different tabs within a Google sheet. Positive are considered the search terms that have seen more than 0 conversions whereas negative can be the search terms with a cost you specify while they didn’t get any conversions. If you choose to run this script weekly, you will receive an email with a link to a Google sheet with the updated search terms. In the Google sheet you can add a column and use a formula to translate any search terms to the language you prefer.
One more script very valuable to PPC agency managers handling a number of accounts is a very simple script that sends an email with a table including information like current monthly spend, target spend, conversions and any other metrics important to you. This can run daily and give a quick overview of an account first thing in the morning or before the end of a working day. It is especially useful for accounts that have a strict budget to help avoid overspends or even underspends for grant accounts.
Since we have a number of ecommerce clients in our agency, this is a must-have script when running shopping ads. One of the biggest challenges when managing several Google Shopping campaigns and essentially Merchant Center Accounts with thousands of products is keeping up with disapproved products. A disapproved product means that it will not be promoted in the shopping ads and therefore this can result in a decrease of sales. That’s were the script comes in to save us time and prevent loss of revenue. This script checks all of the products in the Merchant Center and sends an email informing you if there is a higher percentage of disapproved products from what you defined in the script. This can run daily as it will only send an email when the threshold is exceeded.