Analytics Edge makes it easy to get your data into your spreadsheet. You can place multiple queries anywhere in your workbook. More
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 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 Widget
Creating a dashboard 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.
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
Misunderstood Metrics: Facebook Insights
It can be confusing to download your data from Facebook Insights and try to recreate some of the online reports, only to discover the metric names don’t match. 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