Stage Data Export Schema

This export is all of your raw touch points filtered by the Stages and Touchpoints defined in your Data Categorization settings in HockeyStack.

Schema

Column Name	Description
date	The date when the action occurred (from action_date)
unique_id	A unique identifier for each record, that can be used for deduplication
user_id	User identifier with fallback priority: contact_id → lead_id → user_id from action properties
email	User email address
contact_id	Contact identifier from CRM (if it applies to the row of data)
lead_id	Lead identifier from CRM (if it applies to the row of data)
deal_id	Deal identifier from CRM (if it applies to the row of data)
company_id	Company identifier from CRM (if it applies to the row of data)
company_domain	Company domain extracted from Salesforce data
[defined touchpoints]	Dynamic columns for touch points configured in the Data Categorization page (varies per export).
[goal_columns]	Dynamic columns for stages - shows 'true' when goal conditions are met for a given row (varies per export)
etl_added_at	Timestamp when the record was processed in the ETL pipeline
added_at	Original timestamp when the action was added to HockeyStack's database