User interview snippets

Tag quotes from user interviews by the pain they describe and how serious it is.

Run this on your file Download the template CSV

Columns to upload

Name the columns in your CSV like this. Extra columns are fine: every column of the row is sent with the questions.

Column	What it holds
`participant`	Participant ID
`quote`	The quote from the transcript
`context`	What the interviewer asked

Questions

Each question adds a column to your file. The answer is one of the listed values, or Unsure when the model's confidence is below the cutoff: 70% for pick-one and scale questions, 80% for yes or no.

New column	Question	Possible answers
`pain_point`Yes or no	Does the participant describe a problem, frustration or workaround?	yes They describe a problem, frustration or workaround no They describe no problem
`severity`Scale	How much does the problem cost the participant?	no problem minor annoyance costs time or money stops them doing the task Lowest to highest
`workaround`Yes or no	Does the participant describe doing something by hand or with another tool to get around the problem?	yes They describe a workaround no They describe no workaround
`feature_request`Yes or no	Does the participant ask for a specific feature?	yes They ask for a specific feature no They ask for no feature

Example row

Column	Value
`participant`	P07
`context`	How do you track what you've ordered?
`quote`	I keep a spreadsheet of every bottle because the account page only shows the last three orders.

Answers from a test run on this row

Column	Answer	Confidence
`pain_point`	yes	98%
`severity`	costs time or money	83%
`workaround`	yes	96%
`feature_request`	no	87%

More research use cases

Use case	What it does	New columns
Survey open-ended answers	Code the free-text answers of a survey into themes and sentiment, and pull out the ones that name a specific change.	`theme` `sentiment` `actionable` `off_topic`
Literature review abstract screening	Screen the titles and abstracts of a literature search against your inclusion criteria before you read the full texts.	`design` `population` `outcome` `include`
News and media content analysis	Code news articles by frame and tone for a media study.	`frame` `tone` `cites_study`
App store reviews	Sort app reviews into bugs, requests and praise, and see which version the problems come from.	`category` `sentiment` `crash`
Social listening posts	Code public posts about a topic by stance, and separate first-hand experience from repeated claims.	`on_topic` `stance` `first_hand` `health_claim`