Skip to main content
Answer

GA4 to BQ backfill schema

  • November 20, 2024
  • 1 reply
  • 120 views
xuchen1987
Forum|alt.badge.img

the ga4 product does not offer a native bq backfill, therefore, i'd want to understand the exact schema of the data this is offering since supermetrics is doing some "magic" to backfill the data. if it's 100% the same as the native ga4 bq export.

Best answer by Kathy

Hi! Supermetrics uses the GA4 API to fetch data, so there are some key differences compared to the native export:

  • The native export contains nested data, which is not the case with Supermetrics. As a result, the data is more “report-ready.”
  • Unlike the native export, data is not available at the highest level of granularity, meaning fields like User ID or Session ID are not available when using the API/Supermetrics.
  • Queries are customizable, allowing you to choose what data is exported to BigQuery.

As long as your use case doesn’t require data at the highest level of granularity, Supermetrics can probably cover it. You can find a detailed list of fields in our documentation: https://supermetrics.com/docs/integration-google-analytics4-fields/

 

Sahra

1 reply

Kathy
Forum|alt.badge.img+2
  • Kathy
  • Supermetrics Team
  • Answer
  • November 21, 2024

Hi! Supermetrics uses the GA4 API to fetch data, so there are some key differences compared to the native export:

  • The native export contains nested data, which is not the case with Supermetrics. As a result, the data is more “report-ready.”
  • Unlike the native export, data is not available at the highest level of granularity, meaning fields like User ID or Session ID are not available when using the API/Supermetrics.
  • Queries are customizable, allowing you to choose what data is exported to BigQuery.

As long as your use case doesn’t require data at the highest level of granularity, Supermetrics can probably cover it. You can find a detailed list of fields in our documentation: https://supermetrics.com/docs/integration-google-analytics4-fields/

 

Terms & ConditionsCookie settingsAccessibility statement