How to use the Google Analytics Tableau Template | Scribe

    How to use the Google Analytics Tableau Template

    • Victor Andrei Lupaescu |
    • 0 step |
    • 2 minutes
    Navigate to [https://onboard.windsor.ai/](https://onboard.windsor.ai/)
    Click "REGISTER"
    Enter your details and click on "Register / Start Free Trial"
    Choose "Google Analytics (UA)" or "Google Analytics 4" from the Data Sources panel.
    Click "SIGN IN WITH GOOGLE", connect to your Google Analytics account and grant the required permissions.
    Choose the Google Analytics domains that you want to add.
    Click "2. PREVIEW AND DESTINATION"
    You can add your desired fields from the right-side panel.
    Choose Tableau as a Data Destination
    Click "COPY". This will copy your API URL to clipboard and you'll use it later in Tableau Desktop.
    Open the template available on Tableau Public: [https://public.tableau.com/app/profile/victor.lupaescu/viz/WindsorMarketing-GoogleAnalytics/GoogleAnalytics](https://public.tableau.com/app/profile/victor.lupaescu/viz/WindsorMarketing-GoogleAnalytics/GoogleAnalytics)
    Click on the "Download" button
    Choose "Tableau Workbook"
    Choose the Tableau Desktop version that you're using and click "Download"
    Open the downloaded workbook 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](https://tableau.windsor.ai) -> enter the URL you’ve copied at step 10. 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 10): [https://connectors.windsor.ai/googleanalytics?api_key=](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
    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: [https://windsor.ai/templates/tableau/](https://windsor.ai/templates/tableau/)

    Want to make guides like this in seconds? Yes, it's really that fast.

    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe