We discussed that each action and entity in HockeyStack can have properties. If goals are nicknames for a group of actions, defined properties are nicknames for a group of properties.
Let’s go back to our Actions table.
Timestamp | Entity | Action Name | Source | UTM Source | UTM Medium |
---|---|---|---|---|---|
… | [email protected] | start-session | paid_social | ||
… | [email protected] | start-session | organic_social | ||
… | [email protected] | start-session | paid_social | ||
… | [email protected] | start-session | facebook.com |
This table depicts a list of website sessions from various sources. The properties Source, UTM Source, and UTM Medium have meanings on their own. But they have a much larger meaning when looked at together. For example, a UTM Source = linkedin and UTM Medium = paid_social might mean LinkedIn Ads, and a UTM_Source = empty and Source = facebook.com might mean Facebook Organic.
Let’s say we want to add another column to our table to depict this meaning, which will be called “Channel” Our ruleset will be:
Timestamp | Entity | Action Name | Source | UTM Source | UTM Medium | Channel |
---|---|---|---|---|---|---|
… | [email protected] | start-session | paid_social | LinkedIn Ads | ||
… | [email protected] | start-session | organic_social | LinkedIn Organic | ||
… | [email protected] | start-session | organic_social | Facebook Organic | ||
… | [email protected] | start-session | facebook.com | Facebook Organic |
This Channel property doesn’t actually exist in our dataset, but it can be inferred from the list of other properties that our actions have. This is called a “Defined Property”. You can apply the same thing on any Shared Property as well.
For example, a common Defined Company Property to define is “Region”. If your CRM only stores countries, you can create a Defined Company Property that groups relevant countries into regions.
For a ruleset like Country = “Canada” or Country = “United States” → NAM, you can imagine the below Company Properties:
Key | Value | Country | Region |
---|---|---|---|
company_id | 12387 | Canada | NAM |
company_id | 12354629 | United States | NAM |
In HockeyStack, navigate to Definitions > Properties.
This page is your property dictionary.
You can click on the + icon on the top right corner to create a new defined property.
https://app.arcade.software/share/F7tElYD1xnmBiZLY2dqy
Each mapping in a defined property will have: