GA4 e-commerce (demo)
12 concepts · 4 types
Reference9BigQuery Dataset1BigQuery Table1Tour1
Tours
A guided walk through the GA4 export schema, from raw dataset to the metrics built on top of it.
5 stepsStart tour
Subdirectories
- datasets - A sample of obfuscated Google Analytics BigQuery event export data for three months from the Google Merchandise Store is available as a public dataset in BigQuery.
- references - This directory contains specifications for data joins and definitions for user activity and purchase metrics.
- tables - Contains Google Analytics event export data from the
ga4_obfuscated_sample_ecommercedataset.
Recently updated
- GA4 essentials — A guided walk through the GA4 export schema, from raw dataset to the metrics built on top of it.
- Events table (Google Analytics BigQuery Export) — Contains Google Analytics event export data from the `ga4_obfuscated_sample_ecommerce` dataset.
- Overall Average Spend Per Purchase Session — The overall average amount spent across all unique purchase sessions.
- Average Spend Per Purchase Session By User — The average amount of money spent per purchase session for each individual user.
- Join Google Analytics Events to Google Ads Clicks — Join Google Analytics event data with Google Ads click data.
- Average Pageviews — The average number of pageviews per user.
- Average Transactions Per Purchaser — The average number of transactions made by purchasers.
- New User Count — The number of unique users who triggered a first_visit or first_open event.