gizdevans/ga4-bq-flattened-data

---
license: mit
task_categories:
- tabular-classification
language:
- en
pretty_name: GA4 BigQuery Flattened Dataset
size_categories:
- 1M<n<10M
---

task_categories:
- tabular-classification
tags:
- ga4
- ecommerce
- google-analytics
- bigquery
---

# GA4 BigQuery Flattened Dataset

This dataset provides a processed, "flattened" version of the Google Analytics 4 (GA4) public obfuscated dataset.

## Processing Overview
The original data was transformed from its native nested BigQuery structure into a flat tabular format to simplify analysis and machine learning workflows.

**Key Modifications:**
* **Items Removed**: The `items` nested arrays have been excluded from this version to maintain a clean, single-row-per-event structure.
* **Flattened Schema**: All `event_params` and `user_properties` have been unnested and mapped to individual columns.

## Resources & Documentation
* **BigQuery Source Path:** `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_*`
* **In-depth Article:** For a full walkthrough of the profiling and flattening logic, see the Medium post: [Profiling and Flattening GA4 Data in BigQuery: A Step-by-Step Walkthrough](https://medium.com/@dmitrijs.gizdevans/profiling-and-flattening-ga4-data-in-bigquery-a-step-by-step-walkthrough-46d7f9e629a5)
* **Project Repository:** All SQL scripts and export workflows are available on GitHub: [dgizdevans/ga4-bq-flatten](https://github.com/dgizdevans/ga4-bq-flatten/tree/main)

## License
This dataset is distributed under the MIT license, consistent with the public availability of the source data.