Multiple Google Analytics Profiles in One Report

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

Screen height and width around the world

While working on our free spreadsheet report for last week, splitting the Google Analytics screen resolutions into a grid view, I noticed that some of the test sites had very different profiles of popular screen sizes. At first I thought this might be due to variation of discretionary capital (a.k.a. pocket money) in various countries [...]

A Google Analytics Map Overlay in Excel

This is the Microsoft Excel report element you’ve always wanted – showing a map of the world, highlighted to show where your website visitors come from. It is included in this week’s free dashboard, and Next Analytics will automatically create and update it. To learn more about the dashboard, see our Product pages. In this [...]

Does your website have a busy calendar?

Google Analytics uses a line chart across most of their pages, showing the trend of traffic over time. I guess the idea is that you can visually see trends from week to week, month to month, but that has never worked for me. The weekly bump and weekend dips make the chart busy and confusing. [...]

Day of Week Report for Google Analytics

It is surprisingly hard to get day-of-week information out of Google Analytics, and the ‘best’ scenario I have heard is to compare one week to another. That’s not much of a trend, but I guess it’s something. With Next Analytics for Excel, there is a simple way to get reports by day-of-week that lets you create [...]

Building One Excel Dashboard for Multiple Web Sites

There are a surprising number of people that are tracking multiple web sites with Google Analytics, and they often want to see a report or dashboard comparing and contrasting their performance. Next Analytics is one of the few products that makes this a simple task – here’s how.

Powerful Analytics Tip Every Website Should Employ

This blog article over at SEOmozBlog by Rand Fishkin professes the power of segmenting the usual trend charts by categories of pages, so it is easy to see whether traffic changes are due to blog articles or tutorial guides or whatever groupings make sense on your site. When I read the article, I immediately thought [...]

Monthly Metrics – Measuring your Keywords

Jim Gianoglio over at LunaMetrics posted an interesting blog yesterday, suggesting that there is value in tracking the number of keywords referencing your site over time. He laid out an interesting argument that it is supposed to give you a good indication of how well you fair on search indexing and whether there are issues [...]

Customer Intelligence from Google Analytics

I was looking at a report from a customer intelligence vendor last week and got thinking that a lot of the same data was available in Google Analytics, but it wasn’t very accessible in the normal reports that people use. Now I wouldn’t suggest we can replace the paid service entirely, but the value of [...]

Landing Page Performance Across Segments

In this week’s Excel dashboard, we look at website landing pages – which ones are your most effective and how different visitor groups treat them. Four major segments are shown side-by-side: direct traffic, visits from search engines, visits from referring web sites, and clicks from paid advertising. Leveraging Excel’s conditional formatting makes it easy to [...]