Import Website Actions

How to get data tracked from sources such Mixpanel, Google Analytics, PostHog, etc. into HockeyStack

If your historical website data is coming from HubSpot, please refer to this guide for more information on configuration

Schema:

These columns are required for this import type (column names are expected to match, for import to work properly)

Column	Required	Description
page_url	✅	current page associated with action (should include UTM parameters if necessary)
referrer	✅	the URL of the webpage from which a user clicked a link to arrive at the current page
date	✅	The date of the visit
identity	✅	This can be an email or company domain (acme.com)
company_domain	✖️	Can be it's own individual column if identity is an email
user_id	✖️	if you have a user_id for a user that you use elsewhere, you can specify this here
browser	✖️
os	✖️
device	✖️
city	✖️
country	✖️

The benefit of adding non-required columns:

Having these extra defined columns help better connect and enrich your data for better use within HockeyStack. Column names have to match, for import to work properly.

Caveats and Notes:

• The 5 standard UTM parameters are UTM Campaign, UTM Source, UTM Medium, UTM Term, and UTM Content. Those should be included in page_url. If they are defined in their own specific column, the import process will automatically concatenate to page URL if necessary. (If the current value in page_url does not include utm parameters)

  • Other UTM parameters would be usable as action properties

Website action properties:

This is extra information to describe a website action, such as session information or other properties from your export source. Any column that doesn't match the above schema will be used as an action property

How it works:

Here's an example Website action

Column Name	Value in Column	Extra information
identity	[e-mail]
date	2025-01-01T00:00:00.000Z
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 coso	The URL visited by the person, with UTMs included.
referrer	https://facebook.com
company_domain	company.com
user_id	123456789
company_name	Awesome Company	This will be saved as a company property
engagement_type	Direct	This will be saved as an action property
is_returning_user	False	This will be saved as an action property
email_opened_at	1735689600000	This will be saved as an action property
call_scheduled	True	This will be saved as an action property
name	Someone Everyone	This will be saved as an action property
utm_content		Only necessary if page_url does not include UTM parameters
utm_medium		Only necessary if page_url does not include UTM parameters
utm_term		Only necessary if page_url does not include UTM parameters
utm_campaign		Only necessary if page_url does not include UTM parameters
utm_source		Only necessary if page_url does not include UTM parameters