Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

AdWords Scripts: The Complete Guide (+ Our 14 Favorite AdWords Scripts)

Implementing Adwords Scripts into your campaigns doesn’t have to be a daunting process. AdWords scripts are meant to help ease/automate your PPC reporting and performance, after all. So, a helpful guide on the value of these complex code snippets and how to use them goes a long way.
 
These scripts are tools to automate and optimize your PPC campaigns. From bid management and split testing, to improved reporting and avoiding repetition, they’re as useful as you make them. And, what makes these tools so great, is that they’re incredibly customizable.
 
This post will cover what exactly AdWords scripts are, how they work, and how to set them up. Not only that, we’ll also cover a few popular scripts that digital marketers use, and our 14 favorite here at KlientBoost.
 

“[AdWords Scripts] are coming” – image source


 
That’s a lot of ground to cover. Let’s get started.
 

What Are AdWords Scripts

In the most basic definition, AdWords scripts are snippets of JavaScript code that allow you to better control your campaigns. They can be used to automate internal functions within your AdWords account. And they can interact with external data as well.
 
Below you can see a example screenshot of an AdWords script:
 

A custom script for tracking account level Quality Score – image source


 

Why Use AdWords Scripts

Now, the most direct benefit of using AdWords scripts is that they save time. By automating the more tedious processes in PPC account maintenance, you can focus more on optimizing actual performance.
 
Not only do they save time, but scripts can often catch smaller issues or opportunities that you may have missed.
 
We’re only human, after all. There can be a lot of data to comb through in any given PPC campaign. So missing a low performing keyword or a chance to build a new ad group is understandable.
 
That’s where these helpful automation tools can be a big help. As a whole, they’re meant to help optimize your AdWords optimization routine itself.
 

Get Your Proposal

How to Setup AdWords Scripts

If you don’t come from a coding background, scripts can be pretty intimidating. I should know — ‘cuz I don’t come from a coding background and I was super intimidated when I began researching for this blog post.
 

You gotta be tough, like Blake. – image source


 
There are plenty of pre-built scripts available to the public if you want to go with the plug-and-chug method. But, in our experience, a little customization goes a long way, even with these pre-built scripts.
 
So, to make sure you can hold your own when setting up your AdWords scripts, let’s take a look at their different elements.
 
Functions – the Function is the first part of the script code and is fittingly what gets things started. You’ll always need one when using AdWords scripts. The Function element of your script should look something like this:
 
function main( )   {code to execute}face>
 
Variables – the next part of the script you’ll see are the Variables. They’ll typically be expressed as “var” something. Variables are containers that store data values — this is where the customization comes in handy. You can use whichever data in AdWords you want to access. Just keep in mind each Variable must correspond to specific Objects and Entities in your AdWords account.
 
Objects – in AdWords there are actually only four types of Google Objects: AdWordsApp, SpreadsheetApp, MccApp, and UrlFetchApp. For starters, you’ll probably only be using AdWordsApp for the Object of your scripts. This tells the script to look in AdWords for the data you want.
 
Entities – within the AdWordsApp Object, there are quite a few different Entities. There’s the basic account structure to choose from (account, campaign, ad groups, keywords) as well as Ad params, Labels, Ad Schedules, Budgets, and even some targeting. You combine your Variables, Objects, and Entities together to get the code snippet below:
 
var keywords = AdWordsApp.keywords( )face>
 
Selectors – this is where your scripts can become super helpful. Selectors are filters for the data that your script is going to pull from your AdWords account. For example, if your Variable is keywords, your Selectors will help filter which keywords the script references. Most Selectors fall under one of the below types:
  • withCondition( )
  • withIds( )
  • forDateRange( )
  • orderBy( )
  • withLimit( )
face>
You can use multiple Selectors to continually refine the data you’re looking at, which is what makes these so awesome. By now, your script should look something like this (with some added Selectors):
 

