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
-
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 -
Why is our website ranked lower but beats most competitors in full SERP report?
We are analysing why our website ranks so low (currently position 8 in serp). We beat our competitors in most areas. Also we produce by far the most useful content. Do not buy links or do any other malpractice. We have been for a long time ranked in top 3 (well mostly 1-2) positions. In the last year we have seen a decline to position 8-10 and we are not sure why this is the case. Can anyone suggest what we should be focusing on? We are clueless. All the practices we used to "know" now seem obsolete. m8qIeyC,Kf1LLei#0
Competitive Research | | urkeman0 -
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 -
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 -
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 -
Are there any tools to extract keywords and long tail keywords from a site and report keyword density by URL?
I need a tool that does the following: Find exact matches for keywords in content of sites and report keyword density by URL. Then identify the value generated by a particular keyword.
Competitive Research | | MotionPoint0 -
Why there is no even close correlation between MajesticSEO data and Open Site? Explorer?
I compared my site home page against my competitor homepage with Open Site Explorer and I found that according Open Site Explorer I have only 3 backlinks where in MajesticSEO I have more than 100 backlinks in 'Historic' data and more 90 in '30 days fresh data'. Why there is no even close correlation between MajesticSEO data and Open Site Explorer? How SEOMoz count backlinks?
Competitive Research | | eladlvy0 -
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