| session_id | Unique identifier for the session - contains only non-NULL values (cluster column) |
| stream_id | The numeric ID of the data stream from which the event originated |
| user_pseudo_id | Pseudonymous identifier for the user |
| property_id | Google Analytics property ID |
| table_suffix | Suffix of the events table name the event was sourced |
| is_final | Indicates if the data is final or subject to change (based on 72h window) |
| device.description | Information about the device from which the event originated - we take the first value of the session |
| device.category | The device category (mobile, tablet, desktop) |
| device.mobile_brand_name | Mobile device brand name |
| device.mobile_model_name | Mobile device model name |
| device.mobile_marketing_name | Mobile device marketing name |
| device.mobile_os_hardware_model | The device model information retrieved directly from the operating system |
| device.operating_system | Operating system name |
| device.operating_system_version | Operating system version |
| device.vendor_id | IDFV (present only if IDFA is not collected) |
| device.advertising_id | Advertising ID/IDFA |
| device.language | OS language setting |
| device.is_limited_ad_tracking | Indicates if ad tracking is limited. On iOS14+, returns false if the IDFA is non-zero |
| device.time_zone_offset_seconds | The offset from GMT in seconds |
| device.web_info.browser | Web browser name |
| device.web_info.browser_version | Web browser version |
| device.web_info.hostname | The hostname associated with the logged event |
| geo.description | Geographic information - first value of the session |
| geo.continent | The continent from which events were reported, based on IP address |
| geo.country | The country from which events were reported, based on IP address |
| geo.region | The region from which events were reported, based on IP address |
| geo.city | The city from which events were reported, based on IP address |
| geo.sub_continent | The subcontinent from which events were reported, based on IP address |
| geo.metro | The metro from which events were reported, based on IP address |
| app_info.description | Contains information about the app in which the event was initiated - first value of the session |
| app_info.id | The package name or bundle ID of the app |
| app_info.version | The app's versionName (Android) or short bundle version |
| app_info.install_store | The store that installed the app |
| app_info.firebase_app_id | The Firebase App ID associated with the app |
| app_info.install_source | The source that installed the app |
| platform | The data stream platform (Web, IOS or Android) from which the event originated |
| landing_page.description | Information about the landing page (first page_location of the session) |
| landing_page.landing_page_location | Full URL of the landing page |
| landing_page.landing_page_path | Path of the landing page |
| landing_page.landing_page_hostname | Hostname of the landing page |
| landing_page.landing_page_referrer | Referrer URL for the landing page |
| landing_page.landing_content_group | Content group of the landing page |
| session_traffic_source_last_click.description | The session_traffic_source_last_click RECORD contains the last-click attributed session traffic source data across Google ads and manual contexts, where available |
| session_traffic_source_last_click.manual_campaign.campaign_id | The ID of the last clicked manual campaign |
| session_traffic_source_last_click.manual_campaign.campaign_name | The name of the last clicked manual campaign |
| session_traffic_source_last_click.manual_campaign.source | The specific source within the platform of the last clicked manual campaign |
| session_traffic_source_last_click.manual_campaign.medium | The medium of the last clicked manual campaign (e.g., paid search, organic search, email) |
| session_traffic_source_last_click.manual_campaign.term | The keyword/search term of the last clicked manual campaign |
| session_traffic_source_last_click.manual_campaign.content | Additional metadata of the last clicked manual campaign |
| session_traffic_source_last_click.manual_campaign.source_platform | The platform of the last clicked manual campaign (e.g., search engine, social media) |
| session_traffic_source_last_click.manual_campaign.creative_format | The format of the creative of the last clicked manual campaign |
| session_traffic_source_last_click.manual_campaign.marketing_tactic | The marketing tactic of the last clicked manual campaign |
| session_traffic_source_last_click.google_ads_campaign.customer_id | The customer ID associated with the Google Ads account |
| session_traffic_source_last_click.google_ads_campaign.account_name | The name of the Google Ads account |
| session_traffic_source_last_click.google_ads_campaign.campaign_id | The ID of the Google Ads campaign |
| session_traffic_source_last_click.google_ads_campaign.campaign_name | The name of the Google Ads campaign |
| session_traffic_source_last_click.google_ads_campaign.ad_group_id | The ID of the ad group within the Google Ads campaign |
| session_traffic_source_last_click.google_ads_campaign.ad_group_name | The name of the ad group within the Google Ads campaign |
| user_id | Unique identifier for the user - last non-null value of the session |
| exit_page.description | Information about the exit page (last page_location of the session) |
| exit_page.exit_page_location | Full URL of the exit page |
| exit_page.exit_page_path | Path of the exit page |
| exit_page.exit_page_hostname | Hostname of the exit page |
| exit_page.exit_content_group | Content group of the exit page |
| ga_session_number | Google Analytics session number |
| session_date | Date of the session (partitioning column) - based on start date of the session |
| session_info.description | Additional session information |
| session_info.is_engaged_session | Indicates if the session is engaged |
| session_info.is_with_source | Indicates if any of the events of the session has a source |
| session_info.is_direct_session | Indicates if the session is direct (opposite of is_with_source) |
| session_info.is_debug_session | Indicates if the session is in debug mode |
| session_info.is_cross_domain | Indicates if any of the events in the session has a cross-domain source (based on the cross domain url parameter) |
| time.description | Time-related information for the session |
| time.session_start_timestamp_utc | Session start timestamp in UTC |
| time.session_end_timestamp_utc | Session end timestamp in UTC |
| time.engagement_time_msec | Sum of engagement time in milliseconds |
| time.session_duration_s | Session duration in seconds (based on start and end times) |
| session_source.description | Session source of actual session: first non-empty source of the session. Taken from 'fixed_traffic_source' |
| session_source.campaign_id | Campaign ID - utm_id |
| session_source.campaign | Campaign name - utm_campaign |
| session_source.source | Traffic source |
| session_source.medium | Traffic medium |
| session_source.term | Search term - utm_term |
| session_source.content | Content identifier - utm_content |
| session_source.gclid | Google Click Identifier |
| session_source.dclid | DoubleClick Click Identifier |
| session_source.srsltid | Search Result Slot Identifier (google shopping) |
| session_source.gbraid | Google Ads Click Identifier for iOS |
| session_source.wbraid | Google Ads Click Identifier for Web |
| session_source.msclkid | Microsoft Click Identifier |
| session_source.default_channel_grouping | Default channel grouping |
| session_source.source_platform | The platform responsible for directing traffic to a given Analytics property - utm_marketing_platform |
| session_source.creative_format | Type of creative - utm_creative_format |
| session_source.marketing_tactic | Targeting criteria applied to a campaign - utm_marketing_tactic |
| last_non_direct_traffic_source.description | Last non-direct traffic source information. Takes first_source if available, else last source of previous session within lookback window |
| last_non_direct_traffic_source.campaign_id | Campaign ID |
| last_non_direct_traffic_source.campaign | Campaign name |
| last_non_direct_traffic_source.source | Traffic source |
| last_non_direct_traffic_source.medium | Traffic medium |
| last_non_direct_traffic_source.term | Search term |
| last_non_direct_traffic_source.content | Content identifier |
| last_non_direct_traffic_source.gclid | Google Click Identifier |
| last_non_direct_traffic_source.dclid | DoubleClick Click Identifier |
| last_non_direct_traffic_source.srsltid | Search Result Slot Identifier |
| last_non_direct_traffic_source.gbraid | Google Ads Click Identifier for iOS |
| last_non_direct_traffic_source.wbraid | Google Ads Click Identifier for Web |
| last_non_direct_traffic_source.msclkid | Microsoft Click Identifier |
| last_non_direct_traffic_source.default_channel_grouping | Default channel grouping |