function main( ) {
var keywords = AdwordsApp.keywords( )
.withCondition(“clicks > 50”)
.orderBy(“Conversions DESC”)
.withLimit(25)
face>
 
Methods – these script elements are the commands in your code. You can have your code “Get,” “Set,” “Add,” etc. depending on what type of action you’re trying to automate. The complete list of Methods can be found here.
 
Iterators – Iterators essentially keep your script continually firing. By using the hasNext()face> and next()face> Iterator, you set up a loop that will continue to fire as long as your script keeps returning valid data.
 
When you put all the moving parts together, you get something that looks like the image below:
 

The annotations help translate the script. – image source


 
Now that you know the different parts that make up your AdWords scripts, you can better customize whichever scripts you choose to use — your own custom scripts or pre-built ones.
 
You can insert your script into your AdWords account under the “Bulk operations” tab on the left.
 
 

The scripts window allows you to manage existing scripts and create new ones.


 
So, having run through the basics of what make up all AdWords scripts, let’s take a look at the different types of scripts and their features/benefits.
 

Different Types of AdWords Scripts

There’s a lot of different scripts out there, people. And they come in all different shapes and sizes — reporting and adjusting and automating all different aspects of your AdWords account. For the most part, they fall under one of the below types:

  • Bid Modifiers
  • Pausing and Deleting
  • Third-Party Data
  • Bidding and Budgets
  • Tools
  • Alerts
  • Reporting
  • Seasonal Adjustments
  • Automating Maintenance
  • Labeling
  • Tracking
  • Ad Text
  • Keywords
  • Google Display Network
  • Shopping Campaigns

 
Depending on how elaborate your account setup is, and how many campaigns you’re managing, you may lean on different scripts more than others. Which is why it’s so nice that there’s so many different types.
 
There are, of course, some that are more popular than others, and are thus used by a bulk of digital marketers.
 

1) 24/7 Bidding

AdWords only has 6 default bidding time periods to choose from. But, thanks to Brainlabs, there’s an AdWords script that allows you to customize your bids by the hour.
 
After all, it doesn’t make much sense to be bidding on “pizza delivery” keywords at 9:00 in the morning. But it sure does at 7:00 pm.
 
Brainlabs even built a template of the spreadsheet you’ll need to reference in your script:
 

This spreadsheet would be the Object in your script. – image source


 

2) Heat Maps

Another super popular script that digital marketers use en masse is the heat maps tool. Not all scripts are for automating actual bid adjustments, etc. Some are for actually helping your analysis before the bidding even gets started. These heat maps are visual representations of user’s search behavior. You can see an example of a click-through rate heat map below:
 

This shows some significant differences in CTR during certain hours and days. – image source


 

3) Quality Score Tracker

Quality Score (QS) is a mysterious “black box” when it comes to AdWords. But that doesn’t mean that it isn’t worth keeping a weather eye on. Thanks to the team over at the PPC Epiphany blog, there’s a script that even comes with a dashboard as well.
 

It’s a great tool for correlating QS to impressions. – image source


 
This specific script will track the QS for all your keywords, so you can even go back for some historical analysis. And, as always, you can customize the script with the specific Selectors you want to use.
 

4) “0” Impressions Pause

This one is a simple but helpful little script. As the name implies, it automatically pauses any ads running for keywords that are generating zero impressions.
 
This is a great way to eliminate the worst performers from any given ad group before they start generating any wasteful clicks and traffic. Shout out to Russell Savage for this one (and the next one, to be honest).
 

5) Broken URLs Report

Another super convenient script is the Broken URL Report that Russell Savage built. It’s pretty straight forward and can help solve a problem that many of us face from time to time.
 
When we delete a page from our domain or change the URL of certain pages, we can sometimes forget to adjust the rest of our SEM account. This is where broken links come from, either returning 404 Not Found or 500 Server Error response codes.
 
This script will send you a report with any broken links so you can update them as soon as possible before they start costing you valuable traffic.
 

Our Favorite AdWords Scripts (From the KB PPC Experts)

There’s plenty of great AdWords scripts that are already available for you to copy-and-paste into your account. These are just a few of the most popular. But, keep in mind that scripts are a tool to help improve your optimization decisions (not replace your decision making).
 
Even the best scripts can’t replace an insightful PPC advertiser with optimization on the mind.
 
This is because automation truly works best when it’s customized to the specific goals of the account/campaign.
 
At KlientBoost, we like to create our own scripts to help automate our elaborate account setups. SKAGsSPAGs, and the like can get intensive when it comes to PPC reporting and analytics. So we rely on our AdWords scripts to keep us updated on everything we need.
 
Below you can check out our favorite AdWords scripts. Some we’ve made ourselves and others we simply appreciate for being awesome. Let’s start off with the ones that we’ve built ourselves. Not to brag, but we think these are pretty awesome and helpful:
 

Kind of a big deal, you know, whatever… – image source


 

6) N-Gram Script

The N-Gram script is a really neat script that we like to rely on to help grow and optimize our SKAGs. If you don’t know already, SKAGs are Single Keyword Ad Groups designed to create more relevant ads with improved Quality Score, CTR, and CPC.
 
SKAGs work by isolating the keywords you’re targeting to a singular search term. By aligning your search term:keyword ratio closer to a 1:1 correlation, you can control the type of searchers are viewing your ads.
 
But, in order to maintain and grow these SKAGs, you have to deal with a great deal of granularity. And a lot of ad groups.
 

