Stampede Platform
Nothing published in this section yet.
Schema
AI AnalyticsAI Layer
AI_LifetimeValue
Computed LTV per customer per organisation. Historical spend, predicted future value, tier.
9 fields1 relationships
Fields
| Name | Type | Req | Description |
|---|---|---|---|
| ltv_pennies | pennies | yes | Lifetime value in pennies. |
| tier | enum | yes | platinum | gold | silver | bronze. |
| total_visits | number | — | Confirmed visits used. |
| total_spend_pennies | pennies | — | Historical spend in pennies. |
| avg_spend_per_visit_pennies | pennies | — | Avg spend per visit in pennies. |
| months_active | number | — | Months active. |
| predicted_12mo_value_pennies | pennies | — | Predicted 12mo spend in pennies. |
| venues_visited | number | — | Distinct venues visited within org. |
| computed_at | datetime | yes | Last calculated. |
Relationships
Inbound (1)
- Customer[:LIFETIME_VALUE]→Organizationltv_pennies, tier, total_visits, total_spend_pennies, avg_spend_per_visit_pennies, months_active, predicted_12mo_value_pennies, venues_visited, computed_at
Related entities
CustomerGraph AI Engine
The root guest identity node. Every interaction across bookings, Wi-Fi, orders, reviews, and loyalty is unified under a single Customer node per organisation.OrganizationGraph AI Engine
Top-level organisation node. Supports franchise and group hierarchies via :PARENT_OF. Every piece of data in the platform is scoped to an organisation.