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?

Search Terms Pedophiles Use To Get Themselves Off

As an ‘online marketer’ I use keyword tools like Wordtracker to research subjects and potential markets. Unfortunately when using these tools there’s massively common and disturbing occurrences which any sane person cannot fail to notice.

My personal opinion regarding pedophiles or perverts of a similar persuasion is that as long as they aren’t actively harming children, trying to groom or abuse them in any way, it’s cool - whatever. I’m sure they cannot help feeling sexually attracted to children, but it’s in their actions which ultimately decide whether I believe we should cut their bollocks off or shoot them in the face for the safety of other children.

The following is just a tiny selection of keywords Wordtracker is showing which are disturbing to say the least. I will include comparisons with other search terms so there’s an idea of the level of ‘popularity’ these search terms have:

Search Term	Searches		Search Term	Searches
preteen girls	10,279	>>	music videos	10,181
preteen boys	2,639	>>	beyonce naked	2,306
underage girls	5,276	>>	web design	5,430
nude preteen girls	1,818	>>	irs tax forms	1,902
young girls in underwear	1,272	>>	download free ringtones	1,280
naked 13 year old girls	1,156	>>	eminem lyrics	1,105
preteen girls nude	1,116	>>	comcast cable	1,188
13 year old girls	1,078	>>	free internet radio	1,090
illegal girls	1,047	>>	free virus scan	1,032
naked preteen girls	987	>>	ipod movies	981
photos of nude preteen girls	938	>>	internet radio stations	927
illegal young girls	920	>>	internet security	945
12 year old girls	862	>>	ipod video	892
14 year old girls	867	>>	car loans	844
preteen girls nude pictures	712	>>	small business loans	725
naked little boys	656	>>	us patent office	645
preteen girls masterbating	647	>>	msn messenger download	635
nude preteen boys	605	>>	download free clipart	604

preteen models gets 40,500 searches, and you know exactly the demographic that makes up the bulk of that search.

All of those search terms are very highly searched for. I don’t even go after keywords unless they’re below 400 searches. There are more people searching for photos of nude children then car loans, IRS tax forms and even music videos.

I dread to think of the long tail of these types of keywords - you’re obviously talking in the millions and it’s clear this ‘problem’ in society obviously goes very, very deep indeed.

Digg this entry if you believe it’s of interest to others

Discuss.