Overview
The ga4_obfuscated_sample_ecommerce dataset contains obfuscated Google Analytics BigQuery event export data for three months (November 2020 to January 2021) from the Google Merchandise Store. This public dataset is available in BigQuery and emulates a real-world dataset.
Pre-requisites
To work with this dataset, you need access to a Google Cloud project with the BigQuery API enabled. You can use BigQuery Sandbox mode or the Free usage tier for exploration and sample queries.
Limitations
The dataset contains obfuscated data with placeholder values like <Other>, NULL, and ''. Due to obfuscation, the internal consistency of the dataset might be somewhat limited. It cannot be compared to the Google Analytics Demo Account.
Using the dataset
You can access the ga4_obfuscated_sample_ecommerce dataset via the BigQuery UI in the Cloud Console.
Sample Query
The following query shows the number of unique events, users, and days in the dataset:
SELECT
COUNT(*) AS event_count,
COUNT(DISTINCT user_pseudo_id) AS user_count,
COUNT(DISTINCT event_date) AS day_count
FROM `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_*`