I Just Connected Google Analytics to BigQuery—Now What?

I Just Connected Google Analytics to BigQuery—Now What?
Estimated Reading Time: 6 minutes

Intro

One of the key steps in an organization’s journey to greater digital analytics maturity is connecting its Google Analytics (GA) to BigQuery (BQ). The integration between GA and BQ gives marketers ownership of their complete, hit-level analytics dataset, which opens the door to many additional opportunities for analysis and optimization. Here’s our list of the top four things you can start doing now to move your organization forward by utilizing the integration between GA and BQ.   

Note: This post covers the integrations with BQ for both Google Analytics 360 (GA360) and GA4, the next generation of GA. When we refer to GA, the information is relevant for both platforms; when there are differences between the platforms, we’ll call them out explicitly.

For more information on using BigQuery, check out our other posts: what is BigQuery?, the integration between GA and BQ, how to get started with BQ, and data concepts and how they apply to BQ.

Analyze

Gaining access to your complete, hit-level dataset from analytics provides ample new opportunities for analysis. In addition to being able to build custom reports, the GA data in BQ includes some fields that are not available in the GA UI.

For GA360, these include visitNumber, hitNumber, and isTrueDirect:

  • visitNumber allows you to analyze users’ sessions sequentially and create session IDs.
  • hitNumber enables pathing analysis by allowing you to sequence hits.
  • isTrueDirect allows you to see traffic source information prior to the application of the Last Non-Direct Click attribution.  

Similarly, for GA4, these fields include:

  • The event parameter ga_session_number – like visitNumber
  • event_timestamp – enables pathing analysis like hitNumber 

Having your data in BQ makes it possible to analyze cohorts, fit your own attribution models, understand the user journey, and perform basket analysis.

Finally, access to hit-level data is conducive to integrating GA with other datasets. Common use cases include:

  • Joining additional user-level attributes from a CRM or CDP, such as lifetime value or loyalty program status
  • Widening product-level attributes for enhanced analysis of e-commerce performance, such as size, color, or product line
  • Widening content-level attributes for publishers, including author, publish date, and tags
  • Enhancing campaign-level analysis by bringing in additional fields related to targeting and creatives

Regardless of whether you’re diving into the GA data on its own or connecting it with other data sources, putting your SQL skills to work in BQ can help you uncover many new insights and opportunities for improvement.

Predict

With your analytics data in BQ, you can leverage Google Cloud Platform’s (GCP) built-in machine learning and AI-powered tools to get started with predictive modeling. The most straightforward way to start is by using BigQuery ML (BQML), which allows analysts to fit sophisticated models in BQ using standard SQL queries. BQML currently supports several model types, including:

  • Classification – used for predicting a binary outcome (yes/no), such as propensity modeling
  • Regression – used for predicting a numeric value, such as spend
  • Clustering – used for segmenting similar users
  • Time series – used for forecasting
  • Matrix factorization – used for recommendation engines

BQML

Experienced data science teams can build models using Vertex AI, a unified UI for the entire ML workflow, including pre-fit models, end-to-end integration, and MLOps. For the fastest setup, analysts can customize and deploy pre-trained models for regression, image and video classification, and natural language processing. Data scientists can also develop custom training pipelines, use Explainable AI to help understand model outputs, and track model quality using Model Monitoring.

These models can be used to grow your understanding of the complex relationships in your data and for activation.

Activate

Activating your data can take many forms. A very common use case is to use the predictions from a propensity, customer lifetime value, time-to-reorder, or segmentation model for audience targeting. Propensity models are well-suited to improving retargeting campaigns whereas customer lifetime value models can be used to nurture loyal customers, prevent churn, and execute a customer-centric marketing strategy. Time-to-reorder models can help you reach customers when they’re ready for their next purchase and segmentations can be used for personalization, acquisition, and in general, to better understand customers’ needs.

Audience targeting with GA

Other paths to activation include:

  • Forecasting revenue to help meet sales goals
  • Improving customer retention by analyzing cohorts
  • Optimizing marketing campaigns by fitting custom or complex attribution models
  • A/B testing website/app changes based on user journey analysis
  • Optimizing product bundles and offerings via basket analysis
  • Increasing average order value (AOV) or engagement by implementing a recommendation engine

Share

While focused on deriving insights from the data, sometimes teams overlook how the results from these analyses will be shared within the organization. Self-service dashboards, such as those built with Google Data Studio or Tableau, are commonly used to share findings and drive action across teams. When planning for a new dashboard, it’s important to be clear on who needs access to the dashboard, what actions you expect teams to take, what data is needed and where it should come from, and which data visualization platform has the right features to meet these needs. We’ve noticed a pronounced increase in standardized reporting and dashboarding, especially for organizations that have migrated their data to BQ/Google Cloud, that empowers teams to make decisions quickly and strategically.

