Business dashboard template: GOOGLE ANALYTICS (TRIAL VERSION)

Providea workbookcontaining at least14 attributes

Geta ready-to-use,best-in-marketGOOGLE ANALYTICS (TRIAL VERSION) dashboard

Google Analytics (TRIAL Version) Home

Get a Home Page for your Google Analytics (TRIAL Version) dashboard

Google Analytics Cockpit

Get instant overview of the traffic on your web site

Web Traffic Acquisition

Visualize which channels and sources are driving your web traffic

Top Pages

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

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

12 KPIs

4 dashboard pages

Detailed presentation of the GOOGLE ANALYTICS (TRIAL VERSION) dashboard

Your GOOGLE ANALYTICS (TRIAL VERSION) dashboard will contain 12 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
Daily SessionsAverage number of sessions per day

and 4 dashboard pages

Home

Google Analytics (TRIAL Version) Home

Get a Home Page for your Google Analytics (TRIAL Version) dashboard

Cockpit

Google Analytics Cockpit

Get instant overview of the traffic on your web site

Web Traffic Analytics

Web Traffic Acquisition

Visualize which channels and sources are driving your web traffic

Top Pages

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

Creating your GOOGLE ANALYTICS (TRIAL VERSION) dashboard Step-by-Step

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

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

Google Analytics (TRIAL Version) dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Google Analytics (TRIAL Version) 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 device: 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 (TRIAL Version)' and upload your Tableau workbook (note: your data is NOT uploaded).