Big Query Export Of GA4 Data
Nichelle Halstrom
About The Client
This client was an eCommerce space Revenue for this client ranged from $100 - $200 Million Annually.
The request was to export Universal Analytics Data to Big Query and assist with flattening the nested structure within the GA4 data
Process & Tools Utilized
After identifying which metrics and dimensions were important to the client, the API schema was crafted.
From there, several servers were stood up to assist with the large export of data.
After exporting SQL was used to create relational databases.
From there, the data was then visualized in Google Data Studio.
Like this project
Posted Sep 25, 2024
Created GA4 event schema, ran API and imported into Big Query for data visualization.
