Keyword Research 2: How to do Keyword Research

by AJ

A step by step guide on how to use the Free Google keyword Research Tool

Part 2 of a step by step guide on how to do Keyword Research using the free Google Keyword Research Tool. Keyword Research is still important in order to get Search Engine Traffic.

When publishing online you need to include the language that people are using in search phrases. Or how else will the Search Engines know to send traffic your way?

Using the Google Keyword Research tool

SEO Help
Google Keyword Research Tool
Google Keyword Research Tool

Introduction: How to do keyword research

The second in a series of tutorials about researching keywords

This is the second article in a series of tutorials about how to do keyword research. In the first article: Keyword Research 1: Introduction to Researching Keywords, we looked at why Keyword Research is so crucial for getting Search Engine Traffic.

This information applies to publishing content across the web, including here on Wizzley, Squidoo, Hubpages, EZine, blogs and websites.

In this article we will look at how to use the FREE Google Adwords Keyword Planner Tool.

In the following Case Study I will show you how I researched keywords for a page I was planning on Kindle Covers - a competitive niche but one that has made sales for me, because I came across a keyword that has high search volume but low competition.

How to search for Keywords

There's no definitive right way to do Keyword Research

Please Note

The method that is demonstrated here is the keyword research method I have developed and what works for me. Sometimes I go with a gut feeling as to what may make a good topic and I strike lucky with the keywords. Sometimes my research shows me I will have difficulty in getting ranked, but I publish anyway because it is a topic I want to write about.

So there's no guarantees here that my method will work for you but what I can guarantee is that if you assume what people are looking for and go ahead and create a page without doing any keyword research, then it could be a whole load of effort for nothing. Because no amount of promotion in the world is going to get you traffic to a page that does not have the keywords that people are searching for!


1. Go to the free Google Keyword Research Tool

Research Keywords 1
Research Keywords 1

2. Select your preferred location and language

Keyword Research 2
Keyword Research 2

3. Enter your keywords

Enter the Captcha and then submit
Keyword Research 3
Keyword Research 3

4. If more than 50 keywords are returned

toggle to the next page
Keyword Research 4
Keyword Research 4

5. Refine the search to get better matches

or leave the box unticked to get more ideas if you are stuck
Keyword Research 5
Keyword Research 5

6. Toggling to Page 2

I found something worth checking out
Keyword Research 6
Keyword Research 6

Analysing the Competition

Ignore the competition column

If I find a keyword that has high search volume, I research of the competition, once I have downloaded the keywords to an Excel Spreadsheet.

You can ignore the Competition Column as this relates to Adwords not keywords.

7. Select the keywords you think may be useful

Click on the Download Menu
Keyword Research 7
Keyword Research 7

8. Exporting to Excel

Select CSV for Excel
Keyword Research 8
Keyword Research 8

9. Downloading to Excel

Opening the Excel File
Keyword Research 9
Keyword Research 9

10. You will get an Excel Spreadsheet that is read only

Save the spreadsheet as a .xls file to your hard drive
Keyword Research 10
Keyword Research 10

Research the Competition

Enter the numbers in the spreadsheet

You can delete all the columns except the Keyword, Competition and Global Monthly Searches Column.

Delete the data in the Competition Column

Add 1 more column, headed Ratio.

Format the Competition and Global Monthly Search Volume columns as numeric with no decimal spaces.

Format the ratio Column as numerical with 2 decimal spaces.

Once this is done, you need to research the competition. You need to know how many pages compete for your keywords, so you can work out which are the best keywords to use.

Remember, to start with you are looking for high search volume and low competition and you will use a simple Google Search to get the numbers.

Simply go through you keywords list and search for each keyphrase, but enclose the key phrase in " ". For example when searching for medge kindle covers, I entered "medge kindle covers" in the Google Search box.

Once you have researched all your keywords, sort the data in the Ratio Column in ascending order.

11. Populate the Spreadsheet

Research the Competition
Keyword Research 11
Keyword Research 11

Which are the best keywords?

Analysing the Results

In my experience, the best keywords are those that come out with a ratio of less than 1, providing the number of Global Monthly Searches is worthwhile.

If you look at my results, you will see a small number of phrases that fit this criterion.

But what is interesting is that this is a classic example of the wrong name for a product having the potential to get traffic and make sales. The correct name for the product in M-Edge Kindle Covers, not Medge Kindle Covers. However, following on from my success with the Wii Draw, I decided to use this as my main keyword.

