{"id":2108,"date":"2016-02-23T19:52:27","date_gmt":"2016-02-23T14:22:27","guid":{"rendered":"http:\/\/www.karooya.com\/blog\/?p=2108"},"modified":"2019-05-31T18:19:20","modified_gmt":"2019-05-31T12:49:20","slug":"no-side-ads-adwords-script-to-identify-keywords-under-threat","status":"publish","type":"post","link":"https:\/\/www.karooya.com\/blog\/no-side-ads-adwords-script-to-identify-keywords-under-threat\/","title":{"rendered":"No Side Ads – AdWords Script to Identify Keywords under Threat"},"content":{"rendered":"

[Update on 29th Feb: There is an important update at the end of this post.\u00a0<\/strong>]<\/p>\n

While Google has been testing 4 ads on top of the desktop search result page and no side ads, these tests were just that. Tests.\u00a0Last weekend, Moz found<\/a> that Google has moved to 4 top ads format. \u00a0The same was confirmed<\/a> by Google to Search Engine Land.<\/p>\n

<\/p>\n

 <\/p>\n\"no-side-ads\"<\/a>\n

Aaron Levy of EliteSEM published an extremely well-researched post<\/a> on the impact of this change.\u00a0\u00a0Matt Umbro of Hanapin Marketing also weighed in<\/a> with data from 3 different accounts on potential impact of this change. \u00a0These two posts have covered the topic in detail. If you are not fully aware of the issue, you may read those two articles before you proceed here. Really!<\/p>\n

 <\/p>\n

Now, that you\u00a0have received all the gyaan<\/a> from the masters, here’s an AdWords Script to help you quickly identify the keywords that may be under threat of losing substantial amount of valuable traffic. You can get this data by using the “Top Vs Other” segment \u00a0report in AdWords, but it is not intuitive.<\/p>\n

 <\/p>\n

The Result<\/strong><\/p>\n

 <\/p>\n

Let’s start with the final result you will see with this script. \u00a0This script will give you a sheet which shows the keywords with highest number of clicks from Side\u00a0positions. (Here, I’m using the term “Side Position”, but technically, it includes ad shown on side positions as well as the bottom of the search result page ads.) The results are sorted by number of clicks on the side position.<\/p>\n

 <\/p>\n

The first row provides the summary of the entire account. This account received\u00a018% clicks on the side position in last one month (check the highlighted date range). From the next row onwards, you will see numbers for each keyword (along with its match type, ad group and campaign name). \u00a0\u00a0Here, the first keyword received 2670 clicks from the side position. Side position clicks were 26.8% of total clicks received by this keyword in last 30 days. You will also be able to see how many conversions were received by this keyword when appeared in the\u00a0side position.<\/p>\n

Looks useful, right?<\/p>\n

 <\/p>\n\"kw-impact-no-side-ads\"<\/a>\n

 <\/p>\n

With this report in hand, you will be able to identify keywords that may\u00a0lose most clicks, click share and\u00a0conversions. \u00a0You may decide to raise bids on keywords that are valuable to you. \u00a0If you are part of an\u00a0agency, you can send a quick heads up to your clients about potential loss of traffic from AdWords.<\/p>\n

 <\/p>\n

OK, Where’s the Script?<\/strong><\/p>\n

 <\/p>\n

If you are in a hurry\u00a0or you have working knowledge of\u00a0AdWords scripts,\u00a0here’s the script to identify keywords impacted by zero side ads<\/a>. Have fun with the script.<\/p>\n

 <\/p>\n

Rest of you who have stayed back to know a bit more about the script, here’s how you can customize it to get it working for you.<\/p>\n

 <\/p>\n