I have seen tag clouds used all over the web to visualize what keywords are the most  popular, and thought it would be a good additional to the Next Analytics dashboard collection.  Tag clouds can easily be applied to situations where you want to see what people are looking for or talking about — anywhere [...]

Next Analytics was already the best Excel add-in for automating your Google Analytics reporting, but with the release of version 3,1, we have included a Batch Scheduler and a Command Line Utility that take things to a whole new level of automation. And with 3.1, you can also get Facebook, Twitter, LinkedIn and even SQL [...]

When making weekly reports from the Google Analytics API, it is most efficient to download your data using Google’s year and week dimensions. This produces a row of data for each calendar week in the report, but it leaves you with a report that contains no dates — just week numbers. Most people don’t think [...]

I saw a tweet today about an old Google Analytics blog article about custom reporting, and in the comments, it seemed that everyone wanted a simple report showing the popularity of various browser versions. That is not a report you can make using Google Analytics custom reports, so it has gone unanswered…until now. Using the [...]

I made a quick little modification to the Map Overlay dashboard I described in our popular blog article, and produced the same dashboard, but focussed specifically on that USA market.

This is part 2 of a series for the new Next Analytics user, walking through how to create a simple monthly summary report (see Part 1). In this article, I am going to explore how to show distribution of visits over a couple of dimensions:

Show the visits by the traffic source (medium)
Show the visits of [...]

For a new Next Analytics user, the tool can seem quite daunting, so in this article, I will walk through how to create a simple monthly summary report using Next Analytics version 3.0. I am going to roll in a number of common challenges, including:

Show a common metric like visit count
Show a calculated metric like [...]

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 [...]

The Next Analytics for Excel v3 beta is PUBLIC!
Try the v3 Beta, available for Excel 2007 and Excel 2010 (2003 version coming soon).
Now it is possible for you to download and analyze Twitter, Facebook, LinkedIn, Constant Contact and more information sources — all at once! Build an Excel dashboard that pulls information from all those [...]

I was building an Excel dashboard last week, this time about traffic sources from Google Analytics, when I realized it was time to bring together two of the most useful analytics functions: trends and segmentation. We get a lot of requests for segmented trends, and we’ve published an interactive workbook with the functionality (Segmented Trends), [...]