Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
And they have quite a few benefits. First, they can be run against just about whatever schedule you can come up with right down to an hourly granularity. If you want to schedule one of these to run every third day of the month at 1 a.m., you can do that here. Or if you want to use a script to check your actual inventory every hour, pausing ads for products that you don't have in stock, you can do that too. And that leads us to our second big advantage of scripts. They can read from external data sources. We just mentioned pulling in inventory data to automate actions, but you can access any kind of data that you want through a URL fetch service, XML, or even data stored in Google Drive.
Last, scripts can also be created and run at the MCC level. Meaning you can use them to manage multiple linked accounts. Putting all this together is pretty powerful and you can solve a wide range of problems. Generally, the things you'll do with scripts fall into a few categories. First, you can create tools to automate tasks. Things like sifting through search terms reports to add new keywords, or adding the same negative keywords from campaign to campaign, or account to account. Second, you can use scripts to drive highly customized reporting.
For example, you could use a script to bring very specific data into a Google spreadsheet that's already set up with very specific formats, graphs and visualizations based on that data set. Every time your script updates the data, you've got your custom report or dashboard refreshed and ready to go. Third, you can use scripts to alert you to problems that require your immediate attention. Things like, when ads stop running, or when your cost per acquisition gets too high. Or, you could write a script to send you an email when a particular ad group's conversion rate drops for three days in a row.
You can even write anomaly detection scripts that can alert you to abnormal behavior so you can go check things out. Last, AdWords scripts can be used to react to triggers. We've already seen things like pausing ads based on your inventory feed but you could get really creative here. If you're a travel agency selling trips to Hawaii, you might monitor weather feeds and up your bids in all the states where it's snowing and freezing cold. Those are people that probably want a trip to the tropics. Okay. By now, you probably agree that AdWords scripts have the potential to really help you out.
And of course, for a more complete code reference you can always click the link to the full documentation. Note that before you can preview or run a script, you'll have to authorize the script to access the account. This is a security measure. Since it's possible that these scripts will be running when you're not logged in, in those cases, AdWords needs to know that it's okay for it to do whatever the scripts are doing on your behalf. And previewing is important, since these scripts have the power to actually make changes to your account, you'll want to make sure they're working as intended before you let them loose.
A recommendation here is to start learning by creating some reporting related, or read-only scripts. This will ensure that you're not making unintentional bulk changes to your account. And when you get comfortable, you can move on by writing scripts that actually make things happen in your account. But before you do, a good best practice is to make a backup of your account, and that's something we'll talk about in the next chapter. Finally, we're going to look at a sample of an AdWord script that you can download from the link below, copy and paste it into your account, and start running.
As you already know, quality score is one of the most important things to focus on when managing and optimizing accounts. But it's also something that you can't get historical data on. What this script is doing is regularly grabbing quality score and click the rate data, continually appending it to a Google spreadsheet over time. Over in that sheet, you can see that we've created a simple graph that can show us how our quality score is trending over time and how it might be impacting our click-to rate. To use the script, just paste it into the window of a new script, create a blank Google spreadsheet, and replace the spreadsheet URL variable with your own spreadsheet's URL.
Then, you can start keeping a historical record of your quality store. Then you can modify and update this script to do whatever else you want it to do. A good next exercise might be for you to take this script and add a third column of data to see how your average position is being impacted over time. AdWords scripts are extremely powerful and when used properly, they can help you reach new levels of performance in your accounts while simplifying the manual management process. If you're already using scripts, then hopefully you've gotten a few ideas from this video. And if not hopefully you're already working on writing your first script.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.