Google Cockpit W.PNG Google 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

KPi 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

Visualization 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 KPIs

Google Analytics KPIs
Google Analytics KPIsGoogle Analytics KPIs
Understand the contribution to the performance of your top Google Analytics KPIs

Google Analytics Top KPIs Evolution

Google Analytics Top KPIs Evolution
Google Analytics Top KPIs EvolutionGoogle Analytics Top KPIs Evolution
Visualize how your Site Usage Performance is evolving (Month-to-Date, Year-to-Date)

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

Country Analysis

Country Analysis
Country AnalysisCountry Analysis
Visualize the performance of the KPI you selected at Country level

City Analysis

City Analysis
City AnalysisCity Analysis
Visualize the performance of the KPI you selected at City level

Trends Analysis

Trends Analysis

Trends Analysis
Trends AnalysisTrends Analysis
Visualize the evolution of the KPI you selected: Trends, Performance & Year over Year

Segmentation Analysis

Segmentation Analysis

Segmentation Analysis
Segmentation AnalysisSegmentation Analysis
Visualize the value of the KPI you selected split by the dimension you selected (market share analysis)

Pareto Analysis

Pareto Analysis
Pareto AnalysisPareto Analysis
Flexible Pareto Analysis (80 / 20 analysis)

KPI Performance

KPI Performance
KPI PerformanceKPI Performance
Visualize the overall performance of the selected KPI: evolution and breakdown by the dimension of your choice

Getting this GOOGLE ANALYTICS dashboard: step-by-step

 

You want to get a clear understanding of your web site usage? You want to build a Tableau dashboard to better understand Google Analytics data?

Using LinPack-for-Tableau.com, you can generate a stunning Tableau dashboard on Google Analytics (Site Usage) in less than 1 minute!

 

Google Analytics dashboard Live Demo

 

For this, just follow the instructions :-)

 

1st step: Create a Tableau workbook with the connection definition to your Google Analytics account

You must retrieve at least the following attributes:

  • 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) Bahavior - ga:timeOnPage]
  • numeric
    Page Load Time Total page load time in milliseconds [(Site Usage) Behavior - ga:pageLoadTime]

 

The datasource screen should be configured as follow:

 

2nd step: On LinPack-for-Tableau.com, select 'create dashboard from template: Google Analytics' and upload your Tableau workbook

 

3rd step: Map your attributes, click 'Confirm & Download'... you're done!!!

 

This Google Analytics dashboard will help you better managing your web site investments: What is the overall performance of your website? Where do the sessions come from? Which is the most used device? What are the top pages? What are the most efficient channels?....

Home

Google Analytics - Home

Google Analytics - Home
Google Analytics - Home Google Analytics - Home
Get a Home Page for your Google Analytics Dashboard

Cockpit

Google Analytics Cockpit

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

Google Analytics KPIs

Google Analytics KPIs
Google Analytics KPIs Google Analytics KPIs
Understand the contribution to the performance of your top Google Analytics KPIs

Google Analytics Top KPIs Evolution

Google Analytics Top KPIs Evolution
Google Analytics Top KPIs Evolution Google Analytics Top KPIs Evolution
Visualize how your Site Usage Performance is evolving (Month-to-Date, Year-to-Date)

Web Traffic Analysis

Top Pages

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

Web Traffic Acquisition

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

GeoAnalytics

Country Analysis

Country Analysis
Country Analysis Country Analysis
Visualize the performance of the KPI you selected at Country level

City Analysis

City Analysis
City Analysis City Analysis
Visualize the performance of the KPI you selected at City level

Trends Analysis

Trends Analysis

Trends Analysis
Trends Analysis Trends Analysis
Visualize the evolution of the KPI you selected: Trends, Performance & Year over Year

Segmentation Analysis

Segmentation Analysis

Segmentation Analysis
Segmentation Analysis Segmentation Analysis
Visualize the value of the KPI you selected split by the dimension you selected (market share analysis)

Pareto Analysis

Pareto Analysis
Pareto Analysis Pareto Analysis
Flexible Pareto Analysis (80 / 20 analysis)

KPI Performance

KPI Performance
KPI Performance KPI Performance
Visualize the overall performance of the selected KPI: evolution and breakdown by the dimension of your choice

Just try it here :-)

 

DON'T WANT TO READ? Play the video!

 

Enjoy and share your feedbacks with us so we can improve the solution :-)

Other #DataViz Packs