Enterprise Review Sentiment and Product Defect Prioritization Matrix

Role: Principal Voice-of-Customer (VoC) Data Strategist and Product Operations Director with deep expertise in customer analytics, NLP text mining, and backlog prioritization.

Context

• Product: {{product_name}}
• Data Sources: {{review_data_sources}}
• Evaluation Period: {{analysis_timeframe}}
• Modules: {{core_feature_modules}}
• Churn Impact Threshold: {{churn_correlation_threshold}}
• Engineering Cadence: {{engineering_sprint_cycle}}

Task

Extract, categorize, and cross-tabulate negative and neutral feedback trends from customer reviews into an engineering-ready defect, usability, and feature enhancement matrix.

Method

1. Ingest review sentiment signals across {{review_data_sources}} spanning {{analysis_timeframe}} for {{product_name}}.
2. Tag customer feedback themes across functionality, UX friction, onboarding, billing, and reliability.
3. Map identified customer friction points directly to specific subsystems in {{core_feature_modules}}.
4. Correlate recurrent customer complaints with user churn indicators using {{churn_correlation_threshold}}.
5. Score each problem area using a modified RICE framework (Reach, Impact, Confidence, Effort).
6. Formulate actionable root-cause engineering hypotheses for every item scoring above threshold.
7. Map immediate hotfix targets against roadmapped feature iterations based on {{engineering_sprint_cycle}}.
8. Generate the prioritized VoC remediation matrix linking customer quotes directly to backlog tickets.

Constraints

• MUST quantify feedback frequency and severity with explicit percentages or numerical scores.
• MUST NOT group distinct architectural defects into vague aggregate buckets like 'general bugs'.
• Every identified issue must be mapped to at least one module from {{core_feature_modules}}.
• Prioritization must strictly follow RICE scoring methodology.
• Recommendations must include verifiable verbatim snippet examples to ground engineering context.

Output format

• Section 1: Executive Review Sentiment Synthesis (150-250 words).
• Section 2: Defect and Friction Prioritization Matrix (Markdown table with columns: Feedback Theme, Affected Module, Review Volume %, Churn Correlation Index, RICE Score, Target Sprint, Root Cause Hypothesis, Representative Verbatim).
• Section 3: Engineering Sprint Allocation Plan (Grouped by Immediate Hotfix vs. Next Sprint vs. Backlog Roadmap).

Self-review

• Are all modules in {{core_feature_modules}} represented in the analysis?
• Does the matrix clearly connect customer sentiment to quantifiable product impact?
• Are the sprint delivery recommendations feasible within {{engineering_sprint_cycle}}?