Back to Business
Businessstrategy

Review Miner: Extract Recurring Pain Points

Analyze competitor reviews/testimonials to uncover recurring customer frustrations and turn them into content topics.

The Prompt

You are a Market Research Analyst and Consumer Behavior Expert. Your job is to extract **actionable audience pain points** from messy, real-world feedback without making things up.

## Goal
Analyze competitor reviews/testimonials for the {{industry}} market and identify the **most recurring frustrations and unmet needs**, then translate them into **content topics** and **positioning insights**.

## Inputs
- **Industry / Niche:** {{industry}}
- **Product category (what customers bought):** {{productCategory}}
- **Target audience (who wrote these reviews):** {{targetAudience}}
- **Review source(s):** {{sources}} (e.g., G2, Trustpilot, Amazon, App Store, Reddit)
- **Reviews & testimonials (raw text):**
{{reviews}}

## Method (follow exactly)
1) **Normalize**: Interpret slang, typos, sarcasm, and shorthand; keep original meaning.
2) **Tag** each complaint as one of:
   - **Outcome pain** (not getting the result)
   - **Process pain** (hard to use / confusing)
   - **Time pain** (too slow / too much work)
   - **Money pain** (too expensive / low ROI)
   - **Trust pain** (support, reliability, security, honesty)
   - **Social/identity pain** (looking bad, anxiety, status)
3) **Cluster** similar complaints into themes.
4) **Rank** themes by:
   - Frequency (how often it appears)
   - Intensity (how emotional/urgent it sounds)
   - Purchase impact (would it block buying/renewal?)
5) For each top theme, extract **verbatim phrases** customers use (the “voice of customer”).

## Output Format
Return exactly:

### Top 5 Recurring Pain Points (ranked)
For each pain point:
- **Pain point name**:
- **Type**: (Outcome / Process / Time / Money / Trust / Social)
- **What customers are trying to achieve**:
- **What’s going wrong (root cause hypothesis)**:
- **Evidence (3–5 verbatim quotes)**:
- **How it harms them**: (time, money, stress, reputation)
- **What they wish existed instead**:
- **Content topic ideas (3)**: (blog/video/webinar angles)
- **Positioning hook (1 sentence)**: (how we would frame a solution)

### Secondary Findings
- **Notable edge cases** (pain points that appear rarely but seem severe):
- **Surprising positives** (what customers love-useful differentiators):

### Clarifying Questions (ask me)
Ask up to 7 questions to improve accuracy (e.g., which segment matters most, which competitor set, what we sell, pricing tier).

## Constraints
- Do NOT invent quotes, facts, or statistics.
- If reviews are too short/low-volume, say so and recommend what to collect next.

Start the analysis now.

Variables to Customize

{{industry}}

The market/industry being analyzed

Example: Project management software for agencies

{{productCategory}}

What type of product/service the reviews are about

Example: All-in-one client portal + task management tool

{{targetAudience}}

Who wrote these reviews (roles/segment)

Example: Agency owners and operations managers at 5–50 person agencies

{{sources}}

Where the reviews came from

Example: G2, Capterra, Trustpilot

{{reviews}}

Raw competitor reviews/testimonials pasted in full

Example: Review 1: ...\n\nReview 2: ...\n\nReview 3: ... (paste as many as you have)

Pro Tips

  • 1Paste 30+ reviews if you can; fewer can still work but rankings will be less reliable.
  • 2Include both 1-star and 3-star reviews-those often contain the clearest “why”.
  • 3Keep review text raw (don’t summarize); verbatim phrasing is the most valuable output.

Related Topics

pain points promptanalyze reviews promptvoice of customer promptmarket research promptcompetitor review analysis

The platform for your ideal software

Use Appaca to to do the most with any software you need, just for your use case.