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
-
Tool to scrape data from Homedepot,ebay,amazon.
Does anybody know about a tool that you can use to aggregate data about the best seller products in categories for major retailers in USA? I did find a couple not so good tools for amazon and even ebay but retailers like walmart and homedepot are left out.
Competitive Research | | Harveyspecter0 -
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 -
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 -
Why do some sites perform great but show no data on the tool bar?
Hey everyone, Been a paid member for 3 days and this is my first time posting 🙂 I have a quick question about competitive analysis with the MozBar. I do not want to point out the exact website (unless that is something cool to do on this forum), but there is a site ranking for a single keyword in the local 7 pack in slot one, which is also slot one for the SERP entirely. When I go to look at the page in more detail, the MozBar is showing no DA, PA, anything at all, and the Open Site Explorer is showing no links internal or external. I know that the page has to have at least some of these elements populated in order to be ranking for a term this competitive, so why is the bar not showing anything? The bar works GREAT on other sites below this one. Thanks for any help!
Competitive Research | | tonyflorespsa0 -
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'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 -
What is the right way to due a competitive Link analysis?
Trying to use the saturation report suggestion with no luck for google.com,and looking for away to benchmark either Pagerank or page authority to figure out how many links are required to overr take competitors from diversified sources. What is the process to do this to get the best results for the client.
Competitive Research | | bmcfarlane0 -
Gathering SERP analysis data
Hello, Im gathering data to complete the spreadsheet found here http://seomoz.box.net/shared/g3vz0kxbbp (using Ben's). A lot of the data can be gathered from open site explorer, the moz tool bar or via the key previded but where is the quickest place to gather the below info or is a lot of it manual gathering? Lk RDs KW Usage LDA Score Xct Anc. Txt Links Xct Anc. Txt RDs Part Anc. Txt Links Part. Anc Txt RDs Domain # Linking RDs Tweets FB Shares Blog Links
Competitive Research | | RikkiD220