5.26.3. PyGoogle Analytics (Python clip0250 action)

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.26. User-Deprecated Transformations >

5.26.3. 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)