Analyze
Intermediate·25 min
Classify customer feedback sentiment by theme
Turn a column of open-text customer feedback into themed, pivotable sentiment data.
Updated Sep 30, 2026
Churn ticked up and nobody's segmented why yet.
Find the top churn reason and draft an email that addresses it.
| CustomerID | ChurnReason | ChurnDate |
|---|---|---|
| CUST-501 | Switched to a competitor | 2026-02-21 |
| CUST-502 | Price too high | 2026-04-13 |
| CUST-503 | Price too high | 2026-06-12 |
| CUST-504 | Poor support experience | 2026-04-05 |
| CUST-505 | Price too high | 2026-02-27 |
Prompt idea:
Here are 26 churned customers with their stated reason. Tell me the most common reason, then draft a win-back email that directly addresses that specific reason rather than a generic appeal.
What is the most common reason customers gave for churning?
Count occurrences of each ChurnReason value — one reason clearly leads the rest.
The solution files contain the completed challenge. Review the approach to see if you missed any edge cases.
Turn a column of open-text customer feedback into themed, pivotable sentiment data.
Get practical help with AI consulting or ask about training courses for your team.