/uploads/galerie/000003/GA Cockpit W.PNG /uploads/galerie/000003/GA Cockpit D.PNG
14 required attributes
  • dateDate
  • stringChannel Grouping
  • stringDevice Category
  • stringPage Title
  • stringCountry
  • stringCity
  • stringSource / Medium
  • numericPageViews
  • numericUnique PageViews
  • numericSessions
  • numericBounces
  • numericExits
  • numericTime on Page
  • numericPage Load Time
11 KPIs
  • Total Sessions
  • Total Pageviews
  • Total Unique Pageviews
  • Total Bounces
  • Avg Duration (s)
  • Avg Pageviews
  • Avg Unique Pageviews
  • Avg Time on Page (s)
  • Bounce %
  • Page Exits %
  • Page Load Time (ms)

Detailed presentation of the GOOGLE ANALYTICS dashboard

Your GOOGLE ANALYTICS dashboard will contain 11 KPIs

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

and 12 dashboard pages

Home

Google Analytics Home

Google Analytics Home
Google Analytics HomeGoogle Analytics Home
Get a Home Page for your Google Analytics dashboard

Cockpit

Google Analytics Cockpit

Google Analytics Cockpit
Google Analytics CockpitGoogle Analytics Cockpit
Get instant overview of the traffic on your web site

Google Analytics Top KPIs Evolution

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

Google Analytics Top KPIs Overview

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

Web Traffic Analysis

Top Pages

Top Pages
Top PagesTop Pages
Which web pages are the most seen on your web site?

Web Traffic Acquisition

Web Traffic Acquisition
Web Traffic AcquisitionWeb Traffic Acquisition
Get instant understanding on which media and source are driving the most web traffic

GeoAnalytics

Google Analytics Country Analysis

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

Google Analytics City Analysis

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

Trends Analysis

Google Analytics Trends Analysis

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

Distribution Analysis

Google Analytics Segmentation Analysis

Google Analytics Segmentation Analysis
Google Analytics Segmentation AnalysisGoogle 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

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

Google Analytics KPI Performance

Google Analytics KPI Performance
Google Analytics KPI PerformanceGoogle 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!

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

3rd STEP: Map your attributes

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

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 :-)

Other #DataViz Packs