dashboard template for tableau on Trial TRIAL Google Analytics (TRIAL Version) cockpit

Required Attributes

To get your Google Analytics (TRIAL Version) dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

  • date
    Date Reference date [ga:date] (Date used for time-series analysis)
  • string
    Channel Grouping The default channel grouping that is chared within the View (Profile) [Channel Grouping - ga:channelGrouping]
  • string
    Device Category The type of device: desktop, tablet, or mobile [Platform or Device - ga:deviceCategory]
  • string
    Page Title The title of the page [Page Tracking - ga:pageTitle]
  • string
    Country The countries of users [Geo Network - ga:country]
  • string
    City The cities of users [Geo Network - ga:city]
  • string
    Source / Medium Traffic Source [Traffic Sources - ga:sourceMedium]
  • numeric
    PageViews The total number of pageviews for your property [Page Tracking - ga:pageviews]
  • numeric
    Unique PageViews The number of different (unique) pages within a session [Page Tracking - ga:uniquePageviews]
  • numeric
    Sessions The total number of sessions [Session - ga:sessions]
  • numeric
    Bounces The total number of single page (or single engagement hit) sessions for your property [Session - ga:bounces]
  • numeric
    Exits The number of exits from our property [Page Tracking - ga:exits]
  • numeric
    Time on Page How long a user spent on a particular page in seconds [Page Tracking - ga:timeOnPage]
  • numeric
    Page Load Time Total page load time in milliseconds [Site Speed - ga:pageLoadTime]

KPIs

Your Google Analytics (TRIAL Version) dashboard will contain 11 KPIs

Dashboard Pages & Data Visualizations

Your Google Analytics (TRIAL Version) dashboard will contain 4 pages

Home

Google Analytics (TRIAL Version) Home

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

Cockpit

Google Analytics (TRIAL Version) Cockpit

Google Analytics (TRIAL Version) Cockpit
Google Analytics (TRIAL Version) CockpitGoogle Analytics (TRIAL Version) Cockpit
Get a clear picture on your web site traffic: What is the performance of our Web Traffic? Which channels bring us the most sessions? What are the referral sites that send us the most traffic? Where does our traffic come from? What are the most visited pages?

Web Traffic Analytics

Web Traffic Acquisition

Web Traffic Acquisition
Web Traffic AcquisitionWeb Traffic Acquisition
Visualize which channels and sources are driving your web traffic: Which channels bring us the most sessions? What are the sources of traffic?

Top Pages

Top Pages
Top PagesTop Pages
How efficient are our top visited pages?

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!

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

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 (TRIAL Version) dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Google Analytics (TRIAL Version) dashboard is now ready to be used or customized!


Other Dashboard Templates