Schema
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_lastnumberDays since last visit.
total_visitsnumberLifetime visits used in model.
total_spendpenniesLifetime spend in pennies.
contributing_factorsstringSemicolon 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