5.14.2. PyGoogle Analytics (Python clip0250 action)

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.14. Python Various >

5.14.2. PyGoogle Analytics (Python clip0250 action)


Icon: ANATEL~4_img117

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:


Get your "View ID", using the "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)