Data from Google Analytics needs to be extracted into a database in a google sheet. The data will later be used to populate the BI dashboard that can be found here.
A list of google analytic metrics, events and dimensions necessary to populate the dashboard needs to be created. It could also be a mapping that match every metric in the dashboard with the corresponding metric in GA.
Only the data that contains "GA" in the C column belongs to this particular task, but additional data can be collected.
This list could also include other metrics that we want to store but will not necessarily be displayed in the dashboard. This list is created —> list of GA events here.
The use of google analytics data_v1alpha library has been proposed. Starter code here.
There is little documentation on this library, since is very recent and has not much support, so the use of another version (google analytics data) is being tested as alternative.