Connecting GA4

  1. Open Connections from the account menu.
  2. Click Connect next to Google Analytics.
  3. Sign in with your Google account and grant access.
  4. Select your GA4 property from the list.
  5. Click Enable — data begins syncing immediately.

Available Data

TableKey Columns
Sessionssession_date, user_pseudo_id, ga_session_id, session_duration_seconds, pageviews, is_bounce, landing_page, exit_page, session_source, session_medium, session_default_channel_group, device_category, geo_country, geo_city, is_first_visit
Pageviewsevent_date, user_pseudo_id, ga_session_id, page_location, page_title, page_referrer, engagement_time_msec, session_source, session_medium, device_category, geo_country
Usersfirst_seen, last_seen, total_sessions, total_pageviews, avg_session_duration_seconds, bounce_rate, acquisition_source, acquisition_medium, device_category, geo_country, is_new_user
Traffic Sourcessession_date, source, medium, channel_group, sessions, users, new_users, pageviews, bounce_rate, avg_session_duration_seconds
Conversionsevent_date, event_name, page_location, session_source, session_medium, device_category, geo_country
Real-timeActive users in the last 30 minutes with page, country, and device breakdowns

Example Questions

  • "How many sessions did we get this month?"
  • "What are our top 10 landing pages?"
  • "Show me traffic by source for the last 30 days"
  • "What's our bounce rate on mobile vs desktop?"
  • "Who is on our site right now?"

Notes

  • GA4 BigQuery export is enabled automatically when you connect.
  • Historical data is backfilled for the available period.
  • Real-time data covers the last 30 minutes.