Exporting Your Google Analytics 4 Data: File Download vs Google Analytics Data API (GA4) vs BigQuery Export

Exporting Your Google Analytics 4 Data: File Download vs Google Analytics Data API (GA4) vs BigQuery Export
Estimated Reading Time: 8 minutes

As Google Analytics 4 (GA4) users continue to build out reporting and analytics assets, leveraging the correct product is key to ensuring success. There are many different visualization and data storage options available on the market today with some organizations choosing to use a mixture of both. You might be thinking, “What platforms are most heavily utilized by other organizations on GA4?” or “What combination of products tend to provide the best results with GA4 data?”

Now while these questions are important and definitely would be helpful (maybe with enough interest we can dive further into these questions), I am instead going to suggest taking one step back to how users should extract data from GA4. The reason for this is because it will determine the limits and capabilities that will be faced.

Google Analytics Data Extraction

When extracting data from GA4, there are currently three ways to do so: download as a file, connect to the Google Analytics Data API (GA4), or connect to BigQuery (BQ). All three of the solutions are viable depending on the project’s size and scope. In today’s article, we will be focusing on some of the use cases and limitations of the three options.

File Download

The most limited of the three options above, downloading a file from the GA4 UI is typically utilized if a user is trying to complete some simple data extract from a standard report (CSV or PDF) or explore reports (Google Sheet TSV, CSV, or PDF). Typically, the scope of these projects are very small and are a result of an interest in doing some quick data analysis or not wanting to be limited by the max rows being shown in the GA4 UI. 

  • Pros:
    • Easy and straightforward to use.
    • Fastest way to get access to GA4 data (when data sets are small).
    • No cost associated with downloading reports.
    • Can be accessed in the GA4 UI.
  • Cons:
    • Data limited to what is available in the GA4 UI report.
    • Downloading multiple reports will require multiple downloads and files.
    • Large data sets require a long period of time to download and may fail.
    • Downloaded data is static and does not update.
    • Restricted to the date range selected in the report.
    • Sampling, cardinality, and thresholding may affect the data (GA 360 licensed accounts do have access to unsampled reports and expanded data set capabilities).

Google Analytics Data API (GA4)

