Free Google Analytics Plug-In for Microsoft Excel (GA Client/Add-On for Spreadsheets)
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
Using Excellent Analytics is easy. Just download Excellent Analytics.rar, extract the contents using a program such as 7-Zip, and run Setup.exe. Follow the on-screen instructions.
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?
Well, now we need your help. Excellent Analytics is open source, meaning its continuous development depends on all of us.
There are three ways in which you can contribute:
#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.
Download the free Google Analytics plug-in for Microsoft Excel 2007 for Windows XP/Vista
![[del.icio.us]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/digg.png)
![[Facebook]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/facebook.png)
![[Google]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/google.png)
![[LinkedIn]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/linkedin.png)
![[MySpace]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/myspace.png)
![[Reddit]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/reddit.png)
![[Slashdot]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/slashdot.png)
![[Sphinn]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/sphinn.png)
![[StumbleUpon]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/technorati.png)
![[Twitter]](http://www.webanalysts.info/webanalytics/wp-content/plugins/bookmarkify/twitter.png)
Share on LinkedInPosted in Google Analytics | 20 Comments »
Subscribe to RSS feed
Subscribe by email
August 5th, 2009 at 10:56 am
[...] Free Google Analytics Plug-In for Microsoft Excel (GA Client/Add … Tags: 1300-inlinks, analytics, Google Analytics, microsoft, microsoft-excel, open-source, [...]
August 5th, 2009 at 12:03 pm
[...] Free Google Analytics Plug-In for Microsoft Excel (GA Client/Add … Bookmark [...]
August 7th, 2009 at 11:13 am
[...] de Google Analytics, fácilmente desde Excel, algo que siempre se presenta como una gran aventura: Free Google Analytics Plug-In Microsoft Excel (GA Client/Add-On for Spreadsheets) en [...]
August 7th, 2009 at 11:20 am
Let’s say you suspect that your website does not display properly in some web browsers, potentially causing visitors to leave. Well, let’s use Excellent Analytics to find out if your hunch is correct [..]
Keep reading:
http://www.webanalyticsworld.net/2009/08/analyze-google-analytics-data-without.html
August 8th, 2009 at 3:50 pm
[...] If you’re not a programmer/developer and would like to contribute you can always post your comments about improvements that you’d like to see made. [...]
August 13th, 2009 at 7:16 am
[...] Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin. Excellent Analytic’s Query Builder [...]
August 13th, 2009 at 7:47 am
[...] Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin.Excellent Analytic's Query Builder InterfaceShufflePoint – Works somewhat [...]
August 13th, 2009 at 8:19 am
[...] Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin. Excellent [...]
August 13th, 2009 at 9:04 am
Many of our clients use Excel to manage their ad campaigns, visualize marketing performance, and perform complex data analysis. Most analysts use the Google Analytics Export feature to manually export their report data to CSV files. Then they import the CSV file into Excel. No longer! Now, with the Google Analytics API you can bypass this manual step and export Google Analytics data directly from within Excel! Once you’ve set it up, there’s no need to visit the Analytics reports to view data in Excel.
Thanks to a variety of developers, here are four solutions that can transform you from a reporting monkey to an analysis ninja (as Avinash would say)[..]
August 13th, 2009 at 11:54 am
[...] Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin. Excellent Analytic’s Query Builder [...]
August 13th, 2009 at 5:38 pm
[...] Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin. Excellent Analytic’s Query Builder [...]
August 13th, 2009 at 10:54 pm
[...] Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this [...]
August 16th, 2009 at 9:01 pm
[...] Via: WebAnalytics.Info Stem of voeg toe aan: // [...]
September 23rd, 2009 at 1:14 pm
[...] самым экономным аналитикам. На Webanalytics.info есть подробная инструкция по использованию [...]
October 6th, 2009 at 3:20 pm
[...] Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin. Excellent Analytic’s Query Builder [...]
October 14th, 2009 at 10:19 pm
Is it possible in the next build to add in the other goals metrics?
Additionally, the API doesn’t require a dimension in order to make a query. It does require a metric but you can get a query for things like ga:visits without needing a dimension. Can that functionality be added as well?
October 19th, 2009 at 4:31 pm
Chris,
Our lead developer is working on those things.
October 20th, 2009 at 10:49 am
Thanks very much for this initiative. I will soon start using the plugin once I have Excel 2007 on my computer. Since I work on automating reports, I would be happy with the following things:
- The possibility to take the report date ranges from Excel cells
- Possibility to refresh all requests on a worksheet simultaneously (like HBX Report Builder)
Please continue with this great project!
- Milco
October 29th, 2009 at 6:01 pm
How can I get metrics for a specific goal? It makes no sense to get them all at once.
With this done the tool would be awesome
November 11th, 2009 at 12:01 am
Danielo – next release!
Milco – those are planned!