USA Map Overlay for Google Analytics in Excel

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.

How Do I…Create a monthly summary report? Part 2

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

Getting Facebook Insights Data into Excel

Now that Next Analytics supports the Facebook API, it’s possible to build Excel dashboards and reports that automatically refresh with your Facebook fan page activity and fan demographic information. As with all programming interfaces, the Facebook API takes a little getting used to, so in this article, I will walk you through a quick introduction [...]

Average time on site and average pageviews revisited

I read Michael Whitaker’s web analytics blog today about average time on site and average page views, and since it ended with a question and a partial analysis, I thought I’d do a little digging into the topic. What Michael noted early on was that the average numbers do not show how the data is distributed, [...]

How Do I…Create a monthly summary report? Part 1

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

Reading Twitter in Excel with Next Analytics

I was really disappointed this week when Hootsuite stopped telling me what Twitter messages were ‘new’ since the last time I looked. That was the number one reason I used it, and the Twitter interface is missing this valuable feature. Well, there were a few things that bugged me about both Hootsuite and even the [...]