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
-
Why is our website ranked lower but beats most competitors in full SERP report?
We are analysing why our website ranks so low (currently position 8 in serp). We beat our competitors in most areas. Also we produce by far the most useful content. Do not buy links or do any other malpractice. We have been for a long time ranked in top 3 (well mostly 1-2) positions. In the last year we have seen a decline to position 8-10 and we are not sure why this is the case. Can anyone suggest what we should be focusing on? We are clueless. All the practices we used to "know" now seem obsolete. m8qIeyC,Kf1LLei#0
Competitive Research | | urkeman0 -
Can an https: impact (not provided) keywords in Google Analytics? Meaning if I make my site https: will it provide any more keywords. If not how can I get this data?
I have a site that I'd love to have more keyword data on. Can making my site an https: site give me more keyword data than leaving my site an http: site? Thanks!
Competitive Research | | mattdinbrooklyn0 -
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 -
Trouble Exporting Xenu Crawl to Excel
I'm trying to export a Xenu file to Excel, but Xenu is only giving me the option to save as a Xenu or txt file...which I can't open with Excel. What am I missing? Thanks!
Competitive Research | | BrittanyHighland0 -
How can I obtain analytics and social data for a site that I'm not authorized on?
I'd like to get traffic information and facebook /twitter stats for a company. Don't know their ua, logins or have access to any of their pages. Where can I find this information? Any help would be greatly appreciated!
Competitive Research | | brandonschultz0 -
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 -
How to compare my pages with a Keyword Difficulty Report
I'm very new to SEO, but know just enough to be dangerous. I've run my first full KWD report and formatted the results per Jordan Judson's blog post. Now I'd like to compare how related pages on my site compare to these results. Unfortunately I can't figure out how to accomplish this task. Any guidance would be very much appreciated. Thanks, Steve
Competitive Research | | SteveMaguire0 -
Why there is no even close correlation between MajesticSEO data and Open Site? Explorer?
I compared my site home page against my competitor homepage with Open Site Explorer and I found that according Open Site Explorer I have only 3 backlinks where in MajesticSEO I have more than 100 backlinks in 'Historic' data and more 90 in '30 days fresh data'. Why there is no even close correlation between MajesticSEO data and Open Site Explorer? How SEOMoz count backlinks?
Competitive Research | | eladlvy0