Reduce Google Analytics Page Bounces with Excel

How I Use Excel to Reduce Page Bounces and Improve My Conversions
In my role as CTO of NEXT Analytics, I see a lot of dashboards going through my inbox. Over the years, I’ve seen literally thousands of dashboards, all built by experts from all over the world. I have a confession to make :), I don’t actually use […]

Download-and-Analyze-Traffic-Source-Medium-Product-Revenue-Into-Excel

Discover the channels that drive the sales of your best and worst sellers
This is one immediately useful topic that you can invest your time and get a true payback.

Start by getting Google Analytics dimensions “Source and Medium” and eCommerce “products” for the past year into an Excel Spreadsheet.

This will show you:

For each product, which channel performs better
For each channel, […]

Ad Group Top Performers over Last Calendar 13 months

Quickly recognize your Most Profitable Ad Groups
Hey folks, any of you conduct Adwords campaigns? Do you need to produce a report that’s more detailed than campaign level, but not too much detail such as keywords or ad content? This handy report lists all of the Ad Groups for the past 13 months, only completed […]

By |October 23rd, 2014|Google AdWords, Google Analytics|Comments Off

What keywords are driving your Goal Completions?

What keywords are driving your Goal Completions?
Your site has been catalogued by search engines for its keywords and visitors come to your site based on a link to one of your pages. Google Analytics will log the keywords that were in effect at the time of the first click.

These visitors were looking for something. […]

By |October 9th, 2014|Google Analytics, Scripting, Uncategorized|Comments Off

Analyze how Referrals are driving your Goal Completions

Analyze how Referrals are driving your Goal Completions
If you’ve been active in promoting your web site, you will have accrued a number of external sources who drive traffic to your web site. These could be A-List bloggers, industry analysts, critics and fans, and members of your partner or affiliate network.

Reaching out to these groups […]

By |October 9th, 2014|Google Analytics, Uncategorized|Comments Off

How Traffic Source and Medium affects your company’s Goal Completions

Do you care to know how Traffic Source and Medium affects your company’s Goal Completions?
If you know which sources and medium combinations drive highest values in goal completions, you can optimize your marketing activities to promote the more favourable combinations. For example, you can increase or decrease paid advertising or organic search along specific […]

By |October 9th, 2014|Google Analytics, Uncategorized|Comments Off

Google Analytics Monthly Goals Scorecard

This Google Analytics Monthly Goals Scorecard is an Excel Web Analytics report that shows Goal Starts, Completions, Value, and Abandons for the current, previous, and same period one year ago as well as showing the growth and the net change.

You get a trend for twenty Goal values over the past twelve months.

In this sample workbook, only […]

Google Adwords – Ad Group Analytics – Top Ranking and Long Tail Views

This sample spreadsheet lets you see the top ranking Ad Groups by month over one year. When you can see which months and which Ad Groups were performing better, you can imitate the winners and drop the losers. For each Ad Group, in each Month, you get the following data.

Impressions aka ga:impressinos
Ad Clicks aka ga:adClicks
Ad Cost aka ga:adCost
Cost […]

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