All examples for Survey Response Theme Extractor

NPS Promoters vs Detractors Segmentation

Comprehensive NPS analysis with separate theme extraction for promoters (9-10) and detractors (0-6), revealing what drives satisfaction vs dissatisfaction.

Input

What you provide to the skill

I have 456 NPS comments in /data/nps_q4.csv with columns user_id, nps_score, and comment_text. Can you analyze separately for promoters (9-10) vs detractors (0-6)?

Output

What the skill generates for you

NPS Comment Analysis Report

Q4 2024 - Promoters vs Detractors

Total Responses: 456
Promoters (9-10): 274 responses (60%)
Passives (7-8): 116 responses (25%)
Detractors (0-6): 66 responses (14%)
Analysis Date: 2025-12-05


PROMOTERS ANALYSIS (274 responses)

Theme P1: Exceptional Customer Support Experience (42% of promoters - 115 responses)

Sentiment: 96% Positive, 4% Neutral
Key Insight: Customer support responsiveness and expertise is the single strongest driver of promoter scores, with frequent mentions of fast resolution times and helpful agents

Representative Quotes:

  • “The support team is absolutely fantastic. I get responses within minutes and they actually solve my problems, not just send canned replies.” (Score: 10, user_id: 8472)
  • “I’ve had to contact support three times this quarter and every single experience was stellar. They go way beyond what I expect.” (Score: 10, user_id: 3291)
  • “Customer service is the best I’ve experienced in any SaaS product. They treat you like you matter, not like a ticket number.” (Score: 9, user_id: 7134)
  • “Support staff are incredibly knowledgeable and patient. They walked me through a complex setup without making me feel dumb.” (Score: 10, user_id: 5829)
  • “What really sets this company apart is their support. Quick, friendly, and actually helpful every single time.” (Score: 9, user_id: 1946)

Insight: Support quality is your strongest competitive advantage and primary retention driver. Maintain this standard during scaling.


Theme P2: Intuitive Product Design and User Experience (35% of promoters - 96 responses)

Sentiment: 93% Positive, 7% Neutral
Key Insight: Users consistently praise the product’s ease of use and intuitive interface, enabling rapid onboarding without training

Representative Quotes:

  • “The UI is so clean and intuitive. I was productive within 30 minutes without any documentation or training.” (Score: 10, user_id: 6721)
  • “Everything just works the way you’d expect it to. Compared to our old solution, this is night and day.” (Score: 9, user_id: 4018)
  • “My team onboarded in less than a day. The UX is incredibly thoughtful and removes so much friction.” (Score: 10, user_id: 9342)
  • “I’ve tried four competitors and this is by far the most user-friendly. The learning curve is basically non-existent.” (Score: 9, user_id: 2567)
  • “The interface design is beautiful and functional. You can tell a lot of thought went into the user experience.” (Score: 10, user_id: 7893)

Insight: Product UX delivers rapid time-to-value and differentiates from competitors. This is a key selling point.


Theme P3: Reliability and Performance (18% of promoters - 49 responses)

Sentiment: 91% Positive, 9% Neutral
Key Insight: Consistent uptime and fast performance builds trust and reduces friction in daily workflows

Representative Quotes:

  • “The platform is rock solid. In 18 months I think I’ve seen downtime maybe twice, and it was minimal.” (Score: 10, user_id: 5124)
  • “Speed and reliability are exceptional. Pages load instantly and we’ve never lost data.” (Score: 9, user_id: 8761)
  • “Unlike our previous tool which crashed weekly, this just works. Every. Single. Time.” (Score: 10, user_id: 3445)
  • “Performance is excellent even when we’re processing large batches. Never any lag.” (Score: 9, user_id: 6198)

Insight: Infrastructure reliability creates baseline trust that enables other positive experiences.


Theme P4: Continuous Product Improvement (14% of promoters - 38 responses)

Sentiment: 88% Positive, 12% Neutral
Key Insight: Users notice and appreciate frequent feature releases and responsiveness to feedback

