Events Export Schema

This document lists the fields included in the events data exports (e.g., Google BigQuery) and is 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.

Fields

Field	Description
`_timestamp`	DateTime column representing the timestamp of the event
`_is_deleted`	Int column indicating whether the record is deleted (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 (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 for TikTok click ID

For the complete export schema definition, see the full source document in the Help Center.

Was this article helpful?