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

Filter Keywords by Importance (value)

Discussion in 'Black Hat SEO' started by Pixel3, Nov 1, 2013.

  1. Pixel3

    Pixel3 Newbie

    Joined:
    Jun 14, 2009
    Messages:
    35
    Likes Received:
    1
    Hello,


    Just a simple question, I have about 8000 keywords in my niche for local domination, there is 8k keywords but I want to devide it by 7 files and have them in a way that the first notepad file has 100 Keywords but it starts with the most profitable of keywords to the least. Basicly I would like to trim out the no use keywords and order my list of 8K keys by best keyword relativity/profit to least.


    Please help as I am stuck here and it would be greatly appreciated!
     
  2. alternatesword

    alternatesword Jr. VIP Jr. VIP

    Joined:
    Aug 25, 2012
    Messages:
    2,323
    Likes Received:
    484
    Location:
    scabbard
    Home Page:
    You can do it with Excel or with notepad++, do you have scrapebox? if yes, it will reduce some more time.
     
  3. Pixel3

    Pixel3 Newbie

    Joined:
    Jun 14, 2009
    Messages:
    35
    Likes Received:
    1
    Thanks for reply atlernatesword, yes I have legit scrapebox although I got it just recently so I am not a pro.
     
  4. Pixel3

    Pixel3 Newbie

    Joined:
    Jun 14, 2009
    Messages:
    35
    Likes Received:
    1
    I am stuck at this position ... please help anyone.
     
  5. Panther28

    Panther28 Elite Member

    Joined:
    May 2, 2010
    Messages:
    2,268
    Likes Received:
    3,405
    Occupation:
    Internet.
    Location:
    Internet.
    How are you finding out which keyword is the best, or you already have that information beside each of the keywords?
     
  6. Pixel3

    Pixel3 Newbie

    Joined:
    Jun 14, 2009
    Messages:
    35
    Likes Received:
    1
    Well I have scraped 8k keywords and many in that list are useless and I would like to sort them by the best (google importance) to the worst that actually is my question.
     
  7. Panther28

    Panther28 Elite Member

    Joined:
    May 2, 2010
    Messages:
    2,268
    Likes Received:
    3,405
    Occupation:
    Internet.
    Location:
    Internet.
    Not sure how you expect to find out if they are useless or not, however i would personally use semrush or adwords planner to get the search volume, and then organise them that way.
     
    • Thanks Thanks x 1
  8. Pixel3

    Pixel3 Newbie

    Joined:
    Jun 14, 2009
    Messages:
    35
    Likes Received:
    1
    Oh nice I did not know Google's new (or old) GKP tool could do that, so just before I got at it, I can import my 8k list and sort by global search volume trough GKP?