Compare structured benefit scores and price perceptions by customer segment. Build a transparent score table, check response coverage, and choose a focused follow-up without confusing perceived value with customer profitability.
Customer value analysis compares the benefits customers say they receive with their perception of the price they pay. Use coded survey answers, compare like customer segments, and keep the benefit and price measures visible rather than hiding them inside an unexplained score. The result helps select a question to investigate before changing an offer.
For a US equipment supplier, define three benefits: product quality, delivery speed, and support. Ask customers to rate each from 1, very poor, to 5, excellent. Ask a separate price question: how reasonable is the price for the offering, from 1, very unreasonable, to 5, very reasonable.
A higher price score means a more favorable price perception, not a higher invoice amount. Put those anchors in the questionnaire and the report. A label such as price score without its direction invites the wrong decision.
Keep the question wording, response scale, and position consistent when comparing periods. Pew Research Center's questionnaire guidance explains how wording and question order affect answers. These are structured ratings supplied by respondents; do not infer scores by automatically classifying their written comments.
Match survey responses to the customer file using account IDs. Choose segments already defined in the business, such as wholesalers and service companies, rather than creating favorable-looking groups after reading the answers. Customer behavior analysis concerns purchase behavior; this comparison concerns perceptions.
Use one completed response per account for the reporting window. If several contacts answer, set the account aggregation rule before comparing segments. Otherwise, the most talkative account can outweigh several others.
The supplier invited six wholesale accounts and four service companies. Three in each segment completed every scored question. Put the following responses in columns A:F, rows 2:7:
| Account | Segment | Quality | Delivery speed | Support | Price reasonableness |
|---|---|---|---|---|---|
| W1 | Wholesale | 5 | 3 | 4 | 2 |
| W2 | Wholesale | 4 | 3 | 4 | 3 |
| W3 | Wholesale | 5 | 4 | 4 | 2 |
| S1 | Service | 4 | 5 | 5 | 4 |
| S2 | Service | 4 | 4 | 5 | 4 |
| S3 | Service | 3 | 5 | 4 | 3 |
Keep the invitation register separately. It contains all ten eligible accounts, including those without a completed response. Blank answers are missing, not the lowest rating. Review incomplete questionnaires separately rather than silently changing the score denominator between questions.
For this review, the commercial team supplies fixed weights: quality 50%, speed 30%, and support 20%. They sum to 100%. These are explicit management assumptions for the example, not weights proved by the six survey responses.
Put the weights in J2:L2. Calculate G2 and fill down:
=SUMPRODUCT(C2:E2,$J$2:$L$2)
For W1, the calculation is 5 × 0.50 + 3 × 0.30 + 4 × 0.20 = 4.20. The index summarizes ordinal ratings for discussion; it is not a dollar benefit or a precise measure of utility.
| Account | Weighted benefit index | Price reasonableness |
|---|---|---|
| W1 | 4.20 | 2 |
| W2 | 3.70 | 3 |
| W3 | 4.50 | 2 |
| S1 | 4.50 | 4 |
| S2 | 4.20 | 4 |
| S3 | 3.80 | 3 |
| Sum | 24.90 | 18 |
Keep the component ratings next to the index. Equal index values can conceal different issues: W3 has stronger quality than S1, while S1 has stronger speed and support.
Put the segment labels in N2:N3. Calculate each segment's mean benefit and price scores with:
=AVERAGEIFS($G$2:$G$7,$B$2:$B$7,N2)
=AVERAGEIFS($F$2:$F$7,$B$2:$B$7,N2)
Google's AVERAGEIFS documentation describes averaging a range subject to criteria. Apply the same eligible response population to both measures in this complete-response example.
| Segment | Invited | Complete responses | Completion rate | Mean benefit index | Mean price score |
|---|---|---|---|---|---|
| Wholesale | 6 | 3 | 50.0% | 4.13 | 2.33 |
| Service | 4 | 3 | 75.0% | 4.17 | 3.67 |
| Total | 10 | 6 | 60.0% | 4.15 | 3.00 |
Completion rate is completed responses divided by invitations. For example, wholesale is 3 / 6 = 50.0%. Means are rounded to two decimals and rates to one decimal; keep unrounded values in the workbook.
Check the total benefit mean: 24.90 / 6 = 4.15. Check the price mean: 18 / 6 = 3.00. Respondent counts must reconcile to the six included account IDs, and invited counts to the separate register. With unequal segment sizes, calculate the overall mean from responses rather than averaging segment means.
Benefits receive similar aggregate ratings in both groups, while wholesale respondents give price a less favorable rating. That supports a focused discussion with wholesale accounts about the price-benefit tradeoff. It does not prove that a price cut would increase purchases or improve profit.
Review the component ratings before changing the offer. Ask whether delivery speed matters more than the chosen weights suggest. Keep a version of the weights beside each report so a changed index cannot masquerade as changed customer opinion.
Use the customer supplier-switch business case when a buyer can supply measurable operating benefits in dollars. Use customer revenue analysis to check actual purchasing alongside perceptions. The customer ABC analysis explains a separate ranking exercise; revenue importance and perceived value answer different questions.
Bring a sample of your own numeric survey export, customer segments, and declared weights. Covirage maps the columns; its tools compute and check the supplied comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and set up your business before bringing your file.
See Covirage for sales insights for the supporting approach. Covirage is not affiliated with Google.
No. Customer value analysis here concerns value perceived by the buyer: benefits relative to the price they pay. Lifetime value concerns the seller's expected customer contribution over time. An account can perceive excellent value while generating little contribution for the supplier.
You can calculate a ratio, but a ratio of survey ratings rarely has a defensible economic interpretation. A rating of four is not necessarily twice the benefit represented by two. Display the benefit and price measures separately, with their scale anchors and response counts.
There is no universal count that makes a segment comparison reliable. Consider how respondents were selected, the share who answered, and differences between respondents and the wider customer population. Small groups can guide follow-up conversations but should not support precise market-wide claims.