[It stopped working May 26th, 2015] The open source Excellent Analytics add-in for Excel makes use of Google’s ClientLogin authentication, which Google shutdown around April 20, 2015. You can easily convert your existing reports using Analytics Edge Simply Free, a completely free alternative that is up-to-date and fully supported.
If you try the open source Excel add-in now, Excellent Analytics will show Login Failed messages. You can still get free reporting by switching to Analytics Edge.
The free Analytics Edge Basic Add-in, packaged with a free Google Analytics connector, provides a single click refresh for all queries in your workbook. Also included is an Excellent Analytics query conversion wizard that can convert each of your queries in place, requiring no design changes.
Benefits of Analytics Edge Simply Free over Excellent Analytics:
- one click refresh of all queries in the workbook
- all the latest dimensions and metrics available
- no need to learn API field names; uses the same terminology as the web interface
- automatically download more than 10,000 rows if your query returns that many
- flexible date ranges could be driven by worksheet cell values
- easy to build report templates with login and view id from cell references
- fully supported with responsive forum support
- plenty of free reports and expert articles provided
- can create dynamic advanced segments in the query
- can automatically convert dates and percents to Excel compatible format
- can convert numeric dimensions to numbers in Excel
Yes, it is completely free (licensed at no cost) with no artificial limits. If all you need is simple Google Analytics data downloads, this is the tool you’ve been hoping for!
If you need more, Analytics Edge protects your investment by providing several upgrade paths that do not require changes to your existing reports:
- inexpensive upgrade to Pro version with even more capabilities
- inexpensive upgrade to Core add-in for analytics workflow automation
- easy to add inexpensive connectors for Webmaster Tools, AdWords and more
See how Analytics Edge can make your Excel report automation simple. Download your free copy.