Events Export Schema

_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