How To Import Google Analytics Data Into Google Sheets
If you’re like us sometimes you just want to play around with your data a bit more than Google Analytics provides. Maybe you want a different type of chart or simply want to combine your data with some other source. While Google Data Studio is a super useful tool for this type of task, there can be a learning curve in order to get the exact type of data you seek. Enter the Google Analytics Add on for Google Sheets.
What can you do with this data?
If there’s data in your GA account you can pull it into Google Sheets with this plugin. Dates, goals, users, sessions; it’s all there for the taking. What we like to do with this plugin is to leverage this data to create better dashboards than what GA provides as the Sheets plugin allows you to schedule this data to be pulled automatically and thus you can send your team a link that they can access at any time to see fresh data in the format you wish. While the Sheets charts have a long way to go in order to be as useful as Excel, there is still plenty of visualization options at your fingertips.
Take a look at Google’s documentation and tutorial to see what is possible. Then, start putting questions on a white board that your Google Analytics data can provide answers to. Once you know what you’re asking from your data you can begin to query the vast Google Analytics API easily using the Dimensions & Metrics Explorer. As you click on different dimensions or metrics others will gray out if no correlations are available. This Add on is a simple way to start seeing your data in a whole new light and providing better visual insight into new opportunities!