Question:
I refreshed the Visitor Overview workbook with the map, but the map is not updating.
Answer:
This workbook uses Visual Basic for Applications code to refresh the map. In Excel 2007/2010, there is a setting that needs to be enabled for the code to run.
In Excel Options, select Trust Center – Settings…
On the Macros Settings panel, check [...]

Question:
In the Traffic Source Trends dashboard you have “source/medium”. How did you concatenate the separate source and medium columns?
Answer:
The concatenated Medium/Source column is created the same way as the Year-Month combination for the chart horizontal axis in the same workbook — use the Analyze tab, (check the Advanced box at the bottom), and select the [...]

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

While I was building one of our weekly free Excel dashboards (Traffic Source Trends), I realized that most of our dashboards include an interactive dropdown with the Google Analytics advanced segments. While this is a great capability and is similar to the GA web interface, making comparisons between segments is difficult because you have to [...]

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

A number of people need to keep track of multiple web properties – their blog, support site, maybe a social media presence and their main web site. They may even have a series of related websites that they want to track independently. This week’s free Excel dashboard shows just how easily Next Analytics lets you [...]