Connect Google Analytics to Tableau : 3 Easy Steps

|

Google Analytics To Tableau

The process of capturing and analyzing data is a challenge to every organization. Every untracked piece of data is a lost insight that could have helped an organization be one step ahead of its competitors. Tableau is a great tool for understanding and extracting hidden information from data belonging to different sources such as Google Analytics, a comprehensive data analytics tool.

This article is aimed at providing a step-by-step guide on how to connect Google Analytics to Tableau.

Table of Contents

Introduction to Google Analytics

Google Analytics Logo.
Image Source: Wikipedia

Google Analytics is a Web Analytics Service that provides users with Statistical and Analytical information. It is highly useful & helps in managing Search Engine Optimization (SEO) and Product Marketing Operations. It is free of cost service available to every Google User.

It visualizes data using its interactive features such as Dashboard, Motion Charts, and Scorecards to display real-time changes in data. Using Google Analytics, you can generate a custom report that meets your business requirements.

For more information on Google Analytics, visit the Google Analytics Academy to learn about the basic or advanced features for Campaign Tracking. You can also read our blog to learn more about Google Analytics Channels.

Introduction to Tableau

Tableau is a powerful Business Intelligence Tool used to turn raw data into an understandable format. It is a tool popularly used to visualize data and can be understood even by a non-technical user. 

It creates visualizations with the help of Dashboards and Worksheets, helping users perform real-time analysis in a very fast and secure manner. It doesn’t require a user to have any programming skill or technical background to operate it.

For further information on creating Tableau Reports, you can visit our comprehensive blog here.

Hevo Data, a Simpler Way to Integrate your Data for Analysis

Hevo Data, a No-code Data Pipeline helps to combine data from 150+ Data Sources including 30+ Free Sources like Google Analytics and visualize it in Tableau. Hevo is fully managed and completely automates the process of not only transferring data from your desired source but also enriching the data and transforming it into an analysis-ready form without having to write a single line of code. Its fault-tolerant architecture ensures that the data is handled in a secure, consistent manner with zero data loss.

It provides a consistent & reliable solution to manage data in real-time and always have analysis-ready data in your desired destination. It allows you to focus on key business needs and perform insightful analysis using BI tools such as Tableau and many more.

Get Started with Hevo for Free

Check out what makes Hevo amazing:

  • Simplicity: Using Hevo is easy and intuitive, ensuring that your data is exported in just a few clicks. 
  • Schema Management: Hevo takes away the tedious task of schema management & automatically detects the schema of incoming data and maps it to the destination schema.
  • Real-Time Data Transfer: Hevo with its strong integration with 100+ sources, allows you to transfer data quickly & efficiently. This ensures efficient utilization of bandwidth on both ends.
  • Completely Managed Platform: Hevo is fully managed. You need not invest time and effort to maintain or monitor the infrastructure involved in executing codes.
  • Data Transformation: It provides a simple interface to perfect, modify, and enrich the data you want to transfer.  
  • Secure: Hevo has a fault-tolerant architecture that ensures that the data is handled in a secure, consistent manner with zero data loss.

Simplify your data analysis with Hevo today!

Sign up here for a 14-Day Free Trial!

Prerequisites

  • Working knowledge of Google Analytics.
  • Working Knowledge of Tableau.
  • Tableau installed at the Host Workstation.
  • A Google Analytics account.

Using Google Analytics

To use the Google Analytics service, all you need is a working Google Account. If you already have one, you can directly go to Google Analytics’ official website and log in.

Once you have logged in successfully, the Google Analytics home screen will open up.

Google Analytics Dashboard.
Image Source: Google Blogs

Click on the Admin button present in the bottom left corner of the screen. A page representing configuration settings will now show up. It will display your account details such as Account, Properties, and Views.

Creating an Account .
Image Source: Google Analytics

Set up your account by clicking on the Create Account button. Provide the details for your account such as name and link it to your organisation.

Configuring the new account .
Image Source: Google Analytics

Depending upon the kind of data you want to measure, you can either select web or apps as the desired choice. Set the time-zone and the industry your data belongs to carefully. Click on Create.

Adding Property Details.
Image Source: Google Analytics

This is how you can set up a Google Analytics account.

Using Tableau

Tableau is a fast-evolving Business Intelligence Tool, used to analyze & visualize data in real-time using its intuitive interface. It is easy to learn and can be operated even by an individual with no technical background.

Once you have logged in successfully, Tableau’s home screen will open up.

Tableau Workspace.
Image Source: Tableau Help

