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
-
Is Rank Tracker accurate?
Rank Tracker tells me my page is #3 on Google (US) for a keyword phrase When I check Google.com myself, I see my page is #6 Am I missing something here?
Moz Pro | | brianflannery0 -
How are you reporting specific KW ranking metrics these days?
Does Moz report average ranking for the month? What is your best advice for setting expectations for clients about keyword ranking data and reporting?
Moz Pro | | MeridianGroup0 -
How do you explain this in this Keyword Difficulty Report?
Hello here, I am trying to understand how my site virtualsheetmusic.com can better compete for the keyword "sheet music download" where we used to be 3rd until a few months ago, and now we are at the 5th spot. But here is my specific question: I can't find an explanation why two of our competitors are ranked before us at the 3rd and 4th spot. Please, look at the attached image (very wide) which shows the Keyword Difficulty Report for this keyword. You can also download a PDF of it here below: http://www.virtualsheetmusic.com/storage/keyword-sheet-music-download.pdf We are at the 5th spot, and the two competitors highlighted in pink are the ones I am talking about: I am trying to understand why they are ranking better than us, despite our metrics look much better than theirs. In fact, if I look at the metrics in the report, I can't find an explanation to justify their outrank against us, so there must be something else that the report is missing. Any thoughts about this issue are very welcome! Thank you in advance for any help. Sincerely,
Moz Pro | | fablau
Fabrizio [keyword-sheet music download.jpg](http://www.virtualsheetmusic.com/storage/keyword-sheet music download.jpg)0 -
Erroneous "Weekly Keyword Ranking & On-page Optimization Report" For Campaign
Hi, I just received an email alert from Seomoz telling me my "Weekly Keyword Ranking & On-page Optimization Report " for the period 11/06/12 - 11/13/12 is ready. It is just a copy of the previous report though, all rankings and ranking changes are the same. What is up with that? Best regards, Martin
Moz Pro | | TalkInThePark0 -
How do I delete my old keywords in the Keyword Difficulty Tool?
I'd like to clear all my old keywords out and start from scratch. How do I remove them?
Moz Pro | | shawn810 -
How do you add your logo to reports?
I hate to ask such a simple question but I have a good look around and cannot find the solution. I have the right kind of seomoz account....could someone point me in the right direction? Thnank you.
Moz Pro | | dv8media0 -
Where is the keyword difficulty tool data sourced from?
I also use Market Samurai, and I've noticed what seem to be big discrepancies with the keyword data presented by this (data comes from Majestic SEO) and the Keyword Difficulty Tool. To take just one example, I analyze the term "how to remove tea stains" In the Keyword Difficulty Tool, this returns the following: Root Domain Linking Root Domains: 2,233 Page Linking Root Domains: 4 When I use Market Samurai, however, the data returned is: RDD (Domains linking to this domain): 19,911 RDP (Domains linking to this page): 19 I thought that these two metrics were the same for both tools, but I've written them out in case someone sees a difference. As I say, Market Samurai data is sourced from Majestic SEO - a reputable SEO company - but I have no idea where the Keyword Difficulty Tool data is from, nor why these differences are so pronounced? Are they indeed the same metrics in both cases, or am I missing something? Any insight would be much appreciated.
Moz Pro | | ZakGottlieb710 -
My 2 Target Keywords Rank In Top 10 But Don't Show Up...?
Hi, My 2 target keywords definitely rank in the top 10 in the USA version of Google but they dont show up in SEOMOZ rank checker...I started using SEOMOZ abour a week or so ago and in 2 consecutaive ranking checks they haven't shown up... Market Samurai says they're 4 and 8 respectively, I can see them in the top 10 of Google and various USA proxies show they're in the top 10... Is there a glitch with SEOMOZ or am I doing something wrong? Thanks, James
Moz Pro | | James10