AI AnalyticsAI Layer

AI_LifetimeValue

Computed LTV per customer per organisation. Historical spend, predicted future value, tier.

9 fields1 relationships

Fields

NameTypeReqDescription
ltv_penniespenniesyesLifetime value in pennies.
tierenumyesplatinum | gold | silver | bronze.
total_visitsnumber—Confirmed visits used.
total_spend_penniespennies—Historical spend in pennies.
avg_spend_per_visit_penniespennies—Avg spend per visit in pennies.
months_activenumber—Months active.
predicted_12mo_value_penniespennies—Predicted 12mo spend in pennies.
venues_visitednumber—Distinct venues visited within org.
computed_atdatetimeyesLast 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