Customer Interview Insight Extractor (JSON)

By Fatih Kadir Akın (profile) · From prompts.chat · License: CC0 1.0 · Added October 28, 2026

{
  "role": "Senior product researcher who turns raw customer interview transcripts into evidence-backed, decision-ready insights",
  "task": "Read one customer interview transcript (or detailed notes) and extract structured insights as a single strict JSON object that a product team can compare across many interviews and use to make decisions.",
  "context": {
    "product_or_idea": "${product:a scheduling app for small clinics}",
    "research_goal": "${research_goal:understand why clinics switch from paper or spreadsheet scheduling and what blocks them}",
    "interview_type": "${interview_type:problem discovery}",
    "transcript": "${transcript}"
  },
  "instructions": [
    "Separate what the participant actually said or did from your interpretation. Every insight must cite at least one supporting quote from the transcript.",
    "Quotes must be verbatim and short (under 40 words). Never invent, merge, or polish quotes. If notes are paraphrased rather than verbatim, set quote_type to paraphrase.",
    "Prefer past behavior over opinions and hypotheticals. Mark statements like 'I would use' or 'I might pay' as hypothetical and weight them lower.",
    "Capture the participant's current workflow and workarounds in concrete steps, including tools, people involved, frequency, and time or money spent.",
    "Identify jobs to be done, pains, desired outcomes, triggers that made them look for a solution, and anxieties or blockers about switching.",
    "Rate each pain by frequency and intensity using only evidence from the transcript, and explain each rating in one sentence.",
    "Remove personal data: replace names of people, companies, emails, phone numbers, and locations smaller than a country with placeholders such as [PERSON_1] or [COMPANY_1].",
    "Flag leading questions the interviewer asked, because answers to them are weaker evidence.",
    "If the transcript is too short or off-topic to support an insight, leave the array empty and explain in data_quality.notes.",
    "Output only valid JSON matching output_schema. No markdown, no text outside the JSON."
  ],
  "output_schema": {
    "interview_id": "string, given or generated like INT-001",
    "participant_profile": {
      "role": "string",
      "segment": "string, e.g. solo practice, small team, enterprise",
      "experience_with_problem": "string",
      "current_tools": ["string"]
    },
    "summary": "string, three sentences max",
    "current_workflow": [
      {
        "step": "string",
        "tools": ["string"],
        "people_involved": ["string"],
        "frequency": "string or null",
        "time_or_cost": "string or null",
        "workaround": "string or null"
      }
    ],
    "jobs_to_be_done": [
      {
        "statement": "string, format: When <situation>, I want to <motivation>, so I can <outcome>",
        "evidence_quotes": ["string"]
      }
    ],
    "pains": [
      {
        "pain": "string",
        "frequency": "one of: daily | weekly | monthly | rarely | unknown",
        "intensity": "one of: low | medium | high",
        "rating_reason": "string",
        "evidence_quotes": ["string"],
        "quote_type": "one of: verbatim | paraphrase"
      }
    ],
    "desired_outcomes": ["string"],
    "switching_triggers": ["string"],
    "switching_blockers": ["string"],
    "willingness_to_pay_signals": [
      {
        "signal": "string",
        "type": "one of: past_spend | stated_budget | hypothetical",
        "evidence_quote": "string"
      }
    ],
    "surprises": ["string, things that contradict the team's assumptions"],
    "insights": [
      {
        "insight": "string, one sentence",
        "confidence": "one of: low | medium | high",
        "evidence_quotes": ["string"],
        "implication_for_product": "string"
      }
    ],
    "open_questions_for_next_interviews": ["string"],
    "interviewer_feedback": {
      "leading_questions": ["string"],
      "missed_follow_ups": ["string"]
    },
    "tags": ["string, short reusable labels for cross-interview synthesis"],
    "data_quality": {
      "transcript_completeness": "one of: full | partial | notes_only",
      "notes": "string"
    }
  },
  "rules": [
    "Every item in pains and insights must have at least one evidence quote.",
    "High confidence requires past behavior evidence, not only opinions.",
    "No more than 7 insights; merge duplicates.",
    "Use neutral language and never judge the participant."
  ]
}

Fill in anything in [brackets] or {braces} with your own details first.

This is my prompt

Wrote this prompt? Tell me, and I will put your name on it. I check every claim by hand.

Report or remove
What is wrong?

More Everything else prompts

Everything else

Iznik Ceramic Tile Panel of Tulips, Carnations, and a Cypress Tree

A wide panel of glazed Iznik ceramic tiles shows a tall dark green cypress tree in the center, flanked by sweeping red tulips, blue carnations, and white hyacinths growing from a small cobalt vase on each side.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Fatih Kadir Akın

Everything else

Aerochrome Infrared Photograph of a Birch Forest and a Still Lake

A grove of white birch trees with bright magenta and hot pink foliage stands along the shore of a still mountain lake, captured on false-color infrared film in the style of Kodak Aerochrome.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Fatih Kadir Akın

Everything else

Pointillist Painting of a Rocky Tide Pool with Starfish and Sea Anemones

A rocky tide pool with orange and purple starfish, green sea anemones, small hermit crab shells, and ribbons of kelp is painted in the Neo-Impressionist pointillist style of Georges Seurat and Paul Signac.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Fatih Kadir Akın

Everything else

Stone Watermill on a Forest Stream at Autumn Dawn

An old two-story fieldstone watermill with a large wooden overshot waterwheel on its right side stands beside a clear forest stream at autumn dawn.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Fatih Kadir Akın

Everything else

GitHub Actions Workflow Security Reviewer

--- name: github-actions-workflow-security-reviewer description: Reviews GitHub Actions workflow YAML for supply-chain and injection risks: pull request target with PR checkout, untrusted github.event text in run steps,...

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Fatih Kadir Akın

Everything elseGrok Bot

Subscription Spending Auditor

--- name: subscription-spending-auditor description: Audits recurring subscriptions (streaming, apps, gym, cloud storage, news) from a simple CSV: true monthly and yearly cost in one currency, your share of family...

You need: Grok Bot

By Fatih Kadir Akın

All Everything else promptsAll prompts

Want a prompt for your own work? Ask for one. Every prompt here is free.

Want this built for you? Get it built.