Migrate from Excellent Analytics to Reporting Manager

If you model your Google Analytics data in Microsoft Excel, you may be using Excellent Analytics. Over the last several years, Excellent Analytics has been a great free tool for analysts who need basic Excel integration capabilities, but as of April 20, 2015, it will stop working.

Excellent Analytics uses an old method of authenticating with Google, one that was deprecated in 2012. Per Google’s deprecation policy, this means that several old methods of authentication will stop working on April 20 of this year, and only tools using the current standard method, OAuth2, will be allowed to connect to Google.

Excellent Analytics is one of the affected tools, so if you’re using it, you’ll need to move your Excel reporting to use another tool. As a free, enterprise-grade add-in for Microsoft Excel, many users are already migrating to Reporting Manager. To make the move to Reporting Manager easier, we’ve written a migration guide for Excellent Analytics.
Read more

Introducing Reporting Manager: Google Analytics data in Microsoft Excel

Today, we’re launching Reporting Manager, a free add-on for Microsoft Excel that allows you to build powerful refresh-able reporting using Google Analytics data.

We built Reporting Manager to leverage our Analysis Engine cloud platform from within Excel, and today we’re releasing it for free.

[youtube https://www.youtube.com/watch?v=vhUMQd-MN6M?rel=0&controls=0&showinfo=0]

Since Reporting Manager pulls data through Analysis Engine, we have a number of features that take advantage of data processing in the cloud. Using Reporting Manager, you can:

  • Post-process data online before it’s output into Excel.
  • Avoid sampling by merging multiple smaller pulls together.
  • Pull data according to your company’s fiscal calendar.

Reporting Manager comes bundled with Analysis Engine Reporting Edition, which includes a few features of the cloud platform that empower reporting. With Reporting Edition, you can:

  • Create and manage your connections to Google Analytics
  • Configure and run data exports in the cloud
  • Easily upload cost data to Google Analytics
  • Automatically synchronize your Bing Ads cost data with Google Analytics

All of these features come bundled with Reporting Manager for free. You can get started right now by signing up for a free account.