Adding Queries

2020-01-25 The Analytics Edge Standard Add-in has been merged into the Analytics Edge Core Add-in (Standard license option) for existing licensed users only. The Standard Add-in itself has been discontinued and is no longer available.

The Analytics Edge Standard Add-in makes it easy to download data to your workbook. Just select the cell where you want the results put, then open a connector query wizard. When you click Finish and Write to Worksheet, the results are written into Excel.

Adding A Query

As an example, getting Source / Medium data from Google Analytics is a simple process: in Excel, on the Analytics Edge ribbon bar, click the Free Google Analytics connector button and select Analytics Reporting from the menu.

When the query wizard opens, select the standard report for Source / Medium, and click the Finish button.

When the Function wizard opens, you can quickly Pivot, Arrange, Sort or Filter the results, and the click Write to Worksheet to save the results to your worksheet.

Your data appears in Excel. Note the Excel comment (little red triangle) in the cell — this shows where the query was placed.

Adding More Queries

To download more data, simply select another worksheet cell and repeat the process. You can use different reports, different accounts, and even different connectors. Just keep some empty rows and columns between the results so your queries don’t interfere with each other.