Querying Webmaster Tools using ShufflePoint

Summary

The ShufflePoint Webmaster Tools (WMT) integration is really two integrations. This was necessary because Google left out of the WMT API some of the good stuff - namely getting query and page KPIs. Therefore for Sites, Content Keywords, and Crawl Issues, we use the WMT API via OAuth2. But for Query and Page feeds, we use the Google Data API which requires a credential instead of a grant.

Setup

Login to ShufflePoint, and click "Manage Datasources".

In order to write queries to get WMT query and page KPIs, do the following:

1. Create a new Google login credential (note: if you already created a limited reporting credential for GA, then you can use it)
2. Grant this credential limited (read only) access to one or more WMT sites. See article "share access".
3. Enter that credential into the "Webmaster Tools" username and password fields under "Credential or Key Based Datasources"

In order to write queries to get WMT Content Keywords and Crawl Issues, do the following:

1. Login to Google using your regular WMT account (Note: sharing as dicussed above down't span OAuth grants).
2. On the "Manage Datasources" page, under "OAuth Datasources", click "Google Webmaster Tools".
3. Allow the grant.

Running Queries

Content Keywords

SELECT
   METRICS xx:identity ON COLUMNS
   DIMENSIONS wt:keyword,wt:source ON ROWS
FROM [http://www.yoursite.com/]
WHERE TIMEFRAME lastMonth

Crawl Issues

SELECT
   METRICS xx:identity ON COLUMNS
   DIMENSIONS wt:crawlType,wt:url,wt:issueType,wt:issueDetail,wt:linkedFrom,wt:dateDetected ON ROWS
FROM [http://www.yoursite.com/]
WHERE TIMEFRAME lastMonth

Pages

SELECT
   METRICS wt:ctr,wt:avgposition,wt:clicks,wt:impressions ON COLUMNS
   DIMENSIONS wt:page ON ROWS BY wt:ctr
FROM [http://www.yoursite.com/]
WHERE TIMEFRAME lastMonth

Queries

SELECT
   METRICS wt:ctr,wt:avgposition,wt:clicks,wt:impressions ON COLUMNS
   DIMENSIONS wt:query ON ROWS BY wt:ctr
FROM [http://www.yoursite.com/]
WHERE TIMEFRAME lastMonth