How to use the Google Analytics Add-On in Google Sheets

Google Analytics is a robust tool for analyzing website traffic data. Over the years, the GA team at Google has added a ton of functionality that really allows you to build custom views and dashboards. I spend a lot of hours in Google Analytics… more than I care to admit.

However, sometimes I want to be able to maneuver the web data in a different way, and there is no better place to do that than in Google Sheets. Luckily, there is an easy way to get GA data into Google Sheets via an add-on called the “Google Analytics Spreadsheet Add-On”, which I highlight in the video below.

Some of the benefits of using the Google Analytics Spreadsheet Add-On include:

  • Query and report data from multiple views.

  • Compute and display custom calculations.

  • Create visualizations and embed those visualizations on third-party websites.

  • Schedule your reports to run and update automatically.

  • Control who can see your data and visualizations by using Google Sheets' sharing and privacy features.