BigQuery GA4 Export Schema by MeasureSchool
저자: Julian Juenemann
1. event_value_in_usd
2. event_bundle_sequence_id
3. event_server_timestamp_offset
4. user_id
5. user_pseudo_id
6. user_properties (Repeated)
6.1. key
6.2. value
6.2.1. string_value
6.2.2. int_value
6.2.3. float_value
6.2.4. double_value
7. user_ltv
7.1. revenue
7.2. currency
8. geo
8.1. continent
8.2. country
8.3. region
8.4. city
8.5. sub_continent
8.6. metro
9. traffic_source
9.1. name
9.2. medium
9.3. source
10. platform
11. ecommerce
11.1. total_item_quantity
11.2. purchase_revenue_in_usd
11.3. purchase_revenue
11.4. refund_value_in_usd
11.5. refund_value
11.6. shipping_value_in_usd
11.7. shipping_value
11.8. tax_value_in_usd
11.9. tax_value
11.10. unique_items
11.11. transaction_id
12. event_date
13. event_timestamp
14. event_name
15. event_params (Repeated)
15.1. key
15.2. value
15.2.1. string_value
15.2.2. int_value
15.2.3. float_value
15.2.4. double_value
16. event_previous_timestamp
17. privacy_info
17.1. analytics_storage
17.2. ads_storage
17.3. uses_transient_token
18. user_first_touch_timestamp
19. device
19.1. category
19.2. mobile_brand_name
19.3. mobile_model_name
19.4. mobile_marketing_name
19.5. mobile_os_hardware_model
19.6. operating_system
19.7. operating_system_version
19.8. vendor_id
19.9. advertising_id
19.10. language
19.11. is_limited_ad_tracking
19.12. time_zone_offset_seconds
19.13. browser
19.14. browser_version
19.15. web_info
19.15.1. browser
19.15.2. browser_version
19.15.3. hostname