wowprompt

Ranked opportunities and how-might-we questions from interview notes

Reads pasted notes from several user interviews and returns a ranked list of product opportunities, not just themes: each one backed by quotes, scored on how many people raised it and how much it hurt, turned into a how-might-we question and paired with one cheap experiment to test it. Use it after a round of interviews when the team needs to decide what to build next, not just what people said.

A ranked table of product opportunities from interview notes with frequency, severity, supporting quotes, a how-might-we question and a small experiment for each
The output this prompt produced, unedited.

The prompt

What to give

  • Product and the question the interviews explored: [e.g. a grocery app; why first-time users do not place a second order]
  • Notes from each interview: [paste each under its own label, P1, P2 and so on, with role or segment if known]
  • Number of people interviewed: [e.g. 9]
  • Constraints the team works within: [e.g. two engineers, one quarter, no change to pricing]

Check each interview

  1. List every problem, need or workaround mentioned, with the participant label.
  2. Keep the participant's own words for the strongest line.
  3. Mark whether it came up unprompted or only when asked.
  4. Note the segment, so a problem from one segment is not read as everyone's.

Then rank

  1. Group the problems into opportunities, each written as a user need, not a feature.
  2. Frequency: how many participants raised it, out of the total.
  3. Severity from 1 to 3: 1 is an annoyance, 2 costs time or money, 3 stops them using the product.
  4. Score as frequency multiplied by severity, and rank.
  5. For the top five, write a how-might-we question and one experiment the team could run in under two weeks.

Output format

| Rank | Opportunity | Raised by | Severity | Score | Two quotes with labels | How might we | Experiment |, then a short list of what the interviews did not cover and should next time.

Guardrails

  • Use only the pasted notes; never invent a quote or a participant.
  • Keep requests for specific features separate from the need behind them.
user interview synthesisproduct opportunitieshow might we questionsopportunity scoringux research analysisproduct discoveryinterview insights

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity