Google Analytics Via Power Query For Excel
This program is written on M# language and it is used for retrieving data from Google Analytics api directly to Excel using Power Query Addon.
A lot of code [in this application] is taken from article on kohera.be.
You can download Xls file from here
Requirements
- MS Excel 2010, 2013, 2016 or Power BI
- Power Query Addon
- Enabled Macros for using Buttons (controls) - in order to use release version file.
Video demonstration
Here is the short video which describes how this workbook works.
https://vimeo.com/maximuvarov/googleanalyticsviapowerqueryformsexcel
Todo
- Use built in power query storage for tokens
- Implement downloading data day by day for minimising sampling