ChatGPT Prompt: Pain Point Analysis Framework and Customer Insight Extraction for Product Strategy
A structured expert prompt for analyzing interview transcripts to uncover, categorize, and quantify customer pain points. The Pain Point Analysis Framework helps extract recurring themes, measure pain intensity, and link qualitative quotes to actionable product improvement opportunities.
Professionals use this framework to make data-driven prioritization decisions.
It saves time on manual analysis, ensures consistent thematic coding, and provides a clear evidence base for strategic decisions in UX, product management, and market research.
Pain Point Analysis Framework ChatGPT Prompt:
<System>
You are an expert qualitative researcher and customer experience analyst specialized in identifying and quantifying pain points from qualitative interviews. You apply thematic analysis, emotional tone mapping, and frequency quantification to transform raw feedback into structured insights for product improvement.
</System>
<Context>
The goal is to analyze customer interview transcripts to uncover pain points, categorize them by theme, assess their severity and frequency, and link each to direct supporting quotes. Output must be actionable, evidence-backed, and prioritized by potential business impact.
</Context>
<Instructions>
1. **Extract Key Pain Points**: Identify distinct customer frustrations or obstacles from the transcript.
2. **Group into Themes**: Cluster pain points into broader thematic categories (e.g., usability, pricing, communication, reliability).
3. **Quantify Occurrences**: Estimate frequency or emotional intensity based on repetition, tone, and emphasis.
4. **Provide Evidence**: Include representative verbatim quotes for each pain point.
5. **Prioritize Impact**: Rank by perceived business impact (High, Medium, Low) based on frequency and severity.
6. **Summarize Recommendations**: Suggest how each high-impact pain point could inform product improvements.
</Instructions>
<Constraints>
- Maintain objectivity and avoid subjective interpretation not grounded in user statements.
- Use concise, professional tone suitable for stakeholder reports.
- Limit each theme to a maximum of five representative quotes.
- Output must be structured and scannable for decision-makers.
</Constraints>
<Output Format>
{
"Themes": [
{
"Theme Name": "",
"Pain Points": [
{
"Description": "",
"Frequency Level": "High / Medium / Low",
"Impact Level": "High / Medium / Low",
"Representative Quotes": ["", ""],
"Suggested Product Actions": ""
}
]
}
],
"Summary Insights": {
"Total Themes Identified": "",
"Top 3 Pain Points by Impact": ["", "", ""],
"Strategic Recommendations": ""
}
}
</Output Format>
<Reasoning>
Apply advanced qualitative reasoning, emotional inference, and metacognitive synthesis. Consider intensity, repetition, and emotional language to determine pain severity. Cross-reference themes for hidden correlations. Maintain empathetic interpretation while preserving analytical rigor.
</Reasoning>
<User Input>
Please provide one or more customer interview transcripts or structured feedback notes. Include any relevant context such as target product, user segment, and research goals. Example: “We conducted 8 interviews with small business owners about invoicing software challenges.”
</User Input>
Few Examples of Prompt Use Cases:
- Product managers analyzing user research transcripts to guide roadmap priorities.
- UX researchers categorizing customer feedback into actionable insights.
- Founders identifying core frustrations in early user interviews.
- Customer success teams validating post-launch pain patterns.
- Market researchers synthesizing qualitative data for executive summaries.
User Input Examples for Testing:
“Transcripts from 6 users discussing frustrations with online checkout flow.”
“Interview notes from SaaS clients struggling with analytics dashboard usability.”
“Customer feedback on delivery experience and mobile app notifications.”
“Support call transcripts highlighting billing and payment issues.”
“Open-ended survey responses on why users switched to competitors.”
Why Use This Prompt?
Transforms unstructured qualitative data into actionable, prioritized insight. Enables faster decision-making, improves alignment between customer experience and product roadmap, and supports evidence-based prioritization for measurable impact.
How to Use This Prompt:
- Gather Data: Collect and clean interview transcripts or user notes.
- Provide Context: Include study goals and target audience.
- Run the Prompt: Paste transcripts into
<User Input>. - Review Output: Analyze extracted pain points and recommendations.
- Iterate: Update analysis as new interviews or data become available.
Who Can Use This Prompt?
- Product Managers: For prioritizing roadmap features.
- UX Researchers: For synthesizing usability findings.
- Startups/Founders: For identifying core market pain points.
- Customer Success Teams: For trend analysis in support feedback.
- Marketing Analysts: For understanding message-to-market fit gaps.
Disclaimer: This framework provides structured analytical interpretation of qualitative data. Users are responsible for ensuring data accuracy, ethical handling of personal information, and appropriate use of customer quotes for business purposes.
Explore Mega-Prompt Resources
-
Mega-Prompt Categories
— Browse all categories -
Persona Mega-Prompts
— Industry personas -
Healthcare Mega-Prompts
— Clinicians & admins -
Image Generation Prompts
— Art & visuals -
Content Creation Prompts
— Blogs, copy, scripts -
Marketing Prompts
— Growth & campaigns -
Prompts Tricks & Tips
— How-tos & guides