Pulling Data from Google Analytics, Pt 4: ShufflePoint

Part 4 in a 4 part series looking at different tools for accessing the Google Analytics API to pull data into Excel.

Part 1: VBA Macros | Part 2: Tatvic | Part 3: Excellent Analytics

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.

Launching access to ShufflePoint from within Excel 2007

Launching access to ShufflePoint from within Excel 2007

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):

ShufflePoint Query Window

ShufflePoint Query Window

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:

GA Data Imported into Excel

GA Data Imported into Excel

Now, it’s true that in this case, you can create a custom report in Google Analytics to display the same data:

GA New Visits by Month

GA New Visits by Month

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:

Comibining GA + Excel

Comibining GA + Excel

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!

Advertisements

2 Responses

  1. What, no conclusions! I was psyched to find your four part article and appreciate the time you took in putting this together. I wish you had given us a conclusion, however, explaining which tool you chose and why. As it is, we’re left to try all four for ourselves, when I’d hoped your article would at least give me a front-runner to test first.

    This is not meant to detract from my praise for putting this together though. I know how much work it is.

    Thanks,

    Michael

    • Excellent point, Michael! Sorry to leave you high and dry like that. My easy out is that they all have pros/cons that may make any of them more suitable for a particular application than the others, so I hoped to highlight those strengths and weaknesses to enable readers decide what would work best for them. But to get off the fence, based on my experience since writing these posts:

      1. I almost always use ‘Excellent Analytics’, as it is a free tool that is very convenient to use. It is not without occasional buginess, but generally gets the job done without hassle.
      2. As a backup, I turn to VBA macros, which require more hands-on work, but provide great flexibility, ease of replication, and can be used with Excel 2003.
      3. Tatvic and Shufflepoint are worthwhile solutions that have reasonable costs, although so far I’ve been able to get what I need from free tools.

      All 4 of these options continue to evolve, so you may want to check on the latest versions, depending on your particular needs.

      John

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: