FAQ

Our ambition is to fill this page with questions and answers. You may also find instructions on the install, upgrade, and use page. There is even an instructional video. You may also want to read this blog post.

Is it really free?
The short answer is: yes. The long answer is: yes, yes, yes!
[Added: September 23, 2009]

Why is it distributed as a .zip file? I was expecting an .exe file.
It’s compressed. You can use something like 7-Zip to uncompress it.
[Updated: December 9, 2009]

Why can’t I install it?
Make sure you’re running Windows XP or Vista, Excel 2007 and have installed Microsoft .NET Framework 4.
[Updated: May 5, 2010]

Why can’t I log in?
If your login fails, please check the Google help section. If you have made too many attempts to log in you’ll have to enter the letters in the captcha image on the Google Analytics website, or request a new password.
[Added: September 23, 2009]

How are you using my password?
Your username and password is only being sent to Google so that you can login and access your Google Analytics data. We do not store or otherwise use your login information. Excellent Analytics uses the Google Analytics API to fetch data for you. We do not store or use your data. Excellent Analytics is provided as an open source product under the MIT license. It’s provided “as is”. You can examine the full source code.
[Added: September 23, 2009]

The Excellent Analytics menu is gone from Excel. What happened?
If Excel didn’t run properly it may have disabled Excellent Analytics. To enable it again, right click on the Excel menu and select “Customize Quick Access Toolbar.” In the window that opens, select “Add-Ins”, in the drop down menu select “Disabled Items”, and click “Go…” In the dialog that opens select Excellent Analytics, and click “Enable.” Restart Excel.
[Added: September 27, 2009]

Can you give an example of how to use it?
Sure, just have a look at our video or read these two examples: 1 and 2.
[Added: September 25, 2009]

Why doesn’t anything happen when I run a query?
Have you made sure to only select valid combinations of dimensions and metrics? Not all combinations are valid. We will add functionality to help you only select valid combinations in a future release, but for now you need to know what you can select. Use this document as your guide.
[Added: September 23, 2009]

How can I refresh a query?
If you’d like to adjust and run your query again, simply mark the top row of the table generated by the query, and click “Update Query.” Please note that a spreadsheet may contain multiple queries and that you need to mark the heading of the particular table you wish to update. It contains the name of the selected Google Analytics profile and the selected date range.
[Added: October 20, 2009]

What’s start index good for?
You can use start index to fetch more than 10,000 rows. Just set start index to begin from the row # after the last row # in your previous query. Note that you can’t fetch more than 10,000 rows in a single query. That’s the limit in the Google Analytics API. You have to make multiple queries to fetch more than 10,000 rows.
[Added: October 25, 2009]

What’s max results good for?
You can use max results to limit the number of rows in a query. Adjust if you want to fetch fewer than 10,000.
[Added: October 25, 2009]

I can’t find the Excellent Analytics menu in Excel 2007 in Windows 7, what should I do?
In Excel 2007, right-click on the menu area, select “Customize the Quick Access Toolbar”. From the window that pops up, select “Add-ins” in the left menu, then at the bottom of the window select “Managed COM Add-Ins” and hit “GO”. Excellent Analytics shows up in the next window, click the checkbox next to it and then press OK.
[Added: October 20, 2009]

Does it work in VMware Fusion?
Yes, but it is currently very slow when running it that way.
[Added: September 23, 2009]

Are there any plans for a Mac, Excel 2003, or OpenOffice version?
Some of our developers are looking into Excel 2003 and Mac versions, though nothing has been decided yet. No plans for an OpenOffice version right now.
[Added: September 23, 2009]

Who made Excellent Analytics?
See the about page.
[Added: September 27, 2009]

Can I help develop Excellent Analytics?
Yes, we’re always interested in finding more developers willing to contribute to this open source project. Use our application form if you’re interested.
[Added: September 23, 2009]

I can’t connect to my Google Analytics account? Why?
Try to go to LAN settings on your computer and unselect the checkbox by “Use a proxy server..”
[Added: April 25, 2010]

How can I upgrade Excellent Analytics?
Read the instructions here.
[Added: October 21, 2009]

I just get a bunch of numbers for time on site/time on page. What is it?
Google Analytics returns time on site and time on page in seconds. If you want to convert seconds into minutes and seconds divide your cell with 86400. Then right click your new cell and select Format Cells. Under the Numbers tab, select Custom and Type mm:ss. If you want hours, minutes and seconds, format as hh:mm:ss. Note that the format you need to select may be different if you are not using Excel in English.
[Added: April 25, 2010]

How can I run the same query for multiple profiles?
What you can do is the following:
1) Create the query you want and run it.
2) Copy the single cell that begins with the profile name that you used.
3) Paste it into a different cell and make sure that cell is marked.
4) Click update query. Now all settings are there and you can just change profile name before running it.
5) Repeat steps 2-4 as many times as you need (once per query/profile).
[Added: May 6, 2010]

How do I use filters?
Check the filter guide.
[Added: May 11, 2010]

I can’t update my old query, why?
Actually, you can. It’s just a bit tricky. If you mark the very first cell in your query (the one beginning with the name of the website you’re running the query for, for instance yoursite.com) and then edit the query string in it you can make it work.

See the changes you need to make in the example below. Changes/additions highlighted in red:

excellentanalytics.com [ 2010-04-29 -> 2010-05-11 ]queryInfo[queryString=https://www.google.com/analytics/feeds/data?ids=ga:********&dimensions=ga:browser&metrics=ga:bounces&sort=ga:bounces&start-date=2010-04-29&end-date=2010-05-11&max-results=10000;rows=12;columns=2;timePeriod=PeriodNotSpecified]

News: rows, columns, queryInfo[queryString=] and timePeriod.

Note that if you’e changing queries from old versions of Excellent Analytics you should always set timePeriod to PeriodNotSpecified. This has to do with whether your query is using a fixed time period or a custom time period.

Once you have changed your query like this you should be able to use the update query button for your old query again.
[Added: May 11, 2010]