60 Minutes To Global Search Greatness Through Keyword Analysis

What if you could only spend one hour each week identifying some of your biggest opportunities and problems? What would you spend the time doing?

That was a question – well, more of a “challenge” given to me by a few attendees of a recent Advanced Keyword Modeling presentation. While the many possible analysis were great, they were limited by time and wanted to know of all of them, which I personally would do first.

First, the 60 minutes does not include gathering the data and building the reports. Since the challenge was to me and I would obviously use the keyword management tool I have developed to do them. Nevertheless, all of these can easily be done in Excel.

Analysis #1 – Underperforming Important Keywords

I like this analysis since it tells me which of my most important, high ranking words words are not generating traffic. Since they are ranking well most of the battle is over and I just need to understand why they are not getting clicked.

For this analysis I take all my most important keywords, often referred to as “gold words” or “tier 1 words,” segment them to find those that are currently ranking in the top 3 positions of the local search then sort by their “fair share” share of clicks. You can draw the line where you feel comfortable to define “fair share” but I suggest at least 5 percent.

Note:  Research based the rankings from over 30 million keywords from clients using our Back Azimuth Keyword Management suite shows that the average click rate for non-brand terms ranking in the top 3 positions ranges from 11.5% to 22.5%.

In the vast majority of the cases when you rank in the top 3 and you are getting only a few clicks it breaks down into a few root causes that are often easy to fix. The most obvious reason is that there is another listing or paid ad that is more relevant or compelling to click.

If that is not the case it is typically one of the following reasons:

  • The snippet is not relevant and they are not clicking.  This happens when there is not a lot of text on the page in sentence form.
  • Your Paid Ad is more relevant or actionable than your organic listing which happens with discounts and special offers that are harder to represent in the organic snippet.

The steps for this analysis are:

  1. Get the current Organic Ranks for all Tier 1 Keywords (for local specific words get the data from that city)  Authority Labs, Sycara  and LinkDex all offer city-level rank data.
  2. Get the Google Exact Match keyword volume for the Tier 1 keywords. I do this via the AdWords API but you can do it manually using the Google AdWords Keyword Suggestion tool.
  3. Using your analytics tool, get the organic visits for the your Tier 1 keywords. A big thank you to Google for making this harder.
  4. Create a new column in your worksheet named Share of Opportunity and enter the calculation of visits divided by demand and get the current share of traffic. This tells me the percentage of the total opportunity I am getting
  5. Sort the list first by Organic Rank then by Share of Opportunity column. Look at your list and any keyword not getting its fair share of clicks should be evaluated to see why it might not be clicked.

To review the snippet simply go to Google and enter keyword site:yourdomain.com and it will show you the pages that Google finds relevant on your site for that phrase. Find your desired page and review the snippet. Just cleaning up a few of these can increase traffic significantly to the site. This should be done for each of your country sites weekly but at least monthly.

Analysis #2 – High CPC Keywords With No High Organic Listing

For this analysis, I generate a report of my active Paid Search terms and sort them by the Average Cost Per Click and look at my rank reports to see if I am ranking for those terms.

Having paid and organic listings simultaneously allows me to maximize SERP shelf space but also allows me to shift some of the more expensive PPC click costs into organic listings. This is not a Paid or Organic but a Paid AND Organic objective. Once I have both I can analyze the collaboration or cannibalization levels.

At SMX East, I described this analysis during my session few people were doing this analysis but a number of the attendees followed up with me later indicating that as many as 18 of 20 of their top keywords did not have a corresponding organic rank.

The first insight I want is how many and which of my words, starting with the top 20, do not have a corresponding organic listing in the top three positions. I do make an exception when the keyword phrase has a strong correlation to local signals i.e. “Boston Marriott.”

The Steps for this analysis are:

  1. Export a list of your keywords from your paid search accounts and sort them by highest Average Cost Per Click (CPC)
  2. Merge in the keyword rank report that you generated in the first analysis.
  3. I typically just look at the top 20 keywords by CPC for those without corresponding organic ranking terms in the top 3. You can use top 5 but I have found the greatest “collaborative value” is when you paid and organic are both in the top 3 positions. For any that do not rank, do an audit on the appropriate organic page to understand why it is not ranking.

The assumption is that if you are spending a premium for these keywords there should be a similar level of effort and performance on the organic side.   Too many teams do not coordinate the lists of important words are rarely synced between the teams.

Analysis #3 – Tier 1 Keywords – PLP Rank 11 to 15

This analysis helps me identify key pages that are just off the first page that require minimal effort to get them ranking well. This analysis is a bit harder to do in Excel but using Pivot Tables it can be done. For those not familiar with the PLP concept, the goal is have the “optimal” or “preferred landing page” for each keyword the best ranking page.

