Available for Windows or MacOS, works with both Microsoft Excel files and Google Sheets.
The new Analytics Edge Desktop App brings all the automation power of the Add-in to a standalone desktop application that works with both Microsoft Excel files and Google Sheets. Download your data with the built-in connectors, the combine and transform it as required before committing the results to your spreadsheet.
Data Sources
Google Ads, Google Analytics, and Google Search Console connectors are available in the early release with more coming soon. Pay only for what you need. Since you are querying the APIs direct from your computer, there are no account or query limits. Each connector offers all the dimensions and metrics available, and they are updated with new capabilities in a timely manner.
Quick Queries
Pick a spreadsheet cell, make a query using simple popup wizards, repeat as needed. Refresh all with a single click. Simple automation. No limits – use different accounts, different sources, all on the same worksheet or spread over several sheets. Copy and paste, quickly edit with the popup wizards, or get technical and work with the query definitions sheet — you do you. Get your work done fast, refresh whenever you want even faster.
Interactive Mode
Need to clean up some data or just download some data once? No problem – interactive mode lets you pick a location and pick a function. Analytics Edge will load the data and run the function, then save it back or write it to a new location.
Analytics Edge Macros
Want more insights and have a couple of minutes? Convert your Quick Query to a Macro and open the door to limitless analysis. No formulas or coding to learn; everything is wizard based! Replace text, remove duplicates, pivot, filter, sort, combine, lookup — 34 powerful wizard-based functions let you dig into your data in minutes. Easily work with data from multiple sources, making step-by-step changes and seeing the results as you work. Stay focused on your data, not writing code. Refresh in seconds.
