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
-
Rank online sex shop
I have been trying for some time to take the online store to the front page, but it is very difficult to go up in google searches for the keyword ( sex shop ).
Competitive Research | | Constantin2021
Can anyone help me with some tips. Thank you.
https://www.voluptas.ro/0 -
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 -
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 -
Competitor reporting
We are in the process of creating customer profiles, conducting in-depth keyword/competitor research, fleshing out a content strategy, addressing old content, meta data etc, and researching sites (particular industry news sites) relevant to our industry who could be sources of authoritative backlinks. Once we receive approval from the powers that be, we'll start putting our strategy in motion. However, we are looking at SEO efforts as a long-term plan the entire organization understands is necessary. If our strategy is sound, I would think we'll start seeing results and some competitors will begin to take notice (and action.) So here is my question: How easy is it for a competitor to "report" a small/medium size business as breaking Google's rules i.e. could a competitor claim we are scraping their content (or content off of any site for that matter) and anonymously email Google? I think the answer to that question is "yes." How closely would Google look into the claim? We have zero plans on doing anything shady or underhanded but I was wondering if it is a simple process for a competitor to impact our efforts this way? Thanks for any insight.
Competitive Research | | SEOSponge0 -
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 -
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 -
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