I mean…a lot of ad groups. – image source


 
To help grow these ad groups and ensure they don’t overlap with one another (that would kind of defeat the point, wouldn’t it?), we rely heavily on negative keyword lists.
 
This is where the N-Gram script comes in so handy. You can view the entire script in the Google Doc here.
 
This script will take all the search queries within a certain time frame and allow you to extract 1-word, 2-word, and 3-word strings within the account to help with negative keywords and new SKAG creation.
 
 

The red boxes are where you can edit the script.


 
You’ll have to make a new Google Doc for this script, so your data can populate somewhere for you to reference. The spreadsheet will look something like the screenshot below.
 
 

You can continue to filter your new search terms within this spreadsheet.


 
This script is a real time saver when you’re dealing with a large amount of keywords or search terms.
 

7) Link Checker Script

Our Link Checker script is much like the broken link scripts that you can find elsewhere online.
 
This script goes through your account on whatever schedule you choose and looks for broken links. To be more specific, it looks for ads that are returning broken link 404s.
 

Again, the red box is your account-specific edits area.


 
If you don’t have any broken links, you won’t get any notifications — which is nice for marketers who don’t want to read pointless email notifications. You only get an email notification if there are any broken URLs within your account.
 
You’ll have to create a Google Doc for link for the script to place your broken links (if you have any). But after it’s set up this one is a real time saver. You can view the complete script in the link here.
 

8) Bid Adjustment Script

If you’re looking to consistently be on the optimization edge, these scripts are going to be of great help. Our Bid Adjustment script is a big winner — especially in terms of pushing your performance that last micrometer over the finish line.
 

You, trying to milk your AdWords account for every last conversion. – image source


 
For starters, this script is technically two scripts: one for increasing and one for decreasing bids.
 
For the first, you’re going to have to setup a filter within your AdWords account, so the script knows at what point to fire. You’ll want to setup your average position filter as worse than 2.4 (it doesn’t make sense to adjust bidding if you’re already getting placements better than 1.5). Then, set your CPA max that you’re willing to pay.
 
The setup should look something like the screenshot below:
 
 

So: if keywords average below $XX CPA, you can increase the bid to increase traffic/conversion volume.


 
Then, you place the script into your AdWords account to make sure this [RAISE BIDS] function works. This way, your account will automatically adjust the bids for keywords that fit through this custom filter. You can watch this YouTube video here for a more thorough walkthrough of the process.
 
Now, the lowering bids script works in much the same way. However, in terms of the filter, there are now two different requirements that must be filled:
 
 

Cost/Conv must be over a certain threshold, AND there’s a spend minimum.


 
With this script, any keyword bids that fit this filter will start lowering by 5% – 20% every time.
 
One last note on these two scripts before moving on: These scripts are meant for bulk keyword bid adjustments to help save you time. But, for any specific campaign or ad, it’s important you address singularities as such. If you have specific keywords that are bleeding money, make sure you address them in a more granular fashion.
 

9) Ad Spend Report Script

Now, here’s a script that our PPC Account Managers really love. This script will send you recurring emails within an account update on quite a few different KPIs:

  • ad spend
  • conversions
  • CPA
  • recommended daily spend
  • current daily spend

 
It’s a great way to get a quick glimpse at your account performance before diving into the nitty-gritty analytics. This is a huge plus if you’re managing multiple clients and want to get a brief overview before deciding which account to address first.
 

This script really depends on how you customize the time frame.


 
You can set this script to send you reports on any given timeframe. This is where the scripts customizability becomes very important. Check out the full script here.
 
You can set this for daily updates if you want. But it’s important you give any alterations you may be running enough time to reach statistical significance before reporting and analyzing the results.
 

10) Our Ad Copy A/B Test Script

We’re really proud of this custom script that we created at KlientBoost.
 
This script will comb through any campaigns you’re running and actually analyze some of your data for you. This is a huge step, as most AdWords scripts focus on reporting and aggregating data to make your analysis easier. This script takes it one step further and handles some of the easier analysis for you — leaving you more time to focus on implementing actual optimization solutions.
 
This script will actually go through the campaigns you’re running and apply a “Winner/Loser” tag to ad variants depending on their performance.
 

Even better? There’s no editing needed for this script. – image source


 
This is a huge win, because instead of having to click through each ad variant to see CTRs and Conversion Rates, you can see a clear “Winner” or “Loser” tag at the ad level.
 
You can also filter through the campaign by labels, which makes viewing your winners and losers even easier.
 
Then, you can pause the losing variants and make new ads to test against your winners. Check out our full script here to get started.
 

11) Low CTR Ad Pausing Script

