Ten interviews produce ten messy stories, not a spreadsheet. Before any math, reduce each conversation to five fields: an identifier, a use case or segment label, the lower bound of the price they said they would pay, the upper bound, and the sentence explaining why. The reason sentence matters because it tells you whether two people with the same number are in the same segment or not. Willingness to pay is a ceiling that moves with context, so the same dollar figure can mean very different things for a two-person startup and a fifty-person operations team (Conveo).
A worked example helps. Suppose ten interviews give these ranges, in dollars per month:
| Interview | Segment | Low | High | Midpoint |
|---|---|---|---|---|
| 1 | Solo operator | 20 | 40 | 30 |
| 2 | Solo operator | 25 | 45 | 35 |
| 3 | Small team | 60 | 90 | 75 |
| 4 | Small team | 50 | 80 | 65 |
| 5 | Small team | 70 | 100 | 85 |
| 6 | Small team | 55 | 75 | 65 |
| 7 | Agency | 120 | 200 | 160 |
| 8 | Agency | 150 | 250 | 200 |
| 9 | Agency | 100 | 180 | 140 |
| 10 | Agency | 90 | 160 | 125 |
Now you have three segments with midpoints. The instinct is to average all ten and get a single number, but that hides the structure. If your pipeline is mostly agencies, the average is dragged down by solo operators who will never buy the expensive plan. Segment first, then decide which segment you are actually building for.
Two cleaning rules save trouble later. First, drop or flag any interview where the person named a range so wide it spans a whole segment (a 10 to 500 answer is not a price, it is a shrug). Second, note whether the number was stated spontaneously or after you showed a price card. Stated willingness to pay tends to run high because agreeing a price is easier than declining it, so a stated figure is a ceiling to discount, not a promise (Conveo).



