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
-
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 -
Infographics and Data copyright?
If we are creating an infographic but pulling data from other peoples infographics is there any copyright? We will be creating unique visuals and adding to the data but some data will be coming from other people?
Competitive Research | | BobAnderson0 -
Question about the Playback Locations report in YouTube Analytics
We have several hundred YouTube videos. In the Playback Report section in YouTube analytics, I can see a list of sites where people have viewed our videos. Some of the sites listed are competitors. The report does not show the URL of the page where the video is embedded. Is there a way to find this information? I have already tried using Google to search for the URL, but I'm thinking this isn't going to search the source code and the video URL isn't going to appear on the page anywhere. Any ideas? Thanks!
Competitive Research | | danatanseo0 -
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 -
Best methodology for creating local keywords when Google has no data?
Generally I'll look at data for specific geographical searches and incorporate the data from the other keywords, then track the metrics. I think there is likely a more efficient system but I'm not sure where to start.
Competitive Research | | DoriC0 -
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 -
Where are the best places online to build powerful profile pages
So on SEOmoz you can create a profile page with followed links (after 200 points), just as you can do on Google Profiles. I'd like to build a strong backlink profile which features some of these highest links that my competitors will not have the time or effort to do. I'm working hard to answer questions on SEOmoz and to be a helpful part of the community, and have published some Google Knols for the Google profile building. My question is; are there any other sites that allow the same type of responsible profile building, preferably SEO related as this is my area of expertise. Thanks Aaron Solar Monster Ltd
Competitive Research | | aarondicks0 -
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