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
-
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 -
Question about the Playback Locations report in YouTube Analytics
We have several hundred YouTube videos. In the Playback Report section in YouTube analytics, I can see a list of sites where people have viewed our videos. Some of the sites listed are competitors. The report does not show the URL of the page where the video is embedded. Is there a way to find this information? I have already tried using Google to search for the URL, but I'm thinking this isn't going to search the source code and the video URL isn't going to appear on the page anywhere. Any ideas? Thanks!
Competitive Research | | danatanseo0 -
Competitor research: No data / results displaying on Keyword tools, Aexa
Hi there! I'm trying to research a few competitors using various Keyword tools (SEM Rush, Compete, Keyword Spy -- even Alexa for high level insight). While the bulk of the competitors generate expected results through these tools (a smattering of their top organic and paid search keywords, some traffic estimations through Alexa), ONE of these competitors lists "No results" across all categories and all tools: http://www.bgstar.ca Despite this, we know that they invest heavily in search -- and my SEM Rush toolbar indicates that they have a Google PR of 5 (though I recognize that that should be taken with a grain of salt). So I'm stumped! Has anyone encountered this before? Is there something structural that they might be doing, that's blocking not only Google-based platforms, but Alexa too? Thanks for your help!
Competitive Research | | MACJ0 -
Excel workbook for SEO?
A while back someone on here posted a really good workbook for analyzing ranking factors for competitors. Unfortunately I lost it, and I am hoping someone might know what i'm talking about and hit me up with a link to it, or perhaps your favourite seo workbook for excel? Thanks!
Competitive Research | | adriandg0 -
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 -
Excel Concatenate Function for Google Places?
I'm trying to expedite my research by using the concatenate function. How should the search URL be modified to trigger a google places search as opposed to a normal search. Thanks!
Competitive Research | | BlueFountainMedia0 -
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