GA4 + BigQuery SQL Builder Project ID GA4 Table events_* users_* Dimensions event_date country source medium device.category page_location page_referrer session_source session_medium event_name event_timestamp Aggregated Metrics COUNT SUM AVG MAX MIN Session Count Engagement Time (Total) Engagement Time (Avg) event_count session_engaged Custom Param ➕ Add Another Metric Filters (optional) 🔽 Select Common Filter event_name = ‘page_view’ event_name IN (‘add_to_cart’, ‘purchase’) country = ‘United States’ device.category = ‘mobile’ Order By (optional) Limit (optional) ▶️ Generate SQL 📋 Copy SQL 🔁 Reset Generated SQL Notice: JavaScript is required for this content.
