Analytics Edge Add-ins and Connectors

The Analytics Edge Advantage: Time and Money

If you use Microsoft Excel for web analytics, SEO, PPC or email marketing reports, Analytics Edge can save you both time and money. Features like scheduled refresh, custom analysis macros, and quick queries supplement Excel’s already powerful reporting capabilities. The simple automation add-ins have connectors for popular services like Google Analytics, Facebook Ads and more. Analytics Edge products are installed and run inside Microsoft Excel on your Microsoft Windows computer. This means:

  • your computer does all the work; there are no account limits, no query limits, no report limits.
  • your account credentials are stored on your computer; there is no worry of security breaches.
  • your queries go direct to APIs at Google, Facebook, etc.; there is no intermediate service to slow you down.
  • your results are secure, sent direct to your computer from the APIs; your data is not available to others.
  • you are in control of the queries; you can get all the data you need for your reports.
  • you pay only for the software you use; you don’t pay for server usage.
  • your report is created in Microsoft Excel; you have the ultimate flexibility for analysis and presentation.
  • it is fully integrated with the Windows/Excel environment; schedule the refreshes for overnight.


Awesome add in
“Saves me a lot of time creating ad hoc reports and much easier than pulling data from Google. Thank you so much !!”
ecommerce@terrybicycles.com | Aug. 15, 2018


Analytics Edge Core Add-in

Analytics Edge Macros:

  • Create ‘macros’ to download and transform your data
  • Multiple queries can be combined or compared
  • One button refresh for all ‘macros’ in the workbook
  • Wizard-based: No formulas or programming
  • Import data: from text files, worksheets or other workbooks
  • Combine data: with append, combine, compare, lookup, match and update functions
  • Transform: arrange, sort, filter, pivot, unpivot, total, subtotal, top-10
  • Modify: convert text, numbers and dates, make calculations, join or split columns, or replace characters
  • Save and Email: save as PDF or workbook file, and send as an email attachment
  • Schedule: manage refreshes of selected reports daily, weekly or monthly

Download Now!

Quick Queries:

  • Downloads data to selected worksheet cell
  • Multiple queries can be placed on a single worksheet
  • One button refresh for all queries in the workbook
  • Supports multiple accounts, multiple sources (connectors)
  • Functions: Pivot, Arrange, Sort, Filter or Append your data

Free License Option:

  • Downloads data to selected worksheet cell
  • Multiple queries can be placed on a single worksheet
  • One button refresh for all queries in the workbook
  • Supports multiple accounts, multiple sources (connectors)

Includes:

  • Includes: free Google Analytics connector
  • Optional: selection of premium connectors


Extremely useful tool
“I have been using this tool for detailed SEO Reports, managing big loads of data. It’s very easy to use and has nearly all the features a web analyst needs. If combined with great excel skills, it can be a blast for killer reports.”
trafficseo | Sept. 8, 2016


Connectors

Analytics Edge Connectors work in any combination, are easily added, frequently updated and fully supported.

  • Mix-and-Match: pay only for what you need, add when you want
  • No Query Limits: use with multiple logins, profiles and queries
  • Secure: direct API connectivity from your computer
  • Safe: credentials encrypted on your computer, not on a server or in workbooks
  • Easy Install: simple installation and upgrade managed by the application

google-adwords

facebook-ads

bing-ads

google-search-console

google-analytics

facebook-insights

Plus:   Constant Contact, MailChimp, Bing Webmaster Tools,  Moz,  and more

Get Started (install an add-in)  top

Installed From the Add-ins!
Add the connectors you need at any time.