Organizing voice-of-customer interview data for conversion copy

Executive overview

Most copywriters end interviews with either too little usable data or so much they can't find what they need. The fix is a structured system that begins before the interview and ends with a sortable, master-referenced spreadsheet.

Know your one reader's stage of awareness before the interview; it determines every question you ask and every category you sort data into afterward.

Preparing before the interview: core questions

• Identify two core questions before any interview: what are you writing, and what is your one reader's stage of awareness?
• Five awareness stages — unaware, problem aware, solution aware, product aware, most aware — determine what you lead with in copy.
• Map each interview question to the awareness stage it informs:
  • "What word would you use to define the product?" → identity cues for unaware prospects
  • "What was the tipping point that led you to buy?" → pain triggers for problem-aware prospects
  • "If the product disappeared, what would you miss most?" → benefits for solution-aware prospects
  • "What ultimately led you to go ahead?" → differentiators for product-aware prospects
  • "Is there something you can't accomplish with the product?" → gaps for most-aware prospects
• When you don't yet know what to write (e.g. a client asks for a nurturing funnel but actually needs a sales funnel), run a four helpful lists exercise: brainstorm what's right, wrong, missing, and confusing before setting interview goals.

Running the interview

• Treat it as a conversation, not an interrogation — shift focus from your nerves to genuine curiosity about buying decisions.
• Don't let the customer lead; you run the interview toward specific outcomes.
• Record and get a verbatim transcript — do not take notes during the call.
• Verbatim transcripts preserve ums, likes, and pauses that signal heightened emotion and are verbal clues for copy.

Organizing data after the interview: the worksheet system

• Immediately after each interview, fill out initial impressions: what's intriguing, what's surprising, what's similar or different to other interviews, and standout quotes.
• Once the transcript arrives, sort every data point into labelled categories — do not keep everything in one place.
• Standard categories (add or remove as needed):
  • Objections
  • Motivations
  • Expected benefits
  • Unexpected benefits and detriments
  • Referral source / how they found the product
  • Competition
  • Recommendations (what they'd tell a friend)
  • Heightened emotion
  • Interesting use cases
  • Repeated instances (anything said more than once signals importance)
  • Sticky messaging — vivid turns of phrase, verbal pictures, language worth borrowing verbatim
  • Action items (follow-ups, testimonial requests, support escalations)
• For each category, write a short header summarising the insight, then paste the raw quote beneath it.
• Add tags at the top of each customer's tab for fast cross-interview scanning.

Using the data: master lists and targeted retrieval

• When writing a specific asset (e.g. an FAQ email), go directly to the relevant category — you don't need to re-read the full transcript.
• For shared themes across interviews, build a master list: copy a whole category section from every customer tab into one consolidated view.
• Always build a sticky messaging master list — it is the most reusable asset from any research project.
• Budget roughly 20 minutes per hour of interview to complete the sorting; the time investment pays back faster retrieval on every future writing task.

Sorting practice: what to pull and where

• "It would have felt weird to have a stranger there" → Objections (intrusive presence); "a very intimate beautiful birth" → Sticky messaging
• "I really just wanted to hit undo… some kind of magical surgery" → Sticky messaging and Heightened emotion and Motivations (fear drove the doula hire)
• "I didn't want to be a burden on my husband… scary thing to see your wife transform" → Motivations, Sticky messaging, and Unexpected benefits (spousal support angle emerged in reflection)
• One data point can — and often should — appear in multiple categories.