Big Query Export Of GA4 Data
Nichelle Halstrom
Digital Marketer
Business Analyst
Data Analyst
Google Analytics
Google BigQuery
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.
