Database schema

This document describes all available columns organized by scope.

Name	Display Name	Scope	Type	Description
id	Event ID	event	String	A unique event identifier, generated server-side when the hit is received, used to deduplicate events.
name	Event Name	event	String	The name of the event. This identifies the action the user performed (e.g., 'page_view', 'click', 'purchase', 'sign_up').
property_id	Property ID	event	String	The unique identifier for the property that sent this event, used to distinguish between different tracked properties and route data to appropriate destinations.
property_name	Property Name	event	String	The name of the property that sent this event.
date_utc	Event Date (UTC)	event	Date	The date when the event occurred in the UTC timezone, formatted as YYYY-MM-DD.
timestamp_utc	Event Timestamp (UTC)	event	Datetime (s, UTC)	The precise UTC timestamp of when the event occurred, with second-level precision. This represents the time recorded when the hit is received by the server.
client_id	Client ID	event	String	The Client ID is a unique, randomly generated identifier assigned to each device-browser pair or app installation. It is stored client-side and sent with every event, enabling the analytics system to calculate the number of unique users. It is also used as one of the identifiers that merge events into a session.
user_id	User ID	event	String	An optional, user-provided identifier for authenticated users. It is set by the tracking implementation when a user is logged in (and can be identified) and enables tracking across devices and sessions for the same user.
ip_address	IP Address	event	String	The IP address (IPv4 or IPv6) from which the tracking request originates, used as the source for geolocation data.
page_location	Page Location	event	String	The complete URL of the page where the event occurred, including protocol, domain, path, and query parameters (e.g., 'https://www.example.com/products/shoes?color=red&size=10'). Tracking parameters (UTM, click IDs) are excluded once extracted into dedicated columns.
page_hostname	Page Hostname	event	String	The hostname of the page where the event occurred, as specified in the URL (e.g., 'www.example.com', 'shop.example.com').
page_path	Page Path	event	String	The path of the page where the event occurred, as specified in the URL (e.g., '/products/shoes', '/blog/article-name').
page_title	Page Title	event	String	The title of the page where the event occurred, as specified in the HTML title tag.
page_referrer	Page Referrer	event	String	The URL of the page that referred the user to the current page, set to empty string for direct traffic or when referrer information is not available.
platform	Platform	event	String	The platform from which the event was sent. Identifies whether the event originated from a website, mobile app, or another source (e.g., 'web', 'ios', or 'android').
utm_campaign	UTM Campaign	event	String	The campaign name from the 'utm_campaign' URL parameter, used to identify specific marketing campaigns (e.g., 'summer_sale', 'product_launch_2024').
utm_source	UTM Source	event	String	The traffic source from the 'utm_source' URL parameter, identifies where the traffic originated (e.g., 'google', 'facebook', 'newsletter').
utm_medium	UTM Medium	event	String	The traffic medium from the 'utm_medium' URL parameter, identifies the marketing medium (e.g., 'cpc', 'email', 'social', 'organic').
utm_content	UTM Content	event	String	The content identifier from the 'utm_content' URL parameter, used to differentiate similar content or links within the same campaign (e.g., 'banner_top', 'button_cta').
utm_term	UTM Term	event	String	The search term from the 'utm_term' URL parameter, used primarily for paid search campaigns to identify the keywords that triggered the ad.
utm_id	UTM ID	event	String	The campaign ID from the 'utm_id' URL parameter, used to identify a specific campaign with a unique identifier for integration with advertising platforms.
utm_source_platform	UTM Source Platform	event	String	The source platform from the 'utm_source_platform' URL parameter, identifies the platform of the traffic source (e.g., 'Google Ads', 'Display & Video 360', 'Meta Ads').
utm_creative_format	UTM Creative Format	event	String	The creative format from the 'utm_creative_format' URL parameter, identifies the format of the creative asset.
utm_marketing_tactic	UTM Marketing Tactic	event	String	The marketing tactic from the 'utm_marketing_tactic' URL parameter, describes the targeting criteria (e.g., 'remarketing', 'prospecting').
click_id_gclid	Google gclid	event	String	Google Click ID from Google Ads campaigns, extracted from the 'gclid' parameter in the page URL, used for tracking ad clicks and linking conversions to Google Ads.
click_id_dclid	Google dclid	event	String	Google Click ID from Google Display & Video 360 campaigns, extracted from the 'dclid' parameter in the page URL, used for tracking display ad clicks and conversions.
click_id_gbraid	Google gbraid	event	String	Google Click ID for iOS app-to-web conversions, extracted from the 'gbraid' parameter in the page URL, used for privacy-preserving attribution from iOS apps.
click_id_srsltid	Google srsltid	event	String	Google Shopping Result Click ID, extracted from the 'srsltid' parameter in the page URL, used for tracking clicks from Google Shopping results.
click_id_wbraid	Google wbraid	event	String	Google Click ID for iOS web-to-app conversions, extracted from the 'wbraid' parameter in the page URL, used for privacy-preserving attribution to iOS apps.
click_id_fbclid	Facebook fbclid	event	String	Meta Click ID from Meta Ads campaigns (Facebook, Instagram, WhatsApp), extracted from the 'fbclid' parameter in the page URL, used for tracking ad clicks and linking conversions to Meta Ads.
click_id_msclkid	Microsoft msclkid	event	String	Microsoft Click ID from Microsoft Advertising campaigns, extracted from the 'msclkid' parameter in the page URL, used for tracking Bing/Microsoft ad clicks and conversions.
geo_city	City	event	String	Stub column, always returns null, since your geolocation provider does not implement this column.
geo_region	Region	event	String	Stub column, always returns null, since your geolocation provider does not implement this column.
geo_metro	Metro Area	event	String	Stub column, always returns null, since your geolocation provider does not implement this column.
geo_country	Country	event	String	Stub column, always returns null, since your geolocation provider does not implement this column.
geo_continent	Continent	event	String	Stub column, always returns null, since your geolocation provider does not implement this column.
geo_sub_continent	Sub-Continent	event	String	Stub column, always returns null, since your geolocation provider does not implement this column.
device_category	Device Category	event	String	The type of device used to access the site, extracted from the User-Agent header or query parameters (e.g., 'smartphone', 'desktop', 'tablet', ...).
device_language	Device Language	event	String	The language setting of the user's device, extracted from the User-Agent header or device information, based on ISO 639 standard for languages and ISO 3166 for country codes (e.g., 'en-us', 'en-gb', 'de-de').
device_mobile_brand_name	Device Brand (mobile)	event	String	The brand name of the mobile device, populated only for mobile devices, extracted from User-Agent header (e.g., 'Apple', 'Samsung', 'Google').
device_mobile_model_name	Device Model (mobile)	event	String	The model name of the mobile device, populated only for mobile devices, extracted from User-Agent header (e.g., 'iPhone 13', 'Galaxy S21').
device_operating_system	Operating System	event	String	The operating system running on the user's device, extracted from the User-Agent header (e.g., 'iOS', 'Android', 'Windows', 'macOS', 'GNU/Linux').
device_operating_system_version	Operating System Version	event	String	The version of the operating system running on the user's device, extracted from the User-Agent header (e.g., '26.0.1', '18.7').
device_web_browser	Web Browser	event	String	The browser used to access the site, extracted from the User-Agent header (e.g., 'Chrome', 'Safari', 'Firefox', 'Mobile Safari').
device_web_browser_version	Web Browser Version	event	String	The version of the browser used to access the site, extracted from the User-Agent header (e.g., '141.0.0.0', '26.0.1').
tracking_protocol	Tracking Protocol	event	String	The tracking protocol implementation used to send this event. Identifies which protocol parser processed the incoming hit (e.g., 'ga4_gtag', 'ga4_firebase').
ignore_referrer	Ignore Referrer	event	Boolean	If true, referrer must not be used for session source attribution.
measurement_id	Measurement ID	event	String	The Google Analytics 4 measurement / tracking identifier. A unique identifier for the property that sent this event. Extracted from the first-party cookie. Use only to compare numbers with GA4. For real property data calculated on the backend, use the property_id column.
params_ignore_referrer	Ignore Referrer	event	Boolean	Indicates whether to ignore the referrer information.
params_engagement_time_ms	Engagement Time (ms)	event	Numeric (Int64)	The time in milliseconds a user was engaged with the app or page.
ecommerce_purchase_revenue	Ecommerce Purchase Revenue	event	Numeric (Float64)	The total purchase revenue calculated by summing item_revenue across all items in the event. Only populated for purchase events. Represents the total transaction value from purchased items.
ecommerce_purchase_revenue_in_usd	Ecommerce Purchase Revenue (USD)	event	Numeric (Float64)	The total purchase revenue converted to USD, calculated from ecommerce_purchase_revenue using the currency converter.
ecommerce_refund_value	Ecommerce Refund Value	event	Numeric (Float64)	The total refund value calculated by summing item_refund across all items in the event. Only populated for refund events, zero otherwise. Represents the total value refunded.
ecommerce_refund_value_in_usd	Ecommerce Refund Value (USD)	event	Numeric (Float64)	The total refund value converted to USD, calculated from ecommerce_refund_value using the currency converter.
ecommerce_shipping_value	Ecommerce Shipping Value	event	Numeric (Float64)	The shipping cost associated with the transaction, extracted from the params_shipping parameter, with zero as default if not present. Only populated for purchase and refund events.
ecommerce_shipping_value_in_usd	Ecommerce Shipping Value (USD)	event	Numeric (Float64)	The total shipping cost converted to USD, calculated from ecommerce_shipping_value using the currency converter.
ecommerce_tax_value	Tax Value	event	Numeric (Float64)	The ecommerce tax value for the transaction.
ecommerce_tax_value_in_usd	Tax Value (USD)	event	Numeric (Float64)	The ecommerce tax value converted to USD, calculated from ecommerce_tax_value using the currency converter.
ecommerce_items_total_quantity	Ecommerce Items Total Quantity	event	Numeric (Int64)	Total quantity of all items in the event, calculated by summing the quantity field across all items. Represents the total number of product units in the transaction.
ecommerce_unique_items	Ecommerce Unique Items	event	Numeric (Int64)	The count of unique items in the event, determined by distinct item_id or item_name values. Useful for understanding product variety in transactions.
ecommerce_items	Ecommerce Items	event	Array<item: Object<item_id: String, item_name: String, affiliation: String, coupon: String, discount: Numeric (Float64), index: Numeric (Float64), item_brand: String, item_category: String, item_category2: String, item_category3: String, item_category4: String, item_category5: String, item_list_id: String, item_list_name: String, item_variant: String, location_id: String, price: Numeric (Float64), price_in_usd: Numeric (Float64), quantity: Numeric (Float64), item_refund: Numeric (Float64), item_refund_in_usd: Numeric (Float64), item_revenue: Numeric (Float64), item_revenue_in_usd: Numeric (Float64), promotion_id: String, promotion_name: String, creative_name: String, creative_slot: String>, nullable>	An array of ecommerce items associated with the event. Each item contains detailed product information including: item_id, item_name, affiliation, coupon, discount, index, item_brand, item_category (1-5 levels), item_list_id, item_list_name, item_variant, location_id, price, price_in_usd, quantity, item_refund, item_refund_in_usd, item_revenue, item_revenue_in_usd, promotion_id, promotion_name, creative_name, and creative_slot. Used in ecommerce events like purchase, add_to_cart, view_item, etc.
ga_session_id	GA Session ID	event	String	The Google Analytics 4 session identifier. A unique identifier for the current session, used by GA4 to group events into sessions. Extracted from the first-party cookie. Use only to compare numbers with GA4. For real session data calculated on the backend, use the session_id column.
ga_session_number	GA Session Number	event	Numeric (Int64)	The Google Analytics 4 sequential count of sessions for this user. Increments with each new session (e.g., 1 for first session, 2 for second). Extracted from the first-party cookie.
gtm_debug	GTM Debug	event	String	The Tag Manager debug mode identifier, present when the Tag Manager is running in debug/preview mode for testing.
page_load_hash	Page Load Hash	event	Datetime (s, UTC)	Timestamp when the page was loaded. Usually contains a millisecond-precision Unix timestamp. Used to correlate events from the same page load. For ga4_gtag tracking protocol, extracted from the _p parameter.
params	Event Params	event	Array<item: Object<name: String, value_string: String, value_number: Numeric (Float64)>, nullable>	All the parameters associated with the event.
params_aclid	Apple aclid (Param)	event	String	The Apple Search Ads campaign ID for attribution (e.g., 'aclid_12345').
privacy_ads_storage	Privacy Ads Storage	event	Boolean	Indicates whether the user has consented to advertising. Extracted from the Google Consent Settings (gcs) parameter.
privacy_analytics_storage	Privacy Analytics Storage	event	Boolean	Indicates whether the user has consented to analytics. Extracted from the Google Consent Settings (gcs) parameter.
params_anid	Android anid (Param)	event	String	The Android Advertising ID for attribution (e.g., 'anid_abc123').
params_achievement_id	Achievement ID	event	String	The ID of the achievement unlocked (e.g., 'A_12345', 'first_win').
params_ad_event_id	Ad Event ID	event	String	A unique identifier for an ad event (e.g., 'ad_click_001', 'impression_xyz').
params_ad_unit_code	Ad Unit Code	event	String	The code or name of the ad unit where an ad is displayed (e.g., 'banner_top', 'sidebar_300x250').
params_app_version	App Version	event	String	The version number of the application (e.g., '1.2.3', '2.0.1').
params_campaign	Campaign	event	String	The campaign name associated with the traffic source (e.g., 'summer_sale', 'brand_awareness').
params_campaign_content	Campaign Content	event	String	Used to differentiate ads or links within the same campaign (e.g., 'banner_blue', 'textlink_red').
params_campaign_id	Campaign ID	event	String	The unique identifier for the campaign (e.g., 'camp_12345', 'Q1_2024_001').
params_campaign_medium	Campaign Medium	event	String	The medium of the campaign traffic (e.g., 'cpc', 'email', 'social').
params_campaign_source	Campaign Source	event	String	The source of the campaign traffic (e.g., 'google', 'newsletter', 'facebook').
params_campaign_term	Campaign Term	event	String	The paid search keywords for the campaign (e.g., 'running shoes', 'best laptop').
params_cancellation_reason	Cancellation Reason	event	String	The reason a user canceled a subscription or service (e.g., 'too_expensive', 'not_using_enough').
params_character	Character	event	String	The character selected or used by the player (e.g., 'warrior', 'Player 1').
params_content_description	Content Description	event	String	A description of the content viewed or interacted with (e.g., 'product review', 'how-to guide').
params_content_group	Content Group	event	String	A category grouping for content (e.g., 'blog', 'videos', 'products').
params_content_id	Content ID	event	String	The unique identifier for a piece of content (e.g., 'article_001', 'video_xyz').
params_content_type	Content Type	event	String	The type of content viewed or interacted with (e.g., 'article', 'video', 'product').
params_coupon	Coupon	event	String	The coupon code applied to a transaction (e.g., 'SAVE20', 'FREESHIP').
params_creative_name	Creative Name	event	String	The name of the creative used in advertising (e.g., 'summer_banner_v2', 'product_showcase').
params_creative_slot	Creative Slot	event	String	The position or slot where the creative was displayed (e.g., 'slot_1', 'homepage_hero').
params_currency	Currency	event	String	The currency code for monetary values (e.g., 'USD', 'EUR', 'GBP').
params_dclid	Google dclid (Param)	event	String	The DoubleClick Click Identifier for attribution (e.g., 'dclid_xyz789').
params_deferred_analytics_collection	Deferred Analytics Collection	event	Boolean	Indicates if analytics collection was deferred.
params_disqualified_lead_reason	Disqualified Lead Reason	event	String	The reason a lead was disqualified (e.g., 'out_of_territory', 'invalid_contact').
params_exposure_time	Exposure Time	event	Numeric (Int64)	The time a promotion or element was visible to the user.
params_fatal	Fatal	event	Boolean	Indicates if an error or exception was fatal.
params_file_extension	File Extension	event	String	The extension of a downloaded or interacted file (e.g., 'pdf', 'jpg', 'xlsx').
params_file_name	File Name	event	String	The name of a downloaded or interacted file (e.g., 'whitepaper.pdf', 'product_catalog.xlsx').
params_firebase_error	Firebase Error	event	String	The type or code of a Firebase error (e.g., 'auth_failed', 'network_timeout').
params_firebase_error_value	Firebase Error Value	event	String	The specific value or message of a Firebase error (e.g., 'invalid_credentials', 'connection_lost').
params_firebase_previous_class	Firebase Previous Class	event	String	The class name of the previous screen in the app (e.g., 'MainActivity', 'ProfileActivity').
params_firebase_previous_id	Firebase Previous ID	event	String	The identifier of the previous screen in the app (e.g., 'screen_home', 'screen_profile').
params_firebase_previous_screen	Firebase Previous Screen	event	String	The name of the previous screen viewed in the app (e.g., 'Home', 'Product Detail').
params_firebase_screen	Firebase Screen	event	String	The name of the current screen viewed in the app (e.g., 'Home', 'Checkout').
params_firebase_screen_class	Firebase Screen Class	event	String	The class name of the current screen in the app (e.g., 'MainActivity', 'CheckoutActivity').
params_firebase_screen_id	Firebase Screen ID	event	String	The identifier of the current screen in the app (e.g., 'screen_home', 'screen_checkout').
params_form_destination	Form Destination	event	String	The destination URL or page after form submission (e.g., '/thank-you', '/confirmation').
params_form_id	Form ID	event	String	The unique identifier of the form (e.g., 'contact_form_01', 'newsletter_signup').
params_form_name	Form Name	event	String	The name of the form (e.g., 'Contact Us', 'Newsletter Subscription').
params_form_submit_text	Form Submit Text	event	String	The text on the form submit button (e.g., 'Submit', 'Send Message', 'Subscribe').
params_free_trial	Free Trial	event	Boolean	Indicates if a subscription or in app purchase includes a free trial.
params_ga_session_id	GA Session ID	event	String	The Google Analytics 4 session identifier. A unique identifier for the current session, used to group events into sessions. Extracted from the first-party cookie. Use only to compare numbers with GA4. For real session data calculated on the backend, use the session_id column.
params_ga_session_number	GA Session Number	event	Numeric (Int64)	The Google Analytics 4 sequential count of sessions for this user. Increments with each new session (e.g., 1 for first session, 2 for second). Extracted from the first-party cookie.
params_gclid	Google gclid (Param)	event	String	The Google Click Identifier for attribution from Google Ads (e.g., 'gclid_abc123def').
params_group_id	Group ID	event	String	The identifier for a group or cohort (e.g., 'group_a', 'beta_testers').
params_introductory_price	Introductory Price	event	Numeric (Float64)	The introductory or promotional price for a product or subscription.
params_item_list_id	Item List ID	event	String	The identifier for a list of items (e.g., 'related_products', 'search_results').
params_item_list_name	Item List Name	event	String	The name of a list of items (e.g., 'Related Products', 'Search Results').
params_item_name	Item Name	event	String	The name of an item or product (e.g., 'Blue Running Shoes', 'Wireless Headphones').
params_label	Label	event	String	A custom label for categorization or tracking (e.g., 'promo_click', 'special_offer').
params_language	Language	event	String	The language code of the content or interface (e.g., 'en', 'es', 'fr').
params_lead_source	Lead Source	event	String	The source from which a lead originated (e.g., 'website_form', 'trade_show', 'referral').
params_lead_status	Lead Status	event	String	The status of a lead in the sales process (e.g., 'qualified', 'contacted', 'converted').
params_level	Level	event	Numeric (Int64)	The level number in a game or progression system.
params_level_name	Level Name	event	String	The name of a level in a game or progression system (e.g., 'Tutorial Island', 'Boss Battle 3').
params_link_classes	Link Classes	event	String	The CSS classes of a clicked link (e.g., 'btn btn-primary', 'nav-link').
params_link_domain	Link Domain	event	String	The domain of a clicked link (e.g., 'example.com', 'partner-site.org').
params_link_id	Link ID	event	String	The ID attribute of a clicked link (e.g., 'cta_button', 'footer_link_1').
params_link_text	Link Text	event	String	The visible text of a clicked link (e.g., 'Learn More', 'Download Now').
params_link_url	Link URL	event	String	The full URL of a clicked link (e.g., 'https://example.com/page').
params_message_device_time	Message Device Time	event	Numeric (Int64)	The device time when a message was sent or received.
params_message_id	Message ID	event	String	The unique identifier for a message (e.g., 'msg_12345', 'notification_abc').
params_message_name	Message Name	event	String	The name or title of a message or notification (e.g., 'Welcome Email', 'Promotion Alert').
params_message_time	Message Time	event	Numeric (Int64)	The server time when a message was sent or received.
params_message_type	Message Type	event	String	The type of message sent or received (e.g., 'notification', 'in-app_message', 'email').
params_method	Method	event	String	The method used for an action like signup, login or share events (e.g., 'Google', 'Facebook', 'Email').
params_outbound	Outbound	event	Boolean	Indicates if a link click is outbound.
params_payment_type	Payment Type	event	String	The payment method used for a transaction (e.g., 'credit_card', 'paypal', 'apple_pay').
params_percent_scrolled	Percent Scrolled	event	Numeric (Float64)	The percentage of a page scrolled by the user.
params_previous_app_version	Previous App Version	event	String	The previous version of the app before an update (e.g., '1.1.0', '2.3.5').
params_previous_first_open_count	Previous First Open Count	event	Numeric (Int64)	The count of first opens before the current session.
params_previous_gmp_app_id	Previous GMP App ID	event	String	The previous Google Mobile Platform app identifier (e.g., 'app_id_123', 'old_app_456').
params_previous_os_version	Previous OS Version	event	String	The previous operating system version before an update (e.g., 'iOS 14.0', 'Android 10').
params_price	Price	event	Numeric (Float64)	The price of an item or product.
params_product_id	Product ID	event	String	The unique identifier for a product (e.g., 'SKU12345', 'prod_abc').
params_promotion_id	Promotion ID	event	String	The unique identifier for a promotion (e.g., 'promo_001', 'summer_sale_2024').
params_promotion_name	Promotion Name	event	String	The name of a promotion (e.g., 'Summer Sale', 'BOGO Deal').
params_quantity	Quantity	event	Numeric (Float64)	The quantity of items in a transaction or action.
params_renewal_count	Renewal Count	event	Numeric (Int64)	The number of times a subscription has been renewed.
params_reset_analytics_cause	Reset Analytics Cause	event	String	The reason analytics data was reset (e.g., 'user_request', 'app_reinstall').
params_reward_type	Reward Type	event	String	The type of reward earned (e.g., 'coins', 'badge', 'power_up').
params_reward_value	Reward Value	event	Numeric (Float64)	The value or amount of the reward earned.
params_score	Score	event	Numeric (Int64)	The score achieved in a game or activity.
params_screen_resolution	Screen Resolution	event	String	The screen resolution of the user's device (e.g., '1920x1080', '375x667').
params_search_term	Search Term	event	String	The search query entered by the user (e.g., 'running shoes', 'best laptop 2024').
params_shipping	Shipping	event	Numeric (Float64)	The shipping cost for a transaction.
params_shipping_tier	Shipping Tier	event	String	The shipping tier or method selected (e.g., 'standard', 'express', 'overnight').
params_srsltid	Google srsltid (Param)	event	String	The Shopping Ads result ID for attribution (e.g., 'srsltid_12345').
params_subscription	Subscription	event	Boolean	Indicates if a purchase is a subscription.
params_success	Success	event	Boolean	Indicates if an action was successful.
params_system_app	System App	event	Boolean	Indicates if an app is a system app.
params_system_app_update	System App Update	event	Boolean	Indicates if a system app was updated.
params_tax	Tax	event	Numeric (Float64)	The tax amount for a transaction.
params_topic	Topic	event	String	The topic or category of content (e.g., 'technology', 'sports', 'finance').
params_transaction_id	Transaction ID	event	String	The unique identifier for a transaction (e.g., 'T12345', 'order_abc123').
params_unconvert_lead_reason	Unconvert Lead Reason	event	String	The reason a lead was unconverted or lost (e.g., 'no_response', 'chose_competitor').
params_updated_with_analytics	Updated with Analytics	event	Boolean	Indicates if analytics was updated.
params_value	Value	event	Numeric (Float64)	The monetary value associated with an event.
params_video_current_time	Video Current Time	event	Numeric (Int64)	The current playback time of a video in seconds.
params_video_duration	Video Duration	event	Numeric (Int64)	The total duration of a video in seconds.
params_video_percent	Video Percent	event	Numeric (Int64)	The percentage of a video watched.
params_video_provider	Video Provider	event	String	The provider or platform hosting the video (e.g., 'youtube', 'vimeo', 'self-hosted').
params_video_title	Video Title	event	String	The title of the video (e.g., 'Product Demo', 'How-To Tutorial').
params_video_url	Video URL	event	String	The URL of the video (e.g., 'https://youtube.com/watch?v=abc').
params_virtual_currency_name	Virtual Currency Name	event	String	The name of the virtual currency used (e.g., 'coins', 'gems', 'credits').
params_visible	Visible	event	Boolean	Indicates if an element was visible to the user.
session_is_entry	Session Is Entry Event	session-scoped-event	Numeric (Int64)	An integer flag indicating whether this event is the first event (entry point) of the session. Returns 1 for the first event in the session, 0 for all subsequent events.
session_hit_number	Session Hit Number	session-scoped-event	Numeric (Int64)	The sequential number of this event within its session, starting from 0. This is the index position of the event in the chronological sequence of all events in the same session.
session_page_number	Session Page Number	session-scoped-event	Numeric (Int64)	The sequential page number within the session, starting from 0. Increments when the page location changes. Tracks which page view in the session this event occurred on.
time_on_page	Time On Page	session-scoped-event	Numeric (Int64)	Time spent on a particular page, calculated as the interval between subsequent page view events in seconds, or using other events timestamps if no subsequent page view was recorded.
session_is_entry_page	Session Is Entry Page	session-scoped-event	Numeric (Int64)	An integer flag indicating whether this event is the first page view in the session. Returns 1 for the first page view event in the session, 0 for all other events. Returns 0 if there are no page views in the session.
session_is_exit_page	Session Is Exit Page	session-scoped-event	Numeric (Int64)	An integer flag indicating whether this event is the last page view in the session. Returns 1 for the last page view event in the session, 0 for all other events. Returns 0 if there are no page views in the session.
next_page_location	Next Page Location	session-scoped-event	String	The URL of the next page viewed in the session after the current page. Only populated when a page transition is detected. Returns nil for the first page or when no page change has occurred.
previous_page_location	Previous Page Location	session-scoped-event	String	The URL of the previous page viewed in the session before the current page. Only populated when a page transition is detected. Returns nil for the first page or when no page change has occurred.
next_page_title	Next Page Title	session-scoped-event	String	The title of the next page viewed in the session after the current page. Only populated when a page transition is detected. Returns nil for the first page or when no page change has occurred.
previous_page_title	Previous Page Title	session-scoped-event	String	The title of the previous page viewed in the session before the current page. Only populated when a page transition is detected. Returns nil for the first page or when no page change has occurred.
session_id	Session ID	session	String	A unique identifier for the session, derived from the first event's ID in the session, used to group all events that belong to the same user session.
session_source	Session Source	session	String	Traffic origin (e.g., google, facebook, direct) detected from referrer, click IDs, or UTM parameters. For details, see the D8A documentation on traffic attribution.
session_medium	Session Medium	session	String	Marketing channel (e.g., organic, cpc, social, email, referral) classifying how traffic arrived. For details, see the D8A documentation on traffic attribution.
session_term	Session Term	session	String	Search keyword or campaign term extracted from referrer query parameters or UTM tags. For details, see the D8A documentation on traffic attribution.
session_referrer	Session Referrer	session	String	The referrer of the session. Collected from the first event in the session.
session_duration	Session Duration	session	Numeric (Int64)	The duration of the session in seconds, calculated as the difference between the last event time and the first event time. Zero for single-event sessions.
session_total_events	Session Total Events	session	Numeric (Int64)	The total number of events that occurred during this session. Includes all event types (page views, clicks, custom events, etc.).
session_first_event_time	Session First Event Time	session	Datetime (s, UTC)	The timestamp of the first event in the session. Marks the beginning of the user's session and is used as the baseline for calculating session duration.
session_last_event_time	Session Last Event Time	session	Datetime (s, UTC)	The timestamp of the last event in the session. Marks the end of the user's session and is used along with first_event_time to calculate session duration.
session_entry_page_location	Session Entry Page Location	session	String	The URL of the first page view event in the session.
session_second_page_location	Session Second Page Location	session	String	The URL of the second page view event in the session. Useful for analyzing user navigation patterns after landing.
session_exit_page_location	Session Exit Page Location	session	String	The URL of the last page view event in the session.
session_entry_page_title	Session Entry Page Title	session	String	The title of the first page view event in the session.
session_second_page_title	Session Second Page Title	session	String	The title of the second page view event in the session. Useful for analyzing user navigation patterns after landing.
session_exit_page_title	Session Exit Page Title	session	String	The title of the last page view event in the session.
session_utm_campaign	Session UTM Campaign	session	String	The UTM campaign from the first page view event in the session.
session_utm_source	Session UTM Source	session	String	The UTM source from the first page view event in the session.
session_utm_medium	Session UTM Medium	session	String	The UTM medium from the first page view event in the session.
session_utm_content	Session UTM Content	session	String	The UTM content from the first page view event in the session.
session_utm_term	Session UTM Term	session	String	The UTM term from the first page view event in the session.
session_utm_id	Session UTM ID	session	String	The UTM ID from the first page view event in the session.
session_utm_source_platform	Session UTM Source Platform	session	String	The UTM source platform from the first page view event in the session.
session_utm_creative_format	Session UTM Creative Format	session	String	The UTM creative format from the first page view event in the session.
session_utm_marketing_tactic	Session UTM Marketing Tactic	session	String	The UTM marketing tactic from the first page view event in the session.
session_click_id_gclid	Session Click ID GCLID	session	String	The Google Click ID (gclid) from the first page view event in the session.
session_click_id_dclid	Session Click ID DCLID	session	String	The Google Display & Video 360 Click ID (dclid) from the first page view event in the session.
session_click_id_gbraid	Session Click ID GBRAID	session	String	The Google Click ID for iOS app-to-web conversions (gbraid) from the first page view event in the session.
session_click_id_srsltid	Session Click ID SRSLTID	session	String	The Google Shopping Result Click ID (srsltid) from the first page view event in the session.
session_click_id_wbraid	Session Click ID WBRAID	session	String	The Google Click ID for iOS web-to-app conversions (wbraid) from the first page view event in the session.
session_click_id_fbclid	Session Click ID FBCLID	session	String	The Meta Click ID (fbclid) from the first page view event in the session.
session_click_id_msclkid	Session Click ID MSCLKID	session	String	The Microsoft Click ID (msclkid) from the first page view event in the session.
session_total_page_views	Session Total Page Views	session	Numeric (Int64)	The total number of page views (event name: page_view) in the session.
session_unique_page_views	Session Unique Page Views	session	Numeric (Int64)	The unique number of page views (event name: page_view) in the session. Deduplicated by page_location.
session_total_purchases	Session Total Purchases	session	Numeric (Int64)	The total number of purchases (event name: purchase) in the session.
session_total_scrolls	Session Total Scrolls	session	Numeric (Int64)	The total number of scrolls (event name: scroll) in the session.
session_total_outbound_clicks	Session Total Outbound Clicks	session	Numeric (Int64)	The total number of outbound clicks (event name: click) in the session.
session_unique_outbound_clicks	Session Unique Outbound Clicks	session	Numeric (Int64)	The unique number of outbound clicks (event name: click) in the session. Deduplicated by params_link_url.
session_total_site_searches	Session Total Site Searches	session	Numeric (Int64)	The total number of site searches (event name: view_search_results or search) in the session.
session_unique_site_searches	Session Unique Site Searches	session	Numeric (Int64)	The unique number of site searches (event name: view_search_results or search) in the session. Deduplicated by params_search_term.
session_total_form_interactions	Session Total Form Interactions	session	Numeric (Int64)	The total number of form interactions (event name: form_submit or form_start) in the session.
session_unique_form_interactions	Session Unique Form Interactions	session	Numeric (Int64)	The unique number of form interactions (event name: form_submit or form_start) in the session. Deduplicated by params_form_id.
session_total_video_engagements	Session Total Video Engagements	session	Numeric (Int64)	The total number of video engagements (event name: video_start, video_complete or video_progress) in the session.
session_total_file_downloads	Session Total File Downloads	session	Numeric (Int64)	The total number of file downloads (event name: file_download) in the session.
session_unique_file_downloads	Session Unique File Downloads	session	Numeric (Int64)	The unique number of file downloads (event name: file_download) in the session. Deduplicated by params_link_url.
session_split_cause	Session Split Cause	session	String	The cause of the split of the session. If the session was not split, this will be null. Possible values: null, utm_campaign_changed, user_id_changed, max_events_reached, max_time_since_first_event_reached.
session_is_engaged	Session Is Engaged	session	Numeric (Int64)	Session engagement indicator. Set to 1 if ANY event in the session is engaged (sessions with meaningful user interaction).
session_returning_user	Session Returning User	session	Numeric (Int64)	Returning user indicator. Set to 1 if any event in the session indicates that this is a subsequent session for the user. Derived from data extracted from the first-party cookie.
session_abandoned_cart	Session Abandoned Cart	session	Numeric (Int64)	Session abandoned cart indicator. Set to 1 if there's an add_to_cart event but no purchase event, or if add_to_cart occurs after the latest purchase event.