What's The Best Way To Clean A 10,000 Keyword List For A Certain Amount Of Searches A Month!

11 replies
  • SEO
  • |
I've got a large keyword list that has some keywords I know that get
maybe 10 searches a month & I need to find the ones that get a least
3,000 searches a month & weed out the low search keywords.

I know the new Google Keyword Planner allows you to import 800 at a time
is there a way to keep the ones that's going to be left over that has
3,000 searches a month & keep adding them & then download one big
spreadsheet with all the keywords that get 3,000 searches a month.
#amount #clean #keyword #list #month #searches
  • Profile picture of the author Bent SEO
    How did you generate the list originally? May be easier to re-generate the list with search volume parameters.
    {{ DiscussionBoard.errors[8520993].message }}
  • Profile picture of the author cpacashman
    There's a online site that generates a huge amount of related keywords
    that are similar, unfortunately I cannot locate the link to it in my bookmarks
    I'll post it when I do, also Freshkey does a lot to.
    {{ DiscussionBoard.errors[8521308].message }}
  • Profile picture of the author Tacit
    Could try term explorer - import them all into there.
    Signature

    "While tacit knowledge appears to be simple, it has far reaching consequences and is not widely understood."

    {{ DiscussionBoard.errors[8521479].message }}
  • Profile picture of the author Bambu
    Term Explorer would work or you can import 800 at a time into Keyword Planner, export their search data to Excel, and then sort by search volume, and remove those terms below X searches a month.
    {{ DiscussionBoard.errors[8522227].message }}
  • Profile picture of the author MikeFriedman
    Originally Posted by cpacashman View Post

    I've got a large keyword list that has some keywords I know that get
    maybe 10 searches a month & I need to find the ones that get a least
    3,000 searches a month & weed out the low search keywords.

    I know the new Google Keyword Planner allows you to import 800 at a time
    is there a way to keep the ones that's going to be left over that has
    3,000 searches a month & keep adding them & then download one big
    spreadsheet with all the keywords that get 3,000 searches a month.

    I don't know who told you that you can only search 800 keywords at a time in the Keyword Planner. You can import up to 10,000.
    {{ DiscussionBoard.errors[8522300].message }}
  • Profile picture of the author Monja
    I'd use Market Samurai so you can put those you don't want on a negative list but also set a minimum monthly search - easy, quick and free for 14 days
    Signature

    Free Business Class on Skillshare:
    http://skl.sh/2bvH8nS

    {{ DiscussionBoard.errors[8522354].message }}
    • Profile picture of the author MikeFriedman
      Originally Posted by Monja View Post

      I'd use Market Samurai so you can put those you don't want on a negative list but also set a minimum monthly search - easy, quick and free for 14 days

      It's good that it is free for 14 days because that is about how long it would take that piece of junk to get through a large list of keywords. :rolleyes:
      {{ DiscussionBoard.errors[8522364].message }}
      • Profile picture of the author Monja
        I know it takes a bit to run the research but then, it's a good tool though. I know about Longtail pro but that has to be paid monthly I believe

        Originally Posted by MikeFriedman View Post

        It's good that it is free for 14 days because that is about how long it would take that piece of junk to get through a large list of keywords. :rolleyes:
        Signature

        Free Business Class on Skillshare:
        http://skl.sh/2bvH8nS

        {{ DiscussionBoard.errors[8522416].message }}
        • Profile picture of the author MikeFriedman
          Originally Posted by Monja View Post

          I know it takes a bit to run the research but then, it's a good tool though. I know about Longtail pro but that has to be paid monthly I believe
          I'm just going to disagree. I do not think there is anything at all good about Market Samurai. Totally worthless and time consuming.
          {{ DiscussionBoard.errors[8522417].message }}
  • Profile picture of the author Monja
    what do you use instead?
    Signature

    Free Business Class on Skillshare:
    http://skl.sh/2bvH8nS

    {{ DiscussionBoard.errors[8522421].message }}
    • Profile picture of the author MikeFriedman
      Originally Posted by Monja View Post

      what do you use instead?
      Google Keyword Planner, Ahrefs, and SEO SpyGlass.

      The biggest problem with MS is it provides no useful backlink information about the sites you are competing with.
      {{ DiscussionBoard.errors[8522451].message }}

Trending Topics