Depending on what kind of optimization routines you’re running and what kind of ad rotation you’re using, you might be dealing with quite a few ad variants.
 
Now when it comes to testing, the more variants you’re able to test in a controlled and targeted manner, the better. However, if you’re dealing with too many ads to keep track of, some can fall through the cracks.
 
By this, I mean that certain losing variants may not be turned off or deleted. These slip-through ads, while they may seem like a small oversight, can ad up in terms of wasted ad spend.
 
This is why the Certified Knowledge script for Pausing Ads with Low CTR is such a quick and easy solution.
 

A real short snippet of code, at that – image source


 
This script will automatically pause the lowest performing ad in your campaign, so long as there is at least one other variant. It’s a great way to continually be paring down your account to clean it of your worst performers.
 

12) Bid By Weather Script

Adjusting your bids by using a weather script can get fairly complicated. But if you can set it up properly the script should generate some automatic bid adjustments that should yield some strong results.
 
For starters, you’ll need to create a Google Spreadsheet filled with your campaign data and the locations for each of the respective campaigns. You’ll then have to integrate a call to the OpenWeatherMap API for each location.
 
The script will calculate weather conditions for each location based on some basic rules. And it will then fire your bid-multiplier to increase the bids for certain locations based on specific rules you’ve defined.
 
Keep in mind that all this data needs to be housed in your original Google Sheet. It should look something like the image below:
 

First, you’ll have to setup your campaign details. – image source


 
That’s not all the data you’ll need, however. You’re going to have to set some very clear parameters to make sure the weather adjustments work as you want them to.
 
For example, after you setup your campaign location data, you’ll need to set the actual weather adjustment rules (what changes in the weather constitute a firing of the script). You can see a screenshot of that below:
 
 

These are some considered parameters for the script. – image source


 
Lastly, you’ll need to align your OpenWeatherMap API code with an AdWords geo-targeting code to make sure your ads fire for the right weather in the right location.
 
This way you can automatically increase bids for weather-affected ad campaigns in the specific locations. For instance, someone is more likely to be searching for “local ice cream shops” on a hot, summer day than a cold rainy one — so increasing your bids when a hot front roles in makes sense for more conversions.
 

13) Changes in CTR Script

We use our SKAGs method to create highly relevant ad copy that targets actual user search terms to increase CTR. So, it’s important that we keep that CTR as high as possible to ensure that we are still generating highly qualified clicks.
 
Because of this, a script continuously monitoring our ads CTR would be incredibly helpful.
 
And thanks to Sean Dolan from Pushfire, we have one.
 

You can view the whole script on Evernote. – image source


 
This script will actually populate a Google sheet so you can track the CTR of specific ads, historically. This is a great way to track any changes in user behavior in relation to your ad, and may open up new insights into what new search terms you may need to target.
 

14) Declining Ad Groups Report Script

Being the original masterminds behind SKAGs, we work with a lot of different ad groups. Just like the N-Gram script helps manage and grow our ad groups, this script helps us keep their performance up to par.
 
The Declining Ad Groups Report script will produce a multi-tabbed spreadsheet that will populate with any ad groups that are dropping in performance. It will look something like the image below:
 

This screenshot is for a multiple-account view. – image source


 
This is an pre-built AdWords script, so there’s not as much customizability as some other scripts out there. So you’ll have to work within the AdWords definition of certain parameters:
  • The ad group is enabled (on) and is part of an enabled campaign.
  • The ad group’s CTR (click-through-rate) has decreased.
  • The ad group’s CTR has been decreasing for 3 consecutive weeks.

 
That last criteria is the big kicker. This means that the script isn’t going to notify you any time any ad group sees a small dip in clicks. Which is good. This is a natural filter to ensure a higher rate of statistical significance.
 
Which means that if you’re getting an alter from this script, your ad group is in serious trouble.
 

Start Optimizing Your Reporting for Optimized Performance

So we’ve run the gamut in terms of AdWords scripts. We’ve addressed the most popular pre-built scripts that digital marketers love to use. And we’ve even thrown in a few of our favorites and our own custom scripts.
 
Always remember, though: scripts are tools, and just like any tool they’re only as powerful as the marketer using them.
 
So get cracking

The post AdWords Scripts: The Complete Guide (+ Our 14 Favorite AdWords Scripts) appeared first on KlientBoost.



This post first appeared on KlientBoost - PPC Management And CRO Experts, please read the originial post: here

Share the post

AdWords Scripts: The Complete Guide (+ Our 14 Favorite AdWords Scripts)

×

Subscribe to Klientboost - Ppc Management And Cro Experts

Get updates delivered right to your inbox!

Thank you for your subscription

×