First-time web visitor landing page analysis

When you want to analyze first-time visitors to your web site, where they land first is often a key question. Maybe you had an email campaign with embedded links or you want to measure traffic from blogs that targeted special landing pages. Your challenge is to identify and report on the traffic to these special [...]

Website visitor engagement report

Using Google Analytics web analytics service to monitor your web site gives you some excellent metrics to monitor the engagement level of your site visitors. Engagement is typically measured with four distribution reports that explore your visitors’ loyalty, recency, and the duration and depth of visit profiles. Distribution reports can be very difficult to program [...]

Adding interactivity: selecting a web profile

When building a web analytics dashboard, adding interactivity is often required to make the application truly useful. In this example, you will see how we can add a web profile selector to our web dashboard with very little effort.

Making a pivot table simple

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.

Changing the display date format

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.

The easy way to convert date formats

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!

Adding a top 10 chart

This is part of a series showing how easily you can build a daily web dashboard using Nextanalytics for Excel with the new Google Analytics connector. In this article, I want to show how to add a new item to an existing workbook (our Daily web dashboard). Along the way, you will see how easy [...]

Daily web dashboard

If you track your web site with the Google Analytics web analytics service today, it is really easy to create a dashboard in Excel that shows key metrics of your web site — and refresh it daily with a single click! All you need is Nextanalytics for Excel along with your copy of Microsoft Excel [...]

Welcome to the new analytics edge

We have a new Nextanalytics product line (Nextanalytics for Excel), so it is only fitting that we launch a new support forum for our community. I’ve had this domain for a while as well, and it is appropriate to join the two — Nextanalytics really does give you an edge in analytics today!
With this new [...]