Have you heard about the free, open source, Microsoft Excel plug-in for Google Analytics? It was released in June, and so far the project has generated 10,000 visits from 8,000 unique browsers, 2,000 downloads, 1,300 inlinks from blogs and websites, and countless tweets.
Excellent Analytics is an Excel add-on that allows you to define data queries and embed them into Microsoft Excel. Simply go to the Excellent Analytics menu in Excel and use the wizard interface to add a report query to your spreadsheet. It can be used to correlate variables and track them over time. You can also add external data to Google Analytics reports to get a more complete view of how your business is performing.
No longer do you have to use Omniture SiteCatalyst, HBX, or WebTrends to get a web analytics Excel client. Forget about awkward exports from the GA interface. No more exporting! Import and refresh your data from within Microsoft Excel instead! Then you can easily sort, manipulate, and distribute your data to anyone using Excel.
Excellent Analytics is 100% free to download and use. If you’re a programmer and passionate about analytics, you can even sign up to help improve the plug-in since it’s open source.
If you’ve already used Excellent Analytics, make sure you have the latest version. An important update has been released since the plug-in was first introduced.
Requirements to use the plug-in:
- Microsoft Excel 2007
- Windows XP or Vista
If you’re running an old version of Excellent Analytics and would like to upgrade, you need to remove the old installation and make a clean install.
Once installation has completed, you should be able to find the Excellent Analytics menu in Excel.
The first thing you need to do is to click “Account.”
The credentials (the e-mail address and password you use when you log in to Google Analytics) that you enter will be sent to only Google so that your Google Analytics data can be accessed. Your credentials are not stored or shared in another way.
Once you have successfully logged in, click “New Query.” This will open the Excellent Analytics window where you will be able to select the Google Analytics data you wish to pull into Excel.
The first thing you need to do is to select which dimensions to include.
If you tick a box, you’ll select everything included in that level. For instance, if you tick the “Content” box, “exit page path,” “landing page path,” “page path,” and “page title” will all be selected. If you wish to select only one of them, you need to expand that level and tick only the box in front of the dimension you wish to add.
Selecting metrics works the same way as selecting dimensions. Tick an entire level, or simply tick the metrics of your choice.
An example showing the available campaign metrics. No metrics have been chosen yet in this example.
To find out which combinations of dimensions and metrics are valid, check the official list.
The final step to consider before running your query is whether you want to filter which data should be included.
OK, this example is a bit silly, but if you are familiar with the way filters usually work in other programs, I know you’ll get the point.
If you have selected the date range you’re interested in, you’re now ready to push the “Execute” button, and watch the magic happen.
If you’d like to run your query again using a different date range, simply mark the top row of the table generated by the query (in this case it’s row 1), and click “Update Query.” Please note that a spreadsheet may contain multiple queries and that you need to mark the heading of that particular table. It contains the name of the selected Google Analytics profile and the selected date range.
That’s it. Pretty cool, huh?
#1. Become a developer.
#2. Submit your Excel dashboards based on Excellent Analytics (send a link to where we can download them from, or contact us and we’ll let you know of alternative methods for submission)
#3. Submit your suggestions of functionality that could be added or changes you’d like to see made
Excellent Analytics is a project initiated by Mark Red. Anyone is, however, welcome to join. It doesn’t matter if you are independent or part of a different agency.