Part 4 in a 4 part series looking at different tools for accessing the Google Analytics API to pull data into Excel.
Part 4: ShufflePoint
ShufflePoint.com has a set of tools for “making presentations manageable”, including “dynamically associated Google Analytics data with Excel, Powerpoint, and Google Gadgets. Unlike the other solutions reviewed in this series, there is a cost, which is $29-$199/mth depending on volume. You can take a free 7 day test drive – BUT – you will have to provide a credit card to get set up (and then remember to cancel your account within 7 days if you don’t want to pay for the service).
Once you register and login, you open a new workbook in Excel and go to Data > (Get External Data) From Web and enter “https://www.shufflepoint.com/feed” into the New Web Query address bar.
Clicking on ‘New query in GAQL Studio‘ gets you to the handy interface below, where you can set up your Google Analytics query (you may have to log in first):
The available choices for Metrics and Dimensions correspond to the available options in Google Analytics, although with different terminology in some cases.
I found this to be a very user friendly interface with drag-n-drop functionality, some helpful notes in the ‘Help’ panel, and even definitions that show up when you roll-over metrics, etc. It looks easy enough to change date range, but you actually have to select ‘Given‘ from the list in the ‘Date Range‘ dropdown first. Otherwise, you just go with the provided date range options. If you hit ‘Get Results‘ you get a preview of your report. You’d expect that clicking the ‘Import‘ would then import your data from GA into your spreadsheet, but you’d be wrong. In fact, the next step is to hit ‘Continue‘ and go through a couple more clicks to get the data imported.
You add some rich text formatting prior to import and here’s what it looks like for the query shown above:
Now, it’s true that in this case, you can create a custom report in Google Analytics to display the same data:
The benefit of using a tool like ShufflePoint to get the data easily into Excel is that you can then extend the data to get something like this, with accompanying chart:
And, with a few clicks, you can update the data from within Excel – for example for the next month.
So another tool worth checking out if you have a need to import data from Google Analytics into Excel. As for me, I’m going to get busy figuring out how I can get build some loyalty and increase return visits!