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
-
Page Title Length
Hi Gurus, I understand that it is a good practice is to use 50-60 characters for the a page title length. Google appends my brand name to the end of each title (15 characters including spaces) it index. Do I need to count what google adds as part of the maximum recommended length? i.e.
On-Page Optimization | | SunnyMay
is the maximum 50-60 characters + the 15 characters brand name Google adds to the end of the title or 50-60 including the addition? Many thanks!
Lev0 -
Which is better? One dynamically optimised page, or lots of optimised pages?
For the purpose of simplicity, we have 5 main categories in the site - let's call them A, B, C, D, E. Each of these categories have sub-category pages e.g. A1, A2, A3. The main area of the site consists of these category and sub-category pages. But as each product comes in different woods, it's useful for customers to see all the product that come in a particular wood, e.g. walnut. So many years ago we created 'woods' pages. These pages replicate the categories & sub-categories but only show what is available in that particular wood. And of course - they're optimised much better for that wood. All well and good, until recently, these specialist page seem to have dropped through the floor in Google. Could be temporary, I don't know, and it's only a fortnight - but I'm worried. Now, because the site is dynamic, we could do things differently. We could still have landing pages for each wood, but of spinning off to their own optimised specific wood sub-category page, they could instead link to the primary sub-category page with a ?search filter in the URL. This way, the customer is still getting to see what they want. Which is better? One page per sub-category? Dynamically filtered by search. Or lots of specific sub-category pages? I guess at the heart of this question is? Does having lots of specific sub-category pages lead to a large overlap of duplicate content, and is it better keeping that authority juice on a single page? Even if the URL changes (with a query in the URL) to enable whatever filtering we need to do.
On-Page Optimization | | pulcinella2uk0 -
How to schedule the on page reports myself
The on page reports are scheduled on mondays, but is there a way to schedule it my self.
On-Page Optimization | | JoostBruining0 -
On Page Reports - Multiple URLs Appearing for a Keyword
Hello, I have a question regarding the on page reports automatically generated by seomoz When I look at my on page reports I notice that each keyword appears a number of times, each with a different url and then a grade for the on page report and sometimes a rank. I'm not sure I understand this, firstly I thought the on page reports were only generated for keywords in the top 50, does that mean the global top 50, or my top 50? Also why are they appearing for so many urls, I find this confusing and am not sure which pages to focus on improving, it's not always my intended pages that are ranking the best. I believe that I read somewhere that I can choose which pages to have the on page reports rank for, perhaps this is the solution? Any thoughts would be appreciated. Thanks, Iain
On-Page Optimization | | jannkuzel0 -
View all Page for Product Overview Pages
Hi everybody! We have an ecommerce site with product overview pages, where sometimes there are hundreds of products listed. Usually, we just display 30 and have a button where users can click to see 30 more - or all products listed at once. This is the overview page (as indexed in google): http://www.geschenkidee.ch/aussergewoehnliches.html
On-Page Optimization | | zeepartner
And this is the view-all page: http://www.geschenkidee.ch/aussergewoehnliches.html#all What should I do here? The product overview page will hardly generate more traffic by listing all products (because the overview page will rank for generic keywords, while the product keyword searches will be referred to the specific product pages themselves). I was originally thinking of using rel=canonical pointing to the view-all page. But this would just lead to longer load time. Should we just leave those overview pages or is there a best practice for how to deal with such pages? Thanks for your thoughts on this!0 -
Ranking for specific pages
HI, Lets say my website is abc.com and my targeted keyword is abc for index page. Internal pages, like abc.com/apple.htm, abc.com/banana.htm. The targeted keyword for apple.htm is fresh apples, buy apples, and for banana.htm, fresh banana, buy banana. How to define these keywords in the campaign. Please suggest. Thanks.
On-Page Optimization | | younus0 -
Duplicate Page Titles?
I'm running a campaign report within SEOmoz & am getting 9 pages that appear on this report. They all happen to be our author pages www.example.com//author/admin We have multiple authors. Is there a proper way that I should take care of this? Also as a side note, I'm using Yoast Wordpress SEO plugin, is there a setting on their I should change that will fix this issue? Or is it an issue at all? Thanks, BJ
On-Page Optimization | | seointern0 -
Why home page ranks higher than keyword-optimized page
We have a page that is optimized for the keyword "job scheduling". A search on the keyword "job scheduling" results in this page not ranking at all, while our home page (uc4.com) ranks third. Could you provide some ideas/suggestions as to why this would be the case and how to make our job scheduling page rank higher? Thanks, claudia
On-Page Optimization | | claudmar0