Customer Feedback Analysis

You are a product analyst. Analyze customer feedback and extract actionable insights.

**Feedback Source:** {source}
**Time Period:** {time_period}
**Total Responses:** {response_count}

Analyze feedback systematically:

**1. Sentiment Analysis:**

**Overall Sentiment Distribution:**
- Positive: {positive_pct}% ({positive_count} responses)
- Neutral: {neutral_pct}% ({neutral_count} responses)
- Negative: {negative_pct}% ({negative_count} responses)

**Net Promoter Score (NPS):**
- Promoters (9-10): {promoter_pct}%
- Passives (7-8): {passive_pct}%
- Detractors (0-6): {detractor_pct}%
- **NPS Score:** {nps_score}

**Trend:** {trending_direction} (vs last period: {previous_nps})

**2. Thematic Analysis:**

**Top Themes (by mention frequency):**

**Theme 1: {theme_1}** - Mentioned {mention_count_1} times
- Sentiment: {sentiment_1}
- Sample quotes:
  - "{quote_1}"
  - "{quote_2}"
- Actionable insight: {insight_1}

**Theme 2: {theme_2}** - Mentioned {mention_count_2} times
- Sentiment: {sentiment_2}
- Sample quotes:
  - "{quote_3}"
  - "{quote_4}"
- Actionable insight: {insight_2}

**Theme 3: {theme_3}** - Mentioned {mention_count_3} times
- Sentiment: {sentiment_3}
- Sample quotes:
  - "{quote_5}"
  - "{quote_6}"
- Actionable insight: {insight_3}

[Continue for top 5-7 themes]

**3. Feature Requests:**

**Most Requested Features:**
| Feature | Requests | Paying Customers | MRR Impact | Priority |
|---------|----------|------------------|------------|----------|
| {feature_1} | {count_1} | {paying_1} | ${mrr_1} | High |
| {feature_2} | {count_2} | {paying_2} | ${mrr_2} | Medium |
| {feature_3} | {count_3} | {paying_3} | ${mrr_3} | High |

**Feature Request Analysis:**

**{feature_1}:**
- **Use Cases:** {use_cases}
- **User Segments:** {segments}
- **Competitive Gap:** {competitive_analysis}
- **Effort Estimate:** {effort}
- **Recommendation:** {recommendation}

**4. Pain Points:**

**Critical Pain Points (by severity & frequency):**

**Pain Point 1: {pain_1}**
- Severity: High
- Frequency: {frequency_1}
- Affected users: {affected_users_1}
- Current workaround: {workaround_1}
- Recommended fix: {fix_1}
- Impact if not fixed: {impact_1}

**Pain Point 2: {pain_2}**
- Severity: Medium
- Frequency: {frequency_2}
- Affected users: {affected_users_2}
- Current workaround: {workaround_2}
- Recommended fix: {fix_2}
- Impact if not fixed: {impact_2}

**5. Customer Segmentation:**

**Feedback by User Segment:**

**Power Users ({power_user_pct}%):**
- Top requests: {power_user_requests}
- Sentiment: {power_user_sentiment}
- Key insight: {power_user_insight}

**New Users (<30 days) ({new_user_pct}%):**
- Top requests: {new_user_requests}
- Sentiment: {new_user_sentiment}
- Key insight: {new_user_insight}

**At-Risk Users ({at_risk_pct}%):**
- Top complaints: {at_risk_complaints}
- Sentiment: {at_risk_sentiment}
- Churn risk: {churn_risk}
- Retention strategy: {retention_strategy}

**6. Competitive Insights:**

**Competitor Mentions:**
- {competitor_1}: Mentioned {mentions_1} times
  - Context: "{context_1}"
  - What they do better: {better_1}
  - What we do better: {better_us_1}

- {competitor_2}: Mentioned {mentions_2} times
  - Context: "{context_2}"
  - What they do better: {better_2}
  - What we do better: {better_us_2}

**7. Action Items by Priority:**

**High Priority (Next Sprint):**
1. **{action_1}**
   - Why: {reason_1}
   - Impact: {impact_1}
   - Effort: {effort_1}
   - Owner: {owner_1}

2. **{action_2}**
   - Why: {reason_2}
   - Impact: {impact_2}
   - Effort: {effort_2}
   - Owner: {owner_2}

**Medium Priority (Next Quarter):**
1. {action_3} - {reason_3}
2. {action_4} - {reason_4}

**Low Priority (Backlog):**
1. {action_5} - {reason_5}
2. {action_6} - {reason_6}

**8. Quantitative Metrics:**

**Key Metrics:**
- Response rate: {response_rate}%
- Average rating: {avg_rating}/5
- CSAT Score: {csat_score}%
- Feature adoption after feedback: {adoption_rate}%

**Correlation Analysis:**
- Usage frequency vs satisfaction: {correlation_1}
- Account size vs NPS: {correlation_2}
- Onboarding completion vs retention: {correlation_3}

**9. Feedback Loop:**

**How to Close the Loop:**

**For Positive Feedback:**
- Reply: "Thank you for the kind words! Would you be willing to write a quick review?"
- Action: Request testimonial/case study

**For Feature Requests:**
- Reply: "Thanks for the suggestion! We've added this to our roadmap. You'll be the first to know when it's ready."
- Action: Add to roadmap, tag requester

**For Complaints:**
- Reply: "I'm sorry you experienced {issue}. We're working on a fix, expected by {date}. Meanwhile, try {workaround}."
- Action: Assign to team, follow up when fixed

**10. Reporting:**

**Executive Summary:**
```
**Feedback Analysis - {time_period}**

**Overview:**
- {response_count} responses analyzed
- NPS: {nps_score} ({trend} vs last period)
- Top theme: {top_theme}

**Key Insights:**
1. {insight_1}
2. {insight_2}
3. {insight_3}

**Recommended Actions:**
1. {action_1} - Expected impact: {impact_1}
2. {action_2} - Expected impact: {impact_2}

**Risks:**
- {risk_1}
- {risk_2}

**Next Steps:**
- {next_step_1}
- {next_step_2}
```

Provide: Complete analysis + prioritized actions + executive summary.