Skip to content

Connect Tableau to Google Analytics

Tableau connects natively to the Google Analytics website tracking service.

1. CONNECT

In Tableau Desktop, choose Connect to a Server > Google Analytics.  At the pop-up box, grant access to Google Analytics.

Initially, Tableau requires an extract connection type.

2. CONNECTION DIALOG

Once authenticated, you are prompted with a Connection dialog.  Choose your Google account, property, and view.  The default date range is the past 30 days.  The dropdown shows other date range filters.  If this is a static analysis, select one of the time frames.  Select a fixed start date if this data will be refreshed using time increments.

The Segment dropdown allows for filtering by traffic portions.  All Sessions is selected by default.

Next, select up to 7 dimensions and 10 measures.  These limitations are from the Google Analytics API.  Use the ‘Add dimension’ dropdown to add categorical or qualitative data.  Date already appears by default.  Use the ‘Add measure’ to add qualitative data.  You can use the ‘Choose a Measure Group’ dropdown to select common combinations of analytical fields.

Finally, you can edit the title of the data connection.

3. BEGIN ANALYSIS

Navigate to Sheet 1.  An extract database is automatically created and saved locally in the default file path for tableau data sources.  Many cloud data sources save copies of data extractions locally.   The extractions can be thought of as a snapshot, not as a persistent connection.

4. GET CREATIVE

Google Analytics traffic data is often used in conjunction with other data.  You can connect to data elements found on your website.  For example, you could use a WordPress MySQL extract that includes post author, post publication date, or post categories.

Tableau is a fast track for new data insights.