In our analysis we have found that the click and more importantly the conversions are as must as 65% higher when the optimal page is ranking over any other page. The steps for this analysis are:

  1. Use the current rank report generated in Analysis 1.
  2. Merge the rank report with your list of preferred landing pages (PLP).
  3. Sort the merged list by the rank and look for those with a rank between 11 and 15.
  4. Audit the pages and identify specific on or off page improvements.

A variation of this report is to just make sure the PLP is the page that is ranking for your tier 1 keywords. Too often we only check for ranking and not to make sure the page that is ranking is the optimal page. If you have an incorrect or outdated page ranking it can dramatically reduce clicks and revenue since it may not match the goals of the user.

Clearly the gathering of the data and creating the reports will take more than the allotted hour but once you have developed your process and worksheets you can replicate it easily reducing the time. In my normal process of “60 minutes to Search Greatness” I am able to do 15 of these types of “find the anomalies” analysis using automation.

What types of weekly opportunity analysis do you do?

Opinions expressed in the article are those of the guest author and not necessarily Search Engine Land.

Related Topics: Channel: SEO | How To | How To: SEO | Intermediate | Multinational Search


About The Author: is currently the President of Back Azimuth Consulting and co-author of Search Engine Marketing Inc. His personal blog is whunt.com.

Connect with the author via: Email | Twitter


Get all the top search stories emailed daily!  


Other ways to share:

Read before commenting! We welcome constructive comments and allow any that meet our common sense criteria. This means being respectful and polite to others. It means providing helpful information that contributes to a story or discussion. It means leaving links only that substantially add further to a discussion. Comments using foul language, being disrespectful to others or otherwise violating what we believe are common sense standards of discussion will be deleted. Comments may also be removed if they are posted from anonymous accounts. You can read more about our comments policy here.
  • http://www.patrickwagner.com/ Patrick Wagner

    What a great post! Thanks for packing in a whole webinars worth of information on Keyword Analysis. Why is it that KEI or KEI3 drop from Keyword Analysis – I thought this type of calculation would only increase in value as we get many more factors to compare.

  • http://www.ydeveloper.com/e-smart-ecommerce-suite.html eCommerce

    Keyword analysis is an interesting part before starting a campaign for seo, It has been changing timely.

  • Bill Hunt

    Thank you Patrick, glad you liked the article. I want to do more of
    these types of articles to help people work smarter not harder
    especially as Google takes away more of the organic real estate.

    I have never been a fan of KEI/KEI3 I do agree it has a place in the
    keyword research process. I think too many companies waste time trying
    to find new words and not enough on getting more out of the ones they
    have. At SMX East none of the attendees in my Keyword Modeling session
    had done the “underperforming organic” analysis I describe above. That
    is such a wasted opportunity. These words you already rank for and just
    simple adjustments to the snippet can easily double traffic.

    many companies get distracted by how easy/hard a word is to rank for a
    keyword and loose sight of those already ranking. The key point of this
    article to help companies get more out of what they have. Then, once
    they have maximized keyword yield they can move on to new ones and that
    is where KEI values can help them sift though all the words to find the
    next batch that have the best opportunities. I think you just helped
    me pick my next article “How to use Consumer Interests to identify new
    keyword opportunities.”

  • David Rekuc

    Bill, the 11.5% to 22.5% benchmark you gave, is that for when the ad is appearing in the top 3 spots only? Meaning is this specifically when you’re looking at the top vs. other comparison in adwords? I’m a little fuzzy on whether you meant an average position of 1-3 or whether you meant actually appearing as a top ad.

    I’m assuming the approach you outlined is primarily for exact match keywords? I like using advanced segments in Google Analytics to segment based on landing page. Then, examine the inbound organic keywords to that page. It helps identify a disparity in keywords between paid and organic for a given landing page.

    Another great report you can use to spot disparity between PPC and Natural traffic is to export a search term report and a natural search report from Google Analytics. Use a vlookup to put the natural visits next to the paid visits on the same spreadsheet. Look for traffic drivers that are performing well in paid, but not organic, and vice versa. Works with conversions too.

  • http://twitter.com/SocialJulio Julio Fernandez

    Great post, thanks Bill!

  • yasir usman

    Search Engine Optimization |SEO| Tools – Softwares – Services – Guides – Tutorial & Ebooks




Get Our News, Everywhere!

Daily Email:

Follow Search Engine Land on Twitter @sengineland Like Search Engine Land on Facebook Follow Search Engine Land on Google+ Get the Search Engine Land Feed Connect with Search Engine Land on LinkedIn Check out our Tumblr! See us on Pinterest


Click to watch SMX conference video

Join us at one of our SMX or MarTech events:

United States


Australia & China

Learn more about: SMX | MarTech

Free Daily Search News Recap!

SearchCap is a once-per-day newsletter update - sign up below and get the news delivered to you!



Search Engine Land Periodic Table of SEO Success Factors

Get Your Copy
Read The Full SEO Guide