Helpful Articles (filter at right)

2 Help Resources Available

The Analytics Edge help site has plenty of resources available for learning and assistance with reporting. This article explains what is available and highlights the ‘account not found’ problem people experience when sharing workbooks. More →

Account Deletion

To delete a saved account from Analytics Edge products, open the Accounts wizard for the service/connector involved, select the saved account from the list, and click the delete button. More →

Account Reference Names

Analytics Edge takes account security very seriously. When you use the add-in or one of the connectors to access one of your accounts, the product will encrypt a security token and save it to your computer. You will be asked for an account reference name for this token. More →

Creating an Excel Dashboard KPI Card

Creating a dashboard KPI/metric card or widget in Excel can be quite simple — it’s really just a matter of downloading the right data and some easy formatting techniques. Layout is your challenge, but even that can be overcome. This article discusses 3 ways to build a widget for your Excel report.

creating-a-dashboard-widget More →

Error: Account not found. Check Account wizard

This error usually occurs when you share workbooks with coworkers, or after a computer move or rebuild. Analytics Edge stores a reference to the account in the workbook, but the actual security tokens are stored on your computer.  More →

Error: Invalid/missing dates

This error usually occurs when the cells you referenced in a query have moved or the contents are changed. Analytics Edge connectors offer the ability to use cell references for the dates, but the references can get out of alignment if you add rows or columns in the worksheet, or if you renamed the worksheet. More →

Facebook Ads Bidding and Budgets

The Facebook Ads bidding and budget information may seem to work in mysterious ways, especially when you are trying to generate a report from the API. Here is a picture of how it fits together. More →

Please reduce the amount of data you’re asking for

When the Facebook Ads API returns an error 500, it is usually telling you that the combination of the number of metrics and rows of data being asked for is too large for them to process all at once. You may hit the limit around 1000 rows, or it could be higher or lower depending on the number of columns you are asking for. More →

Selecting a Date Range

In most Analytics Edge wizards, you can select a data range for your query. There are a large number of combinations possible, but here are the most common selections. More →