Google Webmaster Tool - Extracting to Excel

by GGpaul
13 replies
  • SEO
  • |
Hey, so....

I'm having a little dilemma. I really like the fact that I can extract all the crawl errors to Excel. I'm more efficient, and I can go through the links MUCH faster than using Webmaster tool..


Here's the problem.

I can only download the TOP 1,000 pages with errors. So if you see that tab that says "NOT FOUND" 5,851 errors? I can only get 1,000. Does that mean the rest of the 4,851, I need to go through manually?

Is there a way to download ALL of it? I really don't want to use the fetch tool cause 1) it takes too long 2) you're only allowed 500 fetches a week. 3) I rather use excel and go through each manually and mark it as fixed on my own.

Or some kind of trick? Thanks.
#excel #extracting #google #tool #webmaster
  • Profile picture of the author yukon
    Banned
    My question is, why do you have 5,851 errors on a single domain, are those 404s?

    If those are all 404s you need better management of the site, redirects from dead pages/URLs to live pages/URLs, etc...
    {{ DiscussionBoard.errors[8527041].message }}
    • Profile picture of the author GGpaul
      Originally Posted by yukon View Post

      My question is, why do you have 5,851 errors on a single domain, are those 404s?

      If those are all 404s you need better management of the site, redirects from dead pages/URLs to live pages/URLs, etc...
      This is the company I work for. A lot of problems. There's 300 employees, so I have to work with the IT. And they're the worst.

      But anyways, back to my question. How do we go about with that?
      Signature

      RIP Dad Oct 14 1954 - Mar 14 2015.

      {{ DiscussionBoard.errors[8527131].message }}
  • Profile picture of the author bhartzer
    Is there a way to download ALL of it?
    Yes, there is, actually. Fix the errors first (or mark 1000 of them) and another 1000 will pop up. Most likely one "fix" on your site will fix a lot of errors that you can mark as fixed.
    Signature

    Buy or Sell Links Based on Authorship Status at AuthorLinks.net

    {{ DiscussionBoard.errors[8527138].message }}
    • Profile picture of the author GGpaul
      Originally Posted by bhartzer View Post

      Yes, there is, actually. Fix the errors first (or mark 1000 of them) and another 1000 will pop up. Most likely one "fix" on your site will fix a lot of errors that you can mark as fixed.
      That's not going to work. I have to manually go through each link. Not going to mark them without going through each one.
      Signature

      RIP Dad Oct 14 1954 - Mar 14 2015.

      {{ DiscussionBoard.errors[8527209].message }}
  • Profile picture of the author yukon
    Banned
    I don't have thousands of errors so I have no way to test GWT export.

    I searched on Google & found this tutorial for exporting errors. Not sure If that helps? Might want to read the entire page including any problems in the comments below the tutorial.

    hxxp://luckyboost.com/exporting-data-from-google-webmaster-tools/

    The tutorial is dated April 2, 2013, so it should be up to date.
    {{ DiscussionBoard.errors[8527227].message }}
  • Profile picture of the author bhartzer
    Not going to mark them without going through each one.
    So how are you going to fix them anyway?

    When I've seen sites that have lots of errors like this, it's typically been an issue that can be an easy fix that affected tons of internal links to bad pages.

    Google gives us the top 1000. Yeah, there are 5000+ errors, but you just aren't going to get it all. Just like Google gives us the links to our site--but they only give us 100,000 links. If you have over a million links, you'll only get 10 percent. Google says "tough luck", pretty much, that's what they give us.
    Signature

    Buy or Sell Links Based on Authorship Status at AuthorLinks.net

    {{ DiscussionBoard.errors[8527241].message }}
    • Profile picture of the author GGpaul
      Originally Posted by bhartzer View Post

      So how are you going to fix them anyway?

      When I've seen sites that have lots of errors like this, it's typically been an issue that can be an easy fix that affected tons of internal links to bad pages.

      Google gives us the top 1000. Yeah, there are 5000+ errors, but you just aren't going to get it all. Just like Google gives us the links to our site--but they only give us 100,000 links. If you have over a million links, you'll only get 10 percent. Google says "tough luck", pretty much, that's what they give us.
      I'm manually going through each link through Excel. I mark down red if it isn't fixed. The fetch tool like I said only gives us 500 once a week. If the page is working and there is no 404 I then mark it as fixed.

      The ones that are NOT fixed, I send it over to IT and have them work on it.


      Edit: I have gone through 20,000 links already within the past month(s). So this isn't even a big # for me.
      Signature

      RIP Dad Oct 14 1954 - Mar 14 2015.

      {{ DiscussionBoard.errors[8527247].message }}
      • Profile picture of the author yukon
        Banned
        Originally Posted by GGpaul View Post

        Edit: I have gone through 20,000 links already within the past month(s). So this isn't even a big # for me.
        I would be talking to someone at work with enough authority to make that stop ASAP.

        There's no reason to have that many errors on a site.

        What are they doing, deleting old sales pages? What's an example URL look like that's getting all these errors?
        {{ DiscussionBoard.errors[8527274].message }}
        • Profile picture of the author GGpaul
          Originally Posted by yukon View Post

          I would be talking to someone at work with enough authority to make that stop ASAP.

          There's no reason to have that many errors on a site.

          What are they doing, deleting old sales pages? What's an example URL look like that's getting all these errors?
          I'll PM you.
          Signature

          RIP Dad Oct 14 1954 - Mar 14 2015.

          {{ DiscussionBoard.errors[8527279].message }}
          • Profile picture of the author Mike Anthony
            Not sure I am understanding.....Why do you have to use WMT? There are a number of crawl error tools that will export to csv and they have no limitations
            Signature

            {{ DiscussionBoard.errors[8527336].message }}
            • Profile picture of the author aygabtu
              Where is Google getting links to bad addresses and why rely on Google to tell you what's broken? Don't you have a sitemap, or can't you generate one that you can then use PHP or Perl to validate that the pages exist? If there are links from other sites to yours that are bad, you don't need to worry about those unless they are supposed to exist.

              Crazy task.
              Signature

              Check top 300 Google SERP results free. WhatsMySERP.com tracks and graphs changes for multiple domains/keywords/regions. Also includes advanced keyword density tool.

              {{ DiscussionBoard.errors[8527347].message }}
              • Profile picture of the author yukon
                Banned
                Originally Posted by aygabtu View Post

                If there are links from other sites to yours that are bad, you don't need to worry about those unless they are supposed to exist.
                Any links on other domains pointing to a dead page/URL on OPs site should be redirected to a live web page on OPs site, otherwise it's a wasted backlink.

                Personally I keep it simple, I don't use a 404 page, I redirect my 404s to my index page. IMO a 404 is a trash can & a bad user experience for traffic. Nobody wants to look at a 404 page.
                {{ DiscussionBoard.errors[8527498].message }}
  • Profile picture of the author GGpaul
    I don't know, I just do what they tell me to do and that's that.
    Signature

    RIP Dad Oct 14 1954 - Mar 14 2015.

    {{ DiscussionBoard.errors[8527458].message }}

Trending Topics