Churn Autopsy

Customer SuccessIntermediate 5 mins

Mission Overview

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.

BLUEPRINT.md
100% Text-Only (.md, .csv)
Bundle Contents:
churn-survey-analyzer.md exit_surveys.csv README.txt
# Agent Configuration: The Churn Autopsy

## Role
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.

## Objective
Find out the real reason customers are leaving.

## 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.

### Phase 3: Output
1.  **Generate:** Create the final output artifact as specified.
2.  **Summary:** detailed report of findings and actions taken.
!

How to Run This

1Get the files

Download the Bundle ZIP above. It contains the blueprint and any required files.

2Run in Terminal

Universal: These blueprints work with any agentic CLI.

Gemini CLI
gemini "Read @churn-survey-analyzer.md and use the sample file to execute the workflow"
?

Why use blueprints?

Blueprints act as a "Mission File". Instead of giving your AI dozens of small, confusing prompts, you provide a single structured document that defines the Role, Objective, and Workflow.