Avoid Google Analytics BigData Problems

Download data from Google Analytics to local storage to avoid #BigData Problems

 

 

 

 

 

 

For many web sites, Google Analytics will send sampled data (also known as Fast Access Mode). The problem is that, when sampled data is present, the numbers are wrong, making them useless for many types of business decisions.

Some software solutions, including NEXT Analytics, can automatically break up […]

By |April 30th, 2015|Data Mining, Google Analytics, Support, Web Analytics|Comments Off on Avoid Google Analytics BigData Problems

Build Reports and Dashboards with Multiple Google Analytics Segments

Build Reports and Dashboards with
Multiple Google Analytics Segments

By |April 26th, 2015|Google Analytics, Support|Comments Off on Build Reports and Dashboards with Multiple Google Analytics Segments

Including Multiple Google Analytics Views

How To Build Reports and Dashboards with Multiple Google Analytics Views

By |April 24th, 2015|Google Analytics, Support, Uncategorized|Comments Off on Including Multiple Google Analytics Views

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

By |November 5th, 2014|Data Mining, Example, Excel, Google Analytics, Web Analytics|0 Comments

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

By |October 25th, 2014|Data Mining, Excel, Google Analytics|0 Comments

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

You […]

By |October 23rd, 2014|Google AdWords, Google Analytics|Comments Off on Ad Group Top Performers over Last Calendar 13 months

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. It’s […]

By |October 9th, 2014|Google Analytics, Scripting, Uncategorized|Comments Off on What keywords are driving your Goal Completions?

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

By |October 9th, 2014|Google Analytics, Uncategorized|Comments Off on Analyze how Referrals are driving your Goal Completions

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

This […]

By |October 9th, 2014|Google Analytics, Uncategorized|Comments Off on How Traffic Source and Medium affects your company’s Goal Completions

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

By |October 6th, 2014|Dashboard, Example, Excel, Google Analytics, Uncategorized|Comments Off on Google Analytics Monthly Goals Scorecard