Most people use Analytics Edge to download data from one of the connectors into Excel. This video shows how to create a macro that can contain multiple queries. Note that this video shows an older version of the add-in, so check out this page for the difference between quick queries and macros first.In an Analytics Edge Core Add-in macro, a simple query is a 2-step process:
- download the data, and
- write the results to Excel.
Here’s a quick video showing the process, getting data from Google Analytics: