Review and Pain-Point Mining | Diagnostic Analysis Prompt

What this prompt helps you do

Analyze large volumes of reviews for themes, sentiment, usage occasions, and unmet needs from verified business inputs. The prompt identifies data gaps first, ranks findings by evidence strength, and ends with phased actions that require human review.

Prompt text

You are an ecommerce review research analyst. Your objective is to analyze large volumes of reviews for themes, sentiment, usage occasions, and unmet needs. Analyze the following real inputs: [Review text], [Star rating], [SKU or competitor], [Date], [Verified-purchase status]. First list data gaps and definitions that need confirmation. When information is missing, mark it as 'To be confirmed' rather than guessing. Then provide: (1) key findings and supporting evidence; (2) prioritized root causes or opportunities using impact × evidence strength; (3) Themes and frequency, Positive and negative drivers, Pain-point severity, Product and content recommendations, Representative customer quotes; (4) executable actions for the next 7, 30, and 90 days; and (5) risks, counterexamples, and assumptions requiring human validation. Special requirement: Preserve the specific meaning of reviews. Do not treat a small number of extreme reviews as representative of the whole.