Skip to content
AI AnalyticsAI Layer

AI_ChurnRisk

Computed churn risk per customer per organisation. Identifies at-risk guests with contributing factors for targeted intervention.

7 fields1 relationships

Fields

NameTypeReqDescription
risk_scorenumberyesNumeric risk — higher means more likely to churn.
risk_levelenumyeshigh | medium | low.
days_since_lastnumbernoDays since last visit.
total_visitsnumbernoLifetime visits used in model.
total_spendpenniesnoLifetime spend in pennies.
contributing_factorsstringnoSemicolon list, e.g. no_visit_90_days;declining_frequency.
computed_atdatetimeyesLast calculated.

Relationships

Inbound (1)
  • Customer[:CHURN_RISK]→Organizationrisk_score, risk_level, days_since_last, total_visits, total_spend, contributing_factors, computed_at