Install and Use

Requirements
Install
Upgrade
Use
Video

Requirements

  • Windows XP or Windows Vista
  • Microsoft Excel 2007
  • Google Analytics account

Install

If you experience problems installing Excellent Analytics we recommend that you first install the Microsoft .NET Framework 3.5 SP1. Then reboot your computer before attempting to install Excellent Analytics.

Upgrade to latest version of Excellent Analytics

  1. Use “Add or Remove Programs” in the Windows control panel to uninstall the current version of Excellent Analytics from your computer
  2. Download the latest version of Excellent Analytics
  3. Run “Setup.exe”
  4. Follow the on-screen instructions

Use Excellent Analytics

Excellent Analytics Menu

Once you have installed Excellent Analytics and opened Microsoft Excel, locate the Excellent Analytics menu and select “Account.”

Excellent Analytics Credentials

Enter the e-mail address and password you use when you log in to Google Analytics. Make sure you enter the correct information. 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.

When you have successfully logged in the next step is to create your first query. Simply press “New Query.” The Excellent Analytics window will then open.

Dimensions
Excellent Analytics Dimensions

First you have 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 only wish to select one of them you need to expand that level and only tick the box in front of the dimension you wish to add.

Metrics
Excellent Analytics Metrics

Selecting metrics works the same way as selecting dimensions. Tick an entire level, or simply tick the metric(s) of your choice.

Google has written an excellent list explaining which dimensions and metrics you can combine.

The last step to consider before executing the query is whether you want to limit the data to be imported by setting up one, or multiple, filters.

Filters
Excellent Analytics Filters

Finally, you may refresh your data at any time.

Excellent Analytics Credentials

Simply mark the top row of the table generated by the query and click “Update Query”. You need to mark the heading of the particular table that you wish to update. It contains the name of the selected Google Analytics profile and the selected date range.

More reading:
Using Excellent Analytics
A practical example of how to use Excellent Analytics

A video tutorial:

Some features have been added since the video was recorded. Read about the new features.

Check our FAQ before you report an error.

Happy analyzing!


4 blogs link to this page »