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
-
Combine poorly ranking pages into a single page?
I'm doing on-page optimizations for an apartment management company, and they have about seven apartments listed on their site. Rather than include everything on the same page - /apartments/apartment-name/ - they have the following setup: /apartments/apartment-name/contact /apartments/apartment-name/features /apartments/apartment-name/availability /apartments/apartment-name/gallery /apartments/apartment-name/neighborhood With very few exceptions, none of these pages appear to rank for anything, and those that do either rank very poorly for seemingly random keywords or for keywords like the apartment complex name (alongside the main landing page for the complex). I'm of the mind to recommend combining the pages into a single one that contains all the info, eliminates the chances for duplicate content (all of the neighborhood pages contain the same content verbatim), and prevents keyword cannibalization. Thoughts? Thanks.
On-Page Optimization | | Alces1 -
Renamed a page and created a 301, page lost its rankings.
We changed a page name to fall under the root of our site from domain.com/page1/page301d/ to domain.com/page301d/ and after 2 weeks it still is not back to its #3 position. Now it is on the bottom of page 3. I cant figure out what im doing wrong here. The original .com/page1/ that this page fell under was removed totally and redirected to antoher page that was more relevant. I went ahead and re-enabled this page and its contnent, because the page was linking out to the page we 301d. This page we re-enabled had about 150 links poitning to it and therefore i was thinking that maybe the link juice from this page (or relevancy) via an internal link was helping it rank. This was updated about 6 days ago and the internal link is back Any other ideas why this might not be working. Ive checked all the 301s, content has not changed on the page. We have updated the strcuture for many pages. Instead of having the pages in question fall under anotehr page, they all fall under the root and its sub content is now only 2 levels deep , instead of being 3. hope that makese sense.
On-Page Optimization | | waqid0 -
Updated page not ranking.
Hi Guys. Bit flummoxed by this. I've recently updated our Mid year diaries page to be this years mid year products. i.e) Diaries that go from 2015-16 not 2014-15. Last year we rank really well for the search term 'mid year diaries 14-15'. All i've done is update the page to be focused on 2015-16 diaries, but when i type in 'mid year diaries 15-16' it's no where to be seen in the SERP. Even our home page is ranking higher! I'm really puzzled about this, nothings changed apart from the year! The only reason I can think of is that Google is reading the file name of the images which are related to lasts years products? For example the file name might say mid year diary 2014-15. Do you think this is what's effecting us? Very puzzling 😕 I've submitted it through Webmaster tool btw 🙂 Isaac.
On-Page Optimization | | isaac6630 -
Does the title tag on the home page affect sub-pages?
Hello. I am thinking of changing our home page title tag to include our two most valuable keywords from two of our sub-pages. Would this help the rankings of those two sub-pages? Thank you!
On-Page Optimization | | nyc-seo0 -
Optimization for pages with lists of data
I am looking for some ideas on what best practices are for pages that contain lists similar to this page: http://www.backcountrysecrets.com/outdoor-sport/15/places-to-swim-and-swimming-holes.aspx Is it better to break up the list into seperate pages of 25 listings or keep everything on the same page?
On-Page Optimization | | kadesmith0 -
Too many on-page links
Hi, My website - www.thepartyhouse.com.au is showing as having too many on-page links for over 4,000 pages. Take for example the homepage which is showing as 188 links, but I don't understand this because I've used SEO tools to display the links and I am showing around 90 links on this page. How can I see what all the links are? Thanks
On-Page Optimization | | Spyre0 -
Landing page too long
In my first seomoz test I have many tilte pages for products that are over 70 charachers long. The part #'s are long like 10-782-10-10-10-PPxxxx etc. All these part #'s are not my key products and I could delete or truncate. My question is if the part numbers are not that important, is it OK to leave them as is or is ranking being damaged because they exist?
On-Page Optimization | | Wales0 -
One domain with keyword optimized pages or multiple domains
Hi There. I have a client in the real estate law services business. Which is better for long term search traffic? 1. A single domain ie. smith and smith law.com with pages focussing on each neighbourhood they operate in ie. .com/real estate law manhattan.php, .com/real estate law brooklyn.php etc or 2. multiple domains each focusing on one neighbourhood the business operates in ie: real estate law manhattan.com, real estate law brooklyn.com etc Thanks for the help, Josh
On-Page Optimization | | dreadmichael0