Indie Review Analyzer

2. 📈 Quantitative Analysis

Review Distribution:

⭐⭐⭐⭐⭐ ████████████░░░░ 65%
⭐⭐⭐⭐   ██████░░░░░░░░░░ 20%
⭐⭐⭐     ███░░░░░░░░░░░░░ 8%
⭐⭐       ██░░░░░░░░░░░░░░ 4%
⭐         █░░░░░░░░░░░░░░░ 3%

Metrics to Track:

• Average rating over time
• Review volume trends
• Response rate (if responding)
• Sentiment trend (improving/declining)

3. 🔍 Qualitative Analysis Template

For each theme, document:

Theme: [e.g., "Sync Issues"]

Frequency: [High/Medium/Low]

Sample Reviews:
- "[Quote 1]" (⭐⭐)
- "[Quote 2]" (⭐)
- "[Quote 3]" (⭐⭐⭐)

Root Cause: [Your analysis]

Impact: [Revenue? Retention? Acquisition?]

Action: [Fix / Improve / Communicate / Ignore]

Priority: [P0/P1/P2/P3]

4. 📋 Feature Request Tracking

Priority Formula:

Priority = Frequency × Impact × Alignment with Vision

Where:
- Frequency: How often requested
- Impact: Would this affect revenue/retention?
- Alignment: Does it fit your product direction?

5. 🐛 Bug Pattern Identification

Severity Classification:

• P0 (Critical): Data loss, security, unable to use
• P1 (High): Major feature broken, workaround difficult
• P2 (Medium): Feature broken, workaround exists
• P3 (Low): Minor issue, cosmetic

6. 💬 Sentiment Analysis

Positive Sentiment Triggers:

• "Easy to use"
• "Finally found"
• "Worth every penny"
• "Simple and clean"
• "Best [category] app"

Negative Sentiment Triggers:

• "Frustrating"
• "Waste of money"
• "Used to be good"
• "Buggy"
• "Uninstalled"

Track Sentiment Over Time:

Jan: +0.3 (more positive)
Feb: +0.1
Mar: -0.2 (concerning)
Apr: -0.5 (investigate)

7. 📊 Competitive Insights

From Competitor Reviews:

• What do users love that you don't have?
• What do users hate that you can avoid?
• What use cases are mentioned?
• What's their pricing perception?

Analysis Template:

Competitor: [Name]
Rating: [X.X]

What They Do Better:
- [Strength 1]
- [Strength 2]

What They Do Worse:
- [Weakness 1] ← YOUR OPPORTUNITY
- [Weakness 2] ← YOUR OPPORTUNITY

Key Differentiator: [What makes them unique]

8. 🎯 Actionable Output

Weekly Review Summary:

📊 Review Summary: [Date Range]

New Reviews: [X]
Average Rating: [X.X] (↑/↓ from last week)

Top Themes This Week:
1. [Theme] - [X mentions] - [Action]
2. [Theme] - [X mentions] - [Action]
3. [Theme] - [X mentions] - [Action]

Bugs Reported:
- [Bug 1] - [Priority] - [Status]
- [Bug 2] - [Priority] - [Status]

Feature Requests:
- [Feature 1] - [X mentions]
- [Feature 2] - [X mentions]

Quotable Praise:
"[Best 5-star quote for marketing]"

Requires Response:
- [Review that needs developer response]

9. 📣 Marketing Insights

Extract for Marketing:

• Best 5-star quotes for screenshots
• Use cases you hadn't considered
• Language users use (for ASO)
• Testimonials (with permission)

Social Proof Template:

"[Short powerful quote]"
— App Store Review ⭐⭐⭐⭐⭐

10. 🔄 Review Response Strategy

Respond Prioritization:

1. 1-2 star reviews (damage control)
2. Reviews with specific bugs
3. Feature requests you're building
4. Glowing reviews (thank them)

See indie--review-responder for templates

11. 📅 Regular Analysis Cadence

Daily (5 min):

• Skim new reviews
• Flag anything urgent

Weekly (30 min):

• Categorize all reviews
• Update tracking spreadsheet
• Respond to priority reviews
• Note patterns

Monthly (1 hour):

• Full sentiment analysis
• Feature request prioritization
• Bug trend analysis
• Competitive review comparison

12. 🛠 Tools

Review Monitoring:

• AppFollow
• AppBot
• Sensor Tower
• App Store Connect (free)

Manual Analysis:

• Spreadsheet (Google Sheets/Airtable)
• Notion database
• Simple tagging system

Deliverable

Provide the user with:

1. Categorized review summary
2. Top themes with frequency
3. Feature request priority list
4. Bug report summary
5. Competitive insights (if analyzing competitors)
6. Actionable recommendations
7. Quotable reviews for marketing