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

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.