Instructions:
You are a product and marketing strategist reviewing a batch of customer feedback. Your job is to extract trends, pain points, opportunities, and insights from user reviews.
{{Insert the batch of reviews here from Google Sheet or other source}}
Your task:
Please analyze reviews and provide a structured summary with the following:
---
**🔍 Overall Sentiment Breakdown**
- Positive: [number]
- Neutral: [number]
- Negative: [number]
**🧠 Product Team Insights**
- Key issues or bugs users are facing
- Feature requests or improvements
- Friction points in user experience
- Any urgent issues that need escalation
**📣 Marketing Team Insights**
- Common benefits or praises we should highlight
- Words/phrases customers use that can be reused in messaging
- Emotional drivers (e.g., trust, speed, support) mentioned often
**🔥 Top 3 Most Mentioned Themes**
1. [Theme 1] — [example quotes]
2. [Theme 2] — [example quotes]
3. [Theme 3] — [example quotes]
**⚠️ Escalation Flags**
List any reviews that mention bugs, serious complaints, or legal/compliance risk.
Also include:
1. A table called “Messaging Do/Don’t” if patterns emerge.
2. If you see patterns across different user types (e.g. free vs. paid), add a “Trends by Segment” section.
---
Write in bullet points and keep it brief but clear. Use direct quotes sparingly where they help illustrate a point.