Analyze a fictional Parcel Window study about choosing parcel pickup times. There are 12 consented interviews and 47 coded excerpts. The allowed use is aggregate product research. Build a reproducible, human-reviewed analysis from bounded transcript segments, not a contact list or a marketing audience. The deliverable is a decision memo with evidence links, disagreement records, counterexamples, and a testable next step.
Project: analyze Parcel Window pickup interviews
Prepare and code the records
Remove an unrelated third-party phone number from P-07's transcript before model analysis. Keep P03-S18 as one contextual segment because P-03 corrects an initial claim; mark its noisy word for audio review. Use codebook v2: WINDOW_CLARITY includes uncertain displayed intervals and excludes a slow page when the interval was understood. Coder A and coder B assign different codes to P03-S18; the review keeps both WINDOW_CLARITY and NOTIFICATION_TIMING, each tied to its own span. P09-S04 stays unresolved until the recording is checked.
Reconcile themes and propose a check
Nine window-clarity excerpts come from five distinct participants, including four repeated mentions by P-07. Two participants report a language barrier. P-11 prefers a broad pickup interval; the counterexample stays beside the proposed theme. State 'five of the 12 interviewed participants' only as a sample description, not a population rate. Propose a plain-language range with an optional narrower alert. Test comprehension and pickup planning before claiming the feature improves outcomes.
Study: 12 interviews; 47 coded excerpts
WINDOW_CLARITY: 9 excerpts, 5 distinct participants
LANGUAGE_BARRIER: 2 distinct participants
Counterexample: P-11 prefers flexibility
P09-S04: unresolved audio
Decision: prototype range plus optional alert; measure before rolloutPerformance and review cost
Scope screening and segmenting are O(N) in the transcript records; direct coding against K codes can be O(NK). Participant deduplication across M coded excerpts is O(M) expected time with a set. Human reviewers should inspect every disputed span and a sample of accepted labels. The project passes only when each theme has segment references, its contrary cases, a stable codebook version, reconciled counts, and an explicit boundary between interview evidence and product hypothesis.
Common Mistakes
- Do not export incidental identifiers for an unrelated use.
- Do not discard P-03's correction or P-11's counterexample.
- Do not count nine excerpts as nine people.
- Do not claim a prototype has already reduced missed pickups.
Related lessons
- Interview prompts: limit transcript use to the study purpose
- Interview prompts: preserve speaker and segment boundaries
- Interview prompts: write a codebook with inclusion rules
- Interview prompts: keep coder disagreement visible
- Interview prompts: build a theme evidence ledger
- Interview prompts: count people, not repeated excerpts
- Interview prompts: turn bounded findings into testable decisions
- Research prompts: fix the question and eligibility first
- Aggregation prompts: pin the denominator and recompute the rate
- Qualitative interview prompt decisions
