| 推荐 | 9-10 分 |
|---|---|
| 中立 | 7-8 分 |
| 贬损 | 0-6 分 |
NPS
NPS
SELECT (sum(CASE WHEN score >= 9 THEN 1 ELSE 0 END)
- sum(CASE WHEN score <= 6 THEN 1 ELSE 0 END)) * 100.0 / count(1) AS nps
FROM fact_survey
WHERE survey_id = 'NPS-2026Q3';渠道偏差（只回收满意用户）会让 NPS 虚高：回收过程要随机化或加权。