Providea workbookcontaining at least14 attributes
Geta ready-to-use,best-in-marketGOOGLE ANALYTICS dashboard
Google Analytics - Home
Google Analytics - Home
Get a Home Page for your Google Analytics Dashboard
Trends Analysis
Trends Analysis
Visualize the evolution of the KPI you selected: Trends, Performance & Year over Year
Google Analytics Cockpit
Google Analytics Cockpit
Get instant overview of the traffic on your web site
Top Pages
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
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
Get a Home Page for your Google Analytics Dashboard
Cockpit
Google Analytics Cockpit
Google Analytics Cockpit
Get instant overview of the traffic on your web site
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
Visualize how your Site Usage Performance is evolving (Month-to-Date, Year-to-Date)
Web Traffic Analysis
Top Pages
Top Pages
Which web pages are the most seen on your web site?
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
Visualize the performance of the KPI you selected at Country level
City Analysis
City Analysis
Visualize the performance of the KPI you selected at City level
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
Visualize the value of the KPI you selected split by the dimension you selected (market share analysis)
Pareto Analysis
Pareto Analysis
Flexible Pareto Analysis (80 / 20 analysis)
KPI Performance
KPI 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 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) Bahavior - ga:timeOnPage]
-
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
Get a Home Page for your Google Analytics Dashboard
Cockpit
Google Analytics Cockpit
Google Analytics Cockpit
Get instant overview of the traffic on your web site
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
Visualize how your Site Usage Performance is evolving (Month-to-Date, Year-to-Date)
Web Traffic Analysis
Top Pages
Top Pages
Which web pages are the most seen on your web site?
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
Visualize the performance of the KPI you selected at Country level
City Analysis
City Analysis
Visualize the performance of the KPI you selected at City level
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
Visualize the value of the KPI you selected split by the dimension you selected (market share analysis)
Pareto Analysis
Pareto Analysis
Flexible Pareto Analysis (80 / 20 analysis)
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 :-)
