mirror of
https://github.com/Kaelio/ktx.git
synced 2026-06-07 07:55:13 +02:00
97da9919e9
* refactor: remove legacy compatibility paths * fix: support legacy metabase native queries * test: use canonical semantic layer descriptions * Rename CLI description * Recover setup scan from SQLite ABI mismatch * Remove legacy product name from CLI help
36 lines
861 B
YAML
36 lines
861 B
YAML
name: churn_risk
|
|
descriptions:
|
|
user: |
|
|
Customer churn risk score combining tenure,
|
|
usage trends, and support burden.
|
|
sql: |
|
|
SELECT
|
|
c.id AS customer_id,
|
|
c.name AS customer_name,
|
|
calculate_churn_score(c.id) AS score,
|
|
CASE
|
|
WHEN c.arr < 50000 THEN 'SMB'
|
|
WHEN c.arr < 500000 THEN 'Mid-Market'
|
|
ELSE 'Enterprise'
|
|
END AS customer_type
|
|
FROM customers c
|
|
JOIN usage_summary u ON c.id = u.customer_id
|
|
JOIN ticket_summary t ON c.id = t.customer_id
|
|
grain: [customer_id]
|
|
columns:
|
|
- name: customer_id
|
|
type: number
|
|
- name: customer_name
|
|
type: string
|
|
- name: score
|
|
type: number
|
|
- name: customer_type
|
|
type: string
|
|
joins:
|
|
- to: customers
|
|
"on": customer_id = customers.id
|
|
relationship: many_to_one
|
|
measures:
|
|
- name: avg_risk
|
|
expr: avg(score)
|
|
description: "Average churn risk score"
|