2.1 Free Versus Premium Licenses

Analytics Edge add-ins and connectors are licensed individually – there is no package or combination license. The Analytics Edge Core Add-in can be used with a Free or a Premium license. Independent from that, you can use the included Google Analytics (Free) connector or upgrade to the optional Google Analytics (Pro) connector.

Analytics Edge Core Add-in – Free vs Premium License

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. Switching between License Types is as easy as clicking the other (Free) option. You can see the currently selected License type when you open the License Wizard (click the Register/License button on the ribbon bar).

Google Analytics Connectors – Free vs Pro Connector

With the Core Add-in, you get the Google Analytics (Free) connector by default, and you can install any number of premium connectors (each is individually licensed). Simply open the License wizard, select the premium connector you want (such as the Google Analytics (Pro) connector), then click the Add button.

Analytics Edge Core Add-in Licenses

Free License

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

  • can use any premium connectors (licensed separately)
  • writes downloaded data to selected cell
  • no account limits
  • no query limits*
  • one click workbook refresh
  • online support forum

Does not include:

  • scheduled refreshes
  • Quick Functions
  • Analytics Edge macros
  • VBA integration

Premium License

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

  • can use any premium connectors (licensed separately)
  • writes downloaded data to selected cell
    • includes Quick Functions (pivot, arrange, sort, filter)
  • no account limits
  • no query limits*
  • one click workbook refresh
    • includes Scheduled 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
    • read/write to Google Sheets
  • 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 Connectors

Google Analytics (Free)

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

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

Does not include:

  • GA360 extra custom metrics and dimensions
  • GA360 resource quota access
  • Multi-Channel Funnel reporting
  • User activity or management list reporting
  • Filter or data upload capability

Google Analytics (Pro)

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
  • Google Analytics 4 reports (NEW)
  • 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