{"id":1806,"date":"2022-08-09T15:04:12","date_gmt":"2022-08-09T09:34:12","guid":{"rendered":"https:\/\/easyinsights.ai\/?p=1806"},"modified":"2025-04-17T13:02:42","modified_gmt":"2025-04-17T07:32:42","slug":"free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide","status":"publish","type":"post","link":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/","title":{"rendered":"Free Raw Data Export From Google Analytics4 (GA4) to Google BigQuery &#8211; An Easy Guide"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\"> 8<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/ga4tobq-1024x504.png\" alt=\"Google Analytics4 to Google BigQuery\" class=\"wp-image-1861\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-1024x504.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-300x148.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-768x378.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-940x462.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-345x170.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-525x258.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-720x354.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-626x308.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-317x156.png 317w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-484x238.png 484w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-665x327.png 665w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-541x266.png 541w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-813x400.png 813w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-455x224.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-340x167.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-293x144.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-267x131.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-195x96.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-50x25.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-60x30.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png 1470w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Google Analytics (GA4) is one of the most widely used analytics platforms. Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now populate data in BigQuery for free. BigQuery comes in handy as it is a cloud data warehouse that enables you to carry out extremely fast queries on huge datasets on raw data.&nbsp;<\/p>\n\n\n\n<p>You can export all of your raw data to BigQuery from Google Analytics 4, where you can then query the data with a SQL-like syntax. You can choose whether to export your data to external storage or import external data into BigQuery so that it can be combined with your Analytics data. In this blog we will discuss how you can export raw data from Google Analytics to BigQuery to use this information to improve your marketing strategy and increase your sales figures.<\/p>\n\n\n\n<p><strong>If you are interested in learning the best ways to export raw data from Universal Google Analytics, <a href=\"https:\/\/easyinsights.ai\/blog\/the-best-way-to-export-raw-data-from-google-analytics\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">click here<\/span><\/a>.<\/strong><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Jump ahead to:<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#Why_Should_You_Export_The_Data_From_Google_Analytics_4_To_BigQuery\" >Why Should You Export The Data From Google Analytics 4 To BigQuery?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#What_Are_The_Benefits_Of_Exporting_Data_From_Google_Analytics_4_To_BigQuery\" >What Are The Benefits Of Exporting Data From Google Analytics 4 To BigQuery?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#What_Is_The_Cost_Of_Exporting_Data_From_Google_Analytics_4_To_BigQuery\" >What Is The Cost Of Exporting Data From Google Analytics 4 To BigQuery?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#Exporting_Raw_Data_From_Google_Analytics_4_To_BigQuery\" >Exporting Raw Data From Google Analytics 4 To BigQuery<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#Step_1_Create_a_Google-APIs-Console_project_as_the_first_step\" >Step 1: Create a Google-APIs-Console project as the first step.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#Step_2_Activate_BigQuery\" >Step 2: Activate BigQuery<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#Step_3_Connect_Google_Analytics_4_to_BigQuery\" >Step 3: Connect Google Analytics 4 to BigQuery<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#Why_EasyInsights_can_be_used_to_sync_data_between_GA4_and_Google_Bigquery\" >Why EasyInsights can be used to sync data between GA4 and Google Bigquery?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#Final_Words\" >Final Words<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_Should_You_Export_The_Data_From_Google_Analytics_4_To_BigQuery\"><\/span>Why Should You Export The Data From Google Analytics 4 To BigQuery?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The raw data is extremely useful in producing valuable insights.&nbsp;You can precisely analyze your business processes using raw (unprocessed) data. Gathering raw data allows you to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Segment your audience<\/li>\n\n\n\n<li>Create targeted advertising<\/li>\n\n\n\n<li>Perform deep metrics analysis<\/li>\n\n\n\n<li>Track the entire user journey<\/li>\n\n\n\n<li>Objectively evaluate your business operations<\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/easyinsights.ai\/blog\/data-sampling-and-data-latency-issues-in-google-analytics-how-to-effectively-resolve-it\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Sampling<\/span><\/a> means extrapolating the analysis results for a given segment, when the amount of information is too big to process quickly. When you customise Google Analytics&#8217; reports, it will first check the default report to determine if the data you want is accessible. If the relevant data is absent, Google Analytics will examine the sessions in the visit tables. Google Analytics will sample the data to give your report if there are too many sessions.<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">Additional Reading &#8211; <a href=\"https:\/\/easyinsights.ai\/blog\/your-guide-to-data-sampling-in-ga4\/\">Everything You Need to Know About Data Sampling in GA4<\/a><\/span><\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/easyinsights.ai\/blog\/data-sampling-and-data-latency-issues-in-google-analytics-how-to-effectively-resolve-it\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Sampling<\/span><\/a> might significantly distort your analysis and make you underrate your results because you&#8217;re simply analyzing a subset of the data. If your insights are based on sampled data, you might face the possibility of spending money on ineffective advertising campaigns or cutting off ad channels that bring in money. So it is wise to avoid sampling because it can skew results. As the data we are importing from Google Analytics is the raw data and as we already have the data we are importing from GA4 in our control, we can also fill our Big Query with unsampled data. So, Google BigQuery can assist you in producing unsampled results.<\/p>\n\n\n\n<p>Among marketers worldwide, Google BigQuery is undoubtedly the most popular data warehouse. It is a multi-cloud data warehouse with a built-in query service, high levels of security, and scalability. Since BigQuery is a component of the Google ecosystem, it naturally integrates with other Google products and helps in the rapid growth of your business. BigQuery allows you to query huge datasets and get effective outputs, making it crucial to pull data from GA4 to BigQuery.<\/p>\n\n\n\n<p><strong><em>Additional Reading &#8211; <a href=\"https:\/\/easyinsights.ai\/blog\/google-bigquery-for-marketers-a-comprehensive-overview\/\">Google Big Query for Marketers: A Comprehensive Overview<\/a><\/em><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Are_The_Benefits_Of_Exporting_Data_From_Google_Analytics_4_To_BigQuery\"><\/span>What Are The Benefits Of Exporting Data From Google Analytics 4 To BigQuery?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It facilitates the storage of your data in Google Cloud&#8217;s BigQuery and\/or the transfer of that data to your data warehouse in other clouds like AWS, Azure, or Snowflake.<\/li>\n\n\n\n<li>It facilitates the storage of unsampled data, and hence more accurate analysis.<\/li>\n\n\n\n<li>You can combine and enhance your data with additional contextual, CRM, and marketing data.<\/li>\n\n\n\n<li>You can use <a href=\"https:\/\/easyinsights.ai\/blog\/the-3-best-data-visualization-tools-for-digital-marketing-folks\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Business Intelligence tools<\/span><\/a> like <a href=\"https:\/\/lookerstudio.google.com\/\">Data Studio<\/a>, <a href=\"https:\/\/www.tableau.com\/\">Tableau<\/a> or <a href=\"https:\/\/powerbi.microsoft.com\/en-au\/\">PowerBI<\/a> to visualise your data.<\/li>\n\n\n\n<li>You can carry out a detailed analysis of your raw data.<\/li>\n\n\n\n<li>With BigQuery, you can analyze any type of data in real-time, and perform quick SQL analysis.<\/li>\n\n\n\n<li>It gives you complete control over your project and a high level of security.<\/li>\n\n\n\n<li>It provides native Google product integration.<\/li>\n\n\n\n<li>You can simply adapt to the rapidly changing environment since it is scalable.<\/li>\n\n\n\n<li>You can create machine learning prediction models for data that is both structured and semi-structured.<\/li>\n\n\n\n<li>You can analyze geospatial data using the BigQuery Geographic Information System (GIS) and decide which consumers should receive mailers for particular retail locations<\/li>\n<\/ul>\n\n\n\n<p>Besides these, there are many other advantages of the BigQuery export, like connecting multiple data streams from GA4 property to pull into BigQuery.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Is_The_Cost_Of_Exporting_Data_From_Google_Analytics_4_To_BigQuery\"><\/span>What Is The Cost Of Exporting Data From Google Analytics 4 To BigQuery?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You might wonder how much this exporting would cost. However, you will be happy to know that exporting data from GA4 to BigQuery is free, and no cost is involved. BigQuery linking is undoubtedly one of the most exciting new features in the new Google Analytics (GA4). Now that the data export to BigQuery has been enabled, all GA4 property owners can start using the raw event data collected on their websites and apps.&nbsp;<\/p>\n\n\n\n<p>Everyone can access the data export function in GA4 for free. You only pay for the actual data storage and querying when your usage exceeds the Google Cloud free tier limit. Your credit card won&#8217;t be charged until you&#8217;ve used 10 GB of storage and 1 TB of monthly querying.<\/p>\n\n\n\n<p><em>Note: Only Google cloud projects with billing enabled can export real-time data using the &#8220;Streaming&#8221; option.<\/em><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"950\" height=\"376\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM.png\" alt=\"Streaming option in Google Analytics 4 - GA4\" class=\"wp-image-1811\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM.png 950w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-300x119.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-768x304.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-940x372.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-345x137.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-525x208.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-720x285.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-626x248.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-586x232.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-880x348.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-455x180.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-340x135.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-293x116.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-267x106.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-195x77.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-50x20.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.25.35-PM-60x24.png 60w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Exporting_Raw_Data_From_Google_Analytics_4_To_BigQuery\"><\/span>Exporting Raw Data From Google Analytics 4 To BigQuery<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can start exporting the data if it is already present in Google Analytics 4. You will require GA4 Property and Google Cloud Project with Admin rights to start your export procedure. Make sure both of these are using the same email address. Once you have these, follow the following steps to export the data.&nbsp;<\/p>\n\n\n\n<p>To pull your data from Google Analytics 4 to BigQuery:<\/p>\n\n\n\n<p>1. Create a <a href=\"https:\/\/console.cloud.google.com\/getting-started\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Google-APIs-Console<\/span><\/a> project.<\/p>\n\n\n\n<p>2. Enable BigQuery.<\/p>\n\n\n\n<p>3. Link BigQuery to a Google Analytics 4 property.<\/p>\n\n\n\n<p>Let\u2019s take a detailed look at all the steps to pull data from GA4 to BigQuery.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_1_Create_a_Google-APIs-Console_project_as_the_first_step\"><\/span>Step 1: Create a Google-APIs-Console project as the first step.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>To setup an APIs-Console project:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the <a href=\"https:\/\/console.cloud.google.com\/getting-started\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Google APIs Console<\/span><\/a> and<strong> log in.<\/strong><\/li>\n\n\n\n<li>Click on <strong>Select a project<\/strong>.<\/li>\n\n\n\n<li>Choose an existing project or start a new one.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"249\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-1024x249.png\" alt=\"Select a project option in Google Big Query\" class=\"wp-image-1813\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-1024x249.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-300x73.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-768x187.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-1536x373.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-2048x498.png 2048w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-940x229.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-345x84.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-525x128.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-720x175.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-626x152.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-586x142.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-880x214.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-455x111.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-340x83.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-293x71.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-267x65.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-195x47.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-50x12.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.35.18-PM-60x15.png 60w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_2_Activate_BigQuery\"><\/span>Step 2: Activate BigQuery<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Visit the <strong>table of APIs.<\/strong><\/li>\n\n\n\n<li>Select <strong>Library<\/strong> by clicking <strong>APIs &amp; Services<\/strong> from the <strong>Navigation <\/strong>menu.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"400\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-1024x400.png\" alt=\"APIs &amp; Services\" class=\"wp-image-1814\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-1024x400.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-300x117.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-768x300.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-1536x600.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-2048x799.png 2048w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-940x367.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-345x135.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-525x205.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-720x281.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-626x244.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-586x229.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-880x344.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-455x178.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-340x133.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-293x114.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-267x104.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-195x76.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-50x20.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.28.18-AM-60x23.png 60w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Select the <strong>BigQuery API option<\/strong> under <strong>Google Cloud APIs.<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"356\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-1024x356.png\" alt=\"BigQuery API\" class=\"wp-image-1815\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-1024x356.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-300x104.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-768x267.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-1536x534.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-2048x712.png 2048w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-940x327.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-345x120.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-525x183.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-720x250.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-626x218.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-586x204.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-880x306.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-455x158.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-340x118.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-293x102.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-267x93.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-195x68.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-50x17.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-11.29.55-AM-60x21.png 60w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>When a new page appears,<strong> click Enable.<\/strong><\/li>\n\n\n\n<li>To your Cloud project, <a href=\"https:\/\/cloud.google.com\/iam\/docs\/creating-managing-service-accounts\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">add a service account<\/span><\/a>. Check that firebase-measurement@system.gserviceaccount.com is a project member with the <a href=\"https:\/\/cloud.google.com\/iam\/docs\/understanding-roles#primitive_role_definitions\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">editor-role<\/span><\/a> assigned.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_3_Connect_Google_Analytics_4_to_BigQuery\"><\/span>Step 3: Connect Google Analytics 4 to BigQuery<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter your <a href=\"https:\/\/analytics.google.com\/analytics\/web\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">Google Analytics login information<\/span><\/strong><\/a><strong>.<\/strong> The account should have Edit access to the Google Analytics 4 property you&#8217;re working with and Owner access to your BigQuery project.<\/li>\n\n\n\n<li>Go to the <strong><a href=\"https:\/\/support.google.com\/analytics\/answer\/6132368\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Admin section<\/span><\/a><\/strong>, and find the<strong> <a href=\"https:\/\/support.google.com\/analytics\/answer\/6099198\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">Analytics property<\/span><\/a><\/strong> you need to link to BigQuery.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"560\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-1024x560.png\" alt=\"BigQuery Link\" class=\"wp-image-1816\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-1024x560.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-300x164.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-768x420.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-1536x840.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-2048x1120.png 2048w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-933x510.png 933w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-342x187.png 342w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-519x284.png 519w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-713x390.png 713w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-620x339.png 620w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-285x156.png 285w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-435x238.png 435w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-598x327.png 598w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-487x266.png 487w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-732x400.png 732w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-455x249.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-340x186.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-293x160.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-267x146.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-195x107.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-345x189.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-50x27.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.51.06-PM-60x33.png 60w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Set<strong> BigQuery Linking <\/strong>on in the <strong>Property <\/strong>column.<\/li>\n\n\n\n<li>Click<strong> Link<\/strong><\/li>\n\n\n\n<li>After clicking Link, Click to view the projects you have access to<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"519\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-1024x519.png\" alt=\"BigQuery project\" class=\"wp-image-1818\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-1024x519.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-300x152.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-768x389.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-1536x779.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-2048x1039.png 2048w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-940x477.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-345x175.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-525x266.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-720x365.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-626x317.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-308x156.png 308w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-469x238.png 469w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-645x327.png 645w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-789x400.png 789w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-455x231.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-340x172.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-293x149.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-267x135.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-195x99.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-50x25.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.52-PM-60x30.png 60w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Select a <strong>BigQuery project.<\/strong> Click <strong>Learn more <\/strong>to begin a new BigQuery project.<\/li>\n\n\n\n<li>Click <strong>Confirm<\/strong> after selecting your project.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"168\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-1024x168.png\" alt=\"BigQuery project confirmation\" class=\"wp-image-1819\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-1024x168.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-300x49.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-768x126.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-1536x252.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-2048x335.png 2048w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-940x154.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-345x56.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-525x86.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-720x118.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-626x103.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-586x96.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-880x144.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-455x75.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-340x56.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-293x48.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-267x44.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-195x32.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-50x8.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.13-PM-60x10.png 60w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Choose a location<\/strong>. (You cannot define this option if your project already contains a dataset for the Analytics property.)<\/li>\n\n\n\n<li>Choose<strong> Next.<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"671\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-1024x671.png\" alt=\"BigQuery project location\" class=\"wp-image-1820\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-1024x671.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-300x197.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-768x503.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-1536x1006.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-778x510.png 778w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-285x187.png 285w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-433x284.png 433w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-595x390.png 595w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-517x339.png 517w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-238x156.png 238w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-363x238.png 363w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-499x327.png 499w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-406x266.png 406w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-611x400.png 611w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-455x298.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-340x223.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-293x192.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-267x175.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-195x128.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-345x226.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-50x33.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM-60x39.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.50.27-PM.png 1856w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Choose the <strong>data streams<\/strong> from which you wish to export the information.<\/li>\n\n\n\n<li>Check Add advertising identifiers for mobile app streams if you need to include them.<\/li>\n\n\n\n<li>Set the Frequency to Daily Export.<\/li>\n\n\n\n<li>Click <strong>Submit.<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"541\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-1024x541.png\" alt=\"Data Stream\" class=\"wp-image-1822\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-1024x541.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-300x158.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-768x406.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-1536x812.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-940x497.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-345x182.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-525x277.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-720x380.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-626x331.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-295x156.png 295w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-450x238.png 450w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-619x327.png 619w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-503x266.png 503w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-757x400.png 757w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-455x240.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-340x180.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-293x155.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-267x141.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-195x103.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-50x26.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM-60x32.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/Screenshot-2022-08-09-at-2.49.07-PM.png 1942w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p><strong>Within 24 hours, Google Analytics 4 data will appear in your BigQuery project.&nbsp;<\/strong><\/p>\n\n\n\n<p>You will have all raw user behavior data in BigQuery. However, you must include cost data from advertising providers, data from CRM systems, call monitoring services, and mobile apps to do marketing analysis and identify your growth zones and weak points. The data should also be combined into a single dataset and made business-ready so marketers can quickly produce reports using BigQuery data.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/easyinsights.ai\/book-demo\/\" target=\"_blank\" rel=\"noreferrer noopener\">Want experts to handle it for you? Book a demo<\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_EasyInsights_can_be_used_to_sync_data_between_GA4_and_Google_Bigquery\"><\/span>Why EasyInsights can be used to sync data between GA4 and Google Bigquery?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here&#8217;s why:<\/p>\n\n\n\n<p><strong>Complexity and Efficiency:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Automation:<\/strong> EasyInsights automates the entire process of extracting, transforming, and loading data, saving you countless hours of manual work and potential errors.<\/li>\n\n\n\n<li><strong>Data Volume:<\/strong> Handling large datasets efficiently becomes challenging with manual methods. EasyInsights is optimized for bulk data movement, ensuring smooth and efficient migration.<\/li>\n<\/ul>\n\n\n\n<p><strong>Enhanced Data Quality and Flexibility:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Filtering and Transformation:<\/strong> Clean and transform data before loading it into BigQuery for better analysis with myriad filters. Filtering unwanted data or restructuring records for specific needs becomes much easier with EasyInsights.<\/li>\n\n\n\n<li><strong>Customizable Pipelines:<\/strong> Build complex data pipelines for various scenarios. Need to combine GA4 data with other sources? EasyInsights makes these syncs, seamless.<\/li>\n\n\n\n<li><strong>Data Validation:<\/strong> Ensure data integrity by implementing data quality checks and error handling routines.<\/li>\n<\/ul>\n\n\n\n<p><strong>Additional Benefits:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Security and Governance:<\/strong> Integrated access control within EasyInsights workflow, enhances data security and governance.<\/li>\n\n\n\n<li><strong>Scalability:<\/strong> Easily scale your data processing needs as your data volume grows without worrying about manual limitations.<\/li>\n\n\n\n<li><strong>Version Control:<\/strong> Track changes to your data transformations and revert to previous versions if needed.<\/li>\n\n\n\n<li><strong>Collaboration:<\/strong> Share and collaborate with your team for better data management.<\/li>\n<\/ul>\n\n\n\n<p><strong>Here are some use cases where EasyInsights excels in GA4 to BigQuery exports:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Integrating GA4 data with other marketing platforms (CRM, etc.)<\/strong><\/li>\n\n\n\n<li><strong>Running advanced analytics requiring granular user-level data<\/strong><\/li>\n\n\n\n<li><strong>Handling large or growing data volumes efficiently<\/strong><\/li>\n\n\n\n<li><strong>Maintaining data quality and consistency across various sources<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Ultimately, the decision to use such tools depends on your specific needs and technical expertise. But if you&#8217;re dealing with complex data pipelines, large datasets, or require more control and flexibility, EasyInsights can be a true game-changer for your GA4 to BigQuery data integration.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Final_Words\"><\/span>Final Words<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>New features in Google Analytics 4 (GA4) include a brand-new data model, user interface, Data API, and BigQuery Export, which is now accessible to all users. Exporting the data means making the most out of it to scale your business. We hope this article helped you understand the process of exporting the data, and now you are comfortable using your own Google Analytics 4 data in BigQuery.<\/p>\n\n\n\n<p>If you are interested in learning the best ways to export raw data from Universal Google Analytics, <span style=\"text-decoration: underline;\"><a href=\"https:\/\/easyinsights.ai\/blog\/the-best-way-to-export-raw-data-from-google-analytics\/\" target=\"_blank\" rel=\"noreferrer noopener\">click here<\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now populate data in BigQuery for free. BigQuery comes in handy as it is a cloud data warehouse that enables you to carry out extremely fast queries on huge datasets on raw data.\u00a0<\/p>\n","protected":false},"author":6,"featured_media":1861,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[158,19],"tags":[94,93],"class_list":["post-1806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytic-platform","category-digital-analytics","tag-ga4","tag-google-analytics"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Export Raw Data From Google Analytics 4 to Google BigQuery<\/title>\n<meta name=\"description\" content=\"Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now harvest data in BigQuery for free.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export Raw Data From Google Analytics 4 to Google BigQuery\" \/>\n<meta property=\"og:description\" content=\"Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now harvest data in BigQuery for free.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"EasyInsights\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-09T09:34:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-17T07:32:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1470\" \/>\n\t<meta property=\"og:image:height\" content=\"723\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Piyush Gupta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@easy_insights\" \/>\n<meta name=\"twitter:site\" content=\"@easy_insights\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Piyush Gupta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/\"},\"author\":{\"name\":\"Piyush Gupta\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4\"},\"headline\":\"Free Raw Data Export From Google Analytics4 (GA4) to Google BigQuery &#8211; An Easy Guide\",\"datePublished\":\"2022-08-09T09:34:12+00:00\",\"dateModified\":\"2025-04-17T07:32:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/\"},\"wordCount\":1672,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png\",\"keywords\":[\"GA4\",\"google analytics\"],\"articleSection\":[\"Analytic Platform\",\"Digital Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/\",\"url\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/\",\"name\":\"Export Raw Data From Google Analytics 4 to Google BigQuery\",\"isPartOf\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png\",\"datePublished\":\"2022-08-09T09:34:12+00:00\",\"dateModified\":\"2025-04-17T07:32:42+00:00\",\"description\":\"Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now harvest data in BigQuery for free.\",\"breadcrumb\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage\",\"url\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png\",\"contentUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png\",\"width\":1470,\"height\":723,\"caption\":\"ga4tobq\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/easyinsights.ai\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Free Raw Data Export From Google Analytics4 (GA4) to Google BigQuery &#8211; An Easy Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#website\",\"url\":\"https:\/\/easyinsights.ai\/blog\/\",\"name\":\"EasyInsights\",\"description\":\"Uncover Growth in Digital Marketing Data\",\"publisher\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/easyinsights.ai\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\",\"name\":\"Easyinsights\",\"url\":\"https:\/\/easyinsights.ai\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png\",\"contentUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png\",\"width\":649,\"height\":117,\"caption\":\"Easyinsights\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809\",\"https:\/\/x.com\/easy_insights\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4\",\"name\":\"Piyush Gupta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g\",\"caption\":\"Piyush Gupta\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Export Raw Data From Google Analytics 4 to Google BigQuery","description":"Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now harvest data in BigQuery for free.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/","og_locale":"en_US","og_type":"article","og_title":"Export Raw Data From Google Analytics 4 to Google BigQuery","og_description":"Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now harvest data in BigQuery for free.","og_url":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/","og_site_name":"EasyInsights","article_publisher":"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809","article_published_time":"2022-08-09T09:34:12+00:00","article_modified_time":"2025-04-17T07:32:42+00:00","og_image":[{"width":1470,"height":723,"url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png","type":"image\/png"}],"author":"Piyush Gupta","twitter_card":"summary_large_image","twitter_creator":"@easy_insights","twitter_site":"@easy_insights","twitter_misc":{"Written by":"Piyush Gupta","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#article","isPartOf":{"@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/"},"author":{"name":"Piyush Gupta","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4"},"headline":"Free Raw Data Export From Google Analytics4 (GA4) to Google BigQuery &#8211; An Easy Guide","datePublished":"2022-08-09T09:34:12+00:00","dateModified":"2025-04-17T07:32:42+00:00","mainEntityOfPage":{"@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/"},"wordCount":1672,"commentCount":4,"publisher":{"@id":"https:\/\/easyinsights.ai\/blog\/#organization"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png","keywords":["GA4","google analytics"],"articleSection":["Analytic Platform","Digital Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/","url":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/","name":"Export Raw Data From Google Analytics 4 to Google BigQuery","isPartOf":{"@id":"https:\/\/easyinsights.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png","datePublished":"2022-08-09T09:34:12+00:00","dateModified":"2025-04-17T07:32:42+00:00","description":"Google Analytics 4 makes it easier than ever to analyse data in Google BigQuery. Almost anyone may now harvest data in BigQuery for free.","breadcrumb":{"@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#primaryimage","url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png","contentUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq.png","width":1470,"height":723,"caption":"ga4tobq"},{"@type":"BreadcrumbList","@id":"https:\/\/easyinsights.ai\/blog\/free-raw-data-export-from-google-analytics4-ga4-to-google-bigquery-an-easy-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/easyinsights.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Free Raw Data Export From Google Analytics4 (GA4) to Google BigQuery &#8211; An Easy Guide"}]},{"@type":"WebSite","@id":"https:\/\/easyinsights.ai\/blog\/#website","url":"https:\/\/easyinsights.ai\/blog\/","name":"EasyInsights","description":"Uncover Growth in Digital Marketing Data","publisher":{"@id":"https:\/\/easyinsights.ai\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/easyinsights.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/easyinsights.ai\/blog\/#organization","name":"Easyinsights","url":"https:\/\/easyinsights.ai\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png","contentUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png","width":649,"height":117,"caption":"Easyinsights"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/EasyInsightsai-522100504893809","https:\/\/x.com\/easy_insights"]},{"@type":"Person","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4","name":"Piyush Gupta","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g","caption":"Piyush Gupta"}}]}},"fimg_url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/08\/ga4tobq-1024x504.png","reading_time":"9 minutes","_links":{"self":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/1806"}],"collection":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/comments?post=1806"}],"version-history":[{"count":16,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/1806\/revisions"}],"predecessor-version":[{"id":8830,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/1806\/revisions\/8830"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/media\/1861"}],"wp:attachment":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/media?parent=1806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/categories?post=1806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/tags?post=1806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}