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

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