Report: keyword difficulty verses SERPS ranking
-
Hi there,
I've been using the PRO tools for a few months now, and find them great for revealing information for my clients, and planning our SEO approach.
One report I've put together has been really helpful for a client, but I built it manually and it took ages.
It lists, in a spreadsheet, keywords side-by-side with keyword difficulty, target URL, and SERPs result. Sorting by keyword difficulty or SERPS position has helped us to prioritise which pages to hit first.
But it took a while to generate the report, and I'm wondering if anyone has a better approach, or if this kind of report can be generated automatically:
http://www.cicada-online.com/app/images/documents/product-page-SEO-blank.pdf
Thanks Mozzers!
-
You could basically run two separate reports and join them together in one spreadsheet. One from Google's keyword tool (the competition is PPC based data but a good indicator) and the second from your SEOmoz account for rankings and get a similar view to what you have but much faster. The one thing you would be lacking is the target URL. Raven provides the adwords competition data next to its ranking view as well.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Ranking keyword ecommerce product
Hi guys, I run an ecommerce store footdistrict.com. We sell sneakers. My question relates to the name of some of my products and how to rank for them. This concerns to the shoes from New Balance The name of this products follows this format: New Balance XXNumberXXX . But actually I have realized I am ranking for New Balance XXNumber XXX . Note the space between the number and the last 3 characters. All my titles, h1, keywords follow this format. Example: New Balance WL574 RUP vs New Balance WL574RUP My questions are: 1. How would you determine which keyword to rank for: New Balance XXNumberXXX or New Balance XXNumber XXX? I have thought of using analytics data to see the pattern of the users search or maybe the difficulty of the keyword? I am receiving a decent amount of traffic for New Balance XXNumber XXX but I wonder if it'd be higher ranking for New Balance XXNumberXXX 2. Does the algorithmn take into account this space? According to the On page Grader, I have an A for New Balance XXNumber XXX and a F for New Balance XXNumber XXX but I assume the engine doesn't work this way 3. What would you do? Thanks very much Kind regards
Moz Pro | | footd0 -
Campaign report errors
one of the heavily noted errors for the first crawl of our domain was duplicate titles. I did not see a list of the pages and their current titles, but i am pretty sure it is somewhere to be found. That would help focus the work to do. Am I wrong about that?
Moz Pro | | Jacog0 -
How can I change the day my keyword rankings are updated?
I have several campaigns which currently get their weekly keyword ranking reports updated on different days. I'd like all of them updated on the same day, so I can just check in one a week for everything.
Moz Pro | | RichardDavies0 -
Very Slow Advanced Reports
Hello All - I've been running some Advanced Reports again lately, and they seem much slower than I remember from last time I ran some. Currently I've got one (Inbound Links) report at 2,500 out of 10,000 links retrieved through LSAPI, and it's been at that point for about 6 hours. Did something get cloggered on the reports, or is it this just the expected performance?
Moz Pro | | icecarats0 -
Keyword Difficulty Tool Problems?
I was just using the keyword difficulty tool and for some reason, some of the keywords show "not enough data"...I'm not sure why this is the case because a few days ago, there was data... Anyway, is this because it take time for the tool to gather data each month, or is it because there's an issue with the GoogleAPI? Thanks a lot for your help!
Moz Pro | | simonmhchiu870 -
Why is the Rankings Report of SeoMoz always show inaccurate results?
I have been using SEOmoz PRO tool from last two months but I am not happy with the SEOmoz PRO Ranking Report.The results are very inaccurate and I am not able to understand why there is such a difference in the ranking results when SEOmoz tracks and when I track?Please reply at the earliest. Regards, Prashakth Kamath
Moz Pro | | 1prashakth0 -
Ranking
Why is comunicatedepresa.net ranking better than comunicatedepresa.ro for the term "comunicate de presa" Absolutely ALL the factors (links, domains linking, authority, onpage etc) seem to say that comunicatedepresa.ro should have ranked better.
Moz Pro | | seo.academy0 -
A tool for seeing all the keywords a website ranks for
As title, is there a tool out there that will allow you to see all the keywords a website ranks for in the first few pages of a particlur search engine? I would be particularly interested for keywords in the first 10 pages of Google. Thanks
Moz Pro | | blagger0