# Important Notes ## GA4\_BQ vs GA4\_BQ\_STG There are two schemas created by the GA4 BQ integration: `ga4_bq_stg` and `ga4_bq` ### **GA4\_BQ\_STG** This is a staging schema for data extracted from your GA4 export tables in BigQuery Many of the standard reports have 2 different tables: a `_stg1` table and a `_stg2` table. The difference between these tables is whether they were extracted from the daily export or the streaming export. Note: The multi-channel funnel report is the only report that isn't split out into 2 separate tables because the table contains data from both the daily and streaming export. The `_stg1` tables contain data from the fully processed daily export, while the `_stg2` tables contain data from the real-time streaming export. The `_stg1` and `_stg2` tables need to be blended to give a full picture of your data. ### **GA4\_BQ** This is the destination schema for `ga4_bq_stg` data that has been prepped and stitched. Currently there is only base code that transforms multi-channel funnel and hourly data from the `ga4_bq_stg` tables into the `ga4_bq` tables. In the future, we will have base code that stitches data from the Landing Page, PDP Performance, Shopping Stage, Traffic, and Transactions data from the `ga4_bq_stg` schema into the `ga4_bq` schema. However, that code does not yet exist. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/google-analytics-4/bigquery-integration/important-notes.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.