Events Export Schema

This document lists the fields included in the events data exports (e.g., Google BigQuery) and will be the reference for future export integrations. Use it to understand the structure, key identifiers, timestamps, and marketing attribution fields available in exports.

Notes

Field types are included within the descriptions for clarity.

“decoded” variants contain URL-decoded values of their counterparts.

Map(…) types represent JSON key/value pairs parsed into structured columns where supported.

Field	Description
`_timestamp`	DateTime column representing the timestamp of the event
`_is_deleted`	Int column indicating whether the record is deleted (likely a boolean represented as 0 or 1)
`_offset`	UInt64 column representing the offset in the data stream or log
`_kafka_timestamp_ms`	DateTime column representing the Kafka timestamp in milliseconds
`_partition`	UInt64 column representing the partition number (likely for distributed storage)
`api_key`	String column for storing API keys
`autocapture_attributes`	String column for storing automatically captured attributes
`source_page_url`	String column containing the source page URL without query parameters
`source_page_url_decoded`	String column containing the decoded source page URL without query parameters
`ac_text_label`	String column extracted from autocapture_attributes for element text
`ac_destination_url`	String column extracted from autocapture_attributes for href attribute
`ac_destination_url_decoded`	String column containing the decoded destination URL
`ac_tag_name`	String column extracted from autocapture_attributes for HTML tag name
`ac_event_type`	String column extracted from autocapture_attributes for event type
`ac_attr_id`	String column extracted from autocapture_attributes for id attribute
`ac_attr_name`	String column extracted from autocapture_attributes for name attribute
`ac_attr_class`	String column extracted from autocapture_attributes for class attribute (cleaned)
`ad_id`	String column extracted from URL parameter ‘ad_id’
`click_id_dclid`	String column extracted from URL parameter ‘dclid’
`click_id_fbclid`	String column for Facebook click ID
`click_id_gclid`	String column for Google click ID
`click_id_ko_click_id`	String column extracted from URL parameter ‘ko_click_id’
`click_id_li_fat_id`	String column extracted from URL parameter ‘li_fat_id’
`click_id_msclkid`	String column extracted from URL parameter ‘msclkid’
`click_id_ttclid`	String column extracted from URL parameter ‘ttclid’
`click_id_twclid`	String column extracted from URL parameter ‘twclid’
`click_id_wbraid`	String column extracted from URL parameter ‘wbraid’
`company_created_at`	String column for company creation timestamp
`parsed_company_created_at`	DateTime column parsed from company_created_at
`company_custom`	String column for custom company data
`company_custom_map`	Map(String, String) column parsed from company_custom JSON
`company_id`	String column for company ID
`company_name`	String column for company name
`default_channel`	String column determining the default marketing channel based on various parameters
`default_source`	String column determining the default traffic source based on various parameters
`doc_encoding`	String column for document encoding
`doc_host`	String column for document host
`parsed_doc_host`	String column containing the parsed domain from doc_host
`doc_path`	String column for document path
`doc_path_decoded`	String column containing the decoded document path
`doc_search`	String column for document search query
`event_date`	Date column derived from _timestamp
`event_attributes`	String column for event attributes
`event_attributes_map`	Map(String, String) column parsed from event_attributes JSON
`event_id`	String column for event ID
`event_type`	String column for event type
`eventn_ctx_event_id`	String column for event context ID
`ids_ajs_anonymous_id`	String column for Segment.io anonymous ID
`ids_ajs_user_id`	String column for Segment.io user ID
`ids_fbp`	String column for Facebook pixel ID
`ids_ga`	String column for Google Analytics ID
`local_tz_offset`	Int64 column for local timezone offset
`location_city`	String column for user’s city
`location_continent`	String column for user’s continent
`location_country`	String column for user’s country code
`location_country_name`	String column for user’s country name
`location_lat`	Float column for latitude
`location_lon`	Float column for longitude
`location_region`	String column for user’s region code
`location_region_name`	String column for user’s region name
`location_zip`	String column for user’s ZIP code
`page_title`	String column for page title
`parsed_device`	String column determining device type based on screen resolution
`parsed_referer`	String column containing the parsed referrer domain
`parsed_referer_channel`	String column for referrer channel
`parsed_referer_source`	String column for referrer source
`parsed_ua_bot`	Enum8 column indicating if the user agent is a bot
`parsed_ua_device_brand`	String column for user agent device brand
`parsed_ua_device_family`	String column for user agent device family
`parsed_ua_device_model`	String column for user agent device model
`parsed_ua_os_family`	String column for user agent OS family
`parsed_ua_os_version`	String column for user agent OS version
`parsed_ua_ua_family`	String column for user agent family
`parsed_ua_ua_version`	String column for user agent version
`project_id`	String column for project ID
`referer`	String column for referrer URL
`screen_resolution`	String column for screen resolution
`server_side_event`	Int column indicating if the event is server-side
`session_id`	String column for session ID
`source_ip`	String column for source IP address
`src`	String column for source
`url`	String column for URL
`url_decoded`	String column containing the decoded URL
`user_agent`	String column for user agent string
`user_anonymous_id`	String column for user’s anonymous ID
`user_created_at`	String column for user creation timestamp
`parsed_user_created_at`	DateTime column parsed from user_created_at
`user_custom`	String column for custom user data
`user_custom_map`	Map(String, String) column parsed from user_custom JSON
`user_email`	String column for user’s email
`user_first_name`	String column for user’s first name
`user_hashed_anonymous_id`	String column for user’s hashed anonymous ID
`user_language`	String column for user’s language
`user_last_name`	String column for user’s last name
`utc_time`	DateTime column for UTC time
`utm_campaign`	String column for UTM campaign
`utm_campaign_decoded`	String column containing the decoded UTM campaign
`utm_content`	String column for UTM content
`utm_medium`	String column for UTM medium
`utm_source`	String column for UTM source
`utm_term`	String column for UTM term
`vp_size`	String column for viewport size
`user_id`	String column for user ID
`ver`	Int column with a default value of 1, likely for version tracking