GA4 table definitions - willsql4food/LakehouseToolkit GitHub Wiki

Table ga_users

user_id|string|None user_info__last_active_timestamp_micros|bigint|None user_info__user_first_touch_timestamp_micros|bigint|None user_info__first_purchase_date|string|None device__operating_system|string|None device__category|string|None device__mobile_brand_name|string|None device__mobile_model_name|string|None device__unified_screen_name|string|None geo__city|string|None geo__country|string|None geo__continent|string|None geo__region|string|None user_ltv__revenue_in_usd|double|None user_ltv__sessions|bigint|None user_ltv__engagement_time_millis|bigint|None user_ltv__purchases|bigint|None user_ltv__engaged_sessions|bigint|None user_ltv__session_duration_micros|bigint|None predictions__in_app_purchase_score_7d|double|None predictions__purchase_score_7d|double|None predictions__churn_score_7d|double|None predictions__revenue_28d_in_usd|double|None privacy_info__is_limited_ad_tracking|string|None privacy_info__is_ads_personalization_allowed|string|None occurrence_date|string|None last_updated_date|string|None user_id|string|None

Table ga_users_user_properties

user_id|string|None key|string|None string_value|string|None set_timestamp_micros|int|None user_property_name|string|None user_id|string|None key|string|None

Table ga_users_audiences

user_id|string|None id|int|None name|string|None membership_start_timestamp_micros|int|None membership_expiry_timestamp_micros|int|None npa|boolean|None user_id|string|None name|string|None id|int|None

Table ga_pseudonymous_users

pseudo_user_id|string|None stream_id|string|None user_info__last_active_timestamp_micros|bigint|None user_info__user_first_touch_timestamp_micros|bigint|None user_info__first_purchase_date|string|None device__operating_system|string|None device__category|string|None device__mobile_brand_name|string|None device__mobile_model_name|string|None device__unified_screen_name|string|None geo__city|string|None geo__country|string|None geo__continent|string|None geo__region|string|None user_ltv__revenue_in_usd|double|None user_ltv__sessions|bigint|None user_ltv__engagement_time_millis|bigint|None user_ltv__purchases|bigint|None user_ltv__engaged_sessions|bigint|None user_ltv__session_duration_micros|bigint|None predictions__in_app_purchase_score_7d|double|None predictions__purchase_score_7d|double|None predictions__churn_score_7d|double|None predictions__revenue_28d_in_usd|double|None privacy_info__is_limited_ad_tracking|string|None privacy_info__is_ads_personalization_allowed|string|None occurrence_date|string|None last_updated_date|string|None pseudo_user_id|string|None

Table ga_pseudonymous_users_user_properties

pseudo_user_id|string|None key|string|None string_value|string|None set_timestamp_micros|int|None user_property_name|string|None pseudo_user_id|string|None key|string|None

Table ga_pseudonymous_users_audiences

pseudo_user_id|string|None id|int|None name|string|None membership_start_timestamp_micros|int|None membership_expiry_timestamp_micros|int|None npa|boolean|None pseudo_user_id|string|None name|string|None id|int|None

Table ga_events

join_key|string|None ga_session_id|int|None user_pseudo_session_id|string|None event_date|string|None event_timestamp|bigint|None event_name|string|None event_previous_timestamp|bigint|None event_value_in_usd|double|None event_bundle_sequence_id|bigint|None event_server_timestamp_offset|bigint|None user_id|string|None user_pseudo_id|string|None privacy_info__analytics_storage|string|None privacy_info__ads_storage|string|None privacy_info__uses_transient_token|string|None user_first_touch_timestamp|bigint|None user_ltv__revenue|double|None user_ltv__currency|string|None device__category|string|None device__mobile_brand_name|string|None device__mobile_model_name|string|None device__mobile_marketing_name|string|None device__mobile_os_hardware_model|string|None device__operating_system|string|None device__operating_system_version|string|None device__vendor_id|string|None device__advertising_id|string|None device__language|string|None device__is_limited_ad_tracking|string|None device__time_zone_offset_seconds|bigint|None device__browser|string|None device__browser_version|string|None device__web_info__browser|string|None device__web_info__browser_version|string|None device__web_info__hostname|string|None geo__city|string|None geo__country|string|None geo__continent|string|None geo__region|string|None geo__sub_continent|string|None geo__metro|string|None app_info__id|string|None app_info__version|string|None app_info__install_store|string|None app_info__firebase_app_id|string|None app_info__install_source|string|None traffic_source__name|string|None traffic_source__medium|string|None traffic_source__source|string|None stream_id|string|None platform|string|None event_dimensions__hostname|string|None ecommerce__total_item_quantity|bigint|None ecommerce__purchase_revenue|double|None ecommerce__purchase_revenue_in_usd|double|None ecommerce__refund_value|double|None ecommerce__refund_value_in_usd|double|None ecommerce__shipping_value|double|None ecommerce__shipping_value_in_usd|double|None ecommerce__tax_value|double|None ecommerce__tax_value_in_usd|double|None ecommerce__unique_items|bigint|None ecommerce__transaction_id|string|None collected_traffic_source__manual_campaign_id|string|None collected_traffic_source__manual_campaign_name|string|None collected_traffic_source__manual_source|string|None collected_traffic_source__manual_medium|string|None collected_traffic_source__manual_term|string|None collected_traffic_source__manual_content|string|None collected_traffic_source__gclid|string|None collected_traffic_source__dclid|string|None collected_traffic_source__srsltid|string|None is_active_user|boolean|None join_key|string|None

Table ga_events_items

join_key|string|None item_id|string|None item_name|string|None item_brand|string|None item_variant|string|None item_category|string|None item_category2|string|None item_category3|string|None item_category4|string|None item_category5|string|None price_in_usd|double|None price|double|None quantity|double|None item_revenue_in_usd|double|None item_revenue|double|None item_refund_in_usd|double|None item_refund|double|None coupon|string|None affiliation|string|None location_id|string|None item_list_id|string|None item_list_name|string|None item_list_index|string|None promotion_id|string|None promotion_name|string|None creative_name|string|None creative_slot|string|None string_val|string|None int_val|int|None float_val|double|None double_val|double|None join_key|string|None

Table ga_events_event_params

join_key|string|None key|string|None string_val|string|None int_val|int|None float_val|double|None double_val|double|None join_key|string|None key|string|None

Table ga_events_user_properties

join_key|string|None key|string|None string_val|string|None int_val|int|None float_val|double|None double_val|double|None set_timestamp_micros|int|None join_key|string|None

⚠️ GitHub.com Fallback ⚠️