I need to export RAW GA4 data for example using some kind of API and Python.
There are 4 APIs available:
- Google Analytics Reporting API
- Google Analytics API
- Google Analytics Data API
- Google Analytics Admin API
I used Data API and it return aggregated data.
Is there a way to export GA4 to have every event row by row?
If there is no such way then can you tell me where is this written in spec?
BIG Thanks for any answers
Jake
I think what you're looking for is to link your GA4 property to BigQuery. It's easy to set up the link in the GA4 admin area.
Mind you, I'm on this site right now looking for answers to a GA4 / BigQuery issue I'm having, so I can't wholly recommend this, but I do think it's the right general solution for your problem.
My problem is that I have already linked GA4 property to BQ and this worked fine but for some time in past my link was broken so I have gap in this raw data. So I was looking for a way how to fill this missing data gap. Note that I tried relinking GA4 to BQ but this not triggered backfill of historical data because this link was already created in the past and google do backfill only once at initial setup.
This article might help, https://www.optimizesmart.com/how-to-backfill-ga4-data-in-bigquery/
I haven't tried the backfill yet.