Google Analytics
Google Analytics (GA4) and BigQuery for marketing and audience insights
Google Cloud works with Google Analytics to help businesses become more data-driven. Bringing Google Analytics data into BigQuery can help you reveal business insights across more data and increase time to value.
Overview
Familiar data tools to supercharge your marketing
If you're looking for a way to bring more data to your marketing and make data-driven decisions about your business, leveraging Google Analytics and BigQuery together with Looker Studio is a great place to start. These familiar tools work together with built-in integrations to make it easy to bring your data together for analysis, audience segmentation, and sharing insights.
What is the difference between GA4 and Universal Analytics?
Google Analytics 4 (GA4) properties will replace Universal Analytics properties on July 1, 2023. This means Universal Analytics properties will stop processing new data, so you will not be able to process new data or show updated reports and metrics about your app or website performance after that date. Google Analytics 4 properties will be the only fully functional version of Google Analytics after July 1, 2023. Universal Analytics 360 properties will continue to process new data until July 1, 2024.
Why should you export Google Analytics data into BigQuery?
You can export all event data from Google Analytics properties to BigQuery for free with the BigQuery Export, which resides in Google Analytics (GA4). In BigQuery, you can import external data from other sources, like CRM data, and combine it with your Google Analytics data, using SQL-like syntax to query the data for advanced reporting beyond sampling and quota limits. This enables you to build audience segments, explore custom traffic attribution, and build simple ML models for reporting and audiences.
How do you set up the Google Analytics BigQuery Export?
First, you'll need to create a new Google Cloud project and enable BigQuery. Then you'll need to prepare your project for BigQuery Export. If this is your first time getting started, you can link Google Analytics to the BigQuery sandbox, which is free and doesn't require a credit card to get started (sandbox limits apply). If your organization already has existing BigQuery pipelines, you can also link to your existing BigQuery project. Finally, you'll link BigQuery to Google Analytics properties.
Can BigQuery bring Google Analytics data into Looker Studio?
Organizations can connect Google Analytics data directly into Looker Studio to build reports and dashboards that can be shared across teams. (Looker Studio reports connected to Google Analytics data are subject to Google Analytics Data API quotas). The BigQuery export feature to Looker Studio provides capabilities beyond the Google Analytics Data API without the worry about dealing with high cardinality, while allowing you to get an accurate picture of your marketing data without limitations from the API.
What is BigQuery?
BigQuery is a cloud-based data warehouse that can store and analyze large amounts of data. You can use BigQuery to store data from Google Analytics, as well as other sources, such as your website's logs and your CRM system. This data can be used to run complex queries and identify trends that you might not be able to see with Google Analytics alone.
What is the BigQuery sandbox?
The BigQuery sandbox lets you explore BigQuery capabilities at no cost to confirm whether BigQuery fits your needs. The sandbox lets you experience BigQuery and the Google Cloud console without providing a credit card, creating a billing account, or enabling billing for your project.
What is Google Analytics?
Google Analytics is a measurement platform that provides a detailed understanding of your customers across devices and platforms free of charge. You can use Google Analytics to measure your website or app's performance, make data-driven decisions based on how customers interact across your sites and apps, and improve your marketing ROI.
What is Looker Studio?
Looker Studio is a free tool used to power your data with interactive dashboards and beautiful reports that inspire smarter business decisions. Easily access a wide variety of data with Looker Studio’s built-in connectors that make it easy to bring in data from BigQuery and Google Analytics 4. These enable you to build and share reports and dashboards across your stakeholders and collaborate in real time across a single source of truth.
How It Works
Connect Google Analytics data to BigQuery with the BigQuery Export, now free to all GA4 users, to quickly query all of your Google Analytics data and build audience segments.
Connect Google Analytics data to BigQuery with the BigQuery Export, now free to all GA4 users, to quickly query all of your Google Analytics data and build audience segments.
Common Uses
Uncover marketing insights with speed
Query Google Analytics data for fast business insights
BigQuery allows you to query your Google Analytics data to get answers to your important business questions quickly. Here are some of the questions you can get answered in a matter of seconds:
1. What is the average number of transactions per purchaser?
2. What are the other products purchased by customers who purchased a certain product?
3. What are the top 10 items added to cart over the course of the last 12 months?
How-tos
Query Google Analytics data for fast business insights
BigQuery allows you to query your Google Analytics data to get answers to your important business questions quickly. Here are some of the questions you can get answered in a matter of seconds:
1. What is the average number of transactions per purchaser?
2. What are the other products purchased by customers who purchased a certain product?
3. What are the top 10 items added to cart over the course of the last 12 months?
Build and activate audience segments
Quickly segment audiences based on any combination of events
Better understand customer behavior and target digital marketing with audiences that are valuable to your business while increasing marketing ROI.
Start by segmenting your audiences based on Google Analytics events, from site visitors who added to cart but didn't purchase to high lifetime value customers. BigQuery allows you to quickly segment and share these audiences back into Google Analytics.
How-tos
Quickly segment audiences based on any combination of events
Better understand customer behavior and target digital marketing with audiences that are valuable to your business while increasing marketing ROI.
Start by segmenting your audiences based on Google Analytics events, from site visitors who added to cart but didn't purchase to high lifetime value customers. BigQuery allows you to quickly segment and share these audiences back into Google Analytics.
Use BigQuery ML for predictive analytics
Create demand forecasts and build predictive audiences
Use BigQuery's built-in machine learning to better forecast and plan marketing performance. You can use historical marketing data to create accurate forecasts that include seasonality to better plan for business peaks.
BigQuery ML allows you to build predictive audiences like propensity to purchase or predictive customer lifetime value based on Google Analytics data that you can use to target potentially valuable new customers. ML-based predictive capabilities also allow you to predict churn.
How-tos
Create demand forecasts and build predictive audiences
Use BigQuery's built-in machine learning to better forecast and plan marketing performance. You can use historical marketing data to create accurate forecasts that include seasonality to better plan for business peaks.
BigQuery ML allows you to build predictive audiences like propensity to purchase or predictive customer lifetime value based on Google Analytics data that you can use to target potentially valuable new customers. ML-based predictive capabilities also allow you to predict churn.
Build marketing performance dashboards
Build marketing reports and dashboards with Looker Studio
Looker Studio connects with hundreds of data sources and allows you to create highly visual dashboards, so you can blend and analyze data from your marketing activities for rapid insights. Input your marketing analytics data, including Google Analytics and Google Search Console, and customize your own views, including tables and charts, to highlight performance.
How-tos
Build marketing reports and dashboards with Looker Studio
Looker Studio connects with hundreds of data sources and allows you to create highly visual dashboards, so you can blend and analyze data from your marketing activities for rapid insights. Input your marketing analytics data, including Google Analytics and Google Search Console, and customize your own views, including tables and charts, to highlight performance.
