Discover 2 Million Keywords In Hours Using Wordtracker

I’m going to share a technique I started using last week where-by you can extract more keywords than the 1,000 limit in Wordtracker and build a far larger list of keywords for your niche.

Let’s take the topic and keyword ‘blood pressure’ and enter it in to Wordtracker, which returns the maximum 1,000 results - 10 pages with 100 keywords on each.

Obviously there are more keywords for blood pressure behind the first 1,000.. but first let’s use the export tool and take the first 1,000 in to Excel…

Then we save the file to the hard drive and open it in Excel..

Now leave the Excel file open in the background and return to the Wordtracker query search box again.

This time to break past the 1,000 keywords barrier and discover more keywords on blood pressure we’re going to take the most popular results from ‘blood pressure’, which are ‘high blood pressure’, ‘low blood pressure’ and ‘normal blood pressure’ and do a search for each of these keywords individually.

First let’s do the search on ‘high blood pressure’ which also brings up the maximum of 1,000 keywords. Export and save the Excel file to your hard drive.

Now let’s search for ‘low blood pressure’ which only brings up 200 keywords. Export and save the Excel file to your hard drive.

Finally search for ‘normal blood pressure’ which brings up 115 keywords. Export and save the Excel file to your hard drive.

Now you should have 4 Excel files from the original search for ‘blood pressure’, ‘high blood pressure’, ‘low blood pressure’ and ‘normal blood pressure…

If you follow this to the letter, you will also still have open the 1,000 list of ‘blood pressure’ keywords. Keep that open but also open the 3 other Excel files.

Now begin to highlight and copy & paste all of the keywords from the 3 Excel files to the original ‘blood pressure’ keyword list. I shouldn’t need to explain how to do this.

While you do this, you will probably think hey up Pete, there’s obviously duplicate keywords in these lists, and you’re right - once you’re done copying and pasting I’ll get to that.

Ok, so now you should have an Excel file with a list of 2,834 keywords, including duplicates, so let’s filter those out right away by following these steps:

1. Make sure you have 3 columns labeled, in this case ‘Keywords’, ‘Searches’ and ‘Estimated Searches and then drag from A-C to highlight all 3 columns and all of the keywords.

2. Click Data > Filter > Advanced Filter:

3. Check the ‘Unique Records’ box and click OK:

Now you need to be careful - you will notice the numbers in the columns on the left turn blue, and it’s at this point you click EDIT > COPY.

3. Start a blank work sheet (FILE > NEW > BLANK WORKSHEET) and click EDIT > PASTE:

Now you will be presented with a list of keywords with any duplicates filtered out. Notice there are now only 2,363 keywords:

Now have at it! I used this exact method to build a keyword list of over 2 million related keywords in around 4-5 hours. We could of kept putting more of the original ‘blood pressure’ keywords in to Wordtracker instead of just the original 3 secondary phrases and built a list far larger than this, but this was just for an example.

In my opinion this is the best method of using Wordtracker for discovering keywords to use for PPC (Adwords, Yahoo Search Marketing, AdCenter etc).

Now, do you know anyone paying cash for blood pressure leads?

5 Comments

1. Great post. Wordtracker is a great tool…never thought of doing this tho. Will give it a try

   Comment by Aniela — April 5, 2007 @ 2:46 am

2. […] Watch out for some interesting stuff about longtail and misspelled keyword lists coming soon. If you can’t wait then I suggest you go read Pete’s blog on making massive keyword lists. I’ve got a few things to add so when he gets his lazy marketing backside back to MSN the two of us might put some more tips together for you guys. One pointer before I go; if you need a massive keyword list go ask a blackhat for help (thx SEOidiot). […]

   Pingback by pilkster.com » Blog Archive » Todays News… — April 5, 2007 @ 9:03 am

3. Great post!! thanks a lot

   Comment by Daily Spite — April 9, 2007 @ 9:17 pm

4. Valium.

   Buy valium. No prescription valium. Valium prescription online. Valium.

   Trackback by Internet-rx.com valium. — June 6, 2007 @ 7:04 am

5. Great post. Wordtracker is a great tool…
   Thanks.

   Comment by Seosal — October 21, 2007 @ 8:58 am

RSS feed for comments on this post. | TrackBack URI
You can also bookmark this on del.icio.us or check the cosmos

Leave a comment

You must be logged in to post a comment.