Google WebmasterCentral Downloads

Introduction

This documentation is part of the Google Query and Link Stats File Conversion Tool to convert files that were downloaded from Google's WebmasterCentral console. Google did a number of additions and changes to the downloads available and the conversion tool does not incorporate all those changes yet. The documentation below reflects the available downloads as of December 2007, while the conversion tool is based on the downloads as of Spring 2007. Even though some of the new stuff is not supported yet, are the most relevant features still working with the new downloads.

Google plans additional changes to the downloads in the coming months and also an API for full automated access to the data was announced and is expected to become available at the end of the first quarter of 2008 or early second quarter 2008.

Also see my Guide to Google Webmaster Central Tools and Downloads.

Links \ Pages with internal links
Links \ Pages with external links
Statistics \ Top search queries
Statistics \ What Googlebot sees \ In external links to your site (Phrases)
Statistics \ What Googlebot sees \ In external links to your site (Keywords)
Statistics \ What Googlebot sees \ In your site's content (Keywords)
Diagnostics \ Web crawl \ Errors
Site Overview
Sitemaps (Single Site or All Sites)
Old versus New Downloads (Spring 2007/December 2007)

Links \ Pages with internal links

Format: comma delimited, double quotes are only used for values that contain a comma in the content itself
File name: Links_internal_www.site.com__yyyymmddThhmmssZ.csv

Column	Format	Sample Value
Page	string	http://www.site.com/pagelinkedto.html
Link	string	http://www.site.com/pagelinkedfrom.html
Last found	MMM DD, YYYY	"Nov 18, 2007"

.oOo. top .oOo.

Links \ Pages with external links (3)

Format: comma delimited, double quotes are only used for values that contain a comma in the content itself
File name: Links_external_www.domain.com__yyyymmddThhmmssZ.csv

Column	Format	Sample Value
Page	string	http://www.site.com/pagelinkedto.html
Link	string	http://www.othersite.com/pagelinkedfrom.html
Last found	MMM DD, YYYY	"Nov 18, 2007"

.oOo. top .oOo.

Statistics \ Top search queries

Search and Click Data, Images, Web , Mobile Images, Mobile Content per Location; Selections: 1 week ago and monthly data since October 2007

All \ Including Subfolders (5)

File name: QueryStatsSiteGlobal_yyyymmddThhmmssZ.csv

Column	Format	Sample Value
Site Information	string	http://www.site.com/folder/
Location	string	(United States) google.com
Search Type	string	Web Search, All searches, Images, Mobile Images, Mobile Devices
Top search queries	delimited string A*	[keyword phrase 1: 125]
Top search query clicks	delimited string A*	[keyword phrase 2: 2]

.oOo. top .oOo.

*delimited string A

Format: records enclosed in "[" and "]", delimited is space; values within record are separated by colon (:), values are not enclosed in double quotes, although double quotes can be part of the query term itself; columns: phrase, position in the SERPs

Column	Format	Sample Value
	string	keyword phrase
	string	1

.oOo. top .oOo.

Summarized (5)

File name: QueryStatsSiteGlobal_yyyymmddThhmmssZ.csv

Column	Format	Sample Value
	string	"1 week ago" or month name e.g. "November"
Location	string	(United States) google.com
Search Type	string	Web Search, All searches, Images, Mobile Images, Mobile Devices
Top search queries	delimited string B*	[keyword phrase 1, 2%, 125]
Top search query clicks	delimited string B*	[keyword phrase 2, 12%, 2]

.oOo. top .oOo.

*delimited string B (3)

Format: records enclosed in "[" and "]", delimited is space; values within record are separated by comma, values are not enclosed in double quotes, although double quotes can be part of the query term itself; columns: phrase, percentage searched/clicked (in relation to other phrases for the same website), position in the SERPs

Column	Format	Sample Value
	string	keyword phrase
	string	10%
	string	1

.oOo. top .oOo.

Statistics \ What Googlebot sees \ In external links to your site (Phrases) (2)

Format: the phrase itself is not enclosed in double quotes, but the example might be, if the example itself contains one or more commas, for example: "[word1, word2:phrase2]"
File name: AnchorPhrases_www_site_com_.csv

Column	Format	Sample Value
In external links to your site	string	keyword phrase
Example:	delimited string C*	[phrase 1:phrase 2:phrase 3]

.oOo. top .oOo.

*delimited string C (1)

Format: records enclosed in "[" and "]"; values within record are separated by colon (:), values are not enclosed in double quotes, although double quotes can be part of the query term itself; column(s): phrase

Column	Format		Sample Value
	string		keyword phrase

.oOo. top .oOo.

Statistics \ What Googlebot sees \ In external links to your site (Keywords) (1)

Format: single words only, not enclosed in double quotes
File name: AnchorWords_www_site_com_.csv

Column	Format		Sample Value
In external links to your site	string		keyword

