topic How to fetch Google Analytic Data into SAS through SAS Code in SAS Programming

How to fetch Google Analytic Data into SAS through SAS Code

kaushalsolanki — Tue, 01 Dec 2015 07:09:26 GMT

Hello All,

Can any one guide me how to fetch Google Analytics Data through SAS Programing,

thanks in advance.

Regards,

Kaushal Solanki

SteveM_UK — Sun, 06 Dec 2015 13:03:26 GMT

Hi Kaushai,

I haven't tried any if this myself but the two authors cover the topic well

The only thing I'll add: these articles are from 2010/2011 so things may have changed and there might be new methods you could use.

Regards

Steve

ChrisHemedinger — Mon, 17 Apr 2017 17:52:55 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.

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!