Upcoming LunaMetrics Seminars
Los Angeles - Anaheim, Sep 8-12 Washington DC, Sep 22-26 Boston, Oct 6-10 Chicago, Oct 20-24

GWT to tackle (not provided) Bookmarklet – Top Page Export

Note: This article provides a bookmarklet of an updated script from a previous article. For a fuller description of the applications and intended analysis for this bookmarklet, see the original article, Using ALL of Google Webmaster Tools data to tackle (not provided)

GWT mechanic -Mabda Technologies

A few months ago I wrote a post with a JavaScript method for exporting the Top Page report from Google Webmaster Tools. I have converted this JavaScript into a bookmarklet:

GWT Pages Export 1.0

And below is an updated Bookmarklet with a progress count:

GWT Pages Export 1.1

In order to save this Bookmarklet, drag and drop this link onto your Bookmarks Toolbar. Alternatively, right-click it and copy its link address. Then, create a new bookmark and paste your copied address as the Bookmark address.

GWT TSV Top Pages Search Queries

Now you can click this Bookmarklet when you are on the Google Webmaster Tools Top Pages Report (remember to first expand the table to the maximum number of rows by appending the GWT Top Pages URL with &grid.s=100000), and the table will be downloaded as a TSV file. The code can take a while to run,  so be patient. It can take up to 5 minutes for 1000 pages. The reason that the code is slow to run is that the table is not loaded completely upon page load. We have to individually request that each page be expanded to display its search queries.

Although there is already a Download this table option for this report, it only downloads a CSV file of the top search queries (not delimited by page). In my previous post, I outline a method for using this page-delimited search query data for addressing not provided. It seems to be one of the last (albeit slightly cumbersome) methods for regaining our data.

Noah Haibach

About Noah Haibach

Noah Haibach is a data analyst at LunaMetrics. Working with Google Analytics provides Noah with more data than his wildest dreams (or even nightmares sometimes), enabling him to pursue his passion of data mining and predictive analytics. Noah wasn't always working in the tech field. His background includes math and biology research. He also has an affinity for languages, racquet sports, and brewing.

http://www.lunametrics.com/blog/2014/04/30/gwt-top-pages-export-bookmarklet/

6 Responses to “GWT to tackle (not provided) Bookmarklet – Top Page Export”

Sean Henri says:

Awesome hack, but when I try this for a larger site with tens of thousands of pages, the data is capping at around 19,000 rows of page/keyword data which equates to around only 700 or so pages. It’s still a huge chunk of helpful data, but any ideas on why I’m not getting the full batch visible in GWT?

When I try to use the bookmarklet it takes me to a 404 page here on lunametrics.com. I tried editing the bookmark to remove the URL and start with (function)… but Chrome won’t allow me to do that. Am I missing something obvious here?

Thanks!

By the way when I just open up the Developer Tools Javascript console and paste the script in starting with (function…) it works just fine.

Noah Haibach Noah Haibach says:

Hey Everett, it was a WordPress formatting issue. The Bookmarklet has been corrected; try it again.

Sorry about that!

Noah

Dan says:

Never works for me :(

I’ve tried the one on the previous post but it skips so many pages to expand.

Yasir says:

That’s it awesome. It worked perfectly. Thanks for your time !!

Leave a Reply