7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

Is this really too much to ask?

by sprogy
6 replies
  • SEO
    • |
I'm looking for a tool - or at least a manual process that wouldn't take "days" to complete - to do the following:

I would like to take a list of all the keywords my site currently ranks for...which is about 3000 keywords...if I export the list from Google Webmasters.

Then, I would like to calculate what MOZ calls "keyword difficulty" (I could use any similar metric that's calculated from the "competitiveness" of the first 10 search results - PA, DA, backlinks, intitle, inurl matches, etc.) for the entire list.

After that, I would like to gather the average search volume and CPC - for the entire list as well.

My final list would contain the following columns: "keyword", "avg. position", "keyword difficulty", "search volume" and "cpc"

Then I could play around with filtering/sorting (by original data or some compound metric) to identify the "low hanging fruits" - the keywords that are already related to my website and that cn offer the highest ROI (based on search volume, CPC, and competitiveness).

I figure such a list would be an excellent "compass" - to show me in which direction I need to start modifying/expanding the content of my website...

The only question remains - what's the easiest way to create such a list?
  • Profile picture of the author yukon
    Banned
    I stopped reading at moz, PA, DA... Those things don't rank pages.

    Look at the top ranking pages/domains link profiles & on-page (ex: Screaming Frog).
    {{ DiscussionBoard.errors[9712778].message }}
    • Profile picture of the author Mike Anthony
      Originally Posted by yukon View Post

      I stopped reading at moz, PA, DA... Those things don't rank pages.

      Look at the top ranking pages/domains link profiles & on-page (ex: Screaming Frog).
      You can disregard this poster. he is in serious denial that pagerank is still the way to evaluate links when it has not been updated for a year and is reported to be done as a public metric.
      Signature

      {{ DiscussionBoard.errors[9712897].message }}
      • Profile picture of the author yukon
        Banned
        Originally Posted by Mike Anthony View Post

        You can disregard this poster. he is in serious denial that pagerank is still the way to evaluate links when it has not been updated for a year and is reported to be done as a public metric.
        This is the same guy that buys junk auction domains based on idiotic things like homemade metrics (DA/PA). Moz helped dream up the scheme to milk money from noobs.

        The real world is looking at on-page & link profiles when ranking pages.

        Waste your time with homemade metrics or rank pages, your call.
        {{ DiscussionBoard.errors[9712937].message }}
        • Profile picture of the author Mike Anthony
          Originally Posted by yukon View Post

          This is the same guy that buys junk auction domains based on idiotic things like homemade metrics (DA/PA). Moz helped dream up the scheme to milk money from noobs.
          Rofl................you don't know where I buy and we both know it.

          The real world is looking at on-page & link profiles when ranking pages
          .

          and when you look at the links, how do you determine their strength?...do they talk to you?

          "we are strong Yukon"

          is it like a whisper or with an accent? or um..... do you use metrics (of which Pagerank is no longer being updated....tsk tsk)

          Waste your time with homemade metrics or rank pages, your call.
          Just had a customer come back for another set of domains awhile ago....because he's ranking with what he got before. Go figure

          Between your rants in favor of Pagerank which apparently will never be updated again and Dave teaching you how to do a 301 redirect you are making quite the fool of yourself.....and the best part of it is...you don't even realize it..
          Signature

          {{ DiscussionBoard.errors[9713015].message }}
  • Profile picture of the author patco
    I am 10000% sure thre isn't any tool to do all these things... I am really curious what exactly would you like to get as a report for 3,000+ keywords... The tool should do a few million query's to SE's to show you something like this in your situation...
    Signature

    A blog that will show you How to Lose Weight with a cool Quick Weight Loss guide...
    Also enjoy some of my favorite Funny pictures and photos that will make you smile :)

    {{ DiscussionBoard.errors[9712883].message }}
  • Profile picture of the author Mike Anthony
    Originally Posted by sprogy View Post


    Then, I would like to calculate what MOZ calls "keyword difficulty" (I could use any similar metric that's calculated from the "competitiveness" of the first 10 search results - PA, DA, backlinks, intitle, inurl matches, etc.) for the entire list.
    NO such tool. You can however do some of this with a macro/automation tool. You would install SEO quake and Moz tool browser plugins into your browser, have the macro tool start the browser , go to google, type in the keywords for you (read from a text file) and take a screen shot, save it to a folder and move to the next keyword in a loop and

    Rinse and repeat.


    Akward but thats why people use macros for the jobs no tools exists for.
    Signature

    {{ DiscussionBoard.errors[9712914].message }}

Trending Topics