How Do I…Create a monthly summary report? Part 1

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

Change the Date Range of Our Free Dashboards

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

Reporting Multiple Google Analytics Profiles in One Excel Dashboard

Many of the free Excel dashboards available from Next Analytics combine the results from multiple Google Analytics queries into the various elements of one Excel “dashboard” worksheet, but it may not be obvious how you would build such a combination report from the user interface. It is actually quite easy, and in this article, I will [...]

Comparing lists and filtering out common items

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

How do I find my Google Analytics profile ID?

New Next Analytics users sometimes have trouble identifying a Google Analytics profile ID for use in our templates and examples. No, it is NOT the UA-xxxxxxx-x number you used in your tracking code. Here’s the scoop…
When you login to Google Analytics, you gain access to a number of Analytics accounts. Each Analytics account has an account ID [...]