Business dashboard template: GOOGLE ANALYTICS

dashboard template for tableau on Digital & Social Media Google Google Analytics cockpit

Providea workbookcontaining at least13 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 a clear picture on your web site traffic: What is the performance of our Web Traffic? Which channels bring us the most sessions? What are the referral sites that send us the most traffic? Where does our traffic come from? What are the most visited pages?

Google Analytics Top Performers

Get an instant understanding of your top Google Analytics performers: current, mid and long term performance

Web Traffic Acquisition

Visualize which channels and sources are driving your web traffic: Which channels bring us the most sessions? What are the sources of traffic?

13 required attributes

Date
Channel Grouping
Device Category
Page Title
Country
Source / Medium
PageViews
Unique PageViews
Sessions
Bounces
Exits
Time on Page
Page Load Time
...add your own attributes!

11 KPIs

8 dashboard pages

Required Attributes

To get your Google Analytics dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

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

KPIs

Your Google Analytics dashboard will contain 11 KPIs

Total SessionsTotal number of sessions
Session DurationAverage duration per Session (s)
Total PageviewsTotal number of pageviews
Avg PageviewsTotal of pageviews per session
Avg Time on PageAverage 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 TimeAverage page load time

Dashboard Pages & Data Visualizations

Your Google Analytics dashboard will contain 8 pages

Home

Google Analytics Home

Get a Home Page for your Google Analytics dashboard

Cockpit

Google Analytics Cockpit

Google Analytics Top Performers

Get an instant understanding of your top Google Analytics performers: current, mid and long term performance

Top 4 KPIs Trends (MTD/YTD)

Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Web Traffic Analytics

Web Traffic Acquisition

Visualize which channels and sources are driving your web traffic: Which channels bring us the most sessions? What are the sources of traffic?

Top Pages

How efficient are our top visited pages?

Behavioral Analytics

Google Analytics Adhoc Analysis

Perform simple ad-hoc analysis on your Google Analytics data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

GeoAnalytics

Google Analytics Country Analysis

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

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) [Channel Grouping - ga:channelGrouping]
Device Category The type of device: desktop, tablet, or mobile [Platform or Device - ga:deviceCategory]
Page Title The title of the page [Page Tracking - ga:pageTitle]
Country The countries of users [Users - ga:country]
Source / Medium Traffic Source [Acquisition - ga:sourceMedium]
PageViews The total number of pageviews for your property [Page Tracking - ga:pageviews]
Unique PageViews The number of different (unique) pages within a session [Page Tracking - ga:uniquePageviews]
Sessions The total number of sessions [Session - ga:sessions]
Bounces The total number of single page (or single engagement hit) sessions for your property [Session - ga:bounces]
Exits The number of exits from our property [Page Tracking - ga:exits]
Time on Page How long a user spent on a particular page in seconds [Page Tracking - ga:timeOnPage]
Page Load Time Total page load time in milliseconds [Site Speed - 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).

Collapse All Expand All