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 -
Data that shows people who click on paid vs organic listings
Hey Everyone, I've been searching for data on the percentage of people who click on paid vs organic. My last stats which are now outdated show 60% of the people click on organic on average and 40% click on paid. Any help/links would be greatly appreciated.
Competitive Research | | JohnSammon0 -
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 -
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 -
Any chance to out rank Google flight data for company name?
If you search any number with "co" after it you get Continental Airlines flight information of the corresponding number. So you if you search "4co" you get the current flight details for Continental flight 4. Is there any chance if you have a company called 4CO and you own 4co.com that you could get the number one spot for that term or will google flight results always trump the "organic" results? Thanks!
Competitive Research | | 2comarketing0 -
Our site being outranked by competitors with lower "moz" scores - due to on-page SEO?
Howdy, Our SEO efforts are doing well, but for a few keywords it seems we cannot budge one of the competitors sitting in spot #1. Through some competitive analysis I've noticed that our website has a much higher mozRank with regards to both page and domain compared to the current #1 spot. My question is what kind of factors could be the issue as to why we are still being outranked. Is it simply a case of poor on-page SEO at this point or should I be taking the mozRanks with a grain of salt.
Competitive Research | | marketingdepartment.ch0 -
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