The best dashboards have a clear, focused design, avoid common mistakes, and automatically update. Data Studio and Looker are popular choices as they have native integrations with BQ that help reduce set up time. Power BI, Tableau, and Domo are also commonly used. 

Data Studio

Have questions on how to get started with your Google Analytics data in BigQuery?

Submit a Contact Us form to talk with one of our activation or visualization specialists.

Author

  • Pam Castricone

    Pam Castricone is currently an Emerging Solutions Strategist at InfoTrust. Specializing in statistical and machine learning models, Pam is passionate about helping her clients uncover greater insights and value from their data assets. As a Google Cloud Certified Professional Data Engineer, Pam also helps her clients put their models into production in the cloud to drive long-term usability and success. When she isn’t analyzing data, Pam enjoys reading, the arts, and going out for brunch.

Facebook
Twitter
LinkedIn
Email
Originally Published: November 18, 2021

Subscribe To Our Newsletter

November 18, 2021

Other Articles You Will Enjoy

Beyond the Basics: Deep Dive into Google Analytics 4’s Bounce Rate, Engagement Rate, and Engaged Sessions

Beyond the Basics: Deep Dive into Google Analytics 4’s Bounce Rate, Engagement Rate, and Engaged Sessions

You’ve probably come across the notion that Google Analytics 4 (GA4) and Universal Analytics (UA) are distinct platforms, despite both being products of Google….

3-minute read
How to Track User Engagement and Behavior on Your Website Using Google Analytics 4 Custom Metrics

How to Track User Engagement and Behavior on Your Website Using Google Analytics 4 Custom Metrics

Understanding how users engage with your website is crucial for improving user experience and achieving your business goals. Google Analytics 4 (GA4) offers a…

5-minute read
A Beginner’s Guide to Visualizing Google Analytics 4 Data with Looker Studio

A Beginner’s Guide to Visualizing Google Analytics 4 Data with Looker Studio

In today’s digital marketing world, tracking and analyzing user behavior on your website is crucial for making data-driven decisions. Google Analytics 4 (GA4) is…

5-minute read
Unveiling the Mysteries of Google Tag: 10 Things You Need to Know

Unveiling the Mysteries of Google Tag: 10 Things You Need to Know

If you’ve recently stepped into the realm of Google Analytics 4 (GA4) and are scratching your head about the new kid on the block—Google…

4-minute read
Google Tag Best Practices for Google Analytics 4

Google Tag Best Practices for Google Analytics 4

After collaborating with several of my colleagues at InfoTrust including Bryan Lamb, Head of Capabilities, Corey Chapman, Senior Tag Management Engineer, Chinonso Emma-Ebere, Tech…

4-minute read
Is It Time to Upgrade? 4 Signs Your Organization Needs Google Analytics 4 360

Is It Time to Upgrade? 4 Signs Your Organization Needs Google Analytics 4 360

As VP of Partnerships at InfoTrust, I’ve had the opportunity to talk with hundreds of decision-makers about their interest in upgrading to Google Analytics…

4-minute read
Navigating the Complexity of Measuring Connected TV and OTT with Web Analytics Tools: A Privacy-Centric Perspective

Navigating the Complexity of Measuring Connected TV and OTT with Web Analytics Tools: A Privacy-Centric Perspective

Connected TV (CTV) devices and Over-The-Top (OTT) platforms have experienced significant growth in recent years, becoming a preferred choice for consuming content on various…

8-minute read
Leveraging Attribution Models in Google Analytics 4 to Improve Your Marketing Strategy: Tips and Best Practices

Leveraging Attribution Models in Google Analytics 4 to Improve Your Marketing Strategy: Tips and Best Practices

In the dynamic landscape of digital marketing, understanding the customer journey is crucial for optimizing strategies and maximizing ROI. Google Analytics 4 (GA4) introduces…

5-minute read
Best Practices for Leveraging Custom Insights in Google Analytics 4

Best Practices for Leveraging Custom Insights in Google Analytics 4

What Are Custom Insights? Google Analytics 4 (GA4) offers Custom Insights to detect changes in your data that are important to your team specifically….

3-minute read

Get Your Assessment

Thank you! We will be in touch with your results soon.
{{ field.placeholder }}
{{ option.name }}

Talk To Us

Talk To Us

Receive Book Updates

Fill out this form to receive email announcements about Crawl, Walk, Run: Advancing Analytics Maturity with Google Marketing Platform. This includes pre-sale dates, official publishing dates, and more.

Search InfoTrust

Leave Us A Review

Leave a review and let us know how we’re doing. Only actual clients, please.