Representative Quotes:

  • “Love how often you ship new features. You clearly listen to customer feedback and act on it.” (Score: 10, user_id: 4782)
  • “The product keeps getting better every month. You can tell the team is invested in continuous improvement.” (Score: 9, user_id: 2319)
  • “I submitted a feature request and saw it implemented within two months. That’s incredible responsiveness.” (Score: 10, user_id: 9087)
  • “The release notes show you’re constantly innovating. It’s exciting to see what’s coming next.” (Score: 9, user_id: 6543)

Insight: Visible commitment to product evolution signals long-term viability and user-centricity.


DETRACTORS ANALYSIS (66 responses)

Theme D1: Missing Critical Integrations and API Access (48% of detractors - 32 responses)

Sentiment: 88% Negative, 12% Neutral
Key Insight: Lack of integrations with key business tools (especially Salesforce, HubSpot, Slack) and limited API functionality is the PRIMARY blocker preventing satisfaction and creating churn risk

Representative Quotes:

  • “The product itself is decent but without Salesforce integration we’re stuck doing manual data entry for hours every week. This is a dealbreaker.” (Score: 5, user_id: 2847)
  • “No API access in our tier is frustrating. We need to automate workflows but can’t. Considering switching to a competitor.” (Score: 4, user_id: 6192)
  • “Missing basic integrations that competitors have had for years. Can’t connect to Slack, HubSpot, or our project management tools.” (Score: 3, user_id: 8534)
  • “The lack of webhooks and proper API documentation makes this impossible to integrate into our existing stack.” (Score: 5, user_id: 1976)
  • “Integration marketplace is incredibly limited. We need Jira, Asana, and Zendesk connections yesterday.” (Score: 4, user_id: 7261)

Critical Insight: Integration gaps create significant operational friction and position competitors as more viable alternatives. This is an urgent retention risk.


Theme D2: Performance Issues and Technical Bugs (27% of detractors - 18 responses)

Sentiment: 94% Negative, 6% Neutral
Key Insight: Mobile app crashes, slow load times, and recurring bugs significantly degrade user experience and erode trust

Representative Quotes:

  • “The mobile app crashes constantly on Android. I’ve reported this three times and it’s still not fixed.” (Score: 4, user_id: 5318)
  • “Performance has gotten worse over the last two months. Pages that used to load instantly now take 5-10 seconds.” (Score: 5, user_id: 9473)
  • “Too many bugs. Export feature fails half the time, search is unreliable, and the mobile experience is terrible.” (Score: 3, user_id: 3682)
  • “I experience sync issues weekly where changes don’t save properly. This causes real problems for our team.” (Score: 4, user_id: 7549)
  • “The Android app is basically unusable. Freezes, crashes, and data doesn’t sync properly with desktop.” (Score: 2, user_id: 4201)

Critical Insight: Technical reliability issues create daily frustration and signal quality concerns. Mobile problems are especially acute.


Theme D3: Pricing Concerns and Limited Features in Lower Tiers (21% of detractors - 14 responses)

Sentiment: 79% Negative, 21% Neutral
Key Insight: Price increases without corresponding value addition and essential features locked behind expensive tiers create dissatisfaction

Representative Quotes:

  • “The recent price increase was steep and we didn’t get any new features that matter to us. Feels like a money grab.” (Score: 5, user_id: 6824)
  • “Basic features like export and API access should be in the standard tier, not locked behind enterprise pricing.” (Score: 4, user_id: 2195)
  • “The value just isn’t there at this price point. Competitors offer more functionality for less money.” (Score: 4, user_id: 8967)
  • “Pricing structure forces small businesses into expensive plans just to get features that should be standard.” (Score: 3, user_id: 5712)

Critical Insight: Pricing perception issues indicate potential value communication gaps and tier structure problems.


Theme D4: Poor Onboarding and Documentation Gaps (15% of detractors - 10 responses)

