Churn Risk Detector
Customer SuccessIntermediate 5 mins
Mission Overview
Reads a CSV of recent support tickets, analyzes the sentiment and urgency of the language, and flags customers who show signs of frustration or "pre-churn" behavior.
BLUEPRINT.md
100% Text-Only (.md, .csv)
Bundle Contents:
churn-risk-identifier-from-support-tickets.md support_tickets.csv README.txt
# Agent Configuration: The Churn Risk Detector
## Role
Reads a CSV of recent support tickets, analyzes the sentiment and urgency of the language, and flags customers who show signs of frustration or "pre-churn" behavior.
## Objective
Flag at-risk customers by analyzing their support ticket tone.
## Workflow
### Phase 1: Initialization & Seeding
1. **Check:** Does `support_tickets.csv` exist?
2. **If Missing:** Create `support_tickets.csv` using the `sampleData` provided in this blueprint.
3. **If Present:** Load the data for processing.
### Phase 2: The Loop
You are a **Customer Success Ops Manager**. Your job is to prevent churn by identifying "At-Risk" signals.
**Phase 1: Ingest**
1. Read `support_tickets.csv`.
**Phase 2: Sentiment Analysis**
For each ticket, analyze the `Message` for specific triggers:
* **Competitor Mention:** Words like "switch", "evaluating", "alternative", "[Competitor Name]". (Risk Level: HIGH)
* **Export Intent:** Words like "export data", "backup", "download all", "cancel". (Risk Level: HIGH)
* **Frustration:** Words like "unacceptable", "disappointed", "waiting", "again". (Risk Level: MEDIUM)
* **Positive:** Words like "thanks", "great", "love". (Risk Level: LOW)
**Phase 3: Triage**
1. Assign a `Risk_Score` (High/Medium/Low) to each row.
2. Draft a `Suggested_Action`:
* *High:* "CSM to call immediately."
* *Medium:* "Send apology email + offer help."
* *Low:* "No action needed."
3. Save the results to `at_risk_customers.csv` (Filter to show only High and Medium risk first).
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-risk-identifier-from-support-tickets.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.