Share on facebook
Share on twitter
Share on linkedin
Share on email

I Just Connected Google Analytics to BigQuery—Now What?

I Just Connected Google Analytics to BigQuery—Now What?

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.
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on email
Email

Other Articles You Will Enjoy

Google Analytics 4 Update: February 2022 (Part 2) – InfoTrust’s Strategic Recommendation: Transitioning to Google Analytics 4

Google Analytics 4 Update: February 2022 (Part 2) – InfoTrust’s Strategic Recommendation: Transitioning to Google Analytics 4

As a follow-up to our Google Analytics 4 (GA4) February 2022 update, in which we cover some key features of GA4 and address whether…

Back to Basics: Audit and Implementation

Back to Basics: Audit and Implementation

Wondering what an audit and implementation is or why you should consider conducting one for your organization? Today, we’re going back to the basics…

All About Firebase Dynamic Links – Manage Your Mobile App Campaigns Better

All About Firebase Dynamic Links – Manage Your Mobile App Campaigns Better

The Challenge: Why Do We Need Dynamic Links? With hardware and technology advancement, our leads and customers are consuming content faster with each passing…

What I Learned about Digital Analytics from Buying a House

What I Learned about Digital Analytics from Buying a House

I honestly wasn’t sure if I could even buy a house, especially since I didn’t know where to begin—but to my surprise, my career…

A Week in the Life of a Lead Digital Analytics Consultant

A Week in the Life of a Lead Digital Analytics Consultant

Hello there! I’m Stephanie, a recruiter here at InfoTrust. I am excited to be kicking off a new series for our blog, “A Week…

Don’t Just Measure Data … Understand Your Consumers: Top Things to Know from InfoTrust + Google’s Virtual Retail Summit

Don’t Just Measure Data … Understand Your Consumers: Top Things to Know from InfoTrust + Google’s Virtual Retail Summit

Retail marketers and analytics professionals across the globe face a unique set of daily challenges. As a leader in the retail/eCommerce space (with partnerships…

Google Analytics 4 Reporting: Locating Reports

Google Analytics 4 Reporting: Locating Reports

If you’re thinking the Google Analytics 4 (GA4) reporting interface has changed quite a bit, you are not alone. Upon initial login the interface…

Google Analytics 4 Update: February 2022 – InfoTrust’s Strategic Approach & Recommendations

Google Analytics 4 Update: February 2022 – InfoTrust’s Strategic Approach & Recommendations

Introduction Google Analytics 4 (GA4) is a new iteration not only of Google Analytics (GA) as a tool, but also as a way of…

Is Google Analytics Illegal? Part Deux

Is Google Analytics Illegal? Part Deux

**Important – This is not legal counsel, the materials provided are for informational purposes only and not for the purpose of providing legal advice….

Get Your Assessment

  • This field is for validation purposes and should be left unchanged.

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.

Our website uses cookies and may collect user information to provide a good experience. Read our Privacy Policy here.

Leave Us A Review

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