Raw Actions Export Schema

General notes:

  • Anything prefixed defined_ are defined properties set within HockeyStack

  • Anything prefixed action_ are used to describe actions (name, type etc)

  • Anything prefixed sp_company_id_ is a Salesforce Company property

  • Anything prefixed up_ is a user property

  • Anything prefixed sp_deal_id is a Salesforce Opportunity property

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)

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

Last updated