Google Analytics Data API (GA4) is likely the most heavily utilized data extraction capability of the three options. It is used by all third-party data transfer tools (Supermetrics, FiveTran, OWOX, etc.) and any visualization tools (Looker Studio, Tableau, Power BI, etc.) that integrate/connect directly with GA4. Connecting to the Google Analytics Data API (GA4) is typically best for organizations who want to report on aggregate data that is available and seen in the GA4 UI. This might include medium-sized projects or projects that don’t include a need to access more unique data analytics capabilities.

  • Pros:
    • Does not require SQL or coding experience to leverage.
    • Easiest way to connect and extract large amounts of data from the GA4 UI.
    • Is tool-agnostic and is able to be used by a variety of tools and programming languages. 
    • Free to users who wish to use the API Connector (limits do apply, other products may charge to connect).
    • Can be accessed by developers and data scientists through API calls.
    • Not limited to what is available within a specific report (can combine data similar to the explore reports.
    • Historical data available immediately once connected (date range depends on data retention setting).
  • Cons:
    • Data is restricted to what is available in GA4 (if a parameter is not registered in the GA4 UI, then data won’t be pulled through).
    • Key IDs and data such as timestamp and user_id are unavailable to access.
    • Date range for pulling data is restricted to the data retention settings of the GA4 property.
    • No access to the raw unsampled/queried data.
    • Is subject to analytics property quotas as seen below:
Quota NameStandard Property LimitAnalytics 360 Property Limit
Core Tokens Per Property Per Day200,0002,000,000
Core Tokens Per Property Per Hour40,000400,000
Core Tokens Per Project Per Property Per Hour14,000140,000
Core Concurrent Requests Per Property1050
Core Server Errors Per Project Per Property Per Hour1050

For additional limits, please reference analytics property quotas.

As seen above, there are many benefits to leveraging the Google Analytics Data API (GA4), especially when it comes to ease of use and capabilities. For this reason, the Google Analytics Data API (GA4) is typically used to export historical data if BQ wasn’t/isn’t connected or for a majority of KPI reporting. However, it is important to note that if the data is going to be accessed heavily, historical data access beyond what the GA4 data retention setting allows is required, or accessing raw data is pivotal due to advanced analytic needs, then the BigQuery Export is probably the best option.

BigQuery Export (GA4)

BigQuery Export provides the most granular access to data being collected by any organization. With the move from Universal Analytics (UA) to GA4, one of the best product enhancements for standard licensed accounts was the ability to connect GA4 to BQ without the need of a Google Analytics 360 license. The best way to describe BQ probably comes from Google itself: “BQ is a serverless and cost-effective enterprise data warehouse that works across clouds and scales with your data. Use built-in ML/AI and BI for insights at scale.” 

The projects that would be most ideal are large, advanced projects that will likely require data manipulation or a large historical time period. Other projects that might also benefit from BigQuery are standard licensed accounts that don’t have a need to buy a Google Analytics 360 license, but wish to be able to report on data for longer than 14 months (the longest data retention option for standard licensed accounts).

  • Pros:
    • Access to the raw data collected from the site.
    • Is not limited to GA4 data retention settings.
    • Can be leveraged to by-pass third-party servers via server-side tag management, thus making the data and process more privacy-centric and durable.
    • Organizations/teams can utilize advanced analytic engineering capabilities to explore the data and perform advanced user analysis via the user ID or the customer ID.
    • Provides an ability to create ML/AI models without providing access to a third-party system.
    • Feed a real-time dashboard with up-to-date information to inform campaign needs.
    • Enables an environment of offline + online data stitching in a flexible, durable manner (data blending is an option for a majority of other tools, but is typically more limited).
  • Cons:
    • Requires an understanding of Structured Query Language (SQL) to build/create queries.
    • Has a cost associated with the storing and querying of data.
    • Takes longer to stand up and build necessary queries for reporting and analytic needs. 
    • Are some limitations to what data can be seen in the GA4 UI and what is seen in BQ as the data in BQ requires some manipulations.

The benefits of BQ, even if you already use another data warehouse, are large as it provides one of the only places where organizations can access their backend user IDs sent to GA4 to help to tie together the full user journey. There is also an additional benefit that the organization owns all of their data that is collected with access to the full, raw data stream on a first-party server (parameter and user property names/values are still limited to the same character limits as seen in Google Analytics). This allows the organization to adhere more easily to privacy regulation and utilize advanced analytics capabilities.

AbilityFile DownloadGA Data API (GA4)BigQuery Export (GA4)
Easy to access and utilize dataXX
Immediate historical data accessXX
No additional cost associated (from Google)XX
Does not require coding or mapping to match data available ing GA4 UIXX
Tool and programming language agnostic APIX
Viable way to extract large amounts of GA4 dataXX
Easy access to update and change data sets with little redo of the processXX
Raw data stream is accessibleX
Not directly restricted by the GA4 UI settings (data retention, user_id, etc.)X
Unaffected by high cardinality and unregistered dimensionsX
Data stored and accessed on first-party serversX
Flexible and durable solution to combine online and offline dataX
Advanced analytics techniques can be leveragedX

Conclusion

In closing, it is important to understand what data is available and how to go about accessing the necessary data. In doing so, it is important to understand both the size, scope, and success factors of the project to ensure the proper tools are used in the first place. If you are currently trying to decide the best route to extract and leverage your GA4 data or you have identified what the best route is but would like to discuss it further, reach out! Here at InfoTrust, we are all about creating great partnerships, solving complex problems, and making miracles happen.

Do you have questions about exporting data?

Our team of experts is here to help whenever you need us.
Facebook
Twitter
LinkedIn
Email
Originally Published: August 17, 2023
August 18, 2023

Other Articles You Will Enjoy

Unlocking Insights: Your Ultimate Google Analytics 4 Funnel Exploration Tutorial

Unlocking Insights: Your Ultimate Google Analytics 4 Funnel Exploration Tutorial

The funnel report is one of the most important reports available to digital marketers. Luckily, Google Analytics 4 (GA4) has made funnel reports more…

5-minute read
Event Tracking in Google Analytics 4: How to Set Up & Optimize Your Data

Event Tracking in Google Analytics 4: How to Set Up & Optimize Your Data

There are a few out-of-the-box events that Google Analytics 4 (GA4) tracks but custom events require a bit more configuration. GA4 events are freeform…

8-minute read
Maximizing Data Accuracy: How to Implement Referral Exclusion in Google Analytics 4

Maximizing Data Accuracy: How to Implement Referral Exclusion in Google Analytics 4

Introduction In the world of digital analytics, accurate and reliable data is crucial for understanding user behavior, optimizing marketing strategies, and driving business growth. …

4-minute read
Best Practices for Defining and Using Event Parameters in Google Analytics 4

Best Practices for Defining and Using Event Parameters in Google Analytics 4

Introduction Google Analytics 4 (GA4) has introduced a new way to track and measure user interactions on your website or app. Instead of events…

5-minute read
Navigating the Shift: Understanding the Impacts of Transitioning from Universal Analytics to Google Analytics 4

Navigating the Shift: Understanding the Impacts of Transitioning from Universal Analytics to Google Analytics 4

2022 marked a significant shift in the digital analytics landscape. Google announced that Universal Analytics would stop processing hits in July 2023 (July 2024…

3-minute read
Cross-Device Tracking in Google Analytics 4: How to Identify Users Across Multiples Devices

Cross-Device Tracking in Google Analytics 4: How to Identify Users Across Multiples Devices

Google introduced a new and improved way of tracking the user journey across multiple devices in Google Analytics 4 (GA4). In other words, cross-device…

5-minute read
Mastering Video Player Tracking in Google Analytics 4 Using the Player’s API

Mastering Video Player Tracking in Google Analytics 4 Using the Player’s API

Introduction In today’s digital landscape, video content has become increasingly prevalent across various online platforms. As a website or app owner, it is crucial…

8-minute read
Top 4 Considerations When Comparing Google Analytics 4 to Universal Analytics

Top 4 Considerations When Comparing Google Analytics 4 to Universal Analytics

In today’s digital landscape, understanding user behavior is crucial for businesses to optimize their online presence and drive growth. Google Analytics has been a…

5-minute read
Setting Up Google Analytics 4: A Step-by-Step Guide for Beginners

Setting Up Google Analytics 4: A Step-by-Step Guide for Beginners

In the digital age, data plays a crucial role in decision-making for businesses. Google Analytics 4 (GA4) is a powerful tool that enables website…

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.