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
-
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 -
Page grader says we are keyword stuffing but we arn't. Page source shows different story.
Hi community! We have just run a page grader for the keyword 'LED Bulbs' on whichledlight.com and it comes up that we are keyword stuffing! However, a brief look at the source for the homepage and there's only 6 times that LED Bulbs pops up. We do have the non plural version of the word 'LED Bulb' on the page 27 times.. do we think that would contribute to the keyword stuffing? Thanks!!
On-Page Optimization | | TrueluxGroup0 -
SEO Optimization for Sales Page
Hi, I am new to eCommerce. Traditionally I have run a couple of semi-successful websites relying largely on Adsense revenue and affiliate income. So I have a bit of experience with on page and off page SEO. This time around I am creating a membership site and also sell eBooks as bundles that non members can buy. My question is, should I SEO optimize the sales page for my eBook or use another content page that links to the sales page. For example, if I am selling an ebook on Dog Training and targeting the main KW "Dog Training Tips", should my sales page be optimized for "Dog Training Tips"? The reason I ask is because typically Sales pages do not provide a lot of useful information but are more geared around selling the product. The other option would be to create a helpful information page targeted for "Dog Training Tips" and lead users to my sales page through contextual links, banners, popups (I hate popups), etc. This would be the approach for the other LSI keywords anyways. Any thought would be appreciated.
On-Page Optimization | | dwautism0 -
Duplicate Page content | What to do?
Hello Guys, I have some duplicate pages detected by MOZ. Most of the URL´s are from a registracion process for users, so the URL´s are all like this: www.exemple.com/user/login?destination=node/125%23comment-form What should I do? Add this to robot txt? If so how? Whats the command to add in Google Webmaster? Thanks in advance! Pedro Pereira
On-Page Optimization | | Kalitenko20140 -
On Brand Queries Google does not shows my home page first instead of it shows internal pages.
Also on my brand query it doesn't shows sitelinks. What may be the reason?
On-Page Optimization | | vivekrathore0 -
Pages exclusion
Hi there! I don't want to "make relevan"t 3 of the pages my website has. Should I give them a title and a description even if I dont't want them to be shown in the SERPs? Is there any penalty from google if I don't do so? I guess no but just to confirm. Thanks!
On-Page Optimization | | juanmiguelcr0 -
Meta Data definition for multiple pages. Potential duplicate content risk?
Hi all, One of our clients needs to redefine their meta title and description tags. They publish very similar information almost every day, so the structure they propose is the following: Structure 1: Type of Analysis + periodicity + data + brand name Examples 1: Monthly Market Analysis, 1/5/2012 - Brand Name Weekly Technical Analysis, 7/5/2012 - Brand Name Structure 2: Company Name + investment recommendation + periodicity Example 2: Iberdrola + investment recommendation (this text doesn't vary) + 2T12 (wich means 2012, 2nd trimestrer) Regarding meta description they want to follow a similar approach, replicating every time the same info with a slight variation for each publication. I'm afraid this may cause a duplicate content problem because of the resemblance of every "Market Analysis" done or every "Investment recommendation" done in the future. My initial suggestion for them is to define specific and unique meta data for each page, but this is not possible for them given the time it takes to do it for every page. Finally, I ask them to specify the data in each meta title of content published, in order to add something different each time and avoid duplicate content penalty. Will this be enough to avoid duplicate content issues? Thanks in advance for your help folks! Alex
On-Page Optimization | | elisainteractive0 -
Old pages
I have a site where I have 5,000 new products each year, I never waned to deleted the old pages due to links pointing to them and keywords. But I now have 20,000 plus pages, does having that many pages spread out my link juice or does it effect me in any other ways over having a site with 5,000 pages or should I keep not deleting old pages so I dont loose any links? Along with that I currently do not link to my old pages from my site so Im guessing google does not get to them very often if at all, if you agree to still keep them should I link to them somewhere? Because the products are not that simiiar and they do bring added value I dont think canonical would work here
On-Page Optimization | | Dirty0