Google Analytics Dashboard in Excel
In this tutorial I will teach you how to build your own Google analytics dashboard using excel.
- Exporting the data from Google Analytics using custom reports
- Date formats, and modifying to best suit our purpose
- Pivot tables and using them to control the graphs
- Inserting slicers to help dashboard interactivity
- Using two date selector to find 'previous' vs 'current' numbers
The analysis you can do with this style dashboard will help improve the insights you can pull out of this data. Even better than that, you will learn how to provide more value to your clients with an easy to update dashboard. This is definitely not rocket science!
Please provide feedback below, as I would love to hear your thoughts. Any additional insight you can provide is definitely useful.