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_lastnumber—Days since last visit.
total_visitsnumber—Lifetime visits used in model.
total_spendpennies—Lifetime spend in pennies.
contributing_factorsstring—Semicolon 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