Internet Marketing and Web Development Resources
Home Site Map About Contact

Google WebmasterCentral Downloads - Documentation

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.

Table of Contents


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.


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.