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 Looker.
Introduction to Google Analytics
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.
Introduction to Looker
Looker is a cloud-based business intelligence tool that lets you analyze data in real-time. It helps you understand the customer trends, metrics, and how your product is performing in the market.
Rich-visualizations such as charts, graphs, etc, can be created using its interactive dashboard. Using Looker’s data modelling language, you can define performance metrics and get an insight into the relationship between various data sets.
Prerequisites
- Working knowledge of Looker.
- A looker account with admin privileges.
- Working knowledge of Google Analytics.
- A Google Analytics account.
- PostgreSQL instance with admin privileges.
Methods to connect Google Analytics to Looker
There are multiple ways in which you can connect Google Analytics to Looker:
Method 1: Using BigQuery transfer service
Google Analytics supports loading data to Looker via Bigquery for further analysis. Google Analytics 360 and BigQuery, are both Google products and hence, Google provides a data migration solution to transfer your data from one product to another. This is known as the BigQuery Data Transfer Service. In this method, you will first load your Google Analytics data into the BigQuery data warehouse and then connect it to Looker.
But this comes with a caveat. It is only available for premium users who can afford to pay thousands of dollars per year. In case you are a GA360, premium users, you can use the following steps to connect Google Analytics to Looker:
Step 1: Connecting Google Analytics to BigQuery
Use BigQuery Data Transfer service to move your data from Google Analytics to BigQuery. You can check out our easy step-by-step guide to help you load your Google Analytics data. You can schedule the data transfer to occur for a defined frequency as per your business’s data needs.
Step 2: Loading data from BigQuery to Looker
Once you’ve successfully transferred your Google Analytics data into BigQuery, you can now connect BigQuery to Looker to start analyzing your data. Check out our detailed and easy guide to help you connect BigQuery to Looker using Lookers’ connection settings.
Limitations of this method
- This method requires you to have the Google Analytics 360 privileged access, which comes at a very hefty price. Most small business would find this method economically difficult for them to implement.
- There is very less scope of customization in the BigQuery Data Transfer service.
Method 2: Using PostgreSQL as an intermediate database
You can use Google Analytics Reporting APIs to fetch data and then store it in PostgreSQL. Now connect your PostgreSQL database to Looker to start analyzing your data. You can implement this using the following steps:
Step 1: Connecting Google Analytics to PostgreSQL
Google Analytics makes its data available through the Google Reporting API V4. The API can be accessed by authenticating the OAuth protocol. You can check our detailed guide, to help you load data into PostgreSQL.
Step 2: Loading data from PostgreSQL to Looker
Once you have transferred data into PostgreSQL, log in to your PostgreSQL shell and create a user for Looker and provide the necessary permissions. You can do this using the following lines of code:
CREATE USER looker WITH ENCRYPTED PASSWORD 'some_password_here';
GRANT CONNECT ON DATABASE database_name to looker;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO looker;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO looker;
Launch Looker and login to your dashboard. Click on the Connections tab and select the new connection option.
Image Source: Self
The connection settings page will now open up. Choose PostgreSQL as the dialect here. Add your PostgreSQL URL and port values. You now need to provide the details of the PostgreSQL user you had created.
Set the maximum connection parameter to 75 and the pool timeout parameter to 120.
Image Source: www.holistics.io/blog
Click on the add connection option. In the SQLRunner, select the configured connection from the list on the left and start analyzing your Google Analytics data.
Image Source: Self
This is how you can connect Google Analytics to Looker by using PostgreSQL as an intermediate database.
Limitations of this method
- To always have up-to-date data in Looker, you need to refresh the data periodically. This requires users to write custom code lines that can periodically perform a data refresh. This can be a challenging task for the users.
- This method requires users to make multiple configurations to access APIs repeatedly.
Conclusion
This article introduces you to the various methods that can be used to connect Google Analytics to Looker. It also provides in-depth knowledge about the concepts behind every step to help you understand and implement them efficiently. These methods, however, can be challenging, especially for a beginner & this is where Hevo saves the day. Hevo Data, a No-code Data Pipeline helps to transfer data from Google Analytics (Free Data Source) & multiple sources to your desired data warehouse and visualize it in Looker without having to write the code repeatedly. Hevo with its strong integration with 150+ sources & BI tools, allows you to not only export & load data but also transform & enrich your data to make it analysis-ready in a jiff.
visit our website to explore hevo
Want to take Hevo for a spin? sign up and experience the true power of Hevo.
Tell us about your experience of connecting Google Analytics to Looker! Share your thoughts in the comments section below.
FAQ
How to connect Google Analytics to Looker?
To connect Google Analytics to Looker, you need to import your Google Analytics data into BigQuery using the native Google Analytics to BigQuery integration. Once in BigQuery, you can connect Looker to the BigQuery dataset for analysis and reporting.
How do I export Google Analytics data to Looker Studio?
In Looker Studio, you can directly connect to Google Analytics by adding it as a data source using the built-in Google Analytics connector, allowing you to visualize and report on your Google Analytics data.
Is Google Analytics the same as Looker?
No, Google Analytics is primarily a web analytics tool for tracking website traffic and user behavior, while Looker is a business intelligence platform for analyzing and visualizing data from various sources, including Google Analytics through integrations.
Talha is a Software Developer with over eight years of experience in the field. He is currently driving advancements in data integration at Hevo Data, where he has been instrumental in shaping a cutting-edge data integration platform for the past four years. Prior to this, he spent 4 years at Flipkart, where he played a key role in projects related to their data integration capabilities. Talha loves to explain complex information related to data engineering to his peers through writing. He has written many blogs related to data integration, data management aspects, and key challenges data practitioners face.
