Monthly Trend of Ecommerce Metrics (a Customizable Dashboard)

All of the metrics relating to Ecommerce, conveniently in one screen. Shows the trend of values for every metric over a 12 month period.

Get the spreadsheet here:google-analytics-ecommerce-metrics

Click the Refresh Data button on the ribbon bar. Your own data will show.
Customize It
Open the worksheet named “_actions”.

Change the year and month to a 12 month range […]

By |September 18th, 2014|Dashboard, Example, Google Analytics, Scripting|Comments Off

How To Configure a Multi-Profile Report

Google Analytics allows you to create subsets of your web site data; each one is known as a PROFILE. It’s quite common for companies to create a PROFILE for each operational division of their business. For example, this might mean each country unit has its own PROFILE. Alternatively, it might be something other than […]

How Do I Find my Google Analytics Profile ID?

After running setup, the software will guide you through authorizing data access, and choosing your default profile.

From then on, many reports will always use that default.
Changing the Default Profile
If you would like to change the default profile, simply select it from the profiles list and click “Save Default”

A dashboard with multiple profiles on it:
Here’s […]

By |May 23rd, 2014|Google Analytics|Comments Off

Make Google Analytics Weeks Start on Mondays

Frustrated that Google Analytics displays weekly metrics starting on Sunday? With NEXT Analytics, querying weekly data that starts on Mondays is easy—like “you’ve got to be kidding me” easy. In fact, you can tell NEXT to fetch weekly data starting on any day of the week. With NEXT Analytics, you’re in control.

Select […]

By |May 23rd, 2014|Example, Google Analytics|Comments Off

Excellent Analytics for Excel Users

Microsoft Excel: The Perfect Tool for Custom Reports and Dashboards
Excel is a useful tool for preparing and presenting data to managers in an organization.

Working in Excel means one less tool to keep track of
Excel is a familiar interface
Excel lets you combine data from multiple data sources
Use Excel formulas, charts, and pivot tables
Excel lets you […]

Upgrade from Excellent Analytics

Why upgrade From Excellent Analytics?
Excellent Analytics is a free Excel Addin that brings Google Analytics directly into a spreadsheet. People love it and it’s free.

The problem is that it was last updated in 2012. The Google Analytics team has expanded what it provides, but the users of Excellent Analytics are still working with only the […]

Build Custom Queries with Google Analytics, Twitter, Facebook and YouTube Data

Our new video showcases the speed and power of NEXT’s built-in custom queries tools. The 10-minute video showcases the NEXT Analytics Addin for Microsoft® Excel, covering how to build custom Web analytics and social media queries with Google® Analytics, Facebook®, Twitter, and YouTube™.

What to Do When Google Analytics Generates a Sampled Data Set

When you have a busy site, large data can become a problem. NEXT can help with that.

The Problem with Large Data


your reports get sampled data, or
they take a long time to refresh because the software is constantly re-fetching historical data.

Avoid both these problems with NEXT.

What is Data Sampling?

Sampling in Google Analytics (or in […]

By |September 9th, 2013|Google Analytics|Comments Off

NEXT Analytics implements new Google Analytics API

Tuesday, July 09, 2013 Google Analytics announced the release of 40 new Data points. NEXT Analytics has been updated to implement the new Google Analytic API changes. You can download the current version of NEXT Analytics here. Your license key will work with the updated version.
Here are some of the details for the 40 […]

By |July 10th, 2013|Google Analytics|Comments Off

NEXT Analytics and Tableau: Heat Maps

This article provides step-by-step instructions on how to use Next Analytics and Tableau together to create a heat map for almost any NEXT Analytics query that involves a geographic dimension by using NEXT Analytics to put data into Tableau to create heat maps that you can customize. Now you can see your data […]

By |July 10th, 2013|Google Analytics, Tableau|Comments Off