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
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
-
Traffic Data for Competitor Subdomain
Does anyone know of a way to get monthly visitor data for a subdomain that I do not manage? I would normally use SEMRush or Compete, but they only provide domain level data.
Competitive Research | | dsinger0 -
How Do You Create an excel spreadsheet of all blog post content on a site?
Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.? I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?
Competitive Research | | RonMedlin0 -
How to Find Another Site's robots.txt File?
An SEO report, not by SEOmoz, says my top two competitors have robots.txt files that disallows spidering. I suspect that their robots.txt file doesn't disallow all spidering. How do I find out what is in their robots.txt files?
Competitive Research | | lbohen0 -
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 -
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 -
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 -
Advanced yahoo search
Is it possible to see backlinks to a particular site with the parameters: only .edu backlinks page updated in the last 3 months I've tried using the yahoo advanced search at http://uk.search.yahoo.com/web/advanced?ei=UTF-8&fr=siteexplorer&p= but it just redirects me to yahoo site explorer and doesn't give the results I ask for. Cheers, Peter
Competitive Research | | PeterM220 -
Keyword Ranks reported by SEOMOZ don't match actual searches
SEO Moz reported that various keywords I was tracking were not in the top 50 results on Yahoo or Bing, yet when I did a Yahoo or Bing search for those keywords (from multiple computers and not logged into any Yahoo or MSN/Bing account) I found the keywords easily. What's the scoop?
Competitive Research | | Cybernautic0