topic Re: Google Webmaster Tools in QlikView

Google Webmaster Tools

Thu, 25 Oct 2012 13:58:39 GMT

Has anyone had any luck with gathering data from webmaster tools and using it in qlikview? I'm looking for the search queries data. I see it in google analytics but it isn't in the api call. I think they are different datasets.

Re: Google Webmaster Tools

chrisbrain — Fri, 26 Oct 2012 13:57:41 GMT

Hi - Could you explain a little what you mean when you say you see it in Google Analytics but it isn't in the api call?

If you are able to get the data using this interface:
http://ga-dev-tools.appspot.com/explorer

You would be able to use QVSource to get the data.

It doesn't look like there is an API for Google Web Master Tools which would return data on search queries.

Re: Google Webmaster Tools

Mon, 29 Oct 2012 16:08:09 GMT

Hey Chris,

Yeh, you can't see the fields in: http://ga-dev-tools.appspot.com/explorer

I was able to get a script with python working on Friday. That script stores the data in a google doc. I think from there I can use qv source. (I haven't tried the google docs > qlikview yet)

Here is all the documentation I read just in case someone else comes across this one. The key is to use python 2.6.6.

API - https://developers.google.com/webmaster-tools/docs/2.0/developers_guide_protocol?hl=ru

Download Python - http://www.python.org/download/releases/2.6.6/

Python Library - https://developers.google.com/gdata/articles/python_client_lib

Search Queries Download Python - http://googlewebmastercentral.blogspot.com/2011/12/download-search-queries-data-using.html

Wiki how to - http://code.google.com/p/webmaster-tools-downloads/wiki/Running

Python how to - http://www.pagetrafficbuzz.com/download-search-queries-data-google-webmaster-tools/13087/

Java how to - http://www.webkruscht.com/2011/java-tool-to-download-search-query-data

PHP how to - http://code.google.com/p/php-webmaster-tools-downloads/