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

When reporting Google Analytics visits by source, if you have a lot of people coming to your site from web-based email, and you aren’t using any campaign tracking parameters on your links, you may get a lot of sources that look like:
us.mg1000.mail.yahoo.com
us.mc534.mail.yahoo.com
sn117w.snt117.mail.live.com
co120w.col120.mail.live.com
There may be plenty of variants for each of the various mail servers, and [...]

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

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.

Behind every Next Analytics dashboard and report is a series of script commands. These simple text strings start with a command name and are usually followed by comma-separated parameters. When we added the ability to make Google Analytics queries, we had to create a new script command that would translate into a full query behind [...]

For many reports, it is good to see the largest items in a list (top 10 web pages, top 20 keywords, etc). You are only getting part of the story if you don’t keep those items in perspective to the whole – what was the total for all the rest of the items? In this [...]

By using Nextanalytics for Excel to load and pivot your data, you gain immediate access to information you can use. You don’t have to struggle with changing field formats, building transformation formulas or struggling with Excel’s complicated pivot tables.

When building a trend report with Nextanalytics for Excel, you have complete control over the date format displayed. By displaying only the year or month components, the data is automatically aggregated accordingly.

When you get data from other systems (or other countries), you will invariably run into a problem with incompatible date formats. With Nextanalytics for Excel, you can easily adapt to any incoming date format without much effort — and no formulas!