Check out our new excellent analytics tool, now in beta

We’re happy to introduce our new Google Analytics tool for Excel users, FasterMetrics. It’s an easy-to-use plugin that gets your Google Analytics data into Excel, and works on both Mac and Windows Excel. It’s similar to a tool called Excellent Analytics, but it also works in Mac OS X, is faster, and lets you set all your query parameters dynamically using Excel functions – this makes it possible to automate complex reporting dashboards. Compared to GA Data Grabber, FasterMetrics has more limited functionality, as it lacks some features like automatic data visualization and exporting to PowerPoint, but for some purposes, a simple tool like this can be more convenient.

FasterMetrics is currently in beta: you can download the beta version here. After opening the file, on Windows Excel 2007/2010 you will see the button to launch it in the Add-ins tab. In Mac Excel 2011, you will see a custom toolbar pop up.

You can use the full version FasterMetrics for 30 days for free. After that, you can choose to pay for the full version, or continue to use the tool for free, with limited functionality.

We’re still developing the tool, with the aim to get it out of beta in August. If you have any feature suggestions or problems with the tool, please post these to our help forum. Thanks.

11 Responses to “Check out our new excellent analytics tool, now in beta”

  1. Mikael Thuneberg

    Most likely, the restrictions in the free version after 30 days will be max 3 metrics per query, max 1 profile per query, and no refreshing of old queries.

  2. Mikael Thuneberg

    When you have run queries in the workbook, they are stored in a hidden worksheet called “querystorage”. Unhide this worksheet, and you’ll see all the parameters (metrics, dates, profile IDs etc.) of the queries you have run. You can modify these parameters either by typing some values into the cells, or by adding a formulas that determine the parameter values based on other data. When you refresh the queries, the data will be fetched according to the values you inputted.

    When you press “Launch FasterMetrics”, you will see there’s a button for “Modify existing queries” if the tool detects that there are old queries in the workbook that you have open. This button simply unhides the querystorage sheet.

    • Mikael Thuneberg

      At the moment, no. The benefit of doing this via a worksheet is that you can make the parameter values dependent on some other cells values, by placing formulas into the cells. For example, you can make a dashboard where the user can type a date range into two cells, and these dates are then linked to the querystorage sheet, so when the user presses the update button, all the queries are updated with the selected date range.

    • Unknown

      That’s true, i know this already from your google docs integration. But editing using the interface could be an addiotional function for unexperienced users.

    • Mikael Thuneberg

      I agree, we’ll try to think of a way to add this option also. Maybe so that if you have the cursor placed on an existing query when you press Launch FasterMetrics, the parameters of that query would be loaded to the interface, making it easy to modify.

    • Javi Martínez

      It crashes at the start. OS Lion. Excel for mac 2011.

      Microsoft Error Reporting log version: 2.0

      Error Signature:
      Exception: EXC_BAD_ACCESS
      Date/Time: 2012-08-28 07:07:38 +0000
      Application Name: Microsoft Excel
      Application Bundle ID:
      Application Signature: XCEL
      Application Version:
      Crashed Module Name: unknown
      Crashed Module Version: unknown
      Crashed Module Offset: unknown
      Blame Module Name: unknown
      Blame Module Version: unknown
      Blame Module Offset: unknown
      Application LCID: 3082
      Extra app info: Reg=en Loc=0x0c0a
      Crashed thread: 0


Leave a Comment

  • (will not be published)