Google Analytics Custom Events Dashboard and Reporting

Google allows you to store information about what a web visitor does while they are using your web site. By default, it gives you a wealth of information, but often you want to track things that are unique to your organization. They provide a couple of ways for you to store your own specific […]

Google Analytics – All-in-one Dashboard

it already has every single metric plotted for the past twelve months. Just click a button, and all your data shows up.

It’s easy to customize. There are three flavors of it, take your pick and customize one of them:

Dark themed charts
Light themed charts
All the charts on one worksheet

There’s nothing to learn. Just is delete […]

By |September 25th, 2014|Dashboard, Example, Excel, Google Analytics|Comments Off

Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet

Get a complete 12 month overview of everything that happened relating to Adwords. This easily customizable Dashboard runs inside Excel and is free for users of NEXT Analytics. Just download it, and one click later, you’ll know how well your pay per click campaigns are doing.
Download it

Customize It
It’s a simple Excel spreadsheet, so it’s easy […]

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™.