Skip to main content

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.

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/

 


Reply