Providea workbookcontaining at least14 attributes
Geta ready-to-use,best-in-marketGOOGLE ANALYTICS dashboard
Google Analytics Home
Google Analytics Home![Google Analytics Home]()
Get a Home Page for your Google Analytics dashboard
Google Analytics Cockpit
Google Analytics Cockpit![Google Analytics Cockpit]()
Get instant overview of the traffic on your web site
Top Pages
Top Pages![Top Pages]()
Which web pages are the most seen on your web site?
Google Analytics Top KPIs Evolution
Google Analytics Top KPIs Evolution![Google Analytics Top KPIs Evolution]()
Visualize how your Google Analytics KPIs are evolving (Month-to-Date, Year-to-Date)
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)
12 dashboard pages
- Google Analytics Home
- Google Analytics Cockpit
- Top Pages
- Google Analytics Top KPIs Evolution
- Web Traffic Acquisition
- Google Analytics Top KPIs Overview
- Google Analytics Country Analysis
- Google Analytics City Analysis
- Google Analytics Trends Analysis
- Google Analytics Segmentation Analysis
- Google Analytics Pareto Analysis
- Google Analytics KPI Performance
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 Home]()
Get a Home Page for your Google Analytics dashboard
Cockpit
Google Analytics Cockpit
Google Analytics Cockpit![Google 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 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 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 Pages]()
Which web pages are the most seen on your web site?
Web Traffic Acquisition
Web Traffic Acquisition![Web 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 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 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 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 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 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 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 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) 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' and upload your Tableau workbook (note: your data is NOT uploaded).
Dashboard Template
- Predefined (and customizable) KPIs
- Predefined DataViz
Finance
Procurement
Digital Marketing
Processes
Case Management
Banking
Healthcare
Telecommunications
Fundraising
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 :-)
