Newsletter Signup: Text HTML 
 

Turning Customer Data into Critical-to-Satisfaction Data

 
 

By Debra Thomas, iSixSigma Contributing Writer

Most people would agree that customers are the most important part of a business – no customers, no business. In order to be successful, a business must know who its customers are and what the expectations of those customers are for the product or service the business sells. In Six Sigma, that process is known as identifying the voice of the customer (VOC). The key to having success in that process is gathering customer data and converting it into measurable critical-to-satisfaction elements.

Some customer data is readily available to a business from sources such as customer complaints, warranty claims, customer returns, refunds, etc. Additional customer data may be obtained from surveys, focus groups, face-to-face interviews and feedback cards.

  • Customer surveys are used to elicit quality, service and performance data by asking a standardized set of questions. They are either mailed to customers for them to complete and return or are administered by an interviewer.
  • Focus groups are small groups of customers invited to a meeting and asking for their thoughts and opinions on specific questions.
  • Face-to-face interviews are conducted by an interviewer with individual customers or potential customers who are asked about their experience with specific products or services.
  • Feedback cards are a common method of measuring customer satisfaction and are used by many restaurant and hotel chains to rate elements such as quality, cleanliness, and service.

Gathering customer data is the first step in creating useful information for the business. Once obtained, customer data is analyzed to uncover customer perceptions and satisfaction trends over time. There are multiple tools available to analyze this data and determine whether customer satisfaction is trending positive or negative. A few of the most common tools are:

  • Simple line graphs are used to show whether a specific characteristic is changing over time, getting better or worse, or staying the same.
  • Control charts are used to show whether performance is changing over time and to detect special and assignable causes of variation.
  • Pareto analysis is used to identify the top reasons for customer dissatisfaction. With this information, businesses know which problems to address first to get the most improvement most quickly. Also Pareto charts can show whether defect/reject categories are being driven down over time.
  • Statistical tests and comparative analysis are used to determine whether or not customer attitudes or specific performance measures have changed and if so, whether or not the changes are statistically significant.

Once the customer data is analyzed and customer concerns are identified, the information is translated into critical-to-satisfaction requirements for the business. A critical-to-quality (CTQ) tree can help convert customer needs and wants into measurable requirements for products and/or services.

 Figure 1: Customer Satisfaction Scores
A Case Study: Data into Satisfaction Data

The following case study illustrates how a fictitious homebuilding business used customer satisfaction survey data to develop meaningful and measurable critical-to-satisfaction data.

In this example, the business used customer satisfaction surveys to measure performance for the last several years. A line chart showed steadily improving customer satisfaction culminating in a high of 86 points in 2002. But then the annual score plummeted to 82 points in 2003. (Figure 1)

Concerned about this degradation, the business analyzed the survey data. A Pareto analysis revealed that the warranty category was 23 percent of the total customer dissatisfaction score and the largest item on the Pareto chart (Figure 2). While scores for warranty-related items were low (worst ratings), warranty was identified as most important to customers.

The warranty data was analyzed further and an additional Pareto chart (Figure 3) was completed to identify the warranty issue more specifically. When needed, customers were interviewed by phone to clarify the issue. The results showed that the primary causes of dissatisfaction with the warranty were the inconvenience and scheduling of mandatory warranty visits during specific time frames and the lack of an additional warranty visit that some competitors provided.

 Figure 2: Pareto Chart for Customer Dissatisfiers

 Figure 3: Pareto Chart for Warranty Dissatisfiers 

 Figure 4: CTQ Tree

A critical-to-quality tree (Figure 4) was then developed to convert the customer needs/wants to measurable requirements for the business to implement.

By analyzing the customer survey data and developing the CTQ tree, the business was able to identify critical-to-satisfaction requirements. These requirements became the focus for improving customer satisfaction. The business eliminated the mandatory warranty visits and made all warranty visits optional. Eliminating the mandatory visits satisfied the customers who thought there were too many visits and adding an extra optional visit satisfied the customers who thought there were too few visits. Expanding the time frame for scheduling warranty visits from two weeks to three months eliminated the inconvenience for customers who had busy schedules and found the time frame too difficult.

The business took a general, difficult-to-measure need (to improve homeowner warranty satisfaction) and developed specific, measurable and actionable requirements to drive improvements in customer satisfaction.

About the Author

Debra Thomas has worked for Johnson & Johnson, Motorola and Tellabs where she held roles in quality engineering/quality management, business quality, customer quality and strategic quality. She is a certified Master Black Belt and earned her Six Sigma Black Belt while working at Motorola. She has used Six Sigma in both manufacturing and transactional environments. She can be reached at dthomasjob@hotmail.com.

 

Best Selling Products

  1. Certified Lean Six Sigma Black Belt Assessment Exam
    Interested in assessing your knowledge of Lean Six Sigma? Preparing for certifications? Testing your students and traine...
  2. Six Sigma DMAIC Training Slides
    The complete 2008 Lean Six Sigma DMAIC course prepares participants to perform the role of a LSS Black Belt; covering wh...
  3. Process Management Training Slides
    The 2008 Process Management course is designed in two phases comprised of:352 Powerpoint slidesInstructor notesSlide exp...
  4. Certified Lean Six Sigma Green Belt Assessment Exam
    This assessment exam is useful for students interested in assessing their knowledge of Lean Six Sigma on the Green Belt ...
  5. Certified Lean Six Sigma Black Belt E-book
    In 670 pages learn everything within the Lean Six Sigma DMAIC body of knowledge to successfully achieve Black Belt certi...
  6. Gage R&R Excel Template
    Gage Repeatability and Reproducibility (R&R) studies measure the amount of measurement variation that is attributabl...
  7. Six Sigma Black Belt (DMAIC) Training Slides
    The 2008 Six Sigma Black Belt course is comprised of: 1,176 PowerPoint slides, Instructor notes, Slide explanations, 37 ...

Premium Sponsor:

Accenture, Process & Improvement Performance, formerly George Group

Sponsors:

Achieve Operational Excellence: Oriel

Advance your Military Career with Six Sigma Programs from Villanova University

MoreSteam: The Engine Room of Continuous Improvement

Novaces: Six Sigma for the Military

Sponsor iSixSigma Military



 

About iSixSigma Military

The purpose of this iSixSigma Military channel is to document the transformation of the United States Armed Services through the use of Lean Six Sigma and related process improvement methodologies.

Ronald E. Rezek, special assistant to the acting secretary of the Army, has said the goal of the Army's Lean Six Sigma deployment is to "make the business side of the Army as efficient as the war-fighting side is effective." Leaders of the other armed services echo that sentiment and transformation objective.

This portal will serve as a central community for everyone associated with the business transformation of the U.S. military. It will provide communication updates on deployments, the opportunity for military leaders at all levels to learn new skills, advance their careers and contribute to the success of their organizations.