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
-
Tools for Monitoring Hundreds to Thousands of Keywords and Rankings
Hi All, I am in process of doing and SEO overhaul for our five global sites in: US, UK, Canada, Sweden, France I'd like to track hundreds of keywords and rankings per site - I'm talking at least 300-400 keywords each site. Each site has its own country domain with both www and www2 domains. So, I need a keyword tool that will let me track massive amounts of keywords. I know that the Moz Pro tool helps, but we only have 350 keywords on this account. I think on this. Any suggestions on something reliable that will provide good data? I'm sure I can get some budget to purchase something, but I also can't spend too too much money. I'm not looking for a massive analytics package. Right now, I'm concerned mainly with our keyword rankings Thanks in advance!
Moz Pro | | CSawatzky0 -
SEOTools Reporting
Is there any other services or software that provide keyword ranking and traffic data other than SEOMoz or Raven Tools?
Moz Pro | | JohnW-UK0 -
Best Keyword Difficulty Tool?
Hi All, I'm a bit frustrated with the fact that I can only enter 5 words at a time into SEOmoz's keyword difficulty tool. Does anyone know of a better way (or tool) to analyze keyword difficulty for hundreds of keywords?
Moz Pro | | nicole.healthline0 -
Cities in Keywords Ranking Reports
So I've been in the habit of creating a master list of keywords concatenated with the city name so I can track my local rankings versus competitors. 1. Is this the correct thing to do to help hone in on who competitive my sites are ranking in the local market? 2. If so, by doing this the On Page reports seem to be totally screwed, because the searches I'm tracking (with city) vs the keywords I want to analyse for on-page ranking (without city), are different. What is the solution?
Moz Pro | | justlawonline0 -
Keyword Difficulty Score Not Available
What exactly does this mean? That the service is down? Or the score will never be available? It seems like I get that and then the tool gets stuck and I get no other data.
Moz Pro | | endlessrange0 -
Problem with Rankings and On-page Optimization
Hi SEOZ 🙂 I have a question regarding the Rankings and On-page Optimization in the seomoz Campaign Manager. I have setup a website url for examle: www.keyword.com After that created a list of all the target Keywords, that I want to reach within my Website: keyword-a, keyword-b, keyword-c and so on... Then I did a On-Page Analysis for all the urls with the specific keywords. keyword-a: www.keyword.com/keyword-a/ keyword-b: www.keyword.com/keyword-b/ keyword-c: www.keyword.com/keyword-c/ and so on... Most of the urls got the A grade. Now after the Website hast launched and got crawled, I have a problem with the Rankings and the On-page Optimization. The Rankings for my Keywords and also the Grades at the On-page Optimization are only shown for my Start/Homepage: www.keyword.com NOT for the urls that are specific for a Keyword for example: www.keyword.com/keyword-a/ Also the Grades are shown for the Keywords but again only in combination with my Start/Homepage www.keyword.com NOT for www.keyword.com/keyword-a/ What is the problem? Bye, Alex
Moz Pro | | krseo0 -
How long has the keyword difficulty tool had these limits in place?
While working against a tight deadline, I was surprised to see the following message: "We're sorry. Currently we are only able to offer results for 300 keywords per user per day. Please come back tomorrow" How long has this limit been in place and is the limit listed anywhere during the signup process? I rarely use this tool for more than 10-20 keywords at a time, so I have not run into this issue before.
Moz Pro | | davidangotti0 -
Exporting ranking stats; errors
previously, when I went to export the weekly rank stats, the csv opened into excel and everything was fine. This week, one campaign data will not export other than purely in comma deliniated and will not translate to colums in ecel. A second campaign does export directly to excel but the data showing (on 27th June) is for the 22 february (report created march 1). so all my spread sheets for position analysis are up the creek and I cant even get last weeks positional report on my key domain. any thoughts??
Moz Pro | | Citybase0