Import Website Actions

It is very easy to import website data tracked outside of the HockeyStack website tracking snippet. Below we outline the general schema needed and example of what the data would like in your warehouse.

Website actions import currently supports only pageviews and not other website actions (like form submissions and web clicks).

Example Schema

All column names should be in underscores.

Column Name	Example Value	Requirement	Description
identity	[email protected]	required	Identifier column. email address or company domain
date	2025-03-18T12:58:01.000Z	required	The timestamp of the website action
page_url	https://example.com/blog/article-1?utm_source=facebook&utm_medium=organic&utm_campaign=brand_awareness&utm_content=video_ad_1&utm_term=coso	required	Current full page associated with the pageview (should include UTM parameters if possible)
referrer	https://facebook.com	required	The URL of the webpage from which a user clicked a link to arrive at the website
user_id	684748833	recommended	Contact or company id from CRM or other sources. provides additional identifier information
company_domain	company.com		Can be its own separate column if identity is an email address
utm_source			Only necessary if page_url does not include UTM parameters
utm_medium			Only necessary if page_url does not include UTM parameters
utm_campaign			Only necessary if page_url does not include UTM parameters
utm_content			Only necessary if page_url does not include UTM parameters
utm_term			Only necessary if page_url does not include UTM parameters
engagement_type	Direct		This will be saved as an action property
contact_name	Someone Everyone		This will be saved as an action property

UTM Parameters

The 5 standard UTM parameters are UTM Source, UTM Medium, UTM Campaign, UTM Content and UTM Term.

They should ideally be included in page_url but if they are defined as separate columns, the import will automatically concatenate them to the page_url. Other UTM parameters would be usable as action properties.

Action Properties

These are extra information to describe a website action, such as session information or other properties from your data source. Any column name that doesn't map to a specified column in the given schema example will be ingested as an action property.