ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • HubPages Tutorials and Community

How To Do Keyword Research For Free

Updated on August 17, 2013

Using This Free Keyword Research Tool

Google has a new Keyword Research Tool called Google Adsense Keyword Planner. This new tool replaces the Keyword Tool and includes all of the old features with many new ones as well. I am not going into the advanced features of this new keyword research tool.

The other program we'll be using is a spreadsheet. You can buy Microsoft's Excel spreadsheet or download the free OpenOffice Calc spread sheet. I will be displaying the Calc spreadsheet in this how-to.

Together you can do basic keyword research in under an hour and give your lens a better chance at being seen by more people because you are using keywords people are actually using to tag your lens.

Photo Credit

Using the Best Keyword Research Tool - -free is always best

The new Google Adsense Keyword Planner is easy to use. The opening screen will win no awards for being pretty but it is easy to use none the less. I use the tool twice for every search.

Step one: Put in a seed keyword. In this example I used Keyword Research. Put this in the search for Keywords or ad groups ideas box and press the search feature.

Step two Make sure you Select All Locations as your search area and that you select Exact Match as a search filter.

Step three: Start with a seed keyword and select 5 good longtailed keywords from the first search.

Step four: Reseed the Keyword planner with the selected five keywords. Now you have a large group of longtailed keywords for you to filter through with the spreadsheet.

Easy Keyword Research with Google Keyword Planner.

Click thumbnail to view full-size
Step One: add a keyword seedSet Search Type to Exact and Set location to All. Go through the list of ad groups and select 5 good keywords to continue the search.Click on the Magnifying Glass symbol to get your list of selected keywordsClick the modify se3arch button at the top and add your 5 keyword choices( one per line) and do the search again for a second time.Now you'll have a great list of keywords to comb through. Click on the download button.Select Excel CSV optionremove a couple of columns for clarity and ease of data filtering later.add a new column, again to aid in data filtering later.Add a keyword count calculation formula and copy it down the column.Select all the data range and them select a data filter - standard filter.do a word count of 4 or more and a search count of greater than 450Your filtered list. This is a great start to your lens. From here you can get the titles to your next lens or for the different parts of your lens.Use the competition column to choose a good keyword.
Step One: add a keyword seed
Step One: add a keyword seed
Set Search Type to Exact and Set location to All. Go through the list of ad groups and select 5 good keywords to continue the search.
Set Search Type to Exact and Set location to All. Go through the list of ad groups and select 5 good keywords to continue the search.
Click on the Magnifying Glass symbol to get your list of selected keywords
Click on the Magnifying Glass symbol to get your list of selected keywords
Click the modify se3arch button at the top and add your 5 keyword choices( one per line) and do the search again for a second time.
Click the modify se3arch button at the top and add your 5 keyword choices( one per line) and do the search again for a second time.
Now you'll have a great list of keywords to comb through. Click on the download button.
Now you'll have a great list of keywords to comb through. Click on the download button.
Select Excel CSV option
Select Excel CSV option
remove a couple of columns for clarity and ease of data filtering later.
remove a couple of columns for clarity and ease of data filtering later.
add a new column, again to aid in data filtering later.
add a new column, again to aid in data filtering later.
Add a keyword count calculation formula and copy it down the column.
Add a keyword count calculation formula and copy it down the column.
Select all the data range and them select a data filter - standard filter.
Select all the data range and them select a data filter - standard filter.
do a word count of 4 or more and a search count of greater than 450
do a word count of 4 or more and a search count of greater than 450
Your filtered list. This is a great start to your lens. From here you can get the titles to your next lens or for the different parts of your lens.
Your filtered list. This is a great start to your lens. From here you can get the titles to your next lens or for the different parts of your lens.
Use the competition column to choose a good keyword.
Use the competition column to choose a good keyword.
Long Tail Keywords - How to Find Them, and More Important, How to Use Them!
Long Tail Keywords - How to Find Them, and More Important, How to Use Them!

Longtailed keywords are the best. Learn more by reading

 

Search Engine Optimazation Tools

Step five: To get your spreadsheet data ready for filtering you need to delete a few excess columns and add one to the list. In this added column you place a formula to calculate the word count of the keywords. This formula is

=IF(LEN(TRIM(A1))=0;0;LEN(TRIM(A1))-LEN(SUBSTITUTE(A1;" ";""))+1)

Copy this formula to the whole column by clicking on the tiny black box in the bottom right corner of the cell and drag it down the length of the whole column. Then click on the top and rename the cell to Word Count. Now thew data is ready to filter.

Step six: Click in the top left corner to select all the cells. Now click on the menu under the Data heading to Filter and Standard Filter. This brings up a box where you can select different filters for the data. I usually set the word count to greater than or equal to 4 do get descent longtailed keywords and the global search to greater than 450 but you can alter this to whatever you wish. If you are in a very focused niche the searches may be a lot less and find that search of 100 or more is very good. In this example I chose 450.

Step seven: Now you have a select group of focused longtail keywords to group together into a lens. Use the competition column to further select a few of the keywords you plan to use.

Here is another way to get keywords.

Find Competitor Keywords - Keyword Research Made Easy

Comments

Submit a Comment

No comments yet.