Tableau Google Analytics Dashboard Template

  • Victor L 
Tableau Google Analytics Dashboard Template

This Tableau Google Analytics Dashboard template allows you to visualize in Tableau your Google Analytics (Universal Analytics) or Google Analytics 4 data in a few clicks, through our dedicated Tableau Web Data Connectors for Google Analytics and Google Analytics 4 (GA 4).

Dimensions and metrics visualized in this report:

  • Sessions
  • Average Page Views per Session
  • Unique Page Views
  • Bounce Rate
  • Average Session Duration
  • Top Referrals
  • Traffic by Channel
  • Most Visited Pages
  • Traffic by Device
  • Traffic by Country

In this dashboard you’ll be able to see all the above metrics for the selected time frame compared to previous time frame, as well as their trend in the last year. It allows filtering by Referral, Country, Channel, Device and Website Page.

It also contains a powerful custom-built date selector, which isn’t available by default in Tableau.

 

How to use this template

Connect your Google Analytics account to Windsor.ai using our dedicated connector

1. Connect your Google Analytics data to Windsor.ai using Our Onboard Page. Register or login if you already have an account.

2. Choose Google Analytics (UA) or Google Analytics 4 (App + Web) from the left-side menu. If you want to see what other data sources you can connect to, you can find all the available data sources on this page.

3. Click on “Sign in with Google”. In the pop-up, connect to your Google Analytics account and grant the required privileges. You’ll also be able to choose which views to include in this step. Our recommendation is to include all your views, as you’ll be able to filter between them afterwards (either within Windsor.ai or Tableau Desktop).

 

Connect Google Analytics to Windsor.ai - Steps 1-3

Steps 1-3

 

4. Choose at least one Google Ads account from the drop-down.

5. Click on Preview and Destination.

 

Connect Google Analytics to Windsor.ai - Steps 4-5

Steps 4-5

 

6. Choose Tableau as a Destination. As you’ll probably see, there are many destination options. If you want to find out more details, you can check all the destinations that we cover through our Tableau Web Data Connectors.

 

Connect Google Analytics to Tableau - Step 6

Step 6

 

7. Copy the generated URL, you’ll need it later.

 

Connect Google Analytics to Tableau - Step 7

Step 7

Connect Google Analytics data to Tableau through Windsor’s Web Data Connector

8. Download the Tableau Google Analytics Dashboard Template using this link and open it in Tableau Desktop.

 

Download Tableau Google Analytics Dashboard Template - Step 8

Step 8

 

9. In Tableau Desktop, connect to your Google Analytics data by clicking on Data -> New Data Source.

Choose Web Data Connector -> enter https://tableau.windsor.ai -> enter the URL you’ve copied at step 7.

 

Google Analytics Tableau Web Data Connector

Step 9

 

Note: If you want exactly the same fields as in the template, you can use this URL (replacing <API key> with your key from step 7):

https://connectors.windsor.ai/googleanalytics?api_key=<your_API_here>&date_preset=last_365d&fields=avgtimeonpage,bounces,channelgrouping,country,date,devicecategory,exits,pagetitle,pageviews,sessions,sourcemedium,timeonpage,uniquepageviews

 

10. Once your data has been added, replace the existing data source with the newly created one (from Data – Replace Data Source).

 

That’s it. Now you have your own Google Analytics data in Tableau, through a dedicated Web Data Connector and a dashboard that is ready to publish wherever you want. If you like this Tableau Google Analytics Dashboard Template, you can check out our collection of Tableau templates.