Home Blog Service Analytics

How to Set up GA4 Reporting in Looker Studio Using BigQuery Export

Author Image
Max is an analytics expert @VIDEN, specializing in Looker Studio, Google BigQuery, Google Tag Manager, Google Analytics 4 and more, with years of experience in analytics strategy, identifying new trends, challenges, and opportunities for brands across digital.
How to Set up GA4 Reporting in Looker Studio Using BigQuery Export

Since the Universal Analytics (GA UA) deprecation in July 2023, GA4 has become the go-to analytics tool for many businesses. And if you are a GA 360 user, mark your calendar for July 2024, as GA4 will be your main analytics tool starting then. But let’s address the elephant in the room: you have probably noticed that Looker Studio can be painfully slow, especially when handling the large data sets typically pulled from GA UA. You are not alone; we know how frustrating it can be to watch a spinning wheel instead of your much-needed insights. According to a recent survey, 65% of businesses have experienced delays in data analysis due to slow-loading platforms, affecting timely decision-making. Just look at the lag yourself:

Looker Studio low speed

In this article, we will guide you step-by-step on how to set up Looker Studio reporting to work seamlessly — and quickly — with GA4 data through BigQuery export. Say goodbye to endless loading screens and hello to fast, efficient analytics.

Table of Contents:

  1. Why Build Reporting on BigQuery Data?
  2. How to Build Reporting on GA4 Data Exported to BigQuery
  3. Summing up

Why Build Reporting on BigQuery Data?

Deciding how to link Google Analytics 4 (GA4) to Looker Studio can be challenging. Let’s simplify it by looking at three common approaches. Each method offers unique benefits and drawbacks influencing data granularity, setup ease, and performance speed.

Three ways to connect GA4 to Looker Studio

Approach Pros Cons
Native GA4 connector for Looker Studio
  • Easy to connect
  • Free
  • Pre-built metrics
Third-party GA4 connector for Looker Studio
  • Easy to connect
  • There are some additional metrics and dimensions that are not available for the native GA4 connector (optional, depends on the connector)
  • All data API limitations applied to native GA4 connector
  • Paid
GA4 export to BigQuery + native BigQuery connector for Looker Studio
  • Fast (could be improved by BI Engine)
  • Reliable
  • Data ownership
  • Data transformations without native connector limitations (in BigQuery as well as in Looker Studio)
  • Realtime reporting
  • Further opportunities to use exported GA4 data: data quality, machine learning, advanced analytics requests
  • Time-consuming
  • Basic familiarity with Google Cloud Platform and SQL is needed
  • Marketing attribution at the session level should be recreated
  • Paid (BigQuery has free quotas for each month)

Below is a sample table comparing the three approaches across five key criteria:

Comparison table - GA4 and Looker Studio connection options

Now, let’s take a look at the advantages and disadvantages of the BigQuery approach.

Exploring the Pros and Cons of the BigQuery Approach

 

Pros:

  • Reliability. GA4 limitations and quotas are not imposed on BigQuery raw event data, ensuring a more consistent and dependable data source.
  • Data ownership. With BigQuery, you can store data as long as you want; just make sure billing is enabled.
  • Data transformations. Thanks to SQL support, BigQuery allows you to transform data in any way you can imagine, offering a level of customization that is hard to beat.
  • Realtime reporting of almost all exported data. Note that limited realtime data could be shown in GA4 Web UI.
  • Further wide opportunities for advanced analytics use cases, machine learning, data quality, A/B tests and experiments, data blending, and other applications inside GCP.

Cons:

  • Time-consuming as data must be retrieved and stored
  • Marketing attribution at the session level must be recreated by yourself since the export schema does not contain such fields
  • Basic familiarity with GCP and SQL is needed to retrieve and store data used for the reporting
  • This is a paid solution. However, every month, Google provides free resources, and the costs are pretty low for most businesses. Of course, it depends on business size, but, for example, for a company with 100K daily events, it costs only $1 per month.

BigQuery cost

Two Ways to Connect BigQuery Data to Looker Studio

When integrating BigQuery with Looker Studio, the connection options you choose can significantly impact both your workflow and budget. To optimize your analytics, you have two main pathways to explore:

  1. Custom query gives access to BigQuery GA4 data directly without setting up intermediate tables. However, it is cost-inefficient since computationally heavy queries should be executed with every report page load or action.
  2. Connecting to a precalculated table is a much more efficient way to use BigQuery data for reporting in Looker Studio, and it could be cheaper up to 10 times compared to a custom query connection.

Just look at this example: monthly billings before switching from custom query connection to table connection and after:

Before switching from custom query connection

After switching from custom query connection

How to Build Reporting on GA4 Data Exported to BigQuery

