topic Re: Exploiting Google Analytics in SAS: Examples? in SAS Programming

Exploiting Google Analytics in SAS: Examples?

HenriTheuwissen — Mon, 17 Apr 2017 17:54:45 GMT

Hi,

We need to exploit Google Analytics data. We found several documents and blogs, but they're all quite 'old'. The SAS Support team indicated that a lot changed in the meantime and that these articles are outdated. They suggest to work with PYTHON.

Does anybody have some examples of this?

Note: the solution should run on Linux 9.3. 'Plan B' is to run it on Windows.

Regards,

Henri

Re: Exploiting Goodle Analytics in SAS: Examples?

Rick_SAS — Thu, 09 Jun 2016 18:30:25 GMT

You did not mention what SAS tools/products you have. Most modern presentations that I have seen on this topic use a tool such as SAS Visual Analytics.

Re: Exploiting Goodle Analytics in SAS: Examples?

HenriTheuwissen — Fri, 10 Jun 2016 04:28:11 GMT

Hi Rick,

We do not have Visual Analytics

We do have the 'traditional' SAS/EIP platform (with SAS/DI, IMap, Web Report Studio, OLAP Cubes etc.)

Re: Exploiting Google Analytics in SAS: Examples?

ChrisHemedinger — Mon, 17 Apr 2017 17:55:18 GMT

Coming back to this because now with PROC HTTP and the JSON libname engine, it's possible to fetch Google Analytics data via Base SAS code. This does require SAS 9.4m4.

High level steps:

Grant permission and obtain an authorization token for your "app" (a SAS program, in our case). This must be performed in a browser while logged into your Google account.
Obtain an access token and refresh token. You can accomplish this with a SAS program that you run just once. You then save the refresh token (in a safe place!) for subsequent runs.
Convert your saved refresh token into an access token. Do this at the start of every SAS job that needs to get Google Analytics data.
And finally, use the Google Analytics API to get actual data!

Details are in this blog post.