Raw Actions Export Schema
General notes:
Anything prefixed
defined_
are defined properties set within HockeyStackAnything prefixed
action_
are used to describe actions (name, type etc)Anything prefixed
sp_company_id_
is a Salesforce Company propertyAnything prefixed
up_
is a user propertyAnything prefixed
sp_deal_id
is a Salesforce Opportunity property
Other Columns:
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)
source
source of an action
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
ip_address
Tracked IP address of visitor
Last updated