Van Westendorp PSM Excel Template
Van Westendorp PSM Excel Template
Published on
1 July 2022
Chun Hui Lee image
Chun Hui Lee
Insights Writer
Van Westendorp Price Sensitivity Meter
VW

The Price Sensitivity Meter helps determine psychologically acceptable range of prices for a single product and approximately estimate price elasticity.

The Van Westendorp Price Sensitivity Meter is used to determine the psychologically acceptable range of prices for a single product or service. Learn more about the method and its output with our free Excel template.


VW
Features and claims
Pricing research

Van Westendorp Price Sensitivity Meter

The Price Sensitivity Meter helps determine psychologically acceptable range of prices for a single product and approximately estimate price elasticity.

Overview of the Van Westendorp PSM Excel template

The Van Westendorp Price Sensitivity Meter (PSM) is one of the most commonly used pricing techniques to reveal consumer attitudes toward price points and discover the psychologically acceptable range of prices for products and services. To help you understand the Van Westendorp output, Conjointly has set up a free Excel template with an example study for a multivitamin brand.

Conjointly Van Westendorp PSM Excel template

Sign up on Conjointly for free to download the template.

Using Van Westendorp PSM Excel template

On the Respondents tab , the columns AA to AD are the output for the Van Westendorp, where:

  • Column AA = the “too cheap” price.
  • Column AB = the “cheap” price.
  • Column AC = the “expensive” price.
  • Column AD = the “too expensive” price.
Using Van Westendorp PSM Excel template

Download the full report of the example experiment

The example study mirrors question four of the Example experiment 3: Gabor-granger and Van Westendorp, which its full report is available for free along with other example experiments when you sign up to the Conjointly platform.

Download the full example experiment

Also, remember to check out the detailed discussion on interpreting the PSM chart.

Feel free to get in touch with us if you would like to adjust your pricing to maximise profits. Or, if you need custom research or help with the automated tools, Conjointly’s team of research experts are here to help.


Read these articles next:

How to Test Claims for Consumer Products

How to Test Claims for Consumer Products

Claims testing is a research methodology that allows you to identify the most convincing claims for your brand or product category. Learn about types of claims and the ways to test them in this introduction to claims research.

View article
What is TURF Analysis and When to Use It?

What is TURF Analysis and When to Use It?

TURF analysis (Total Unduplicated Reach and Frequency) is a statistical technique that ranks combinations of products by how many people will like these combinations.

View article
Ad Pretesting Tools

How to maximise the impact and return of your ads with ad pretesting

Whether your goal is to maximise the return on your ad spend or convince your stakeholders that your ad proposal will be successful, ad pretesting tools come in handy. Let’s discover which option best fits your brand and objective — and launch successful ads that everyone will discuss.

View article