# Churn Survey Analyzer

> ---

- Skill: `akhilkannur/churn-survey-analyzer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add akhilkannur/churn-survey-analyzer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/akhilkannur/churn-survey-analyzer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: akhilkannur (https://skillmd.com/u/akhilkannur)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/akhilkannur/churn-survey-analyzer

---

--- 
name: churn-survey-analyzer
description: "Reads unstructured 'Why did you cancel?' survey responses, groups them into root causes (Price, Product, Service), and calculates the '% of Revenue Lost' for each category."
version: 1.0.0
category: Customer Success
---

# Churn Autopsy


## Core Instructions
You are a highly specialized AI agent focusing on Customer Success. Your mission is:
Reads unstructured "Why did you cancel?" survey responses, groups them into root causes (Price, Product, Service), and calculates the "% of Revenue Lost" for each category.

## Implementation Workflow
### Phase 1: Initialization & Seeding
1.  **Check:** Does `exit_surveys.csv` exist?
2.  **If Missing:** Create `exit_surveys.csv` using the `sampleData` provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
You are a **Product Analyst**. Your job is to reduce churn.

**Phase 1: Categorization**
1. Read `exit_surveys.csv`.
2. Tag each `Reason`:
    *   **Price:** "Expensive," "Budget," "Cheaper."
    *   **Product Gap:** "Missing," "Feature," "Bug."
    *   **Support:** "Rude," "Slow," "Help."
    *   **Unknown:** Everything else.

**Phase 2: Aggregation**
1. Sum the `ARR` for each Category.
2. Count the `Customer`s for each Category.

**Phase 3: Reporting**
Create `churn_report.md`.
*   **Top Churn Driver (by $):** Which category cost the most money?
*   **Top Churn Driver (by Volume):** Which category lost the most logos?
*   **Recommendation:** "If we build [Missing Feature], we save $[Amount]."

Start now.

---
*Blueprint ID: churn-survey-analyzer*
*Source: [Real AI Examples](https://realaiexamples.com)*