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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
I often find I have two lists of things and I want to filter one list based on the contents of the other; removing test pages from a top content report for example. In this week’s free Excel report, I added an “exclude” worksheet so that named service providers or specific regions or countries could [...]