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

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

Example for: 14 interviews with ops managers at mid-market logistics brokers handling freight billing.

Pain PointEvidence / QuoteSeverity (1-5)Frequency (1-5)Willingness to Pay (1-5)Opportunity Score (1-125)Priority Tier
Manual reconciliation of carrier accessorial charges"We spend 3 hours every morning manually comparing detention claims against GPS logs."555125High
PDF rate confirmations lost in shared inbox"Brokers miss spot rate updates because 4 people work out of one support mailbox."44348Medium
Fragmented payout status updates for independent drivers"Drivers call 6 times a day asking when QuickPay deposits will clear."35345Medium
Inability to split invoices across multiple shipping locations"Two enterprise accounts demand split invoices, so we build them by hand in Excel."42432Low
Delayed POD document upload from mobile app"Drivers forget to take clear photos of the bill of lading until days later."33218Low
Assumptions and Missing Data
  • Sample Bias: All 14 respondents currently run on legacy desktop TMS platforms; cloud-native brokerages were not interviewed.
  • Billing Authority: Willingness to pay is estimated from ops managers who flag budget authority sits with VP-level finance directors.
  • Small-Volume Carriers: Independent owner-operators were not directly interviewed to confirm driver-side app usability issues.
Written by AI from this prompt. Your results will vary.

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.

Keep exploring

More in Research