A Script For Identifying Ad Groups That Lack Sitelink Impressions
We all know by now that ad extensions in AdWords are an extremely effective way to boost our CTR. They’re easy to set up, don’t cost anything extra, and according to Google, sitelinks can boost the CTR of ads for non-brand searches by 10-20% and for branded search by up to 50%. Unfortunately, AdWords doesn’t make it very easy to determine which ad groups are not taking full advantage of this opportunity. So this month I am sharing an AdWords Script that generates a quick report to help identify opportunities with ad extensions.
Simple Scripts Can Be Written In 10 Minutes
The idea for this report came during my all-day training session on AdWords automation at ADworld Experience, an Italian PPC conference. I like to include live examples of writing AdWords Scripts to prove to the audience how easy it can be to come up with a quick solution. One member of the audience suggested I write a script to compare the total impressions for an ad with the number of impressions served with ad extensions. By taking the ratio, we can quickly find ads that have no extensions enabled or that are not serving extensions frequently.
Anyone interested in an upcoming full day training about AdWords automation and scripts should consider joining Anash Oommen, and Leo Sei from Google and me for our training day at Pubcon Las Vegas in October.
Outlining The Functionality Of The Script
With a little help from the audience, we had this script working in about 10 minutes. Here’s the rough flow of how the script works:
- The code pulls 2 separate AdWords reports: an extension report (for some reason Google calls this the Placeholder Report) and an ad text report.
- It must then join the 2 reports around a common element, in this case, the ID of the ad. To store the joined data, we can use an array and use the ad ID as the key. So for an ad with ID 1234, we store the data in an array variable, like map.
- Each of these, in turn, is an object so now we get to store multiple pieces of information for each ad ID. When we’re pulling the extension report, we can store map.impressionsWithExtensions and when we pull the ad text report we can store the data for map.totalImpressions.
- Finally, we iterate through our entire map of ad IDs and we calculate the percentage of impressions with extensions.
- To make it easier to analyze the data we use the SpreadsheetApp service to store the data in a Google Spreadsheet.
Why We Used A Script To Generate This Report
This report can be useful because AdWords itself doesn’t let you merge the 2 reports needed to calculate the percentage of impressions with extensions. You could download the reports manually and merge them in Excel but that tends to be time-consuming and not great if you want to run the same report on a regular schedule.
Try The Script For Yourself
After the conference I cleaned up the code and decided to make 2 changes:
- The script will only check for sitelink impressions. This is extension type 1. You could easily update the script to look at all types of extensions. Simply find the ID of the type you want and update the code that gets the placeholder report.
- The script gets the data at the ad group level rather than the ad level by using the function runReportForAdGroups() instead of runReportForAds(). If you prefer getting the data at another level besides the ad group, simply update the function runReportForAdGroups() to pull the data you want and be sure to update the map with the ID of the common element, usually the ID of the entity you are reporting for.
Here is the script code. Simply copy-and-paste it in AdWords > Bulk Operations > Scripts.
After you run the code, look for a new Google Spreadsheet in your Google Drive with the data. As always, if you’d rather not deal with too much code, take a look at Enhanced Scripts™ for AdWords from Optmyzr and be sure to let us know if there’s a script you’d like to see us build next.
With a simple script like this, you can automate a tedious and repetitive reporting task that helps identify big opportunities in AdWords. Since I’ve written the code, you can literally automate this in one of your accounts in 30 seconds but with just 10 more minutes of your own time, you could tweak this script to do some variation of the same work based on your exact criteria. Happy AdWords Scripting!
Browse By Category
You can’t have an outstanding team without an outstanding culture
There's a reason why our team thinks we are a great place to work and no, its not because we have a ping pong table set up. See more about Hanapin's latest certification + we'll let you in on a little secret!
Tracking UAC Performance Through Third-Party App Analytics
Explore how to link and import app downloads and in-app events in Google Ads through third-party app analytics providers.
The 2019 Budget Season Doesn't Have to Be a Nightmare
You could just go off of a formula and call it a day, but in order to have a solid budget in place you need to take the time to prepare.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
How to Build an In-Platform Facebook Ads Funnel
Facebook has many tools to help you build your funnel right in the platform, and to nurture that funnel without taking users off-platform at all.
How We Gained $21,000 More in Revenue by Changing One Color
Testing button color, or the color of any element on your page can be extremely rewarding - if it is done correctly. See how you can turn a simple test into drastic results.
New Research! The State of PPC
This year's State of PPC annual report has arrived! Grab the download for the latest trends and benchmarks in the PPC industry.
Load More »