Data Schema

Cloud Event Schemas

Blotout Cloud provides two versions of the event schema to accommodate different data collection and processing needs. Each version offers flexibility in how event data is structured, transmitted, and stored — allowing teams to choose the schema that best aligns with their infrastructure and use case requirements.

For the complete schema documentation including example payloads, schema structure, FullUser and Payload object definitions, and both Version 1 and Version 2 schema examples, see the Cloud Schemas Reference.

---

events

Column Name	Datatype
geo_is_e_u_country	string
geo_region_code	string
geo_region	string
user_last_name	string
geo_latitude	string
user_gender	string
event_timestamp	string
user_date_of_birth	string
event_session_id	string
user_zip	string
user_state	string
event_origin	string
geo_postal_code	string
user_first_name	string
geo_ip	string
application_name	string
geo_timezone	string
geo_city	string
user_phone	string
geo_user_agent	string
app_id	string
user_agent	string
query_impact_click_id	string
user_ip	string
user_email	string
user_country	string
event_page_title	string
user_created_at	string
user_user_agent	string
event_page_url	string
geo_longitude	string
user_city	string
geo_continent	string
geo_ja3	string
geo_ja4	string
event_id	string
user_id	string
geo_country	string
event_name	string
query__fbp	string
event_referrer	string
query_utm_medium	string
query_utm_source	string
query_fbclid	string
query_utm_campaign	string
query__fbc	string
query___kla_id	string
custom_data_is_new_customer	string
custom_data_klaviyo_kx	string
query__kx	string
query__rdt_uuid	string
custom_data_google_ads_clicks_gcl_aw	string
custom_data_reddit_rdt_uuid	string
query_gbraid	string
query_glid	string
query__gcl_aw	string
query_gclid	string
custom_data_facebook_fbp	string
custom_data_google_ads_clicksglid	string
custom_data_facebook_fbc	string
query_wbraid	string
custom_data_google_ads_clickswbraid	string
payload_contents	View type array<struct<id:string,variant_id:string,sku:string,quantity:string,item_price:string,title:string,image:string,brand:string,category:string,url:string,type:string,discount_value:string>>
payload_value	string
payload_currency	string
custom_data_klaviyo__kla_id	string
payload_checkout_url	string
query_rdt_cid	string
query__gl	string
custom_data_google_ads_clicks_gl	string
payload_discounts	array<struct<code:string,value:string,type:string>>
payload_order_id	string
query__axwrt	string
query_ttclid	string
query_epik	string
query_msclkid	string
query_twclid	string
query_aleid	string
payload_user_i_p	string
payload_user_zip	string
payload_user_country	string
payload_user_phone	string
payload_user_city	string
payload_user_first_name	string
payload_source	string
payload_user_last_name	string
payload_user_email	string
payload_user_state	string
payload_keywords	array<string>
payload_day	string
custom_data_app_lovin_axwrt	string
payload_search	string
query__sc_cid	string
payload_item_count	string
payload_cart_id	string
payload_gross_value	string
payload_tax_cost	string
payload_shipping_cost	string
custom_data_attributionlast_touch	string
custom_data_attributionfirst_touch	string
custom_data_intent_session_id	string
custom_data_user_consent_preference	string
geo_bot_score	string
event_date	string

core_events

Column Name	Datatype
retention_type	string
geo_is_e_u_country	string
geo_region_code	string
geo_region	string
user_last_name	string
geo_latitude	double
user_gender	string
epoch_utc	bigint
user_date_of_birth	string
session_id	string
user_zip	string
user_state	string
headers_origin	string
geo_postal_code	string
user_first_name	string
geo_ip	string
application_name	string
geo_timezone	string
geo_city	string
user_phone	string
geo_user_agent	string
app_id	string
user_agent	string
query_impact_click_id	string
user_ip	string
user_email	string
user_country	string
page_title	string
user_created_date	string
user_user_agent	string
page	string
geo_longitude	double
user_city	string
geo_continent	string
geo_ja3	string
geo_ja4	string
event_id	string
user_id	string
geo_country	string
event_name	string
query__fbp	string
referrer	string
query_utm_medium	string
query_utm_source	string
query_fbclid	string
query_utm_campaign	string
query__fbc	string
query___kla_id	string
custom_data_is_new_customer	string
custom_data_klaviyo_kx	string
query__kx	string
query__rdt_uuid	string
custom_data_google_ads_clicks_gcl_aw	string
custom_data_reddit_rdt_uuid	string
query_gbraid	string
query_glid	string
query__gcl_aw	string
query_gclid	string
custom_data_facebook_fbp	string
custom_data_google_ads_clicksglid	string
custom_data_facebook_fbc	string
query_wbraid	string
custom_data_google_ads_clickswbraid	string
payload_contents	string
payload_value	string
payload_currency	string
custom_data_klaviyo__kla_id	string
payload_checkout_url	string
query_rdt_cid	string
query__gl	string
custom_data_google_ads_clicks_gl	string
payload_discounts	string
payload_order_id	string
query__axwrt	string
query_ttclid	string
query_epik	string
query_msclkid	string
query_twclid	string
query_aleid	string
payload_user_i_p	string
payload_user_zip	string
payload_user_country	string
payload_user_phone	string
payload_user_city	string
payload_user_first_name	string
payload_source	string
payload_user_last_name	string
payload_user_email	string
payload_user_state	string
payload_keywords	string
payload_day	string
custom_data_app_lovin_axwrt	string
payload_search	string
query__sc_cid	string
payload_item_count	string
payload_cart_id	string
payload_gross_value	string
payload_tax_cost	string
payload_shipping_cost	string
event_date	string

view_id_graph

Column Name	Datatype
user_id	string
provider	string
global_user_id	string
app_id	string
global_id_created	timestamp
persona_age_range	varchar(8)
has_crm	string
persona_id	string
persona_username	string
persona_firstname	string
persona_middlename	string
persona_lastname	string
persona_age	string
persona_dob	string
persona_email	string
persona_number	string
persona_gender	string
persona_address	string
persona_city	string
persona_state	string
persona_zip	string
persona_country	string
persona_creation_date	string
persona_phone	string
total_spent	string
email_verified	string
persona_consent	string
persona_updated_date	string
orders_todate	string
currency	string
tax_exempt	string
persona_tags	string