Analytics Edge products are designed to simplify your spreadsheet reporting from several perspectives:
Fast
Do you find it tedious to download data from multiple services?
Refresh your spreadsheets in seconds with data from popular services.
Get fresh data with connectors to Google Analytics, Google Search Console, Google Ads, Facebook Ads, and many other sources. Refresh all your queries with a single click, even if they are from multiple sources and multiple accounts. Analytics Edge products are designed to get you back to work as quickly as possible without waiting around for a shared server to process your request. Your computer does all the work!
No Code
Don’t have the time or desire to learn programming or formulas?
All queries and analytics functions are created with simple wizards.
No coding, no scripts, not even formulas; pick your accounts, fields, and options from the pop-up wizards. Functions like pivot, lookup, and combine are added simply by picking fields and options in a wizard. A series of function wizards can be combined into ‘macros’, automatically recorded for you. There is no need to learn API terminology or formula syntax. Work quickly, at a high level, and let the application handle the technical stuff.
Flexibile
Every report is slightly different and constantly changing?
Build reports fast with quick queries or perform unique analyses with macros.
Place queries where you want, in the same or different sheets, from the same or different sources. You control what data you want and where it goes. Copy and paste. Edit queries and functions with the same wizards they were created with. Use cell references in the wizards where it makes sense. Analytics Edge products are designed for the dynamic environment that spreadsheets provide. Changes are quick and easily done. When you need something more advanced, build a ‘macro’ by stepping through function wizards like match, split, duplicates or group.
Simple and Powerful
Complicated formulas and pivot tables leaving you in ‘spreadsheet hell’?
Analysis is easy with simple wizards combined into step-by-step macros.
Analytics Edge includes all the common functions like pivot, arrange, filter, and sort as well as more advanced functions like group, unpivot, split-to-rows, lookup, and combine. The results are always available as simple dates, text and numbers, not locked into a pivot table or other data structure. Read data from multiple workbooks, download data from the web, make simple API calls, and send reports via Gmail or Microsoft email. It supports concepts like loops and if statements without formulas or programming — every function is a simple wizard.
Value for Money
Have lots of accounts and queries but not a lot of money?
Analytics Edge is priced low, by computer, with no account or usage limits.
Analytics Edge products are installed and run on your computer. Account credentials (access tokens) are created, encrypted, and stored there. The application makes all the API calls direct to the API servers at Google, Facebook, Microsoft, etc. – your computer does all the work and gets all the results. You don’t pay (or wait) for a shared server to process your requests or data, and you reduce security and privacy concerns since there is no 3rd party data processor or account exposure. Connectors are priced at only $50 per year, the application (add-in or desktop app) is $99 per year.
Bottom line: Analytics Edge products let you get stuff done fast without spending a small fortune.