Code Interview Transcripts into Themes with Participant Counts and Verbatim Quotes
Turns pasted interview transcripts into a theme table with participant counts, exact supporting quotes, counterpoints, and a separate list of one-off mentions.
You getTheme table with columns, strong themes and one-off mentions
Prompt
Act as a qualitative researcher who codes interview transcripts for a living.
I will paste one or more interview transcripts right after this message. Each participant is labeled with an ID (such as P1, P2) or a name. Code the transcripts into themes and show how much support each theme has.
Rules:
1. Use only verbatim quotes copied exactly from the transcripts. Never paraphrase inside quotation marks, and never create a quote that is not in the text.
2. Count participants, not mentions. One person raising a point five times counts as 1.
3. Mark a theme Strong if at least 3 participants or at least half the sample back it, whichever is smaller. Everything else goes under One-off mentions.
4. Tag every quote with its participant ID.
5. If any participant contradicts a theme, show that quote as a counterpoint.
Output format:
1. Theme table with columns: Theme | One-line definition | Participants (count and IDs) | Strength
2. Strong themes: for each, 2-3 supporting quotes with IDs, plus one counterpoint quote if one exists
3. One-off mentions: theme, participant ID, one quote
4. Gaps: questions the transcripts leave unanswered
End with one line on limits: sample size, participants who gave little detail, and anything you could not code with confidence.Example output
Tips and common edits
Why this works
- Requiring verbatim quotes tagged by participant stops the model from paraphrasing or inventing evidence.
- Counting participants instead of mentions keeps one talkative interviewee from inflating a theme.
- A set Strong threshold plus counterpoints separates real patterns from one-offs and shows disagreement.
Use after user interviews, customer calls, or research sessions. Have transcripts ready with participant labels. Long sets work best in Claude or Gemini; in ChatGPT, paste in batches if needed.
Common edits
- Raise the Strong threshold to 4+ participants for larger studies of 12 or more interviews.
- Add a column linking each theme to a product decision or next research question.
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
Build a Verification Checklist for AI Answers and Their Citations
Paste any AI-generated answer and get a table of every claim and citation, rated by risk, with red flags and the exact check needed to verify each one.
Compare How Different Articles Report the Same News Event
Get a side-by-side table showing which facts all your pasted articles agree on, where they conflict, what each leaves out, and how each frames the story.
Fact-Check a Viral Post or Forwarded Message Claim by Claim Before Sharing
Splits a viral post into separate claims, rates each one, and gives you exact search phrases and source types to confirm or debunk it before you share.
Spot Logical Fallacies and Weak Arguments in Any Opinion Piece
Returns a ranked table that quotes each weak passage in an essay, names the fallacy, explains in one line why it fails, and suggests evidence that would fix it.
Trace a Quote or Claim Back to Its Original Source Step by Step
You get a step-by-step research trail with exact search strings, misattribution red flags, and clear criteria for deciding whether a quote is confirmed, misattributed or unverifiable.
Build a Literature Review Matrix from Pasted Abstracts with Gaps and Contradictions
Paste your abstracts and get a study-by-study table of method, sample, finding and limitation, plus themes, disagreements between studies, and untested research questions.
- Analyze a CSV File: Quality Checks, Patterns and Outliers
- Customer Voice Synthesis from Reviews and Forum Threads
- Check Whether a Health Headline Matches the Study Behind It
- Break Down a News Article into Facts, Opinions and Loaded Wording
- Design a Bias-Checked Survey Where Every Question Informs a Decision
- Draft a Research Methodology Section with Justified Design and Validity Threats