system-field-reference
Installation
SKILL.md
Background Knowledge
What Are System Fields
The TE analysis engine presets a set of system fields that:
- In SQL queries: can be used directly without any additional configuration
- In frontend analysis models: hidden by default and cannot be used directly
System fields are divided into two categories:
- System fields in the event table (within the event property scope)
- System fields in the user table (within the user property scope)
Prerequisites for Using System Fields in Frontend Models
Different categories of system fields have different requirements for use in frontend analysis models:
| Field Category | Required Steps | Description |
|---|---|---|
| Event table system fields | Two steps: ① Create and Connect → ② Create virtual property | Event properties must be wrapped as a virtual property with relation_always before they can be used in frontend models |
| User table system fields | One step: Create and Connect | User properties can be used directly in frontend analysis models once "Connected", no virtual property needed |