Skip to content

Data Schema

view_core_events

Column Name Description
user_agent User Agent string
continent Continent from where the event is generated
user_id Cookie ID
zip Zip Code from where the event is generated
ip IP Address from where the event is generated
message_id Unique ID for a event
state State from where the event is generated
epoch_utc epoch time when the event is generated
page_title Title of the page
lat Latitude from where the event is generated
event_name Name of the event
city City from where the event is generated
timezone_offset Timezone offset from where the event is generated
long Longitude from where the event is generated
session_id Identifies the session that an event came from
event_type Type of event - System or Codified
event_received_epoch Server epoch time when the event is received
country Country from where the event is generated
etl_run_date Event Date in yyyy-mm-dd format when the event is generated
app_version Application version
application_name Application Name
app_name Application Name
app_id Application ID
country_name Country Name from where the event is generated
event_datetime event date time when the event is generated
user_id_created_utc user id created time in long utc
user_id_created user id created time
page Complete URL of the page visiting
page_domain Domain of a page
page_protocol Page Protocol like http etc.
page_query_params Query Params present in the page
page_authority Authority of the page
page_path Page paths
page_url URL and complete sub path of a URL
referral Referral full URL (includes sub-path along with query params)
referral_domain Domain Name for the referral
referral_query_params Query Params present in the referral
referral_url Referral URL includes sub-path without query params
retention_type Retention Type of the user with respect to the visit
data_map_id External ID that you want to link to Blotout ID.
data_map_provider Provider that generated external ID, for example hubspot
os_name Operating System Name from where the event is generated
os_version Operating System Version from where the event is generated
device_platform Device Platform from where the event is generated
device_brand Device Brand from where the event is generated
device_manufacturer Device Manufacturer from where the event is generated
browser_name Browser Name from where the event is generated
browser_major Browser Major version from where the event is generated
os_major Operating System Major version from where the event is generated
device_model Device Model
search_gbraid UTM Parameter
search_wbraid UTM Parameter
search_gclid UTM Parameter
search_fbclid UTM Parameter
search_twitterid UTM Parameter
search_utm_source UTM Parameter
search_utm_medium UTM Parameter
search_utm_campaign UTM Parameter
search_utm_content UTM Parameter
search_utm_term UTM Parameter
search_promoted_properties_campaign_id UTM Parameter
search_cpc UTM Parameter
search_cpm UTM Parameter
search_cpi UTM Parameter
search_cpa UTM Parameter
search_cps UTM Parameter
search_cpo UTM Parameter
data_* Column with prefix data_ represents the codified column

view_users

Column Name Description
persona_age_range Age Group of a user
has_crm Always reflects as True as the CRM profile for a user present
global_user_id Global Server ID of a user
persona_id Internal CRM system mapped ID of a user
persona_username User name of a user
persona_firstname First name of a user
persona_middlename Middle name of a user
persona_lastname Last name of a user
persona_age Age of a user
persona_dob User’s birthday
persona_email Email address of a user
persona_number Phone number of a user
persona_gender Gender of a user
persona_address Address of a user
persona_city City of a user
persona_state State of a user
persona_zip Zip code from where the user belongs
persona_country Country of a user
persona_creation_date Date when the user’s account was first created

unified_events

Column Name Description

view_id_graph

Column Name Description
global_user_id Global Server ID of a user
user_id User ID of a user ingested by the respective provider
provider Name of the provider
global_id_created global id created time
persona_age_range Age Group of a user
has_crm Always reflects as True as the CRM profile for a user present
persona_id Internal CRM system mapped ID of a user
persona_username User name of a user
persona_firstname First name of a user
persona_middlename Middle name of a user
persona_lastname Last name of a user
persona_age Age of a user
persona_dob User’s birthday
persona_email Email address of a user
persona_number Phone number of a user
persona_gender Gender of a user
persona_address Address of a user
persona_city City of a user
persona_state State of a user
persona_zip Zip code from where the user belongs
persona_country Country of a user
persona_creation_date Date the user’s account was first created