Turn Qualitative Interview Notes into an Opportunity Matrix
Transforms unstructured user interview findings into a standardized opportunity matrix scored by severity, frequency, and willingness to pay.
You getA Markdown table with columns and 2-3 bullet points under the table highlighting critical…
Prompt
Act as a principal user researcher. Your job is to convert raw qualitative interview notes and customer feedback into a prioritized opportunity matrix.
Rules:
1. Consolidate overlapping interview themes into distinct user pain points phrased from the customer perspective.
2. Score each pain point on a 1-5 scale across three explicit dimensions: Severity (impact when it occurs), Frequency (how often it occurs), and Willingness to Pay (urgency to resolve financially or operationally).
3. Calculate an overall Opportunity Score by multiplying Severity x Frequency x Willingness to Pay (max score 125).
4. Provide one concrete observation quote or evidence snippet from the notes for each theme.
Output format:
- A Markdown table with columns: Pain Point, Evidence / Quote, Severity (1-5), Frequency (1-5), Willingness to Pay (1-5), Opportunity Score (1-125), and Priority Tier (High, Medium, Low).
- 2-3 bullet points under the table highlighting critical assumptions and missing participant segments.
To begin, please ask me 3 brief questions about the user audience, the interview sample size, and then tell me to paste the raw interview notes.Example output
Tips and common edits
Why this works
- Forces a multiplicative 1-125 scoring formula to prevent ties and clearly separate urgent problems from mild annoyances.
- Requires verbatim or direct evidence alongside scores to keep the synthesis grounded in actual interview quotes.
- Prompts for explicit assumptions and missing segments to prevent false confidence from small qualitative cohorts.
Use after completing user interviews or customer feedback rounds in ChatGPT or Claude. Paste your transcript summaries or messy notes after answering the setup questions.
Common edits
- Replace Willingness to Pay with Strategic Alignment or Feasibility if analyzing internal team feedback instead of commercial products.
- Ask the model to cluster findings by customer persona rather than a single unified table if interviewing multiple buyer types.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Map user interview themes to quantitative product metrics
Turn qualitative research themes into testable telemetry events and behavioral metrics. Use it to bridge user feedback with product analytics.
Draft a non-leading user research interview guide
Develop unbiased, behavior-focused interview questions that uncover genuine user habits instead of false compliments.
Build a timed domain expert interview guide
Generate a structured 45-minute or 60-minute interview script focused on uncovering edge cases and workflow breakdowns. Ideal for domain deep dives.
Analyze competitor reviews to find unmet customer needs
Extract recurring customer frustrations, missed expectations, and market gaps from pasted competitor feedback to sharpen your product or service offering.
Build a primary research scoping and ethics checklist
Ensure user interviews and customer studies follow strict consent, privacy, and screening standards before recruiting participants.
Map user friction points to market shifts
Turn customer pain points into strategic signals by connecting immediate user complaints to macro industry and competitor trends.
- Turn market readings into a macro trend brief
- Group disorganized research notes into clear themes
- Turn a research report into executive Q&As
- Create a Board-Ready Executive Research Brief
- Win-Loss Analysis from Sales Debrief Notes
- Build a Literature Review Matrix from Pasted Abstracts with Gaps and Contradictions