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 3.5 SP1.
[Added: September 23, 2009]
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]
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]
Why do I have some static data?
Example: If your first query uses columns A-D and rows 1-10 and then you adjust the query and only columns A-C and rows 1-5 will be needed your old data in column D and rows 6-10 will remain. Solution: clear the cells before running the adjusted query, but make sure to keep the header where the query settings are stored.
[Added: September 26, 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]
How do I set the sort for a query?
There is currently no way you can set the sort order in Excellent Analytics. It is on our list. You have to do the sorting in Excel for now.
[Added: September 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]
Is there a privacy policy?
Excellent Analytics is provided as an open source product under the MIT license. We can therefore not provide any Privacy Policy statements or any other guarantees. It’s provided “as is”. You may, however, examine the full source code. We have no interest in capturing or storing your information.
[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]
How can I upgrade Excellent Analytics?
Read the instructions here.
[Added: October 21, 2009]
Questions? Contact feedback at excellentanalytics.com.
