Is there a way to export the On-page Optimization report data to Excel?
-
I am preparing recommendations for my client's Webmaster from the On-page Report Card. I am integrating them into a larger Excel spreadsheet with other recommended changes.
So many SEO Moz reports can be exported to Excel. Is this an exception, or am I missing something? It would really save me a lot of time and effort.
-
Bryan, thank you very much for your answer. I see the report you are referring to, but (unless I am missing something) it is not the report I had in mind.
The one you are referring to is a summary report that shows the grade of each Keyword-URL pairing, and how it has changed from the previous week.
What I am looking for is an Excel version of the detailed report for a given keyword/URL pairing - the one that shows all of the critical, high, moderate, low and optional elements with a check mark.
My absolute dream would be to have some sort of data dump with all the pages and all their individual elements, but I would be thrilled just to be able to export one page at a time. Any ideas?
-
Yes theres a tab that is by default set to .pdf however if you click it you can change the setting to .cvs (excel format).. You will need to add the site and keywords to a campaign n SEOmoz and then go to the on-site tab within the campaign.
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
-
Changing the url of a page
Hello. I would like to change the url of a page. It currently has very few inbound links. I would set up a 301 redirect to the new url. Is there anything else I should take into account before changing the url? Is there a downside to changing a url? Do inbound links carry the same value when a 301 redirect is involved? Thank you!
On-Page Optimization | | nyc-seo0 -
Locating Duplicate Pages
Hi, Our website consists of approximately 15,000 pages however according to our Google Webmaster Tools account Google has around 26,000 pages for us in their index. I have run through half a dozen sitemap generators and they all only discover the 15,000 pages that we know about. I have also thoroughly gone through the site to attempt to find any sections where we might be inadvertently generating duplicate pages without success. It has been over six months since we did any structural changes (at which point we did 301's to the new locations) and so I'd like to think that the majority of these old pages have been removed from the Google Index. Additionally, the number of pages in the index doesn't appear to be going down by any discernable factor week on week. I'm certain it's nothing to worry about however for my own peace of mind I'd like to just confirm that the additional 11,000 pages are just old results that will eventually disappear from the index and that we're not generating any duplicate content. Unfortunately there doesn't appear to be a way to download a list of the 26,000 pages that Google has indexed so that I can compare it against our sitemap. Obviously I know about site:domain.com however this only returned the first 1,000 results which all checkout fine. I was wondering if anybody knew of any methods or tools that we could use to attempt to identify these 11,000 extra pages in the Google index so we can confirm that they're just old pages which haven’t fallen out of the index yet and that they’re not going to be causing us a problem? Thanks guys!
On-Page Optimization | | ChrisHolgate0 -
Would I be safe canonicalizing comments pages on the first page?
We are building comment pages for an article site that live on a separate URL from the article (I know this is not ideal, but it is necessary). Each comments page will have a summary of the article at the top. Would I be safe using the first page of comments as the canonical URL for all subsequent comment pages? Or could I get away with using the actual article page as the canonical URL for all comment pages?
On-Page Optimization | | BostonWright0 -
On-page: Over optimized images?
Hello guys. I have a small question about an on-page optimization for images. What I have: good title tag / good url structure good content (NOT keyword shuffled, its real content, for real people) images / gallery uploaded to folder named same as article name. For example: Great tips for bloggers [article name], great-tips-for-bloggers [folder name]. So my question is: Will Google harm me for this "too good" paths to images, article related image filenames, with mask like [gtips-img01], and if all images have titles / alt tags? Thank you guys.
On-Page Optimization | | infoo130 -
Best way to optimize site for Google Maps?
I am working with a site right now and they are ranked #1
On-Page Optimization | | WhiteHat12
for many keyword phrases based on their location and service. Their service is an
Insurance agency, so they rank #1 for many keywords like “Miami Insurance” or “South
Florida Insurance Agency” (their not actually ranked for Miami
just giving an example). I also include their address on every page of the site
(maybe that better helps Google maps?). Problem I am having is when searched
just the keyword phrase they rank number 1 but when searching say “insurance”
while being logged in to the area they rank for they do not come up. I hear that
there might be specific ways to optimize for this. What I would like to know is
what would I have to do to optimize for Google maps and what’s everything I possibly
can do. I am good with search engine optimization but have never really dabbled
much with Google Maps, I always thought they just ranked you based on your
address.0 -
SEO Value of Within-Page Links vs. Separate Pages
Title says it all. Assuming that you're talking about similar content (let's say, widgets), which is better: using within-page links for variations or using separate pages? I.e., do we have a widget page and then do in-page links to describe green, blue, and red widgets, or separate pages for each type of widget? In-page pro: more content on a single page, thus more keywords, key phrases, and general appearance of real content. In-page con: Jakob Neilsen says they're confusing. Also, for SEO, you only get one page title, rather than a separate page title for each. My personal bias is for in-page, since I hate creating dozens of short pages for what could be on one page, but my suspicion is that separate pages are better for SEO.
On-Page Optimization | | maxkennerly0 -
Best Way To Host Images For Image Optimization
I need an image optimization expert to tell me whether or not we are hosting images properly for SEO. Currently, we upload all images to Picasa and then call them out with a webpart in our content management system. See example here - http://www.tennisnow.com/Photos/2011-BNP-Paribas-Open-Day-5.aspx Here's an example of the url that is attached to each image - http://lh5.ggpht.com/_1Oyc-Zgkrpk/TX5H-Pfyd7I/AAAAAAAARbc/nG3Cw-G5tsY/s400/1215548409_FU9xA-L.jpg We have a lot of images, and we've hosted them on Picasa for speed purposes based on a recommendation from our developer (makes the pages load faster). I've read that Google can now factor page load time into its ranking parameters. We are not seeing the images from each photo gallery being indexed on images.google.com. We are torn. What should we do to rank for these images?
On-Page Optimization | | tennisexpress0 -
Results in the On-Page
I put one site (www.fmredesdeprotecao.com.br) and register some keywords, but the keywords don't appear in the results On-Page like the other campaigns. How can I solve that?
On-Page Optimization | | Ex20