Excellent Analytics is here!
Excellent Analytics, a simple Excel plug-in that lets you import web analytics data from Google Analytics, has been released.
- Build queries with all dimensions and metrics available in Google Analytics
- Apply filters to create advanced queries
- All queries are stored in the spreadsheet
Imported data is stored in the spreadsheet so you can sort, manipulate and distribute the data to anyone using Microsoft Excel.
Use Microsoft Excel to combine web analytics data from Google Analytics with offline data from any other source. Excellent Analytics makes this easy!
You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
The tool was upgraded in July and the instructions on how to use it were updated in the beginning of August: http://excellentanalytics.com/how-to/
Please let us know if you have any issues that still persist. Be as specific as possible.
Doesn’t work here in Office 2007. Shows no results at all.
Thanks a lot for this wonderful tool
Is there a way to update all queries at one time in a workbook?
Any way to get more than 1000 rows?
Is data retrieved real-time?
login doesn’t work..
I installed the tool, but i can’t log in with my gmail account. What did I wrong? Thank you for any help!
Is it possible to compare 2 different weeks analytics for a given set of metrics??
I have tried but the data is always wrong.
Its not letting me execute.
Hi,
I just installed the new version but still have problems with getting the data. I am using Office 2007 and Windows Vista.
I can select Dimensions and Metrics but then i shows retrieving data but nothing happens.
Any help highly appreciated
J
nice tool, some feedback – would like to be able to:
- pull in my own goals
- remember my last query
- choose weekly/monthly blocks
- combine profiles
- see pages/visit
also, what’s with time on site?
Thanks for solving the no data issue. It’s working wonderfully now.
Feature request:
The GA API returns at most 10,000 rows at a time after which it requires pagination. Would it be possible to build this functionality into the plugin (i.e. start_row=10001)?
Keep up the good work!
Great update it works, let’s play
Upfront thanks for this great app.
The Excellent Analytics.dll.manifest will not install for me so I can’t run the program. Any suggestions?
In the latest version of Excellent Analytics (ver 1.0.0.38) a problem with authentication (log in) is solved and the problem that no data was fetched in to the spreadsheet is also solved. Download the new version and read the How to section for information how to upgrade.
I added a bug report here:
http://code.google.com/p/excellent-analytics/issues/detail?id=1
Are you guys watching the issue quee?
Not sure if this is why or not, but I see that Google just made some modifications to their google analytics api. The changes are here:
http://groups.google.com/group/google-analytics-api-notify/browse_thread/thread/e8eb8f89bb86a6dd?hl=en
I enter the login details but nothing happens then. Is it the same problem with the comment “Mark Red says: June 20, 2009 at 10:15 am” you are working on?
Any idea when a help file will be available as im also having the same problem of no data showing in excel 2007.
Cannot get data into the spreadsheet.
Just downloaded the app and having the same problems as everyone else. Is there an update or patch for this problem?
Really helpfull tool, I guess….when can we expect a Mac version?
Is this for excel 2007 only or will it work on any version of excel?
Any update on this problem? We’re getting no data whatsoever pulled into excel
Hi Mark,
As many other users of your tool, I’m also facing the problem of not retrieving the data. Could you please tell me how do I get to know whether your tool has been updated or not.
Regards.
Arijit
Hi,
THANKS for ur open source plugin app
Ive just downloaded ur app and succesfully launched the plug-in in Excel.
I get a view on my accounts, dimensions and metrics but after selecting several combinations and several profiles including .com .com.ar , nothing happened…
Any news that may help?
Gustavo – Buenos Aires – Argentina
Can’t login…says “Invalid password/username” even though I’m using the correct username and password.
Any help would be appreciated, thanks.
Hi Mark,
Following a comment on the web analytics demystified Yahoo group (someone change the code to change the date format).
The problem happens with users that have the date format (in Windows/Control Panel/Regional and Language Settings) set to something different that yyyy-dd-mm.
You should try to make your plugin work with these different scenarios. Thanks for excellentanalytics!!!
Cheers,
Andres
Same issue here Mark, can’t get any data into XL 2007. Also notice that the Goal options don’t match all the API ones. Could be a very nice tool though.
Would be great if anyone can do a youtube video, this does look excellent but I haven’t been able to get any results yet …
I have also try this app, installing went good but I don’t see any query results. And I’m sure that i selected the correct dimensions en metric. Are there any bugs that you know?
Same problem as above. Simple query: Visits / Day for 1 week. Result: Empty Spreadsheet
We are aware that some users can’t retrieve data in to the spreadsheet. We are working to solve this problem!
HI,
I’ve got the same issue, nothing happen and my combinations are allowed…
thanks
Cool, thank u!!!
I’m not having much luck either. I select Content–page path under dimension, then visitor–entrances under metric. I’ve also tried visitor–day under dimension with visitor–entrances under metric. I’m logged in ok because it knows my profiles.
It could be sweet…
it looks great!!!Does it have any version for excel 2003?
Im missing support for Mac. Will there be a Mac version Excellent Analytics?
I agree it does not work. Installed the plugin for Excel 2007, select some dimensions and metrics and nothing happens!
E.g using a metric of ga:pageviews and a dimension of ga:browser or ga:country results in absolutely nothing happening whatsoever.
I am having problems too, type in my account details and logs in ok.
Select a date range and valid combination.
Says retreiving data… and nothing happens. The selection window just closes.
Same problem here. Read the doc you suggest, and building custom reports in GA to prove that the Dimensions and Metrics should work together. No matter what, no Data in Excel. Would appreciate any assistance, looks like an amazing tool.
None of the reports are working for me, even if I pick a simple dimension e.g. country along with a simple metric e.g. visitors.
Hi
Same problem here: the installation was succesfull but no results came after hitting the “execute” button whatever combination i choose.
Also checked with valid combinations… but nothing
Yeah, I’m having the same issues. I’m sure I’ve selected valid combinations (e.g., Page Title and Page Views)
Same problem here…
works fine
Hi,
I’ve tried all the possible valid combinations. It still isn’t giving any results.
any pointers on what could’ve gone wrong?
Swathi
any plans for an Excel 2003 version?
We have not yet written a help file. I think you are trying to query a combination of metrics and dimension that is not valid. Read more about valid combinations at http://code.google.com/apis/analytics/docs/gdata/gdataReferenceDimensionsMetrics.html#validCombinations
I think there is a problem with the Download File. I am unable to extract the file.
Thanks
Hi,
just downloaded the application and succesfully installed the plug-in in Excel.
i get a view on the dimensionsand metrics but after selecting several combinations / several profiles hitting the query button results in nothing…
is there a manual/help file somewhere around?
looking forward to actually be able to use the tool
sophie
The set up stops on when installing .NET framework… actually, it’s like it never started…
looked promising, but I can’t try it out…
Hi,
i tried your plugin but it didn’t work.
Am i the only one ?
thanks for your answer.
How do you use it?
Mark,
Looks like a great tool, really looking forward to using the application – and very glad you’ve released it as open-source.
However, I’ve had an issue with installation – seems that although I already have a copy of Microsoft Visual Studio Tools for the Microsoft Office system installed on my machine the installer for Excellent Analytics is forcing another install – but has an unresolved path to (I believe) find the libraries online. I’m getting a message telling me that the installer can’t resolve a path.
Hoping this is an easy fix / issue to resolve?
All the best, James.