Raw Actions Export Schema

General notes:

• Anything prefixed defined_ are defined properties set within HockeyStack

• Anything prefixed sp_company_id_ is a Company property

  • These are all the company/account properties from your CRM and also non-CRM sources unified in HockeyStack

• Anything prefixed up_ is a User property

  • These are all the user/person properties from your CRM and also non-CRM sources unified in HockeyStack

• Anything prefixed sp_deal_id is an Opportunity/Deal property

  • These are primarily coming from your CRM

Other Columns:

Column Name	Description
company_id	Company ID associated an action. If a Salesforce Company ID is available, it will be prioritized as the value of the column
multi_column_hash	Unique value for a row (can be used for deduplication)
pageurl	The full URL for a website action occurred
cm_ad_network	The ad network associated with the campaign (if applicable)
cm_campaign_name	The name of the campaign from the ad network (if applicable)
cm_adgroup_name	Name of the ad group within the campaign (if applicable)
display_in_analytics	Indicates whether the action should be displayed in analytics on the frontend
added_at	The timestamp when the data was added to the table
browser	Page visitor's browser
country	Page visitor's country
city	Page visitor's city
device	Page visitor's device
os	Page visitor's os
language	Page vistor's language setting
identity	Page visitor's identity (often times email, but can also be UUID)
session_id_hashed	A unique ID for a given website session
session_start_date	start timestamp for a given website session
referrer	referrer for a website visit
page_index	index of a page within a session
protocol	protocol used during website visit
domain	Domain of the visited page url
path	Path of the visited page url
query_param	Query params of the visited page url
hash	Hash parameter associated with page url