nexscope-ai/ecommerce-skills/product-review-analysis

npx skills add nexscope-ai/eCommerce-Skills --skill product-review-analysis -g

"Analyze reviews for my wireless headphones - what are customers complaining about most?"

"Compare customer sentiment between my product and top 3 competitors from their reviews"

"What features are customers requesting most in fitness tracker reviews?"

## Product Review Analysis Report
**Product:** [Product Name] | **Reviews Analyzed:** [Number] | **Rating:** [X.X★] | **Timeframe:** [Period]
 
### Overall Sentiment Overview
 
**Review Distribution:**
- ⭐⭐⭐⭐⭐ (5-star): [X]% - [Number] reviews
- ⭐⭐⭐⭐ (4-star): [X]% - [Number] reviews  
- ⭐⭐⭐ (3-star): [X]% - [Number] reviews
- ⭐⭐ (2-star): [X]% - [Number] reviews
- ⭐ (1-star): [X]% - [Number] reviews
 
**Sentiment Analysis:**
- **Overall sentiment:** [Positive/Mixed/Negative] ([X.X]/5.0)
- **Sentiment trend:** [Improving/Stable/Declining] over [period]
- **Emotional themes:** [Joy/Frustration/Satisfaction] - [percentages]
- **Review authenticity:** [X]% likely authentic reviews
 
### Pain Point Analysis (By Frequency)
 
**Top Customer Complaints:**
 
| Pain Point Category | Frequency | Severity | Rating Impact | Example Quote |
|---------------------|-----------|----------|---------------|---------------|
| [Issue 1] | [X]% of reviews | High | -[X.X] stars | "[Customer quote]" |
| [Issue 2] | [X]% of reviews | Medium | -[X.X] stars | "[Customer quote]" |
| [Issue 3] | [X]% of reviews | Medium | -[X.X] stars | "[Customer quote]" |
| [Issue 4] | [X]% of reviews | Low | -[X.X] stars | "[Customer quote]" |
 
**Detailed Pain Point Analysis:**
 
**1. [Top Pain Point] - [X]% of negative reviews**
- **Specific issues:** [Detailed breakdown of sub-issues]
- **Customer impact:** [How this affects customer experience]
- **Business impact:** [Effect on ratings, returns, reputation]
- **Root causes:** [Potential underlying causes]
- **Resolution complexity:** [Easy/Medium/Hard] to fix
- **Customer quotes:** 
  - "[Specific customer quote 1]"
  - "[Specific customer quote 2]"
 
### Praise Pattern Analysis
 
**Top Positive Themes:**
 
| Strength Category | Frequency | Rating Boost | Competitive Advantage | Example Quote |
|------------------|-----------|--------------|----------------------|---------------|
| [Strength 1] | [X]% of reviews | +[X.X] stars | [Yes/No] | "[Customer quote]" |
| [Strength 2] | [X]% of reviews | +[X.X] stars | [Yes/No] | "[Customer quote]" |
| [Strength 3] | [X]% of reviews | +[X.X] stars | [Yes/No] | "[Customer quote]" |
 
**Customer Love Factors:**
- **Most appreciated features:** [Features customers consistently praise]
- **Emotional connection points:** [What makes customers enthusiastic]
- **Surprise and delight moments:** [Unexpected positive experiences]
- **Loyalty indicators:** [Repeat purchase intent, recommendations]
 
### Feature Request Intelligence
 
**Customer-Driven Development Opportunities:**
 
| Feature Request | Frequency | Customer Priority | Development Effort | Business Impact |
|----------------|-----------|------------------|-------------------|-----------------|
| [Feature 1] | [X] mentions | High | [Easy/Med/Hard] | [Revenue potential] |
| [Feature 2] | [X] mentions | Medium | [Easy/Med/Hard] | [Market expansion] |
| [Feature 3] | [X] mentions | Medium | [Easy/Med/Hard] | [Competitive advantage] |
 
**Detailed Feature Analysis:**
 
**1. [Top Requested Feature] - [X] customer requests**
- **Customer language:** "[How customers describe the need]"
- **Use cases:** [Specific scenarios where customers want this]
- **Competitive landscape:** [Do competitors offer this?]
- **Implementation considerations:** [Technical/business challenges]
- **Revenue impact potential:** [Market size and willingness to pay]
 
### Competitive Review Intelligence
 
**Cross-Brand Sentiment Comparison:**
 
| Brand | Avg Rating | Strengths vs Our Product | Weaknesses vs Our Product |
|-------|------------|--------------------------|----------------------------|
| [Competitor 1] | [X.X★] | [Their advantages] | [Their disadvantages] |
| [Competitor 2] | [X.X★] | [Their advantages] | [Their disadvantages] |
| [Competitor 3] | [X.X★] | [Their advantages] | [Their disadvantages] |
 
