Transform Customer Interview Transcripts into Ranked Pain-Point Matrix

Turn raw interview notes into a structured matrix that ranks customer pain points by frequency and business impact to guide your product roadmap.

Prompt

Prompt
Act as a Senior Product Manager. I will provide raw notes from customer interviews. Your job is to extract specific pain points and organize them into a ranked matrix. Follow these rules: 1. Identify distinct user problems, not feature requests. 2. For each problem, extract one verbatim quote from the transcript as evidence. 3. Estimate the business impact as either Low, Medium, or High based on mentioned operational or financial consequences. 4. Tally the frequency of each problem across the provided notes. Output format: Provide a markdown table with columns: Problem Statement, Verbatim Quote, Business Impact, and Frequency Count. Follow the table with a 3-bullet summary of the top priorities based on highest frequency and impact. This is for internal product discovery and does not replace formal user research methodologies.

Example output

Example for: a B2B SaaS platform team analyzing 5 customer discovery calls regarding their current billing dashboard.

Problem StatementVerbatim QuoteBusiness ImpactFrequency Count
Manual invoice reconciliationI spend 4 hours every Friday manually matching line items to our bank statements.High4
Lack of bulk export optionsIt is impossible to pull a CSV for the entire quarter without hitting a timeout error.Medium3
Unclear tax line itemsOur accounting team constantly asks why the tax calculation fluctuates by 2 cents.Low2
Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Forces a distinction between user problems and feature requests.
  • Mandates verbatim evidence to ground the analysis in real user data.
  • Uses a structured table to make prioritization decisions visually clear.

Use this to synthesize discovery sessions when you have messy notes from 3-10 user interviews. Paste your combined notes directly after the prompt in ChatGPT, Claude, or Gemini. Ensure your notes contain clear speaker labels.

Common edits

  • Add a column for 'User Persona' if you are interviewing different types of stakeholders.
  • Adjust the impact criteria to focus specifically on churn risk if that is your current primary goal.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Product Management