Pulling Data from Google Analytics, Pt. 3: Excellent Analytics

Part 3 in a series looking at various tools for getting data from Google Analytics in Excel via the API.

Part 1: VBA Macros | Part 2: Tatvic

Part 3: Excellent Analytics

Excellent Analytics is a free, open-source, plug-in/add-on/client for Excel 2007 designed to make it easy to extract and mine data from Google Analytics.  You can download it from the Excellent Analytics site, and where there is also a page with some instructions for how to use it.  And they even have a short tutorial video.  And there’s a lengthy article with an example over at Web Analytics World.

The only hitch I had with downloading the .rar file was losing track of where the files ended up after extraction. Eventually found them: C:\Documents and Settings\me\Local Settings\Temp\Excellent Analytics .

After running the setup file, you will see a menu item for Excellent Analytics when you open Excel:

Excellent Analytics menu in Excel

Excellent Analytics menu in Excel

Operation is pretty straightforward, intuitive, and offers lots of flexibility in selecting the data you would like to collect.  You can easily set the date range and make multiple choices from the complete list of dimensions and corresponding metrics.  A particularly cool function is the ability to filter data.  In the example below, the filter is set to exclude keywords that based on the company name to focus on product keywords.

Filtering Data in Excellent Analytics

Filtering Data in Excellent Analytics

One thing lacking with Excellent Analytics (unless I missed it) is the opportunity to choose how the date is broken down, such as weekly, monthly, etc.  All in all, though, another handy way to grab data from your Google Analytics profiles into Excel for further manipulation.

Advertisements

Pulling Data from Google Analytics API, Pt. 2: Tatvic

Part II in a series looking at getting data from Google Analytics into Excel via the API

Part 1: VBA macros

Tatvic GA Excel Plug-in

The Tatvic GA Excel Plugin requires users to download and install a plugin in order to extract data from the Google Analytics API, unlike the VBA macro approach.  In exchange for this small inconvenience, you get a more robust tool with a built-in interface that makes it easy to grab the data you want.

Installation is intuitive and trouble-free.  Once installed, all you need to do go to the ‘Add-Ins‘ tab in Excel, hit ‘Login‘ and enter a GA username and password.  Click on ‘Add New Data Block‘ and all the accounts and profiles associated with that username will be available for downloading. Pick an account and profile, date range and range breakdown.  This breakdown feature is very handy, as it allows you to, for example, get a year’s worth of data broken down by month – something you can’t do within the GA interface.

Tatvic GA Plug-in screen

Tatvic GA Plug-in screen

After selecting the account, profile and date range you want to report on, next step is to pick your dimensions and metrics.

Tatvic GA Plug-in data selection screen

Tatvic GA Plug-in data selection screen

Hit next and the data lands on your spreadsheet, starting in a cell of your choosing.

Tatvic GA Plug-in data results

Tatvic GA Plug-in data results

Note that in this case I choose to breakdown the data by week, with the weeks being identified as numbers in the output. Not exactly optimal, but with some fiddling with Excel functions, the date for the first day of the week can be derived.

Some of the real convenience factors here include:

  • drop-down list of all available accounts and profiles associated with the username – easy to grab data from multiple profiles in the same spreadsheet file.
  • ability to breakdown time period by day/week/month or year
  • built-in list of all the available GA dimensions and metrics
  • easily add multiple dimensions and metrics, with preview pane showing generally what it will look like
  • can edit reports after the fact if you want to add a metric, dimension, etc.
  • ability to select starting cell, so you can add to existing data over time.

Tatvic GA Plug-in is currently available as a free demo.  Not sure what the future plans are, but at the current price it offers excellent value. Check it out at http://gaexcelplugin.tatvic.com and keep up to date at the Tatvic blog.