Using Excel to report web analytics is fraught with challenges. This article explores how Next Analytics for Excel overcomes the 6 major obstacles.

Next Analytics has an extensive search and replace capability (“Fix” tab)  that includes regular expressions as well as partial and exact match functions. These expressions are saved into comma-separated-value (CSV) files in the user’s Documents directory structure, making them reusable from multiple spreadsheet reports. By referencing files in the file system, though, each workbook is [...]

Next Analytics has a growing list (over 40) of free Excel dashboards and reports that work with our product. Each was created to report on a specific time period, be it 3 days or 13 months, that moves with the calendar so all you have to do is click Refresh and the time period is [...]

Many of the free Excel dashboards available from Next Analytics combine the results from multiple Google Analytics queries into the various elements of one Excel “dashboard” worksheet, but it may not be obvious how you would build such a combination report from the user interface. It is actually quite easy, and in this article, I will [...]

New Next Analytics users sometimes have trouble identifying a Google Analytics profile ID for use in our templates and examples. No, it is NOT the UA-xxxxxxx-x number you used in your tracking code. Here’s the scoop…
When you login to Google Analytics, you gain access to a number of Analytics accounts. Each Analytics account has an account ID [...]

For many reports, it is good to see the largest items in a list (top 10 web pages, top 20 keywords, etc). You are only getting part of the story if you don’t keep those items in perspective to the whole – what was the total for all the rest of the items? In this [...]