Analytics Edge makes it easy to get your data into Microsoft Excel. You can place multiple queries anywhere in your workbook as this video explains. 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 video explains what is available and highlights the ‘account not found’ problem people experience when sharing workbooks. More
3 Reproducing Standard Reports
This video reviews the common problems that people have when trying to reproduce standard web reports in Microsoft Excel using Analytics Edge. More
4 Creating Custom Reports
Analytics Edge was designed to create the customized reports people need for their website or campaign tracking needs. This video explains the common errors you may run across and what you can do about them. More
5 Licenses and Updates
This video explains how Analytics Edge products are licensed and updated. It demonstrates how to identify updates available and how to install them. 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
Automated Email Campaign Reporting
Several Constant Contact Solution Providers use the Analytics Edge Core Add-in for Microsoft Excel to automate their clients’ campaign reports. More
Calculating a Weighted Average (Average of Averages)
A common reporting challenge in Excel is merging sets of data, such as combining monthly numbers for a quarterly or annual total. Adding up simple metrics is obvious, but what do you do with things like the average position or conversion rate? [Hint: you should not average or total anything that is already an average or ratio] More
Constant Contact: Autoresponder Reporting
Constant Contact offers some simple reports on your autoresponder campaigns, but little detail is available. Even through the API, the data is difficult to extract, but it can be done. This article details how Analytics Edge makes it possible to monitor your email series to see who each message was sent to, which ones bounced, whether they were opened, and whether they clicked on a link.
Constant Contact: Click-Through Data
Downloading Constant Contact click-through data for multiple clients has never been easier than with Analytics Edge and the Constant Contact connector. This article describes the process in detail, so you can get the job done fast! More
Constant Contact: Click-Through Data Analysis
In a follow-up to Downloading Constant Contact Click-Through Data, this article shows how Analytics Edge can easily turn the raw downloaded data into meaningful analytics without a lot of work or confusing formulas. More
Constant Contact: Email Cohort Analysis
This article explains how to build a cohort analysis report in Excel using the Analytics Edge Core Add-in with the Constant Contact connector. Cohort Analysis lets you see how one group of subscribers behaves differently from another. More
Constant Contact: Getting Started With The Connector
To get started with Analytics Edge and the Constant Contact connector, you need to install and register an Analytics Edge add-in. Then the Constant Contact connector needs to be installed — it will automatically activate a 30 day trial for you. More
Constant Contact: Reporting Automation
With Analytics Edge, your reporting gets a whole lot easier with single-click refreshes, and you don’t lose any of the flexibility that makes Microsoft Excel so popular for Constant Contact analytics reporting. Here’s an example of one engagement that went from idea to “This is AMAZING!!” in 24 hours. 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
How To: Email Campaign Domain Analysis
Find out how your email campaigns are performing with particular domains, so you can see which ISPs your subscribers use most often, and detect if you’re having delivery or compatibility problems. More