- HubPages Tutorials and Community
How To Do Keyword Research For Free
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.
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
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
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