In the Connect column, you will find multiple sources you can easily connect to with Tableau. The source can be a File, a Server or even saved Data Sources. You can analyze your data by dragging it to the center of the screen called Canvas.

Opening a new Tableau Workbook.
Image Source: Tableau

Tableau comes pre-loaded with several sample Workbooks. You can use these to get a better understanding of how a typical Workbook looks like and how you can visualize data in Tableau.

This is how you can use Tableau.

Connecting Google Analytics to Tableau

Tableau’s in-built Google Analytics Connector lets you connect Google Analytics to Tableau easily. You can establish a connection between the two using Tableau’s interactive interface. Tableau has rich API support that allows you to manipulate data and perform an insightful analysis.

Using Tableau’s Google Analytics Connector

This can be implemented using the following steps:

Step 1: Signing in to Tableau

Launch Tableau on your workstation and log in as a user with a Creator Role. Select Google Analytics from the connect column on the left.

Selecting Google Analytics connector.
Image Source: Tableau

This will open a dialogue box where you need to provide the credentials for your Google account. You can even select your desired account from a list of saved Google Accounts.

Step 2: Signing in to Google Analytics

Enter the credentials for your Google account carefully and sign-in to Google Analytics. Once you have signed in, you will be requested to provide Tableau, access to your data stored in Google Analytics.

Providing Tableau access to Google.
Image Source: BI Insight

Click on Accept to let Tableau successfully access your data. Once you have successfully provided access, you will see the following tab open in your browser:

Tableau access successful.
Image Source: GitHub

Step 3: Extracting Data from Google Analytics

Once you have signed-in successfully, a page representing configuration settings will now show up. It will display your account details such as account name, properties, and views.

Google Analytics Account Properties.
Image Source: Google Analytics

Fill in the desired date range and segment choice under the filters option. You will be able to pull in data up to the previous day. If you select the date range as 30 days, it will bring in data for the past 30 days with the 30th day being yesterday.

The segments option allows you to filter users. Google provides various default segments, however, users can fix custom segments as per their needs. This can be set up easily while establishing a connection with Google Analytics

Setting up Google Analytics dimensions & measures.
Image Source: Google Analytics

Google Analytics allows you to select up to 10 measures and 7 dimensions for the data you’re going to load into Tableau. You can either create a custom set or simply use the drop-down list to select a predefined set of dimensions and measures.

Launch Tableau and select the sheets tab to begin analyzing your data.

Selecting Tableau Sheets to connect Google Analytics to Tableau.
Image Source: Google Analytics

This is how you can connect Google Analytics to Tableau.

Limitations of Connecting Google Analytics to Tableau Using the In-Built Connector

  • It is not possible to load data from Google Analytics to Tableau in real-time. The user must refresh the data source for the changes to reflect.
  • The Google Analytics API limits the connector and restricts the users from querying more than 10,000 rows at once.
  • Querying a large amount of data or scheduling extracts hampers the performance, thus slowing down the process.
  • Querying multiple dimensions at once often results in sampled data being reflected.

Conclusion

This article offers a step-by-step solution to connect Google Analytics to Tableau. It provides a brief introduction of these tools and their operations to help users understand them better and use them to analyze their data efficiently and in real-time. It also introduces an alternative method to simplify your data analysis and get rid of all those limitations.

Hevo Data, a No-code Data Pipeline helps to integrate data from Free sources like Google Analytics or a source of your choice and visualize it in Tableau. Its fault-tolerant architecture ensures that the data is handled in a secure, consistent manner with zero data loss, without writing a single line of code.

Visit our Website to Explore Hevo

Want to take Hevo for a spin? Sign Up here for a 14-day free trial and experience the true power of Hevo.

Tell us about your experience of connecting Google Analytics to Tableau! Share your thoughts in the comments section below.

Nicholas Samuel
Technical Content Writer, Hevo Data

Nicholas Samuel is a technical writing specialist with a passion for data, having more than 14+ years of experience in the field. With his skills in data analysis, data visualization, and business intelligence, he has delivered over 200 blogs. In his early years as a systems software developer at Airtel Kenya, he developed applications, using Java, Android platform, and web applications with PHP. He also performed Oracle database backups, recovery operations, and performance tuning. Nicholas was also involved in projects that demanded in-depth knowledge of Unix system administration, specifically with HP-UX servers. Through his writing, he intends to share the hands-on experience he gained to make the lives of data practitioners better.

Visualize Your Google Analytics Data In Tableau Easily