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:
- Create a new Google login credential (note: if you already created a limited reporting credential for GA, then you can use it)
- Grant this credential limited (read only) access to one or more WMT sites. See article "share access".
- 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:
- Login to Google using your regular WMT account (Note: sharing as dicussed above down't span OAuth grants).
- On the "Manage Datasources" page, under "OAuth Datasources", click "Google Webmaster Tools".
- 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
©2021 ShufflePoint, Inc.