Business dashboard template: GOOGLE ANALYTICS

/uploads/galerie/000003/GA Cockpit W.PNG

/uploads/galerie/000003/GA Cockpit D.PNG

Providea workbookcontaining at least14 attributes

Geta ready-to-use,best-in-marketGOOGLE ANALYTICS dashboard

Google Analytics Home

Get a Home Page for your Google Analytics dashboard

Google Analytics Cockpit

Get instant overview of the traffic on your web site

Google Analytics Top KPIs Overview

Get a transversal view on your top 6 Google Analytics KPIs, split by the dimension of your choice

Google Analytics Top KPIs Evolution

Visualize how your Google Analytics KPIs are evolving (Month-to-Date, Year-to-Date)

14 required attributes

Date
Channel Grouping
Device Category
Page Title
Country
City
Source / Medium
PageViews
Unique PageViews
Sessions
Bounces
Exits
Time on Page
Page Load Time

11 KPIs

12 dashboard pages

Detailed presentation of the GOOGLE ANALYTICS dashboard

Your GOOGLE ANALYTICS dashboard will contain 11 KPIs

Total SessionsTotal number of sessions
Avg Duration (s)Average duration per Session (s)
Total PageviewsTotal number of pageviews
Avg PageviewsTotal of pageviews per session
Avg Time on Page (s)Average time spent on a page (s)
Total Unique PageviewsTotal number of pageviews
Avg Unique PageviewsTotal of pageviews per session
Total BouncesTotal number of bounces
Bounce %Bounce rate
Page Exits %Page exits rate
Page Load Time (ms)Average page load time

and 12 dashboard pages

Home

Google Analytics Home

Get a Home Page for your Google Analytics dashboard

Cockpit

Google Analytics Cockpit

Get instant overview of the traffic on your web site

Google Analytics Top KPIs Overview

Get a transversal view on your top 6 Google Analytics KPIs, split by the dimension of your choice

Google Analytics Top KPIs Evolution

Visualize how your Google Analytics KPIs are evolving (Month-to-Date, Year-to-Date)

Web Traffic Analysis

Web Traffic Acquisition

Get instant understanding on which media and source are driving the most web traffic

Top Pages

Which web pages are the most seen on your web site?

GeoAnalytics

Google Analytics Country Analysis

Visualize the performance of any of your Google Analytics KPIs, at Country level

Google Analytics City Analysis

Visualize the performance of any of your Google Analytics KPIs, at City level

Trends Analysis

Google Analytics Trends Analysis

Visualize the evolution of any of your Google Analytics KPIs: Trends, Performance & Year over Year

Distribution Analysis

Google Analytics Segmentation Analysis

Visualize the value of any of your Google Analytics KPIs, split by the dimension you selected (market share analysis)

Google Analytics Pareto Analysis

Perform a Pareto Analysis on any of your Google Analytics KPIs: the 80/20 rule.

Google Analytics KPI Performance

Visualize the overall performance of any of your Google Analytics KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Creating your GOOGLE ANALYTICS dashboard Step-by-Step

You want to get a clear understanding on your Google Analytics results? You want to build a Tableau dashboard to better understand your Google Analytics data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Google Analytics data in less than 5 minutes!

Google Analytics dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Google Analytics data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

Date Reference date [ga:date] (Date used for time-series analysis)
Channel Grouping The default channel grouping that is chared within the View (Profile) [Acquisition - ga:channelGrouping]
Device Category The type of devide: desktop, tablet, or mobile [Users - ga:deviceCategory]
Page Title The title of the page [Behavior - ga:pageTitle]
Country The countries of users [Users - ga:country]
City The cities of users [Users - ga:city]
Source / Medium Traffic Source [Acquisition - ga:sourceMedium]
PageViews The total number of pageviews for your property [(Site Usage) Users - ga:pageviews]
Unique PageViews The number of different (unique) pages within a session [(Site Usage) Users - ga:uniquePageviews]
Sessions The total number of sessions [(Site Usage) Users - ga:sessions]
Bounces The total number of single page (or single engagement hit) sessions for your property [(Site Usage) Users - ga:bounces]
Exits The number of exits from our property [(Site Usage) Users - ga:exits]
Time on Page How long a user spent on a particular page in seconds [(Site Usage) Behavior - ga:timeOnPage]
Page Load Time Total page load time in milliseconds [(Site Usage) Behavior - ga:pageLoadTime]

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Google Analytics' and upload your Tableau workbook (note: your data is NOT uploaded).

Dashboard Template

Predefined (and customizable) KPIs
Predefined DataViz

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

The template attribute Your workbook attribute

Date Reference date [ga:date]

Channel Grouping The default channel grouping that is chared within the View (Profile) [Acquisition - ga:channelGrouping]

Device Category The type of devide: desktop, tablet, or mobile [Users - ga:deviceCategory]

Page Title The title of the page [Behavior - ga:pageTitle]

Country The countries of users [Users - ga:country]

City The cities of users [Users - ga:city]

Source / Medium Traffic Source [Acquisition - ga:sourceMedium]

PageViews The total number of pageviews for your property [(Site Usage) Users - ga:pageviews]

Unique PageViews The number of different (unique) pages within a session [(Site Usage) Users - ga:uniquePageviews]

Sessions The total number of sessions [(Site Usage) Users - ga:sessions]

Bounces The total number of single page (or single engagement hit) sessions for your property [(Site Usage) Users - ga:bounces]

Exits The number of exits from our property [(Site Usage) Users - ga:exits]

Time on Page How long a user spent on a particular page in seconds [(Site Usage) Behavior - ga:timeOnPage]

Page Load Time Total page load time in milliseconds [(Site Usage) Behavior - ga:pageLoadTime]

Finally, click 'Confirm & Download'... and your Google Analytics dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Google Analytics dashboard is now ready to be used or customized!

Just give it a try here :-)

Packs > Google Analytics

Google Analytics Home

Google Analytics Cockpit

Google Analytics Top KPIs Overview

Google Analytics Top KPIs Evolution

Detailed presentation of the GOOGLE ANALYTICS dashboard

Your GOOGLE ANALYTICS dashboard will contain 11 KPIs

and 12 dashboard pages

Home

Google Analytics Home

Cockpit

Google Analytics Cockpit

Google Analytics Top KPIs Overview

Google Analytics Top KPIs Evolution

Web Traffic Analysis

Web Traffic Acquisition

Top Pages

GeoAnalytics

Google Analytics Country Analysis

Google Analytics City Analysis

Trends Analysis

Google Analytics Trends Analysis

Distribution Analysis

Google Analytics Segmentation Analysis

Google Analytics Pareto Analysis

Google Analytics KPI Performance

Creating your GOOGLE ANALYTICS dashboard Step-by-Step

1st STEP: Create the initial Tableau workbook file

2nd STEP: Upload your Tableau workbook file

Dashboard Template

Sales

Finance

Procurement

Digital Marketing

Supply Chain & Production

Human Resources

Processes

Case Management

Banking

Healthcare

Telecommunications

Fundraising

Insurance

3rd STEP: Map your attributes

Other #DataViz Packs

Dashboard Template

Sales

Finance

Procurement

Digital Marketing

Supply Chain & Production

Human Resources

Processes

Case Management

Banking

Healthcare

Telecommunications

Fundraising

Insurance

Custom Dashboard

Communicate & Monitor

Analyze & Understand

Legal

Contact