To get started, download and install Excellent Analytics. This will add the Excellent Analytics menu to Excel. When you click on it you get three options to choose from: Account, New Query and Update Query.
Account is simply where you enter your Google Analytics e-mail address and password.
New Query is where you define the data you wish to pull into Excel. If you click this option and haven’t entered your login information the Account dialog box will open.
Update Query is only activated once you have run a previous query and marked its heading.
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!
This is what you do:
5. Execute the query
In this example it seems like Safari users are less likely to bounce than Internet Explorer or Firefox users.
Voilà! Using Excellent Analytics doesn’t have to be more complicated than that.
Please note that there are limitations to which metrics and dimensions that you can combine.
Benefits of reporting and analyzing Google Analytics data in Microsoft Excel:
Get one less tool to keep track of
Use a familiar interface
Combine data from multiple data sources
Use Excel formulas, charts, and pivot tables
Define and calculate customized KPIs
Build dashboards just the way you like them
Share workbooks with other Excel users
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.
Author: Lars Johansson