2.1 Free Versus Premium Licenses

The Analytics Edge Core Add-in can be used with a Free license or a Premium License. Both license types include a Free Google Analytics connector and there is an optional premium Google Analytics Pro connector available. The Premium license and Pro connector give you extra features, listed below.

Analytics Edge Core Add-in

The Analytics Core Add-in has both Free and Premium license options, and you can switch back-and-forth between them easily. When installed, the Core Add-in will automatically start a 30-day trial of the Premium license. You can see the currently selected License type when you open the License Wizard (click the Register/License button on the ribbon bar). Switching between License Types is as easy as clicking the other option.

Google Analytics Connectors

Regardless of the license type selected for the Core Add-in, you get the Google Analytics (Free) connector by default, and you can install any number of premium connectors. Simply open the License wizard, click on the premium connector (such as the Google Analytics (Pro) connector) you want to try, then click Install.

Add-in Free License

Designed for simple, fast report automation. The add-in free license provides:

  • access to all premium connectors
  • writes downloaded data to selected cell
  • no account limits
  • no query limits*
  • one click workbook refresh
  • online support forum

A 30-day Premium trial period starts automatically. When it expires:

  • scheduled refreshes will no longer work
  • macros will not run
  • premium functions will no longer work

Add-in Premium License

Designed for simple, fast report automation with the capability to automate all the data transformations needed for professional analysis and reporting. The add-in premium license provides:

  • access to all premium connectors
  • writes downloaded data to selected cell
    • includes ability to Pivot, Filter, Arrange, Sort the data first
  • no account limits
  • no query limits*
  • one click workbook refresh
    • includes ability to schedule refreshes
  • includes confidential email support
  • ability to build wizard-based macros for automation with functions for
    • calculate, convert, formula, rank, replace, split, subtotal
    • arrange, duplicates, filter, group, pivot, sort, top, total, transpose, unpivot
    • append, combine, compare, lookup, match, update
    • read/write text file, read/write worksheet, append to worksheet
    • save/email PDF, save/email workbook, run macro, run VBA macro
    • repeat macro for each row of source data
  • macros or queries can be triggered by VBA or button clicks in the workbook

* Analytics Edge does not limit the queries you can make, but the APIs provided by Google, Facebook, Bing and others do have limits.

Google Analytics (Free)

Designed for the majority of common Google Analytics reporting needs. The included Free Google Analytics connector provides:

  • all standard dimensions and metrics
  • 7 dimensions and 10 metrics per query
  • million-row download capability
  • minimize data sampling feature
  • custom dynamic segments
  • unlimited accounts, views, queries

Google Analytics (Pro) Connector

Designed for professional or corporate Google Analytics reporting needs. The optional Google Analytics Pro connector provides:

  • all standard dimensions and metrics
    • includes extended GA360 custom dimensions and metrics
  • 9 dimensions and 10 metrics per query
  • over million-row download capability
    • fewer/faster queries for large downloads
    • large downloads can be exported to tab or comma-separated files
  • minimize data sampling feature
    • can use GA360 resource quotas for unsampled data
  • custom dynamic segments
  • unlimited accounts, views, queries
  • quick pivot by a selected dimension
  • Multi-Channel Funnel (MCF) reports
  • User Activity reports
  • Management Lists (export filters, custom segments, users)
  • Data Upload capability from worksheet
  • Save Filter capability from worksheet