<< Click to Display Table of Contents >> Navigation:  5. Detailed description of the Actions > 5.26. User-Deprecated Transformations > 5.26.3. PyGoogle Analytics (Python action)

 

Icon:

 

Function: Py_GoogleAnalytics

 

Property window:

 

 

Short description:

 

Connect to Google Analytics.

 

Long Description:

 

 

 

Before executing this Action, please install the "Google API" inside Python by executing inside the windows shell:

 

pip.exe install --upgrade google-api-python-client

 

The "pip.exe" executable is usually inside the directory "<root_of_python_dir>/scripts".

 

 

To create your JSON file (with your credentials), the procedure is:

 

1.You need to first use the setup tool (https://console.developers.google.com/start/api?id=analyticsreporting.googleapis.com&credential=client_key), which guides you through creating a project in the Google API Console, enabling the API, and creating credentials.

 

2.Open the Credentials page (https://console.developers.google.com/apis/credentials): Click Create credentials and select "Service Account Key": select "JSON format" to store your key and download the JSON file.

 

3.Open you JSON file inside a text file editor and search for the field: "client_email": This should be something like: "xxx@yyy.iam.gserviceaccount.com"

 

4.Use the email address obtained on point 3 (just here above) to add a user (https://support.google.com/analytics/answer/1009702) to the Google analytics account you want to access via the API. For this Action only Read & Analyze (https://support.google.com/analytics/answer/2884495) permissions are needed for this user.

 

 

The above 4-steps procedure (to get your JSON file with your credentials) is also documented here:

https://developers.google.com/analytics/devguides/reporting/core/v4/quickstart/installed-py

 

 

Get your "View ID", using the "account explorer":

https://ga-dev-tools.appspot.com/account-explorer/

 

 

If you get the following error message:

 

   "User does not have sufficient permissions for this profile.",

 

...this means that your "View ID" is incorrect.

 

 

It's quite easy to change the Python code to:

 

•change the analyzed period of time (change "dateRanges"): By default, we are looking at the last 30 days.

 

•extract new DIMENSIONS and new METRICS out of Google Analytics:

   All the available DIMENSIONS and METRICS are visible here:   https://www.googleapis.com/analytics/v3/metadata/ga/columns?pp=1

(see the comments in the code to know where to change the code)