The page has made sales and I currently have two articles pointing to the page in the first three pages of Google.

More info about Keyword Research

Keyword Research is an essential part of Search Engine Optimization, which needs to be done BEFORE you grab a URL for articles, blogs and webpages.
Market Samurai is a great keyword tool that will help you analyse your competition andshow their weaknesses.
Keywords and keyphrases are very important terms for every online author. Find out about what they are, how to use them, and why we need them.
Once you have researched your keywords, where do you use them?
Updated: 11/13/2014, AJ
Thank you! Would you like to post a comment now?

Do you have any Questions about How to Research Keywords?

Only logged-in users are allowed to comment. Login
AJ on 07/08/2012

Tolovaj - regarding add ing a "-" or not having one, I have spent no time at all trying to work out which would give me a stronger keyword because to be honest there's been plenty of other keywords, that do not require this level of detail, that I use in my topics that have been successful for me.

So, I dont feel I have any info or experience I can share with you.

AJ on 07/08/2012

Ragtimelil, can I suggest you start a thread asking for specific help in the Wizzley Forum - we have a section on Keyword Research. Either than or send me a persoanl message about the specific topic you are researching - which I will keep confidential.
I cannot promise a quick answer because i am currently spending a lot of my time building niche blogs, however, if you are not worried about sharing your ideas on the Forum, then you may get some faster answers :)

Tolovaj on 07/02/2012

@AJ: This was not the question. According to Google and Google Analytics data is the same in both cases. But there is an on-going battle in SEO community on this detail. I thought some other tools can help to answer that. Is maybe Market Samurai more specific on this one?
Thanks in advance!

Ragtimelil on 07/02/2012

OK it's starting to come to me. But what if you can't find anything that has a ratio of 1 that makes sense? I get all sorts of suggestions that don't have anything to do with what I'm trying to write about. I'm Reeeelly a beginner when it comes to this stuff.

Ragtimelil on 07/02/2012

I get lost at step 10.

AJ on 07/02/2012

Tolojav, the way I would distinguish between the number of searches in this case is to look at the competition and whichever phrase has the least competition is the one I would target.

Tolovaj on 06/30/2012

Thanks for this presentation, I have very specific question: is there any chance to distinguish between these two exact searches: "e books" and "e-books"?

As far as I noticed, numbers are always the same...

AJ on 05/17/2012

Jo I am no expert on Panda and I read and follow what other people I trust are writing about it. Therefore, I DO believe those who say that because backlinking has been totally abused by all sorts of "naughty" stuff (like paying for links), then over the next couple of years backlinking, as we know it, will have less value in the calculation of Google Page Rank.

I think we all realise that quality, original content is increasing in value - and by "quality" I mean content that delivers what the visitor is looking for - so it does not necessarily mean thousands of words, the visitor may gain value with less!

However, nowhere have I seen the slightest hint that keywords will lose their value.

Using Search Engines is the only way we can find info and in my mind keywords are the ONLY thing that can link the Searcher to the exact info they are looking for.

I am a great believer in "If it ain't broke don't fix it" and while I think the backlinking aspect of SEO is very broken, because of the abuse, and needs fixing, keywords work really well so why change it?

Yes, some idiots stuff their titles and their content with keywords - but Google picks that up and yes, those pages will be either ignored or de-indexed. So that abuse gets punished where it really hurts = no traffic.

And you know, if it goes the way we think it will, won't that be great? A bit of keyword research, add them into quality, original content and forget about backlinking - bliss :)

JoHarrington on 05/13/2012

This is a genuine noob question. I've been hearing a lot recently that Penguin has made all kind of SEO defunct. Is that the case with keyword research too?

I'm only asking because I followed this perfectly and would like to put it into operation. Hence checking that we should still be doing it. (Yes, I am hopelessly confused by all of the fast-changing developments, as Google sets out for world domination.)

tribute_to_erasmus on 04/24/2012

The most useful article I've come across yet -- thank you so much for providing such detailed instructions and guidance!

You might also like

What Keyword Research Tool To Use?

Keyword research is essential part of on-line presence. Without proper tools ...

The Google Page Layout Algorithm

What is the Google page layout algorithm and how does it affect your Google r...

Disclosure: This page generates income for authors based on affiliate relationships with our partners, including Amazon, Google and others.
Loading ...