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
-
For an e-commerce product category page that has several funnels to specific products, for SEO purposes does it matter whether the category page's overview content is above or below those funnels?
We manage an e-commerce site. On a category page, there are several funnels to specific products. We moved the category overview content below those funnels to make it easier for users to quickly get to products. Seems more user friendly to me, but could that move of the main content to the lower part of the page be a negative ranking factor?
On-Page Optimization | | PKI_Niles0 -
Best way to move traffic/juice from one page to another?
I’ve got some pages that provide information on some companies in my website topic space, and also corresponding pages that allow users to rate and review those companies. So, for example: Company A information Company A reviews Company B information Company B reviews Google searches for “Company A” or “Company B” generally result in my information page ranking #2 behind the actual company’s website, and the reviews page ranking #3. (Probably not good to have two pages ranking for the same keyword in positions 2 and 3). The information pages do very well in Adsense while the review pages do not. The review pages have always had comments open for reviews, and I’ve just recently opened the information pages to comments. This has resulted in less of a need for the reviews pages as the comments on the Information pages are now serving the same purpose. I can even add a star rating to the information pages if I want so the review pages are completely unnecessary. So, I’d rather strengthen my information pages 1) to more solidify their rankings, and 2) get more visitors there than the review pages as they convert way better in Adsense. Question is, what is the best way to proceed? Option 1: remove internal linking to the review pages (I have sidebar links too), so less link juice just naturally goes to the review pages. On the review pages, direct people to click the link to the information page to go there instead. Eventually, the review pages will fall off the front page of the SERPs and people will just go to my #2 ranked company information page instead (and maybe #1 if I’m lucky, but doubt I’ll get ahead of the brand). Option 2: 301 Redirect the review pages to the information pages. Functionally, this would work well for me, but I fear that Google may not like it for some reason. My information pages are ranked so well that I do not want to risk them dropping. Are these fears unfounded? Is either of these two options better than the other, or does anyone have a better idea? Whatever I do, I don’t want those company information pages dropping from their #2 positions.
On-Page Optimization | | bizzer0 -
Page 2 is ranking
Hey All, I'm working on a wordpress site project and in analytics the sites ranking url is page 2. is this a problem?
On-Page Optimization | | CobraJones950 -
Redirecting https pages
If I add 301 redirects from the https versions of the root domain to the http:www.website.com (canonical version), will this prevent users from being able to access the https version? I believe the https version is only accessed once users log into the site. Thank you!
On-Page Optimization | | HiddenPeak0 -
On page report card instances of key terms in the body - I can't find them all
Hi guys, I'm using the on-page report card for a particular page which is returning 22 instances of my term, however when I check the source of the page, I can only find 6 instances across the whole page, let alone the body. The site is www.sportsbet.com.au, and the term "horse racing". I'm sure I'm missing something, would appreciate any explanation for this apparent discrepancy. Cheers, Jez
On-Page Optimization | | jez0000 -
Is there a SEO penalty for multi links on same page going to same destination page?
Hi, Just a quick note. I hope you are able to assist. To cut a long story short, on the page below http://www.bookbluemountains.com.au/ -> Features Specials & Packages (middle column) we have 3 links per special going to the same page.
On-Page Optimization | | daveupton
1. Header is linked
2. Click on image link - currently with a no follow
3. 'More info' under the description paragraph is linked too - currently with a no follow Two arguments are as follows:
1. The reason we do not follow all 3 links is to reduce too many links which may appear spammy to Google. 2. Counter argument:
The point above has some validity, However, using no follow is basically telling the search engines that the webmaster “does not trust or doesn’t take responsibility” for what is behind the link, something you don’t want to do within your own website. There is no penalty as such for having too many links, the search engines will generally not worry after a certain number.. nothing that would concern this business though. I would suggest changing the no follow links a.s.a.p. Could you please advise thoughts. Many thanks Dave Upton [long signature removed by staff]0 -
Should I convert PDFs to pages?
I have a client that has a lot of content in pdf files that are linked to from their website. The content on the site itself is quite thin. Should I recommend to them that they convert at least some of pdf files to actual pages on their website? That way there could be a title tag, meta-description, header tags, etc associated with the content. What role do pdf files play in SEO? Thanks!
On-Page Optimization | | bvalentine0 -
Is it necessary to optimize every page of a site
I recently took over the SEO work for a website that has a limited budget. I'd like to use the resources to get as much as I can for a few pages on the site (keyword research, on-page optimization). Are there pitfalls to not optimizing every page on a site? If so, what are they?
On-Page Optimization | | EricVallee340