1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Researching huge keyword lists

Discussion in 'Black Hat SEO' started by srhcom, May 25, 2012.

  1. srhcom

    srhcom Junior Member

    Joined:
    May 12, 2009
    Messages:
    101
    Likes Received:
    52
    So I have been scraping keywords, and have hundreds of thousands of them at this point. Obviously I can't use the google tool to research these, but I have Ultimate Niche Finder, and even that can't handle this many keywords. Is there a way to filter out the garbage keywords easily? I'd like to at least filter keywords from my huge lists that have very low search volume. Can anyone recommend a method to get rid of the garbage before I start researching my keywords?
     
  2. metalan1

    metalan1 BANNED BANNED

    Joined:
    Sep 11, 2007
    Messages:
    318
    Likes Received:
    275
    traffic travis has a great keyword tool. You can easily separate search volume.
     
  3. srhcom

    srhcom Junior Member

    Joined:
    May 12, 2009
    Messages:
    101
    Likes Received:
    52
    I just tried traffic travis and it crashed when i pasted like 20k into it. Then it said the free version was not able to do more than 50 and i uninstalled it. Just hoping I can research these keywords instead of constantly hitting google's limit with UNF
     
  4. graphox

    graphox Regular Member

    Joined:
    Feb 1, 2011
    Messages:
    216
    Likes Received:
    17
    I have TT Pro, but TT is very slow at this, and usually gets you captcha blocked on Google if you don't have enough private proxies.. It can only do about 50 kws per proxy lol.
     
  5. markhenry121

    markhenry121 Elite Member

    Joined:
    Oct 14, 2011
    Messages:
    2,149
    Likes Received:
    239
    google adword keyword tool is best for search , here you can search near high searched keyword.
     
  6. utuxia

    utuxia BANNED BANNED

    Joined:
    Feb 14, 2011
    Messages:
    673
    Likes Received:
    111
    100k is a lot to do in 1 run. You will probably have to break up the list.
     
  7. dcuthbert

    dcuthbert Regular Member

    Joined:
    Jun 15, 2011
    Messages:
    411
    Likes Received:
    249
    I normally paste the list into Excel, and then filter on words which I don't want to bother with, and delete them. Cuts the list down a bit, and would probably knock about 25% off your list.

    I delete any which contain a year, eg 2010, 2011 etc, contain terms like 'youtube' and similar terms which you'll never outrank.

    I also delete keywords which are too long - in the cell to the right of your first keyword enter '=LEN(A2)' or whatever your first cell reference is, then copy that down your list. I then sort by the length (descending), and delete all keywords over a certain length - chances are they're too long to be your main keyword anyway.

    I can't remember everything which I filtered out, but that should get rid of a chunk of the list for you.