Did you know that there’s a whole library of easy-to-use Google Analytics plugins for Excel? I didn’t think so! There’s a collection of plugins that connect the Google Analytics API to various tools available in Google’s App Library for Analytics. I’ve been testing out a few of them the last few weeks, focusing specifically on those that can connect to Excel, and I wanted to share a few of my favorites with all of you.
All of the tools I’m going to talk about below met a few requirements:
1. Get data from Google Analytics into Excel in an easy, automated fashion.
2. All of the main data points available through the API are also available (profiles, segments, dimensions, metrics, and filters).
3. Advanced data blocks with multiple dimensions and multiple metrics are possible.
First, I want to tell you about Tatvic’s “Ninja Plugin”, a very easy to use add-in for Excel. After installing the Ninja Plugin, new options will appear on your Add-Ins tab of Excel where you can add a new data block. Adding or editing the data queries brings up the interface below and takes you through a few quick steps to defining the data you want: 1) select the profile and date range, 2) select dimensions and metrics, and 3) select filters and define the rules for sorting. Once you have all of your data blocks in place, you can update them all at once with the ‘Refresh’ button. Tatvic is free for the first profile, so if you really only need data from one profile, this may be a great data automation solution for you!
The Shuffle Point app is slightly more complex to get set up initially, but once you get it going, there are definitely more possibilities for advanced querying. Most of the configuration is actually done through a web interface (see below), where you can build your queries and test them out. The next step is to generate a key and a file that you then use to connect in Excel with an external data connection. You can also configure your queries to be dynamically built based on a few key parameters that you pass in like date range and profile. Once you have the queries set up exactly how you want them, updating is a breeze. You can update individual queries or all of them at once through the Refresh Data command within Excel. Though the plans for this tool start at $49/month the flexibility of the queries and the global refresh features could very easily be worth the cost for those looking to do complex and/or extensive automated reporting.
The Excellent Analytics plugin had a very easy to use interface that is available directly through Excel. After installing the plugin, an additional tab appears in the application where you can basically just build new queries or update existing ones. The query configuration screen simply allows you to select the dimensions, metrics, filters, profiles, and date range you would like to use to define your dataset. With a simple click of the ‘Execute’ button, you are off and running. However, updating the existing queries is not as convenient as some of the other tools. Instead of having a global refresh option, you need to select each individual query and update the query. So, this tool may not be the best option for building reports with many, many queries that would need to be updated often. One of the best properties of Excellent Analytics is the fact that it is completely free!
So, if you’re looking for a quick and easy way to get data from Google Analytics into Excel, I suggest you check out one of the above plugins. See a full list of the reporting apps here.