.oOo. top .oOo.

Statistics \ What Googlebot sees \ In your site's content (Keywords) (1)

Format: single words only, top 200 , not enclosed in double quotes
File name: ContentWords_www_site_com_.csv

Column	Format		Sample Value
In your site's content	string		keyword

.oOo. top .oOo.

Diagnostics \ Web crawl \ Errors (3)

Format: The URL and detail are not enclosed in double quotes, but the "last calculated" date value is

Per Error Type (5 different):
File name: WebCrawlErrors_HTTP_errors_Earliest_available_Latest_available_www_site_com_.csv

All Errors for a Site:
File name: Errors_www_site_com__yyyymmddThhmmssZ.csv

Column	Format	Sample Value
URL	string	http://www.site.com/page.html
Detail	string	various*
Last Calculated	MMM DD, YYYY	"Nov 18, 2007"

.oOo. top .oOo.

*Errors

See Google Help for more details

Type		Details
Not Found		404 not found
HTTP Errors		401/407 authentication error
		4xx error
		Domain name not found
		Couldn't parse HTTP response
		IP in excluded range
		General HTTP error
URLs Times Out		DNS lookup timeout
		URL timeout
		robots.txt timeout
Unreachable URLs		5xx error
		DNS issue
		robots.txt file unreachable
		Network unreachable
URLs not followed		Redirect error
		Redirect loop error
		Redirect URL too long
		Invalid redirect
		Empty redirect
		Cookie error

.oOo. top .oOo.

Site Overview (5)

Format: comma delimited, values not enclosed in double quotes
File name: SiteOverview.csv

Column	Format	Sample Value
Site Information	string	http://www.site.com/
Sitemaps	numeric	0
Errors	numeric	0
Warnings	numeric	0
Verified?	string	Verified or Unverified

.oOo. top .oOo.

Sitemaps (Single Site or All Sites) (8)

Format: comma delimited, double quotes are only used for values that contain a comma in the content itself

Single Site:
File name: Sitemaps_www_cumbrowski_com_.csv

All Sitemaps:
File name: Sites_yyyymmddThhmmssZ.csv

Column	Format	Sample Value
Site Information	string	http://www.site.com/
Filename	string	http://www.site.com/sitemap.xml
Format	string	Sitemap, Atom Feed, RSS Feed*
Type	string	Web
Submitted	MMM DD, YYYY	"Jan 1, 2007"
Last Downloaded	MMM DD, YYYY	"Nov 14, 2007"
Status	string	ok / error
URLs submitted	numeric	500

.oOo. top .oOo.

Sitemap Types

Type	Format	Details
Web	Sitemap Protocol Syndication Feed Text File	Sitemap XML, RSS 2.0, Atom 0.3, UTF-8 encoded text (URLs only)
Mobile	XHTML Mobile Profile (WAP 2.0) WML (WAP 1.2) cHTML (iMode)	see Web sitemaps
Code Search Sitemap	XML	see sitemap specifications, supported languages, supported licenses language, license, actual file name, url to file (download), package map (for archives, see here)
Video Sitemap	XML	see sitemap specifications Landing Page URL, URL to Video File, URL to Player, URL to Thumbnail Image, Title, Description, Family Friendly (yes/no), duration in seconds (max. 8 hours)

.oOo. top .oOo.

Old versus New Downloads (Spring 2007/December 2007)

Old Downloads (Spring 2007)	Downloads as of 12/2007
1 = Top 20 Search Queries Stats	Errors
2 = Top 20 Search Query Clicks Stats	1	Latest Errors
3 = Site Wide Query Stats (including Sub Folders)	2	All Errors
4 = External Links Stats per Page	Queries
5 = External Links Details	3	Search Query Stats
6 = Internal Links Stats per Page	4	Global Query Stats
7 = Internal Links Details	Anchor Text/Keywords
	5	Phrases In External Links
	6	Keywords in External Links
	7	Keywords in Site Content
	Links
	8	External Links
	9	Internal Links
	Sites/Maps
	10	Site Overview
	11	Sitemaps (Site)
	12	Sitemaps (all)

.oOo. top .oOo.

Google WebmasterCentral Downloads - Documentation

Introduction

Table of Contents

Links \ Pages with internal links

Links \ Pages with external links (3)

Statistics \ Top search queries

All \ Including Subfolders (5)

*delimited string A

Summarized (5)

*delimited string B (3)

Statistics \ What Googlebot sees \ In external links to your site (Phrases) (2)

*delimited string C (1)

Statistics \ What Googlebot sees \ In external links to your site (Keywords) (1)

Statistics \ What Googlebot sees \ In your site's content (Keywords) (1)

Diagnostics \ Web crawl \ Errors (3)

*Errors

Site Overview (5)

Sitemaps (Single Site or All Sites) (8)

Sitemap Types

Old versus New Downloads (Spring 2007/December 2007)