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
-
Traffic Data for Competitor Subdomain
Does anyone know of a way to get monthly visitor data for a subdomain that I do not manage? I would normally use SEMRush or Compete, but they only provide domain level data.
Competitive Research | | dsinger0 -
SEOMOZ EXCEL PLUGIN ARRAY FORMATTING
Morning All, I have followed along, and am trying to build my own " dashboard", SEOmoz API in Excel, to get the Domain Authority and MozRank for a bunch of URLs. I have a list of competitor sites / related competitors, and I want to pull in the moz url metrics so I can decide who to investigate further. I'm using this array SEOMOZ_URKMETRICS_toFit(A2,"Cols=128" and it keeps listing the results vertically. All the tutorials show this lovely link data in horzontal rows to the right of the url in question, but mine doesn't want to behave. PS. I do know the bit data is wrong, I'll fix that. Thanks in advance to anyone who can help.
Competitive Research | | Sugartheagency0 -
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 -
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 -
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 -
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 -
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 -
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