Review Mining Skill - The Gold Mine
This skill extracts real customer pain from reviews and testimonials - unfiltered, authentic, and actionable. Reviews are where customers complain about problems they'll pay to solve.
Key Distinction from software-ux-research:
software-ux-research = UI/UX pain points only
startup-review-mining (this skill) = ALL pain dimensions (pricing, support, integration, performance, onboarding, value gaps)
When to Use This Skill
Invoke when users ask for:
- Pain point extraction from reviews (any source)
- Competitive weakness analysis
- Feature gap identification
- Switching trigger analysis (why customers leave competitors)
- Market opportunity discovery through customer complaints
- Review sentiment analysis across platforms
- B2B software evaluation (G2, Capterra, TrustRadius)
- B2C app analysis (App Store, Play Store)
- Community sentiment (Reddit, HN, Twitter/X)
- Support pain patterns (forums, tickets, Stack Overflow)
Quick Reference Table
| Mining Task |
Source Category |
Template |
Output |
| Full Review Mining |
All sources |
review-mining-report.md |
Comprehensive pain analysis |
| B2B Software |
G2, Capterra, TrustRadius |
b2b-review-extraction.md |
Enterprise pain points |
| B2C Apps |
App Store, Play Store |
b2c-review-extraction.md |
Consumer pain points |
| Tech Communities |
Reddit, HN, ProductHunt |
community-sentiment.md |
Technical sentiment |
| Competitor Weakness |
Cross-platform |
competitor-weakness-matrix.md |
Competitive gaps |
| Switching Triggers |
All sources |
switching-trigger-analysis.md |
Why customers leave |
| Feature Requests |
All sources |
feature-request-aggregator.md |
Unmet needs |
| Opportunity Mapping |
All sources |
opportunity-from-reviews.md |
Actionable opportunities |
The 7 Pain Dimensions
Reviews reveal pain across 7 dimensions - not just UI/UX:
| Dimension |
What to Look For |
Example Signals |
| 1. UI/UX Pain |
Usability, navigation, design |
"confusing interface", "hard to find", "ugly design" |
| 2. Pricing Pain |
Cost, billing, contracts |
"too expensive", "hidden fees", "locked in contract" |
| 3. Support Pain |
Response time, resolution quality |
"slow support", "unhelpful", "no documentation" |
| 4. Integration Pain |
API complexity, data migration |
"can't connect to X", "migration nightmare", "no API" |
| 5. Performance Pain |
Speed, reliability, uptime |
"slow", "crashes", "downtime", "buggy" |
| 6. Onboarding Pain |
Setup complexity, time-to-value |
"took weeks to set up", "steep learning curve" |
| 7. Value Pain |
Feature gaps, unmet jobs |
"missing X feature", "can't do Y", "not what I needed" |
Decision Tree: Choosing Mining Approach
Review Mining Need: [What do you want to learn?]
|
+-- Finding pain points in a market?
| +-- B2B software? → G2 + Capterra + TrustRadius (resources/source-by-source-extraction.md#b2b)
| +-- Consumer app? → App Store + Play Store (resources/source-by-source-extraction.md#b2c)
| +-- Developer tool? → GitHub Issues + Stack Overflow + HN (resources/source-by-source-extraction.md#tech)
|
+-- Analyzing specific competitors?
| +-- Direct comparison? → Competitor Weakness Matrix (templates/competitor-weakness-matrix.md)
| +-- Why customers switch? → Switching Trigger Analysis (templates/switching-trigger-analysis.md)
| +-- Feature gaps? → Feature Request Aggregator (templates/feature-request-aggregator.md)
|
+-- Finding opportunities?
| +-- Quick wins (<2 weeks)? → Opportunity Template (templates/opportunity-from-reviews.md#quick-wins)
| +-- Medium bets (2-8 weeks)? → Opportunity Template (templates/opportunity-from-reviews.md#medium)
| +-- Big differentiation? → Opportunity Template (templates/opportunity-from-reviews.md#big-bets)
|
+-- Understanding sentiment?
| +-- Real-time complaints? → Twitter/X monitoring (resources/source-by-source-extraction.md#social)
| +-- Community opinion? → Reddit + HN (resources/source-by-source-extraction.md#community)
| +-- Launch feedback? → ProductHunt (resources/source-by-source-extraction.md#producthunt)
|
+-- Comprehensive analysis?
+-- Full market research? → Review Mining Report (templates/review-mining-report.md)
Review Sources (Complete Guide)
Tier 1: Very High Signal (Start Here)
| Source |
Type |
Best For |
How to Access |
| G2 |
B2B Reviews |
Enterprise software pain |
g2.com/products/[name]/reviews |
| TrustRadius |
B2B Reviews |
In-depth technical reviews |
trustradius.com/products/[name]/reviews |
| App Store |
B2C Reviews |
iOS app pain |
apps.apple.com + AppFollow/Appbot |
| Play Store |
B2C Reviews |
Android app pain |
play.google.com + AppFollow/Appbot |
| GitHub Issues |
Developer |
Bug patterns, feature requests |
github.com/[org]/[repo]/issues |
| Hacker News |
Tech Community |
Technical critiques, scalability |
news.ycombinator.com + Algolia search |
| Reddit |
Community |
Raw unfiltered opinions |
reddit.com/r/[subreddit] |
Tier 2: High Signal
| Source |
Type |
Best For |
How to Access |
| Capterra |
B2B Reviews |
SMB software comparisons |
capterra.com/p/[id]/[name]/reviews |
| ProductHunt |
Launch Feedback |
First impressions, early adopters |
producthunt.com/products/[name] |
| Stack Overflow |
Developer |
Integration difficulties |
stackoverflow.com/questions/tagged/[tag] |
| Gartner Peer Insights |
Enterprise |
Enterprise pain, vendor comparisons |
gartner.com/reviews/market/[market] |
| Twitter/X |
Social |
Real-time complaints |
twitter.com/search?q=[product] |
Tier 3: Medium Signal
| Source |
Type |
Best For |
How to Access |
| Software Advice |
B2B |
SMB-focused reviews |
softwareadvice.com/[category] |
| LinkedIn |
Professional |
B2B complaints, professional sentiment |
linkedin.com/feed |
| Quora |
Q&A |
Questions = unmet needs |
quora.com/topic/[topic] |
| YouTube Comments |
Tutorial |
Confusion points, documentation gaps |
youtube.com/watch?v=[id] |
| Public Support Forums |
Support |
Recurring issues, workarounds |
[product].community.com |
Navigation: Resources
Extraction Methodology
- resources/source-by-source-extraction.md - Platform-specific extraction guides for each source with search queries, filters, and export methods
Analysis Frameworks
- resources/pain-categorization-framework.md - 7-dimension pain taxonomy with severity scoring and prioritization
- resources/sentiment-analysis-patterns.md - Identifying pain vs praise, detecting intensity, and spotting trends
Competitive Intelligence
- resources/competitor-review-comparison.md - Cross-competitor analysis methodology with switching trigger identification
Opportunity Mapping
- resources/review-to-opportunity-mapping.md - Converting pain points to actionable product opportunities with ROI estimation
External References
- data/sources.json - Review platform URLs, API endpoints, and tool recommendations
Navigation: Templates
Full Reports
- templates/review-mining-report.md - Comprehensive mining report with all dimensions
Source-Specific Extraction
- templates/b2b-review-extraction.md - B2B software review extraction (G2, Capterra, TrustRadius)
- templates/b2c-review-extraction.md - Consumer app review extraction (App Store, Play Store)
- templates/community-sentiment.md - Community sentiment analysis (Reddit, HN, ProductHunt)
Competitive Analysis
- templates/competitor-weakness-matrix.md - Cross-competitor weakness comparison
- templates/switching-trigger-analysis.md - Why customers leave competitors
- templates/feature-request-aggregator.md - Unmet needs collection
Pain Analysis
- templates/pain-point-extraction-worksheet.md - Structured worksheet for 7-dimension pain extraction
Opportunity Output
- templates/opportunity-from-reviews.md - Pain → Opportunity conversion
Related Skills
Operational Workflow
Standard Mining Flow
1. SCOPE (Define Target)
+-- Which product/market to analyze?
+-- Which competitors to include?
+-- Time range (last 6-12 months recommended)
2. EXTRACT (Gather Data)
+-- B2B: G2 → Capterra → TrustRadius
+-- B2C: App Store → Play Store
+-- Tech: GitHub → HN → Stack Overflow
+-- Social: Twitter/X → Reddit → LinkedIn
3. CATEGORIZE (7 Dimensions)
+-- UI/UX Pain
+-- Pricing Pain
+-- Support Pain
+-- Integration Pain
+-- Performance Pain
+-- Onboarding Pain
+-- Value Pain
4. SCORE (Prioritize)
+-- Frequency (how often mentioned)
+-- Severity (how painful)
+-- Addressability (can we solve it?)
5. MAP (Convert to Opportunities)
+-- Quick Wins (<2 weeks)
+-- Medium Bets (2-8 weeks)
+-- Big Differentiation (8+ weeks)
6. OUTPUT (Deliverable)
+-- Review Mining Report
+-- Competitor Weakness Matrix
+-- Opportunity Backlog
Integration with Validation Pipeline
USER ASKS SKILL FLOW
──────────────────────────────────────────────────────────────
"Find opportunities in X market" → startup-review-mining → Pain Report
↓
"What's trending?" → startup-trend-prediction → Timing Analysis
↓
"Should we build this?" → startup-idea-validation → GO/NO-GO Score
↓
"What skills do we need?" → startup-mega-router → Implementation Path
Usage Notes
For Claude: When user asks to "find pain points" or "analyze reviews":
- Ask which market/product/competitors to analyze
- Use source-by-source-extraction.md for platform-specific queries
- Categorize findings into 7 pain dimensions
- Score by frequency × severity × addressability
- Output using review-mining-report.md template
For Claude: When user asks to "find opportunities":
- First extract pain points (above workflow)
- Use review-to-opportunity-mapping.md to convert
- Categorize into Quick Wins / Medium Bets / Big Differentiation
- Feed to startup-idea-validation for scoring
Output Formats:
- Pain points: 7-dimension matrix with severity scores
- Competitor analysis: Weakness comparison with quote evidence
- Opportunities: Prioritized backlog with effort/impact estimates
- Switching triggers: Why customers leave (ranked by frequency)
Key Principle: Reviews are the voice of the customer. Mine them systematically.
1---2name: startup-review-mining-33description: THE GOLD MINE: Systematic extraction of pain points, feature gaps, switching triggers, and opportunities from ALL review sources (G2, Capterra, TrustRadius, App Store, Play Store, Reddit, Hacker News, Twitter/X, ProductHunt, GitHub Issues, support forums). Goes beyond UI/UX to cover pricing friction, support failures, integration nightmares, and value gaps.4---5
6# Review Mining Skill - The Gold Mine
7
8This skill extracts **real customer pain** from reviews and testimonials - unfiltered, authentic, and actionable. Reviews are where customers complain about problems they'll pay to solve.
9
10**Key Distinction from `software-ux-research`**:
11- `software-ux-research` = UI/UX pain points only
12- `startup-review-mining` (this skill) = ALL pain dimensions (pricing, support, integration, performance, onboarding, value gaps)
13
14---
15
16## When to Use This Skill
17
18Invoke when users ask for:
19
20- Pain point extraction from reviews (any source)
21- Competitive weakness analysis
22- Feature gap identification
23- Switching trigger analysis (why customers leave competitors)
24- Market opportunity discovery through customer complaints
25- Review sentiment analysis across platforms
26- B2B software evaluation (G2, Capterra, TrustRadius)
27- B2C app analysis (App Store, Play Store)
28- Community sentiment (Reddit, HN, Twitter/X)
29- Support pain patterns (forums, tickets, Stack Overflow)
30
31---
32
33## Quick Reference Table
34
35| Mining Task | Source Category | Template | Output |
36|-------------|-----------------|----------|--------|
37| **Full Review Mining** | All sources | [review-mining-report.md](templates/review-mining-report.md) | Comprehensive pain analysis |
38| **B2B Software** | G2, Capterra, TrustRadius | [b2b-review-extraction.md](templates/b2b-review-extraction.md) | Enterprise pain points |
39| **B2C Apps** | App Store, Play Store | [b2c-review-extraction.md](templates/b2c-review-extraction.md) | Consumer pain points |
40| **Tech Communities** | Reddit, HN, ProductHunt | [community-sentiment.md](templates/community-sentiment.md) | Technical sentiment |
41| **Competitor Weakness** | Cross-platform | [competitor-weakness-matrix.md](templates/competitor-weakness-matrix.md) | Competitive gaps |
42| **Switching Triggers** | All sources | [switching-trigger-analysis.md](templates/switching-trigger-analysis.md) | Why customers leave |
43| **Feature Requests** | All sources | [feature-request-aggregator.md](templates/feature-request-aggregator.md) | Unmet needs |
44| **Opportunity Mapping** | All sources | [opportunity-from-reviews.md](templates/opportunity-from-reviews.md) | Actionable opportunities |
45
46---
47
48## The 7 Pain Dimensions
49
50Reviews reveal pain across **7 dimensions** - not just UI/UX:
51
52| Dimension | What to Look For | Example Signals |
53|-----------|------------------|-----------------|
54| **1. UI/UX Pain** | Usability, navigation, design | "confusing interface", "hard to find", "ugly design" |
55| **2. Pricing Pain** | Cost, billing, contracts | "too expensive", "hidden fees", "locked in contract" |
56| **3. Support Pain** | Response time, resolution quality | "slow support", "unhelpful", "no documentation" |
57| **4. Integration Pain** | API complexity, data migration | "can't connect to X", "migration nightmare", "no API" |
58| **5. Performance Pain** | Speed, reliability, uptime | "slow", "crashes", "downtime", "buggy" |
59| **6. Onboarding Pain** | Setup complexity, time-to-value | "took weeks to set up", "steep learning curve" |
60| **7. Value Pain** | Feature gaps, unmet jobs | "missing X feature", "can't do Y", "not what I needed" |
61
62---
63
64## Decision Tree: Choosing Mining Approach
65
66```text
67Review Mining Need: [What do you want to learn?]
68 |
69 +-- Finding pain points in a market?
70 | +-- B2B software? → G2 + Capterra + TrustRadius (resources/source-by-source-extraction.md#b2b)
71 | +-- Consumer app? → App Store + Play Store (resources/source-by-source-extraction.md#b2c)
72 | +-- Developer tool? → GitHub Issues + Stack Overflow + HN (resources/source-by-source-extraction.md#tech)
73 |
74 +-- Analyzing specific competitors?
75 | +-- Direct comparison? → Competitor Weakness Matrix (templates/competitor-weakness-matrix.md)
76 | +-- Why customers switch? → Switching Trigger Analysis (templates/switching-trigger-analysis.md)
77 | +-- Feature gaps? → Feature Request Aggregator (templates/feature-request-aggregator.md)
78 |
79 +-- Finding opportunities?
80 | +-- Quick wins (<2 weeks)? → Opportunity Template (templates/opportunity-from-reviews.md#quick-wins)
81 | +-- Medium bets (2-8 weeks)? → Opportunity Template (templates/opportunity-from-reviews.md#medium)
82 | +-- Big differentiation? → Opportunity Template (templates/opportunity-from-reviews.md#big-bets)
83 |
84 +-- Understanding sentiment?
85 | +-- Real-time complaints? → Twitter/X monitoring (resources/source-by-source-extraction.md#social)
86 | +-- Community opinion? → Reddit + HN (resources/source-by-source-extraction.md#community)
87 | +-- Launch feedback? → ProductHunt (resources/source-by-source-extraction.md#producthunt)
88 |
89 +-- Comprehensive analysis?
90 +-- Full market research? → Review Mining Report (templates/review-mining-report.md)
91```
92
93---
94
95## Review Sources (Complete Guide)
96
97### Tier 1: Very High Signal (Start Here)
98
99| Source | Type | Best For | How to Access |
100|--------|------|----------|---------------|
101| **G2** | B2B Reviews | Enterprise software pain | g2.com/products/[name]/reviews |
102| **TrustRadius** | B2B Reviews | In-depth technical reviews | trustradius.com/products/[name]/reviews |
103| **App Store** | B2C Reviews | iOS app pain | apps.apple.com + AppFollow/Appbot |
104| **Play Store** | B2C Reviews | Android app pain | play.google.com + AppFollow/Appbot |
105| **GitHub Issues** | Developer | Bug patterns, feature requests | github.com/[org]/[repo]/issues |
106| **Hacker News** | Tech Community | Technical critiques, scalability | news.ycombinator.com + Algolia search |
107| **Reddit** | Community | Raw unfiltered opinions | reddit.com/r/[subreddit] |
108
109### Tier 2: High Signal
110
111| Source | Type | Best For | How to Access |
112|--------|------|----------|---------------|
113| **Capterra** | B2B Reviews | SMB software comparisons | capterra.com/p/[id]/[name]/reviews |
114| **ProductHunt** | Launch Feedback | First impressions, early adopters | producthunt.com/products/[name] |
115| **Stack Overflow** | Developer | Integration difficulties | stackoverflow.com/questions/tagged/[tag] |
116| **Gartner Peer Insights** | Enterprise | Enterprise pain, vendor comparisons | gartner.com/reviews/market/[market] |
117| **Twitter/X** | Social | Real-time complaints | twitter.com/search?q=[product] |
118
119### Tier 3: Medium Signal
120
121| Source | Type | Best For | How to Access |
122|--------|------|----------|---------------|
123| **Software Advice** | B2B | SMB-focused reviews | softwareadvice.com/[category] |
124| **LinkedIn** | Professional | B2B complaints, professional sentiment | linkedin.com/feed |
125| **Quora** | Q&A | Questions = unmet needs | quora.com/topic/[topic] |
126| **YouTube Comments** | Tutorial | Confusion points, documentation gaps | youtube.com/watch?v=[id] |
127| **Public Support Forums** | Support | Recurring issues, workarounds | [product].community.com |
128
129---
130
131## Navigation: Resources
132
133### Extraction Methodology
134- [resources/source-by-source-extraction.md](resources/source-by-source-extraction.md) - Platform-specific extraction guides for each source with search queries, filters, and export methods
135
136### Analysis Frameworks
137- [resources/pain-categorization-framework.md](resources/pain-categorization-framework.md) - 7-dimension pain taxonomy with severity scoring and prioritization
138- [resources/sentiment-analysis-patterns.md](resources/sentiment-analysis-patterns.md) - Identifying pain vs praise, detecting intensity, and spotting trends
139
140### Competitive Intelligence
141- [resources/competitor-review-comparison.md](resources/competitor-review-comparison.md) - Cross-competitor analysis methodology with switching trigger identification
142
143### Opportunity Mapping
144- [resources/review-to-opportunity-mapping.md](resources/review-to-opportunity-mapping.md) - Converting pain points to actionable product opportunities with ROI estimation
145
146### External References
147- [data/sources.json](data/sources.json) - Review platform URLs, API endpoints, and tool recommendations
148
149---
150
151## Navigation: Templates
152
153### Full Reports
154- [templates/review-mining-report.md](templates/review-mining-report.md) - Comprehensive mining report with all dimensions
155
156### Source-Specific Extraction
157- [templates/b2b-review-extraction.md](templates/b2b-review-extraction.md) - B2B software review extraction (G2, Capterra, TrustRadius)
158- [templates/b2c-review-extraction.md](templates/b2c-review-extraction.md) - Consumer app review extraction (App Store, Play Store)
159- [templates/community-sentiment.md](templates/community-sentiment.md) - Community sentiment analysis (Reddit, HN, ProductHunt)
160
161### Competitive Analysis
162- [templates/competitor-weakness-matrix.md](templates/competitor-weakness-matrix.md) - Cross-competitor weakness comparison
163- [templates/switching-trigger-analysis.md](templates/switching-trigger-analysis.md) - Why customers leave competitors
164- [templates/feature-request-aggregator.md](templates/feature-request-aggregator.md) - Unmet needs collection
165
166### Pain Analysis
167- [templates/pain-point-extraction-worksheet.md](templates/pain-point-extraction-worksheet.md) - Structured worksheet for 7-dimension pain extraction
168
169### Opportunity Output
170- [templates/opportunity-from-reviews.md](templates/opportunity-from-reviews.md) - Pain → Opportunity conversion
171
172---
173
174## Related Skills
175
176- [../software-ux-research/SKILL.md](../software-ux-research/SKILL.md) - **UI/UX Sibling**: UI/UX-specific research (this skill goes broader)
177- [../startup-idea-validation/SKILL.md](../startup-idea-validation/SKILL.md) - **Consumer**: Uses review mining data for validation scoring
178- [../startup-trend-prediction/SKILL.md](../startup-trend-prediction/SKILL.md) - **Parallel**: Combines with trend data for timing
179- [../startup-mega-router/SKILL.md](../startup-mega-router/SKILL.md) - **Orchestrator**: Routes to this skill for pain discovery
180- [../product-management/SKILL.md](../product-management/SKILL.md) - **Consumer**: Uses pain points for discovery and roadmapping
181
182---
183
184## Operational Workflow
185
186### Standard Mining Flow
187
188```text
1891. SCOPE (Define Target)
190 +-- Which product/market to analyze?
191 +-- Which competitors to include?
192 +-- Time range (last 6-12 months recommended)
193
1942. EXTRACT (Gather Data)
195 +-- B2B: G2 → Capterra → TrustRadius
196 +-- B2C: App Store → Play Store
197 +-- Tech: GitHub → HN → Stack Overflow
198 +-- Social: Twitter/X → Reddit → LinkedIn
199
2003. CATEGORIZE (7 Dimensions)
201 +-- UI/UX Pain
202 +-- Pricing Pain
203 +-- Support Pain
204 +-- Integration Pain
205 +-- Performance Pain
206 +-- Onboarding Pain
207 +-- Value Pain
208
2094. SCORE (Prioritize)
210 +-- Frequency (how often mentioned)
211 +-- Severity (how painful)
212 +-- Addressability (can we solve it?)
213
2145. MAP (Convert to Opportunities)
215 +-- Quick Wins (<2 weeks)
216 +-- Medium Bets (2-8 weeks)
217 +-- Big Differentiation (8+ weeks)
218
2196. OUTPUT (Deliverable)
220 +-- Review Mining Report
221 +-- Competitor Weakness Matrix
222 +-- Opportunity Backlog
223```
224
225### Integration with Validation Pipeline
226
227```text
228USER ASKS SKILL FLOW
229──────────────────────────────────────────────────────────────
230"Find opportunities in X market" → startup-review-mining → Pain Report
231 ↓
232"What's trending?" → startup-trend-prediction → Timing Analysis
233 ↓
234"Should we build this?" → startup-idea-validation → GO/NO-GO Score
235 ↓
236"What skills do we need?" → startup-mega-router → Implementation Path
237```
238
239---
240
241## Usage Notes
242
243**For Claude**: When user asks to "find pain points" or "analyze reviews":
2441. Ask which market/product/competitors to analyze
2452. Use source-by-source-extraction.md for platform-specific queries
2463. Categorize findings into 7 pain dimensions
2474. Score by frequency × severity × addressability
2485. Output using review-mining-report.md template
249
250**For Claude**: When user asks to "find opportunities":
2511. First extract pain points (above workflow)
2522. Use review-to-opportunity-mapping.md to convert
2533. Categorize into Quick Wins / Medium Bets / Big Differentiation
2544. Feed to startup-idea-validation for scoring
255
256**Output Formats**:
257- Pain points: 7-dimension matrix with severity scores
258- Competitor analysis: Weakness comparison with quote evidence
259- Opportunities: Prioritized backlog with effort/impact estimates
260- Switching triggers: Why customers leave (ranked by frequency)
261
262**Key Principle**: Reviews are the voice of the customer. Mine them systematically.