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

Monitor Your Web Hosting!

Don’t wait for your someone to tell you “Your site is running very slowly”. If you download this free spreadsheet, and click one button, once a month, you’ll be able to spot trends in poor Page Load Time, Domain Lookup Time, Connection and Redirection, and Page Download Time?

This free spreadsheet contains EVERY METRIC SUPPLIED BY […]

By |September 24th, 2014|Dashboard, Example, Uncategorized|Comments Off

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

Automatic Daily Publish

NEXT Analytics can automatically refresh and send spreadsheets to you each day
As of July 1, 2014, certain users of NEXT Analytics will receive a set of reports that contain up to date information. This feature has not yet been fully launched, it will be rolled out during the rest of the month.

For each type of data […]

By |July 2nd, 2014|Dashboard, Uncategorized|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 […]

Report Estimated AdWords Cross Device Conversions in Excel

Create a custom report showing AdWords Estimated Cross Device Conversions using the power of Excel. Build a detailed report that analyzes what device your customer uses to find your site versus what device they use to complete a conversion. Organize your data in an Excel spreadsheet and see trends in an instant. […]

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

Display AdWords Conversion Rate in Excel

Use the power of Excel spreadsheet to uncover Conversion Rate trends in AdWords marketing campaigns. Create custom dashboards in Microsoft Excel that visualize important trends in your conversion rate data. Customize your report the way you like and then use NEXT to refresh your AdWords Conversion Rate data automatically. Share your results […]