Qualitative codebook template for market research
Define codes clearly, retain the participant evidence and record boundary decisions. An editable Excel starting point for structured codebook-based analysis of market-research interviews and groups.
Everyday Packs
All people, quotations and findings in these examples are fictional market-research teaching examples.
Research objective: Understand when consumers choose small or large personal-care packs and the trade-offs they describe.
A participant meaning unit within a turn. A full turn can hold more than one meaning unit. Multiple codes may apply when distinct meanings are explicit. Keep the full turn as evidence and note the meanings supporting each code.
Four example codes and their boundaries
C01 / Portability · Agreed
Participant says a small pack is convenient to carry or keep while travelling.
Include: An explicit link between the small pack and carrying, a bag, commuting or travel.
Exclude: Size mentioned without carrying context; storage at home.
Example: “For travel, the small pack fits in my bag.”
DEMO-R2-IDI01 / I02 / P01
Near miss: A participant says only that the pack is small; no carrying benefit is stated.
C02 / Larger pack for home · Agreed
Participant explicitly prefers or chooses a larger pack for use at home.
Include: Both home use and a preference for a larger pack are stated.
Exclude: Preference for a large pack without a home-use context; carrying a small pack.
Example: “At home I buy the bigger one.”
DEMO-R2-IDI01 / I02 / P01
Near miss: A participant says the big pack lasts longer without saying where they use it.
C03 / Higher unit cost · Agreed
Participant says the smaller pack costs more relative to its quantity.
Include: A price comparison tied to the amount or quantity received.
Exclude: A quoted price without comparison; budget constraints without a quantity comparison.
Example: “The small one costs more for the amount.”
DEMO-R2-FGD01 / F05 / P02
Near miss: A participant says a pack costs INR 20 but makes no quantity or price comparison.
C04 / More frequent purchase · Draft
Participant says the smaller pack leads to more frequent purchases or extra shopping trips.
Include: A clear statement about buying more often or extra trips because of the small pack.
Exclude: Purchase location alone; how often the product is used without a purchase implication.
Example: “I buy the small one more often, so I make extra trips.”
DEMO-R2-FGD01 / F08 / P03
Near miss: A participant says they buy it at a supermarket, with no statement about frequency.
Six selected coded excerpts
These are selected worked examples, not exhaustive coding of the two transcripts. C04 is Draft and provisional pending pilot review.
| Source / turn / speaker | Exact excerpt | Codes | Coding decision |
|---|---|---|---|
| DEMO-R2-IDI01 / I02 / P01 | For travel, the small pack fits in my bag. At home I buy the bigger one. | C01, C02 | One turn contains two distinct meaning units. Apply both codes; this is not two respondents. |
| DEMO-R2-IDI01 / I04 / P01 | It costs more for the amount, and I have to buy it more often. | C03, C04 | Both unit-cost and purchase-frequency meanings are explicit. C04 is a draft code awaiting pilot review. |
| DEMO-R2-FGD01 / F02 / P02 | On the bus, the small pack is easy to carry. | C01 | Carrying benefit is explicit. |
| DEMO-R2-FGD01 / F03 / P03 | For home, I choose the big pack because it lasts longer. | C02 | Home context and choice of the big pack are explicit. |
| DEMO-R2-FGD01 / F05 / P02 | The small one costs more for the amount. | C03 | The participant compares cost with quantity. |
| DEMO-R2-FGD01 / F08 / P03 | I buy the small one more often, so I make extra trips. | C04 | Extra shopping trips are explicit. Review the draft code in the pilot. |
These examples illustrate coding decisions, not population prevalence. Do not infer a missing word, identify an unknown speaker or code a moderator prompt as a participant view. Example v1.0; C04 remains Draft pending pilot coding. The sample is a starting framework, not a universal list of codes.
What we do not code
| Source / turn | Reason |
|---|---|
| DEMO-R2-IDI01 / I06 | The opening feature is unclear. Keep the uncertainty marker and review the audio; do not infer a feature code. |
| DEMO-R2-FGD01 / F06 | Words and speaker are unknown during overlap. No topic or participant attribution can be supported. |
| DEMO-R2-FGD01 / F04 | Moderator question, not a participant opinion. |
A blank structure ready for your study
The workbook starts with project, objective, coding unit, multicode policy, version and owner fields. Its reusable blank codebook contains 30 editable rows.
| Code ID | Code | Definition | Include when | Exclude when | Example excerpt | Source reference | Near miss | Status |
|---|---|---|---|---|---|---|---|---|
| [Enter] | [Enter] | [Enter] | [Enter] | [Enter] | [Enter] | [Enter] | [Enter] | [Enter] |
There are no automatic counts or scores. Add or extend rows as your framework develops; retain definitions and source references.
Pilot, settle boundaries and keep a change record
- Set the research objective and coding unit before adapting the blank codebook.
- Define inclusion and exclusion rules; add an exact example and a near miss for each code.
- Code a small pilot subset. Compare interpretations with another coder where appropriate.
- Record revisions and revisit excerpts affected by a changed definition.
Fictional change-log example · 1.0
Added C04 as Draft after pilot excerpts described repeated purchases and extra trips.
Check whether both meanings should stay under one code before applying the framework more widely.
Affected excerpts: E02 and E06
Pilot with another coder and record the decision; if the code changes, revisit the affected excerpts.
Choose the next resource
Explore qualitative research analysis if you need an analysis deliverable configured around your study.