How due I take the advanced report that i have exported as a excel file and recreate your online color coded version with the data.
-
In the keyword difficulty screen how do I recreate your beutiful color coded spreadsheet in the exported excel file based on the advanced reports.
-
Hi Brian
I just tested it for the first time and indeed there is a problem in that it doesn't recreate the nice output on the web version.
The only way currently that I can see around this is to record an Excel macro to at least get close to the result.
I like you thought it would dump it with the nice formating. Recording my macro now as I have several that I use for the SEOMoz reports t hat I use already as their output does need formating but it is worth it for the raw data.
-
Maybe Im misunderstanding what you mean - you dont recreate it, you just run the tool - the new tool is here http://www.seomoz.org/keyword-difficulty/
takes am inute or two to run but looks amazing
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
-
Data that shows people who click on paid vs organic listings
Hey Everyone, I've been searching for data on the percentage of people who click on paid vs organic. My last stats which are now outdated show 60% of the people click on organic on average and 40% click on paid. Any help/links would be greatly appreciated.
Competitive Research | | JohnSammon0 -
What tools can give reliable competitor traffic data?
Could you give details of reliable tools that can measure and provide competitors' traffic data? Google Adplanner used to provide such information until June of last year, and while it's numbers didn't match Google Analytics data, the numbers were reasonably close. The metrics we are most interested in are visits, page views and unique visitors. We have looked at sites such as Compete -- but feel it is far too inaccurate/ skewed with US data only; also, would prefer to not rely on Alexa traffic stats. Thanks in advance.
Competitive Research | | ontarget-media0 -
How much time takes Google to Index a page in the search?
Hello all, I have created a page and published it 2 days ago and it does not appear in the Google Search.How much time can usually/on average take to index a page by Google in order to appear in the search results of a web search? I have check the Google Webmaster tools and neither no urls have been reported to be blocked nor the content should be blocked. Thank you very much, Best regards, Antonio
Competitive Research | | aalcocer20030 -
Question About Keyword Difficulty Report
If I am trying to assess the difficulty of ranking for a longtail keyword phrase that is 3 or more words long, should I put that phrase in quotes when I enter into the Keyword Analysis Tool or not? For example, let's say I want to see how hard it would be to rank for the phrase "best educational resources for teachers". Should I enter into the keywords analysis tool as "best educational resources for teachers" or just as best educational resources for teachers? Which one would give me the most accurate difficulty assessment for that phrase?
Competitive Research | | AndyHawkins0 -
Competitor's Ranking's Reports are Showing Blank Values for Rankings
When selecting competitors to see how they rank for specific terms in the ranking's report page here, it loads the page normally, but without any actual rankings. Where values should be, it lists all values as our competition not ranking whatsoever (for all competitors). I'm not sure if there is something we're doing wrong, or perhaps we just need to wait for a refresh, but if anybody could help out, that would be wonderful!
Competitive Research | | ACLens0 -
Excel workbook for SEO?
A while back someone on here posted a really good workbook for analyzing ranking factors for competitors. Unfortunately I lost it, and I am hoping someone might know what i'm talking about and hit me up with a link to it, or perhaps your favourite seo workbook for excel? Thanks!
Competitive Research | | adriandg0 -
Online checkers for Anchor Links ?
Okay, we are looking for online tools to check our backlinks, and anchor links top domains, etc. OSE is not working for us, because looks like , it gets updated in some months. We are looking for something, which can drag the statistics in fw hours and show up. Let me know.
Competitive Research | | qubesys0 -
Are there any tools to extract keywords and long tail keywords from a site and report keyword density by URL?
I need a tool that does the following: Find exact matches for keywords in content of sites and report keyword density by URL. Then identify the value generated by a particular keyword.
Competitive Research | | MotionPoint0