**Market Intelligence from Reviews:**
- **Features customers wish we had:** [Competitor advantages mentioned in our reviews]
- **Our competitive advantages:** [What customers prefer about us vs others]
- **Market gaps:** [Needs no brand is meeting well according to reviews]
 
### Customer Segmentation from Reviews
 
**Review-Based Customer Personas:**
 
**Persona 1: [Segment Name] - [X]% of reviewers**
- **Characteristics:** [Demographics, usage patterns, priorities]
- **Pain points:** [What bothers this segment most]
- **Praise patterns:** [What this segment values most]
- **Feature requests:** [What they want added/improved]
- **Language style:** [How they communicate about the product]
 
### Actionable Improvement Priorities
 
**Immediate Fixes (0-30 days):**
1. **[High-impact, low-effort fix]**
   - **Issue:** [Specific problem to solve]
   - **Solution:** [Recommended action]
   - **Expected impact:** [Rating/satisfaction improvement]
   - **Implementation:** [Steps to take]
 
**Medium-term Improvements (1-3 months):**
1. **[Product enhancement opportunity]**
   - **Customer need:** [What customers are asking for]
   - **Business case:** [Why this matters for growth]
   - **Implementation:** [Development approach]
 
**Long-term Strategic Changes (3-6 months):**
1. **[Major product evolution]**
   - **Market opportunity:** [Broader market need identified]
   - **Competitive advantage:** [How this differentiates us]
   - **Investment required:** [Resources needed]
 
### Marketing & Messaging Insights
 
**Customer Language Analysis:**
- **Words customers use:** [Actual language for marketing copy]
- **Emotional triggers:** [What resonates emotionally]
- **Pain point messaging:** [How to address concerns proactively]
- **Benefit communication:** [How customers describe value]
 
**Review-Driven Marketing Recommendations:**
- **Product descriptions:** [Language to emphasize based on praise]
- **FAQ/concerns:** [Address common complaints proactively]
- **Social proof:** [Best customer quotes for testimonials]
- **Positioning:** [How to position against competitors based on reviews]
 
### Quality Assurance Insights
 
**Production/QC Improvement Areas:**
- **Manufacturing issues:** [Consistent defects mentioned in reviews]
- **Packaging concerns:** [Shipping and presentation issues]
- **Documentation problems:** [Manual, setup, or usage confusion]
- **Customer support gaps:** [Service experience issues]
 
### Review Response Strategy
 
**Recommended Response Approach:**
- **Negative reviews:** [How to respond to address concerns]
- **Positive reviews:** [How to leverage for further engagement]
- **Feature requests:** [How to engage customers about development]
- **Competitive mentions:** [How to handle competitor comparisons]
 
### Monitoring & Tracking Framework
 
**Ongoing Review Intelligence:**
- **Daily monitoring:** [New review alerts and sentiment tracking]
- **Weekly analysis:** [Trend identification and pattern changes]
- **Monthly reporting:** [Comprehensive review health assessment]
- **Quarterly deep-dive:** [Strategic insights and roadmap updates]
 
**Key Performance Indicators:**
- **Average rating trajectory:** Target [X.X★] or higher
- **Negative review rate:** Keep below [X]% of total reviews
- **Response time to negative reviews:** Within [X] hours
- **Issue resolution rate:** [X]% of complaints addressed in updates
 
### Implementation Roadmap
 
**Phase 1: Quick Wins (0-30 days)**
- [ ] Address top 3 most frequent complaints
- [ ] Implement review response strategy
- [ ] Update product descriptions based on customer language
- [ ] Create FAQ addressing common concerns
 
**Phase 2: Product Improvements (1-3 months)**
- [ ] Develop solutions for medium-priority pain points
- [ ] Begin development of top-requested features
- [ ] Enhance quality control based on defect patterns
- [ ] Launch proactive customer communication strategy
 
**Phase 3: Strategic Evolution (3-6 months)**
- [ ] Complete major product improvements based on feedback
- [ ] Launch new features addressing customer requests
- [ ] Establish automated review intelligence system
- [ ] Develop predictive customer satisfaction models
 
### Success Metrics
 
**Review Intelligence KPIs:**
- **Rating improvement:** Target increase of [X.X] stars over [period]
- **Complaint reduction:** [X]% decrease in top pain points
- **Feature adoption:** [X]% of customers mention new features positively
- **Competitive sentiment:** Maintain [X]% preference vs competitors
 
### Next Actions
- [ ] Prioritize improvement initiatives based on customer impact and business value
- [ ] Implement quick fixes for highest-frequency complaints
- [ ] Develop customer communication strategy addressing common concerns
- [ ] Establish ongoing review monitoring and analysis processes
- [ ] Create product development roadmap incorporating customer feedback