Sentiment: 85% Negative, 15% Neutral
Key Insight: Some users struggle with initial setup and find documentation insufficient for complex use cases

Representative Quotes:

  • “Onboarding was confusing and the documentation is sparse. Took us two weeks to get set up properly.” (Score: 5, user_id: 4536)
  • “Help docs are outdated and don’t cover our advanced use cases. Had to figure everything out through trial and error.” (Score: 4, user_id: 9182)
  • “No guided setup or tutorials for new users. We wasted a lot of time configuring things incorrectly.” (Score: 4, user_id: 7348)

Critical Insight: Onboarding friction creates negative first impressions that may be difficult to overcome.


Summary & Strategic Recommendations

What’s Working - Amplify and Protect

  1. Customer Support Excellence (42% of promoters) - This is your moat. Feature prominently in marketing, invest in maintaining quality during scaling, and consider support as a key hiring priority.

  2. Intuitive UX Design (35% of promoters) - Lead with ease-of-use in positioning and competitive comparisons. Create case studies showing time-to-value vs competitors.

  3. Reliability and Performance (18% of promoters) - While promoters praise this, detractors cite problems. Ensure infrastructure investments keep pace with growth.

  4. Responsive Product Development (14% of promoters) - Maintain transparency around roadmap and continue showcasing user-driven improvements.

What’s Broken - Fix Urgently

  1. Missing Integrations and API Limitations (48% of detractors) - HIGHEST PRIORITY

    • Immediate action: Audit top 10 integration requests and prioritize Salesforce, HubSpot, Slack
    • Short-term: Expand API access to lower tiers or create mid-tier with API access
    • Medium-term: Build integration marketplace or partner with Zapier for faster expansion
    • Impact: This single issue affects nearly half of all detractors and creates active churn risk
  2. Mobile Performance and Technical Bugs (27% of detractors) - URGENT PRIORITY

    • Immediate action: Dedicated sprint to address Android mobile stability issues
    • Track and prioritize bug reports by frequency and user impact
    • Consider mobile app performance as Q1 engineering focus area
    • Impact: Daily frustration erodes trust and prevents mobile adoption
  3. Pricing and Feature Tier Structure (21% of detractors) - MEDIUM PRIORITY

    • Review tier boundaries and consider moving high-value features (API, exports) to lower tiers
    • Communicate value more effectively, especially around recent price changes
    • Consider grandfathering existing customers or providing migration path
    • Impact: Perception of poor value creates churn vulnerability to competitors
  4. Onboarding and Documentation (15% of detractors) - MEDIUM PRIORITY

    • Create guided setup flows for new users
    • Audit and update documentation, especially for advanced use cases
    • Consider self-service video tutorials
    • Impact: First impression problems set negative tone for entire relationship

Key Metrics & Insights

  • Net Promoter Score: +46 (60% promoters - 14% detractors) - Healthy but vulnerable
  • Conversion Opportunity: 116 passives (25%) represent potential promoters with targeted improvements
  • Churn Risk Concentration: Integration gaps and performance issues create vulnerability to competitors
  • Competitive Moat: Support quality and UX are strong differentiators worth protecting

Strategic Pattern Analysis

Promoters love your service experience (support + UX) but detractors need product expansion (integrations + features). This suggests a two-speed strategy:

  1. Protect the core experience - Support and UX are retention drivers
  2. Close the feature gap - Integrations are table stakes for enterprise expansion

The gap between promoter themes (service quality) and detractor themes (product functionality) indicates you’ve built strong operational excellence but need product roadmap acceleration to retain growth.

Immediate Next Steps

  1. Week 1: Launch integration requirements survey for all detractors and passives
  2. Week 2: Begin Android mobile stability sprint
  3. Week 4: Publish updated integration roadmap with specific timelines
  4. Month 2: Review pricing tier structure based on competitive analysis
  5. Quarter 1: Deliver top 3 integration requests (recommend: Salesforce, Slack, HubSpot)