Create an application analytics dashboard in excel (or other spreadsheet), picking data from the Google Analytics API #5
Description
Instead of monitoring the usage of the software through the online Google Analytics platform, examine the alternative of having a spreadsheet containing the dashboard with the key metrics and graphs.
It should then be possible to give the final spreadsheet file, as a template to the developers using the SoftMeter library.
Add-ons to consider:
-
Analytics Edge Basic Add-in (Simply Free)
The no1 rated free plug-in for Microsoft Excel includes a free Google Analytics connector (with minimize sampling option, and no 10,000 row limit) and a free Social Share Counts connector. There are even free Excel reports available. They are easy to use, with no account limits, no profile limits, no query restrictions, no download limits.
https://www.analyticsedge.com/simply-free/ -
Tatvic Analytics Excel plugin
Excel Plugin imports your Google Analytics, Google Adwords, DFP data into MS-Excel.
https://www.tatvic.com/excel-add-in-google-analytics/ -
Google Analytics spreadsheet add-on
Access all of your Google Analytics data in Google Spreadsheets.
The Google Analytics spreadsheet add-on brings you the power of the Google Analytics API combined with the power of data manipulation in Google Spreadsheets. With this tool, you can:
-- Query data from multiple views (profiles).
-- Create custom calculations from your report data.
-- Create dashboards with embedded data visualizations.
-- Schedule reports to run automatically so your data is always current.
-- Easily control who can see these data and visualizations by leveraging Google Spreadsheet’s existing sharing and privacy features.
https://chrome.google.com/webstore/detail/google-analytics/fefimfimnhjjkomigakinmjileehfopp
https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on -
Also read a solution via macros
https://www.vervesearch.com/articles/easy-google-analytics-api-for-excel-2/