2.1 Free Versus Premium Licenses

Analytics Edge add-ins and connectors are licensed individually — you pay for the features you need. The Analytics Edge Core Add-in can be used with a Free or a Premium license. The add-in comes with a free connector: Google Analytics (Free), and there is a premium Google Analytics (Pro) version available. There are other premium connectors available as well.

When activated, the Add-in will automatically start a 30-day, fully functional trial of the Premium license. Any premium connector you install will also automatically activate a 30-day, fully functional trial.

Using Analytics Edge For Free

To use the add-in for free, once activated, open the License wizard and select the Basic/Free license type. Remove/uninstall all premium connectors — Free connectors are clearly identified as “(Free)”.

The Basic Add-in is designed for simple, fast report automation. It works with any combination of free or premium connectors (licensed separately), allowing you build queries that pull data from a service and write it to Excel.

You can make unlimited queries, from unlimited accounts, subject only to API limits. If the API delivers a limited number of rows per query, the connectors typically make multiple queries to get all your data — you don’t need to know how the APIs work.

Once the queries are set up, one button refreshes the whole workbook.

If you have questions or problems, there is an online support forum.

Google Analytics (Free) Connector

Designed for the majority of common Google Analytics (Universal Analytics) reporting needs. The Google Analytics (Free) connector provides all standard dimensions and metrics with million-row download capability, a minimize data sampling feature, custom dynamic segment definitions and unlimited accounts, views, queries (subject to API limits).

It does not include access to Multi-Channel Funnels or Google Analytics 4 data, or the extra custom dimensions and metrics available to GA360 customers — those are all features of the Google Analytics (Pro) connector.

Analytics Edge Core Add-in: Premium License Features

Designed to automate the analysis of the data you have downloaded, the premium add-in license builds on the Basic functionality: it works with any combination of free or premium connectors (licensed separately). The Quick Queries possible with the free license are extended with Quick Functions, letting you pivot, arrange, sort or filter the data before it gets written into Excel.

You also get the ability to build Analytics Edge “macros” using any combination of 37 wizard-based functions (no formulas or programming required) to download and work with your data. This lets you combine or compare data from different queries/sources to get the information you need for your report.

You do not need a macro-enabled workbook to run Analytics Edge macros, but they can integrate with VBA if you want.

The macro functions also include the ability to read or write to Google Sheets, save as a PDF and optionally send the PDF (or workbook) via email (SMTP or Gmail).

Reports change, so the add-in makes changes easy. Individual functions can be added, deleted, edited, copy/pasted, or moved around easily in the Task Pane. You can even step through the functions and see the intermediate results. Undo your changes, or redo them again.

All quick queries and macros can be refreshed with a single button click, but the premium license also provides integration with the Windows Task Scheduler, allowing you to schedule unattended refreshes after hours.

New with version 10, the wizard-based macro functions are available to interactively modify the data in your workbook, allowing you to do one-off transformations. You even get to decide whether to overwrite the original data, write it to a new sheet or to a specific location on an existing worksheet. You can even change you mind and save the whole thing as a macro so you can repeat it or modify it later.

The Analytics Edge Core Add-in is designed to make it fast and easy to build your reports and effortless to refresh them. No need for restricted Excel Pivot Tables, complicated/fragile formulas, or VBA programming required.