How can I help? Email: support@analyticsedge.com
BETA: AnalyticsEdgeTroubleshooter-64bit.exe for 64-bit Excel installations
BETA: AnalyticsEdgeTroubleshooter-32bit.exe for 32-bit Excel installations
The Analytics Edge Add-in for Excel is an add-in for the Windows version of Microsoft Excel that provides spreadsheet report automation tightly intergrated with Excel.
When you install the Analytics Edge Add-in for Excel, a new ribbon bar will appear in Excel. License status is visible on the License button (‘License ok’). Starting with version 11, all connectors are pre-installed but they are still licensed separately.
More The Constant Contact Connector for Analytics Edge makes it possible to interact directly with the Constant Contact API, automating your downloads and updates. More
How can I help? Email: support@analyticsedge.com
The Analytics Edge Desktop App is a standalone application that provides spreadsheet report automation to both Google Sheets and Excel files on Windows or MacOS computers.
When you open a file, the App interface mimics a typical spreadsheet application, with a menu bar, a strip to display or edit cell contents, a worksheet display area, and a task pane area.
The Analytics Edge Exporter products allow you to automate the download of data into simple CSV (comma-separated) or TSV (tab-separated) files that can be imported into virtually any application. There is no programming or knowledge of the APIs required; the query wizards use report-friendly field names and provide a simple, yet powerful capabilities to download and fine-tune your data in report-friendly formats. Download now
More
To get started with the Facebook Insights connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Facebook Insights button and select the Accounts menu item. More
The License wizard for the Analytics Edge Add-in for Excel [and the Analytics Edge Desktop App] provide a single location to manage product configuration and licensing. More
With this option, you can record a sequence of functions that can easily be edited and refreshed. Macros are created and edited using the Task Pane located to the right of the sheet. More
Choosing the Mode on the Analytics Edge ribbon lets you decide if you want a macro function or connector function to start an Analytics Edge Macro, a Quick Query, or simply run the function once (Interactive). More
Available only for connector queries, selecting this option targets a new, refreshable query to be written to the selected worksheet/cell. After the query runs you will be presented with optional Quick Functions wizard. Intermediate results are visible in the ‘ᴁ Step Results’ worksheet behind the wizard. When you are ready, click the Write to Worksheet button to write the results to the originally selected worksheet/cell location. More
The Account Infomation wizard is used to list details about one or all saved accounts. More
The Accounts wizard is used to manage saved Bing Webmaster Tools accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More
This wizard is used to authorize Constant Contact login accounts to be used by the version 3 API queries. More
The Accounts wizard is used to manage saved Google Business Profile accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use.
More
Use this wizard to log in to your Facebook account and authorize Analytics Edge to access your data. More
The Accounts wizard is used to manage saved Google Ads accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use.
More
The Accounts wizard is used to manage saved Google Analytics accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More
For security reasons, Analytics Edge stores your account information on your computer, not in the workbooks. Accounts are stored using Reference names, and the queries use a Reference name to identify which account to use. More
The Accounts wizard is used to manage saved Google Search Console accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use.
The Accounts wizard is used to manage saved LinkedIn Ads accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More
The Accounts wizard is used to manage saved Microsoft Ads accounts for use by the connector. For security reasons, Analytics Edge stores your account information in an encrypted file on your computer, not in the workbook. Accounts are stored using Reference names, and the queries in your workbooks use a Reference name to identify which account to use. More
The Ads Reports wizard of the Facebook Ads connector allows you to get a list all ad accounts, campaigns, ad sets or ads in your account. More
The Ads Reports wizard of the Facebook Ads connector allows you to get a report of your ads preformance. More
The Ads Reports wizard of the Google Ads connector is used to report the performance of your Google campaigns and ads.
More
Beta – this function is subject to change and may not retain backward compatability!
Send selected columns along with some instructions to an AI service, getting tabular and text responses. More
Append to the existing data in a worksheet, aligning columns to match. More
Use this Analytics Edge connector wizard to download the results of a GoogleSQL query from Google Big Query. More
Use this Analytics Edge connector function to download Google Big Query table data into your spreadsheet. More
The Campaign Reports wizard is used to generate reports about selected campaigns.
The Chrome UX Report wizard of the Google Search connector will pull results from the Chrome UX API [may be quota limited]. More
This Analytics Edge wizard is used to convert columns from one data type (text, number, or date) into another. It can also convert to a variant of the same type, like converting dates to first of the month. Typically used to force imported data into the correct type (such as dates with odd formats), it can also be used to convert dates and numbers into specific formats for reporting purposes. More
The Customers wizard of the Google Ads connector is used to list customers for a selected login accounts. With regular Ads accounts, it will list your account, but for MCC accounts, it will list all customer accounts associated with the MCC account. More
The Customers wizard of the Microssoft Ads connector allows you to get a listing of the customers available to a selected login account. More
Analytics Edge supports Microsoft .NET Framework date format codes which are slightly different from Excel date format codes. The common variants are listed below, but see the references at the end for a full listing. More
This wizard lets you see information about the product installation and allows you to perform a self-test to verify the functionality required for account logins. If you contact support about a probem, please include a copy of this information.
After the product has been activated, you can change the location of the default folders or reactivate the license key after a computer update.
This wizard lets you change the folder location of the database and the default location for exported files. You should backup the database file before changing the folder!
If you purchase a license key for the product (there is a button provided), you can enter and activate it here.
Once a query has been made, you can make a few refinements to the data before it is saved. The last function at the bottom is a critical step: specifying the file to be saved. More
You can schedule a query to be automatically refreshed daily, weekly or monthly. You can also run a refresh from a command line. Note that the options differ on MacOS from what is shown below (for Windows).
The setup process for the Analytics Edge Exporter products starts with agreeing to the Software License Agreement and Privacy Policy.
Download your data for a GA4 Realtime report. This wizard lets you select an account and GA4 property. select the fields, filters and sort criteria for the report.
GA4 Realtime reports show traffic in the last 30 minutes.
The Account Information wizard of the Google Analytics connector allows you to get listing of the saved accounts and the Google Analytics properties available in them. More
The GA 4 Reports wizard of the Google Analytics connector allows you to get a custom report for your GA property. More
This page opens when you try to open a file or folder in Google Drive. Since Analytics Edge products are installed, not web-based, they cannot be opened in a browser, but you have granted permission for the product to access the file or folder.
This Analytics Edge wizard lets you pick the date range for your Facebook Insights query. More
This Analytics Edge wizard lets you select the Facebook Insights metrics you want. More
Use this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query. More
This wizard is provided to enable deprecated Multi Channel Funnel queries for Universal Analytics.
Analytics Edge supports Microsoft .NET Framework format codes which are slightly different from Excel format codes. The common variants are listed below, but see the references at the end for a full listing. More
This Analytics Edge wizard lets you select the date range to be used for the query. More
This Analytics Edge wizard allows you to select a Facebook account and page, and get back details about the posts on that page. More
The PageSpeed Insights wizard of the Google Search connector will pull results from the PageSpeed API [may be quota limited]. More
This Analytics Edge wizard lets you pick the date range for your Facebook Post Insights query. All posts created in this date range will be included in the results. More
This Analytics Edge wizard lets you select the Facebook Post Insights metrics you want. More
Use this Analytics Edge wizard to select one of your saved logins, and the Facebook Page you want to use for this query. More
Following a Quick Query, the Quick Functions wizard allows you to Pivot, Arrange, Sort or Filter your data as well as provides options to Write the results. More
This Analytics Edge wizard is used to read the data from a Google Sheets worksheet. It always reads the entire sheet. More
This Analytics Edge wizard allows you to import a text file into a table. It accepts both delimited files as well as fixed-width fields. More
Read a worksheet into a table in memory. More
Analytics Edge lets you automate worksheet refreshes without coding — all functions are wizard-based. This wizard converts the current macro into a Repeating Macro. Repeating macros allow you to load a tables of values from a worksheet to be used as Analytics Edge named ranges while running the rest of the macro. More
The Reports wizard of the Bing Webmaster connector allows you to get a variety of reports on the status and performance of your websites. More
The Reports wizard of the LinkedInAds connector allows you to get a report of the performance of your ads. More
The Reports wizard of the Microsoft Ads connector allows you to get a report of the performance of your ads. More
This wizard lets you save an Excel workbook copy or your report, and optionally email it to someone. Email options include SMTP email or Google Gmail. More
This wizard lets you save an Adobe PDF copy of the Excel workbook, and optionally email it to someone. Email options include SMTP email or Google Gmail. More
This application is used to managed schedule refreshes for the Analytics Edge Add-in for Excel on Windows computers. If you have problems with a scheduled refresh, see the troubleshooting guide. More
The Search Analytics wizard of the Google Search connector allows you to get a report of the performance of your websites in Google Search.
More
Download a list of the accounts, sites or sitemaps for the selected account and/or website. More
This Analytics Edge wizard lets you save the current table, and switch back to it or reference it later in the macro. It can also assign Analytics Edge range names to all the columns. More
This Analytics Edge wizard lets you keep or remove a specific number of the top or bottom rows. More
This Analytics Edge wizard is used to create a numeric aggregate row or column, like Total or Average. You can choose to aggregate only the first or last group of numeric rows or columns, and position the results before or after the numeric data, or to remove the original (now aggregated) data completely. More
This wizard is provided to enable deprecated Universal Analytics queries.
Get one or more Url Inspection results from the Google Search API [limited to 2000 per day per site]. More
This Analytics Edge wizard is used to get the Facebook share metrics for any URL or list of URLs. More
