A Script For Identifying Ad Groups That Lack Sitelink Impressions
April 28, 2016
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
Faster, Easier Mobile Lead Generation with Social Lead Ads
Explore how lead ads work, what effects they can have on mobile conversion rates and next steps for rolling out campaigns across social channels.
What the State of PPC Report Reveals for 2018
This year we had a great turnout of responses and some mind-blowing insights to share with you. Join Hanapin's President Jeff Allen as he walks through what we found in our State of PPC Report for 2017-2018 and where the industry is going.
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
Bing Ads Content Data To Be Deleted
Bing Ads is Deleting Content Data. What you should know and do before-hand.
What Will 2018 Hold for Social?
In this webinar, join AdStage’s JD Prater and Hanapin’s Steve Burnett as they look into the next year and show you what to look forward to in the social advertising world.
Why Brand Ad Campaigns Are Important
Explore reasons why you should consistently bid on your brand name and gain more real estate in search results for branded searches.