Now, let’s see what key steps are required for building reports based on GA4 data in BigQuery.

  1. Link GA4 property to BigQuery. Here is a detailed instruction created by Google and a schema of exported data. In addition to event data, user data is also available for export.
  2. After successful linking, check the exported data. It is essential to explore data before building a report because it may turn out that important reporting fields are not pulled, missing, incorrectly tracked, or have different incompatible formats, etc. Here are some examples:
    • Duplicated transaction IDs
    • Missing ID fields (transaction ID, session ID, client ID, user ID)
    • Client IDs have different formats
    • An eCommerce event does not have all eCommerce fields
  3. Configure on-demand scheduled query for creating reporting tables with the following settings:
    • Query code can be found on GitHub
    • Schedule options — on-demand
    • Location type: Specify a location that preferably matches the region where GA4 exported data is stored

    On-demand scheduled query

    Location type

    After creating the initialization query, move to the scheduled query page and select the query that you created. Then click on RUN TRANSFER NOW and select Run one-time transfer. This query creates reporting tables, which will be upgraded by an update query configured in the next step.
    Run transfer now

  4. Configure a scheduled query for daily updating reporting tables with the following settings:
    • Query code can be found on GitHub
    • Schedule options: Repeat frequency (days, at 13:00 or later local time converted to UTC)
    • Location type: Specify a location that preferably matches the region where GA4 exported data is stored

    Schedule options

    Location type

    After creating the update query, move to the scheduled query page and select the query that you created. Then click on Run transfer now and select Run one time transfer.

    Run transfer now

    A manual run of the update query allows you to check if everything is pulled correctly and debug your query if needed. After that, this update query will run daily, so no manual intervention is needed.

    Please note that both initialization and update scripts are sample scripts; before using them, you must adapt them to your data and needs.

  5. Connect the table to the Looker Studio as a data source

Connect table to Looker Studio

Summing up

Connecting GA4 data with BigQuery provides businesses with flexibility and scalability for their data analytics needs. BigQuery’s robust features enable more than just enhanced reporting and visualization; they offer a comprehensive solution for data management. You can clean data for accuracy, employ predictive models for future-facing strategies, and even consolidate multiple data sources like advertising platforms and CRM systems for a unified business view. Additionally, BigQuery’s architecture allows for secure data ownership and unlimited retention, aligning with long-term business goals. Should you require assistance in optimizing this powerful toolset, do not hesitate to contact us for expert support tailored to your business needs.

Get in touch

Got a question? We'd love to hear from you. Send us a message and we'll respond as soon as possible.



    By clicking submit, you agree to our Privacy Policy

    Latest Insights

    Get the tips from our experts to optimize and scale your campaigns

    15 July 2025

    How to Optimize Search Ads in 2025

    With the competition for attention and conversions getting fiercer in 2025, simply running Google Ads isn’t enough. According to Google’s recent internal data, advertisers who regularly optimize their ads see up to 12% higher conversions compared to those who don’t. Mikita, our digital marketing manager, has shared how to optimize Google search ads campaigns for […]

    Learn more

    26 June 2025

    What Is Server-Side Tracking and Why Has It Become Essential for Businesses?

    With browsers tightening privacy rules, ad-blockers on the rise, and cookies becoming less reliable, traditional client-side tracking is rapidly losing its accuracy. In fact, up to 40% of conversions are now hidden from browser-based tools, which means that marketers are often optimizing campaigns based on partial or distorted data. Server-side tracking changes that equation. By […]

    Learn more

    5 June 2025

    Why Continuous Product Analytics Is the Only Real Insurance for Digital Growth

    Think back five years. TikTok was a fringe lip-sync app, third-party cookies seemed immortal, and most “Buy Now, Pay Later” buttons hadn’t appeared yet. If your product’s most critical user flow was last redesigned in that era, or even two years ago, its once-dependable conversion rate is probably living on borrowed time. As the saying […]

    Learn more

    13 May 2025

    Top 5 Google Analytics Tips in 2025

    Google Analytics 4 is full of advanced features, but unlocking its full potential takes more than just a basic setup. Whether you’re tracking conversions, spotting drop-offs, or sharing reports with stakeholders, the right GA4 techniques and tricks can make your data far more actionable. To help you get more clarity, efficiency, and impact from your […]

    Learn more

    3 April 2025

    A Comprehensive Guide to Zombie SKUs Across Google Ads Shopping and P-Max Campaigns

    Zombie SKUs can quietly drain your resources without you even realizing it. These products receive little to no attention in your paid campaigns and are often overshadowed by higher-performing items, which can lead to many other issues down the road. Olga Bobchenok, our digital marketing specialist, has put together an all-encompassing guide to Zombie SKUs […]

    Learn more

    13 March 2025

    10 Key Metrics to Measure When Running a D2C eCommerce Business

    For every D2C eCommerce business, regularly assessing performance is key to understanding how well it’s doing and where improvements are needed. But which D2C analytics metrics should you focus on to get a comprehensive view of your brand? Darya Kislova, our marketing analyst, has compiled a list of the 10 most important D2C metrics that […]

    Learn more

    29 January 2025

    How to Measure Incrementality in Advertising: VIDEN’s Detailed Guide

    Figuring out what drives growth can be tricky for marketers. But that’s where incrementality testing comes in. This methodology helps businesses measure the real impact of their marketing initiatives and separates the noise from what drives actual results. While measuring incrementality can be challenging, there is no need to worry. Darya Kislova, our marketing analyst, […]

    Learn more

    20 December 2024

    Prepare Your eCommerce Store for The Holiday Season

    The holiday season is the busiest and most profitable time for eCommerce businesses, with shoppers eager to find the perfect gifts whilst taking advantage of discounts. Every business should embrace this opportunity by preparing for the event, providing a great shopping experience, and standing out in a competitive market. Uncover plenty of helpful tips in […]

    Learn more