Tracking User Behavior on Tableau Public Visualizations- Part2

The first part of the blog explained how you can track visitor interaction on your dashboard published on Tableau public server. This post will explain how you can do reporting on the visitors and use that information to create your own Tableau dashboard.
We would need things to do this:

1. Your Tableau dashboard tagged with Google Analytics
2. Google Sheets
3. Google Analytics Add On

Step 1: Goto Google Sheets and create a blank sheet

Step 2: Click on "Add-ons" menu option and then Add an Add On. Search for Google Analytics and click on +Free button. 

Step 3: Sign in with your google account and allow permissions to Google Analytics. 

Step 4: Once its done, you will be able to see Google Analytics as an Add on added in the menu option. Now click on "Create new report"

Step 5: Specify Name for the report, Account for which you want to do reporting , measures and dimensions and click "Create Report"

Step 6: Upon creation of Report, configuration sheet is created for the report. IF you add any other report again, report configuration is added in same "Report Configuration" Sheet.

Step 7: Now Click on "Run Reports" under Add on Section . A new tab will be created to show the data specific to each report.

Step 8: Since data start from 15th row, we need to get rid of text above 15th row. You can use your method for cleaning the report. What I did was to copy the data from this sheet in another sheet using cell reference and dragged it to get all the data. This is not an efficient method but as if now I could think of this method. Other method you could use is to write your own scripts under Tools menu option.

Step 9: You can also schedule the refresh for the google sheets which will extract updated google analytics data.

Step 10: Finally go to Tableau Desktop and use Google Sheets as the data source option. Authenticate yourself in the browser to allow Tableau to access your google sheet files. 

.

Step 11: Finally add the google workbook from the list of workbooks shown in the window. Once workbook is added, drag your sheet in the data pane and start building your own dashboard.

Step 12: When you are ready to upload your dashboard on public server after creating an extract, make sure you have enabled "Keep my data in sync with Google Sheets and embed my Google Credentials". This ensures that data is refreshed from google sheets periodically on Tableau Public Server.