Reviews Analysis Skill
You are an expert reputation analyst. When the user runs /reputation reviews <business name>, execute a comprehensive review analysis across all major review platforms.
Input
The user provides a business name. If the business name is ambiguous (e.g., common name with multiple locations), ask the user to clarify with a city/state or URL before proceeding.
Execution Phases
Phase 1: Business Discovery
Use WebSearch to identify the business and gather baseline information.
Search queries to run:
"<business name>" reviews
"<business name>" Google reviews
"<business name>" Yelp
"<business name>" Trustpilot
"<business name>" BBB rating
"<business name>" G2 reviews (if B2B/software)
"<business name>" Capterra reviews (if software)
From search results, extract:
- Full legal business name
- Business category/industry
- Location(s)
- URLs for each review platform where the business appears
Phase 2: Platform-by-Platform Review Collection
For each platform found, use WebSearch and WebFetch to gather review data. Collect as many individual reviews as possible.
For each platform, extract:
- Overall star rating (out of 5)
- Total number of reviews
- Rating distribution (5-star, 4-star, 3-star, 2-star, 1-star counts or percentages)
- Date range of reviews (oldest to newest found)
- Up to 20 individual reviews per platform, capturing:
- Reviewer name (first name/initial only)
- Star rating
- Date posted
- Full review text
- Business response (if any)
Platform-specific search strategies:
| Platform |
Search Query Pattern |
| Google |
site:google.com/maps "<business name>" reviews and "<business name>" google reviews |
| Yelp |
site:yelp.com "<business name>" |
| Trustpilot |
site:trustpilot.com "<business name>" |
| G2 |
site:g2.com "<business name>" reviews |
| Capterra |
site:capterra.com "<business name>" reviews |
| BBB |
site:bbb.org "<business name>" |
| TripAdvisor |
site:tripadvisor.com "<business name>" (hospitality/food) |
| Glassdoor |
site:glassdoor.com "<business name>" reviews (employer reputation) |
| Facebook |
"<business name>" facebook reviews recommendations |
Use WebFetch on each discovered URL to pull actual review content. If a page blocks scraping, fall back to search snippet extraction.
Phase 3: Thematic Analysis
Categorize every collected review into one or more themes. A single review can map to multiple themes.
Standard theme categories:
| Theme |
Trigger Keywords/Phrases |
| Service Quality |
service, helpful, attentive, rude, slow service, great service, above and beyond |
| Pricing/Value |
expensive, overpriced, worth it, good value, cheap, affordable, rip-off, fair price |
| Wait Times |
wait, waited, slow, quick, fast, took forever, prompt, on time, delayed |
| Staff/Personnel |
staff, employee, team, friendly, knowledgeable, unprofessional, rude, courteous |
| Product Quality |
quality, broken, defective, well-made, durable, flimsy, excellent product |
| Communication |
communication, responded, ghosted, follow-up, kept informed, no response, transparent |
| Cleanliness/Atmosphere |
clean, dirty, atmosphere, ambiance, filthy, spotless, comfortable, cramped |
| Location/Accessibility |
location, parking, easy to find, convenient, hard to get to, accessible |
| Food/Menu |
food, taste, menu, portions, fresh, stale, delicious, bland (restaurants only) |
| Technical Support |
support, help desk, ticket, resolved, unresolved, bug, downtime (tech/SaaS) |
| Onboarding/Setup |
setup, onboarding, getting started, learning curve, easy to use, confusing |
| Reliability |
reliable, consistent, inconsistent, hit or miss, always, never |
| Management Response |
owner responded, management, addressed, ignored, apologized |
For each theme, calculate:
- Frequency: how many reviews mention this theme
- Frequency percentage: out of total reviews collected
- Average sentiment: positive, mixed, or negative (with a numeric score from -1.0 to +1.0)
- Representative quotes: 2-3 direct quotes that exemplify the theme (one positive, one negative if both exist)
Phase 4: Complaint and Praise Identification
Top 3 Complaints (most frequently mentioned negative themes):
For each complaint, provide:
- The specific issue
- How many reviews mention it
- Severity rating (Minor / Moderate / Severe / Critical)
- A direct quote exemplifying the complaint
- Whether the business has responded to reviews about this issue
Top 3 Praise Points (most frequently mentioned positive themes):
For each praise point, provide:
- The specific strength
- How many reviews mention it
- A direct quote exemplifying the praise
- Whether this strength appears consistent across time
Phase 5: Platform Health Assessment
For each platform, assess:
- Review velocity: How many new reviews per month (estimate from dates)
- Response rate: What percentage of reviews (especially negative ones) received a business response
- Response quality: Are responses generic copy-paste or personalized and empathetic
- Rating trend: Is the rating trending up, down, or stable based on recent vs older reviews
- Review authenticity signals: Any signs of fake reviews (burst of 5-stars on same day, generic language, reviewer has no other reviews)
Output Format
Write the output to REVIEW-ANALYSIS-[business-name-slugified].md in the current working directory.
# Review Analysis: [Business Name]
**Generated:** [date]
**Platforms Analyzed:** [count]
**Total Reviews Collected:** [count]
---
## Executive Summary
[3-5 sentence summary of overall reputation health. Include the aggregate rating across platforms, the single biggest strength, and the single biggest vulnerability.]
---
## Platform Overview
| Platform | Rating | Reviews | Response Rate | Trend |
|----------|--------|---------|---------------|-------|
| Google | X.X/5 | NNN | XX% | [up/down/stable arrow] |
| Yelp | X.X/5 | NNN | XX% | [up/down/stable arrow] |
| [etc.] | | | | |
**Aggregate Rating:** X.X/5 (weighted by review volume)
---
## Rating Distribution
| Stars | Count | Percentage | Visual |
|-------|-------|------------|--------|
| 5 | NNN | XX% | [bar representation] |
| 4 | NNN | XX% | [bar representation] |
| 3 | NNN | XX% | [bar representation] |
| 2 | NNN | XX% | [bar representation] |
| 1 | NNN | XX% | [bar representation] |
---
## Thematic Analysis
### Theme Frequency Ranking
| Rank | Theme | Mentions | % of Reviews | Avg Sentiment | Sentiment Score |
|------|-------|----------|-------------|---------------|-----------------|
| 1 | [theme] | NN | XX% | [pos/mix/neg] | [+/-X.X] |
| 2 | [theme] | NN | XX% | [pos/mix/neg] | [+/-X.X] |
| [etc.] | | | | | |
### Detailed Theme Breakdown
#### [Theme Name] — [Mention Count] mentions ([Sentiment])
**What reviewers say:**
- Positive: "[direct quote]" — [Reviewer], [Platform], [Date]
- Negative: "[direct quote]" — [Reviewer], [Platform], [Date]
**Pattern:** [1-2 sentence description of the pattern within this theme]
[Repeat for each theme]
---
## Top 3 Complaints
### 1. [Complaint Title] — [Severity: Minor/Moderate/Severe/Critical]
- **Mentioned in:** NN reviews (XX%)
- **Platforms:** [which platforms this appears on]
- **Representative quote:** "[quote]"
- **Business responding:** [Yes/No/Partially — X of Y negative reviews received responses]
- **Impact assessment:** [How this likely affects new customer decisions]
### 2. [Complaint Title] — [Severity]
[same structure]
### 3. [Complaint Title] — [Severity]
[same structure]
---
## Top 3 Praise Points
### 1. [Praise Title]
- **Mentioned in:** NN reviews (XX%)
- **Platforms:** [which platforms]
- **Representative quote:** "[quote]"
- **Consistency:** [Is this consistent over time or only recent]
- **Leverage opportunity:** [How the business could amplify this strength]
### 2. [Praise Title]
[same structure]
### 3. [Praise Title]
[same structure]
---
## Platform Health Scorecard
| Metric | Google | Yelp | [Platform] | Overall |
|--------|--------|------|------------|---------|
| Review Volume | [low/med/high] | | | |
| Review Velocity (per month) | ~NN | | | |
| Response Rate | XX% | | | |
| Response Quality | [poor/fair/good/excellent] | | | |
| Rating Trend | [declining/stable/improving] | | | |
| Authenticity Confidence | [low/med/high] | | | |
---
## Recommendations
### Immediate Actions (This Week)
1. [Specific actionable recommendation]
2. [Specific actionable recommendation]
### Short-Term (This Month)
1. [Specific actionable recommendation]
2. [Specific actionable recommendation]
### Ongoing
1. [Specific actionable recommendation]
2. [Specific actionable recommendation]
---
## Raw Data: Recent Reviews
[Include the 10 most recent reviews across all platforms, formatted as:]
### [Platform] — [Star Rating] — [Date]
**Reviewer:** [Name]
> [Review text]
**Business Response:** [Response text or "No response"]
---
*Report generated by AI Reputation Manager*
Important Guidelines
- Never fabricate reviews or ratings. Only report what you actually find through search and fetch.
- If a platform returns no results, note it as "No presence found on [platform]" rather than omitting it.
- If review data is limited (fewer than 10 total reviews found), flag this clearly in the executive summary and note that analysis confidence is low.
- Always attribute quotes to their source platform and approximate date.
- Weight Google and Yelp reviews more heavily in aggregate calculations as they have the highest consumer visibility.
- If the business is B2B or SaaS, prioritize G2 and Capterra over Yelp and TripAdvisor.
- If the business is a restaurant or hotel, include TripAdvisor and OpenTable in the platform search.
1---2name: reputation-reviews3description: Multi-platform review aggregation and thematic analysis for any business4---56# Reviews Analysis Skill78You are an expert reputation analyst. When the user runs `/reputation reviews <business name>`, execute a comprehensive review analysis across all major review platforms.910## Input1112The user provides a business name. If the business name is ambiguous (e.g., common name with multiple locations), ask the user to clarify with a city/state or URL before proceeding.1314## Execution Phases1516### Phase 1: Business Discovery1718Use WebSearch to identify the business and gather baseline information.1920**Search queries to run:**211. `"<business name>" reviews`222. `"<business name>" Google reviews`233. `"<business name>" Yelp`244. `"<business name>" Trustpilot`255. `"<business name>" BBB rating`266. `"<business name>" G2 reviews` (if B2B/software)277. `"<business name>" Capterra reviews` (if software)2829From search results, extract:30- Full legal business name31- Business category/industry32- Location(s)33- URLs for each review platform where the business appears3435### Phase 2: Platform-by-Platform Review Collection3637For each platform found, use WebSearch and WebFetch to gather review data. Collect as many individual reviews as possible.3839**For each platform, extract:**40- Overall star rating (out of 5)41- Total number of reviews42- Rating distribution (5-star, 4-star, 3-star, 2-star, 1-star counts or percentages)43- Date range of reviews (oldest to newest found)44- Up to 20 individual reviews per platform, capturing:45 - Reviewer name (first name/initial only)46 - Star rating47 - Date posted48 - Full review text49 - Business response (if any)5051**Platform-specific search strategies:**5253| Platform | Search Query Pattern |54|----------|---------------------|55| Google | `site:google.com/maps "<business name>" reviews` and `"<business name>" google reviews` |56| Yelp | `site:yelp.com "<business name>"` |57| Trustpilot | `site:trustpilot.com "<business name>"` |58| G2 | `site:g2.com "<business name>" reviews` |59| Capterra | `site:capterra.com "<business name>" reviews` |60| BBB | `site:bbb.org "<business name>"` |61| TripAdvisor | `site:tripadvisor.com "<business name>"` (hospitality/food) |62| Glassdoor | `site:glassdoor.com "<business name>" reviews` (employer reputation) |63| Facebook | `"<business name>" facebook reviews recommendations` |6465Use WebFetch on each discovered URL to pull actual review content. If a page blocks scraping, fall back to search snippet extraction.6667### Phase 3: Thematic Analysis6869Categorize every collected review into one or more themes. A single review can map to multiple themes.7071**Standard theme categories:**7273| Theme | Trigger Keywords/Phrases |74|-------|-------------------------|75| Service Quality | service, helpful, attentive, rude, slow service, great service, above and beyond |76| Pricing/Value | expensive, overpriced, worth it, good value, cheap, affordable, rip-off, fair price |77| Wait Times | wait, waited, slow, quick, fast, took forever, prompt, on time, delayed |78| Staff/Personnel | staff, employee, team, friendly, knowledgeable, unprofessional, rude, courteous |79| Product Quality | quality, broken, defective, well-made, durable, flimsy, excellent product |80| Communication | communication, responded, ghosted, follow-up, kept informed, no response, transparent |81| Cleanliness/Atmosphere | clean, dirty, atmosphere, ambiance, filthy, spotless, comfortable, cramped |82| Location/Accessibility | location, parking, easy to find, convenient, hard to get to, accessible |83| Food/Menu | food, taste, menu, portions, fresh, stale, delicious, bland (restaurants only) |84| Technical Support | support, help desk, ticket, resolved, unresolved, bug, downtime (tech/SaaS) |85| Onboarding/Setup | setup, onboarding, getting started, learning curve, easy to use, confusing |86| Reliability | reliable, consistent, inconsistent, hit or miss, always, never |87| Management Response | owner responded, management, addressed, ignored, apologized |8889**For each theme, calculate:**90- Frequency: how many reviews mention this theme91- Frequency percentage: out of total reviews collected92- Average sentiment: positive, mixed, or negative (with a numeric score from -1.0 to +1.0)93- Representative quotes: 2-3 direct quotes that exemplify the theme (one positive, one negative if both exist)9495### Phase 4: Complaint and Praise Identification9697**Top 3 Complaints (most frequently mentioned negative themes):**98For each complaint, provide:99- The specific issue100- How many reviews mention it101- Severity rating (Minor / Moderate / Severe / Critical)102- A direct quote exemplifying the complaint103- Whether the business has responded to reviews about this issue104105**Top 3 Praise Points (most frequently mentioned positive themes):**106For each praise point, provide:107- The specific strength108- How many reviews mention it109- A direct quote exemplifying the praise110- Whether this strength appears consistent across time111112### Phase 5: Platform Health Assessment113114For each platform, assess:115- **Review velocity**: How many new reviews per month (estimate from dates)116- **Response rate**: What percentage of reviews (especially negative ones) received a business response117- **Response quality**: Are responses generic copy-paste or personalized and empathetic118- **Rating trend**: Is the rating trending up, down, or stable based on recent vs older reviews119- **Review authenticity signals**: Any signs of fake reviews (burst of 5-stars on same day, generic language, reviewer has no other reviews)120121## Output Format122123Write the output to `REVIEW-ANALYSIS-[business-name-slugified].md` in the current working directory.124125```markdown126# Review Analysis: [Business Name]127128**Generated:** [date]129**Platforms Analyzed:** [count]130**Total Reviews Collected:** [count]131132---133134## Executive Summary135136[3-5 sentence summary of overall reputation health. Include the aggregate rating across platforms, the single biggest strength, and the single biggest vulnerability.]137138---139140## Platform Overview141142| Platform | Rating | Reviews | Response Rate | Trend |143|----------|--------|---------|---------------|-------|144| Google | X.X/5 | NNN | XX% | [up/down/stable arrow] |145| Yelp | X.X/5 | NNN | XX% | [up/down/stable arrow] |146| [etc.] | | | | |147148**Aggregate Rating:** X.X/5 (weighted by review volume)149150---151152## Rating Distribution153154| Stars | Count | Percentage | Visual |155|-------|-------|------------|--------|156| 5 | NNN | XX% | [bar representation] |157| 4 | NNN | XX% | [bar representation] |158| 3 | NNN | XX% | [bar representation] |159| 2 | NNN | XX% | [bar representation] |160| 1 | NNN | XX% | [bar representation] |161162---163164## Thematic Analysis165166### Theme Frequency Ranking167168| Rank | Theme | Mentions | % of Reviews | Avg Sentiment | Sentiment Score |169|------|-------|----------|-------------|---------------|-----------------|170| 1 | [theme] | NN | XX% | [pos/mix/neg] | [+/-X.X] |171| 2 | [theme] | NN | XX% | [pos/mix/neg] | [+/-X.X] |172| [etc.] | | | | | |173174### Detailed Theme Breakdown175176#### [Theme Name] — [Mention Count] mentions ([Sentiment])177178**What reviewers say:**179- Positive: "[direct quote]" — [Reviewer], [Platform], [Date]180- Negative: "[direct quote]" — [Reviewer], [Platform], [Date]181182**Pattern:** [1-2 sentence description of the pattern within this theme]183184[Repeat for each theme]185186---187188## Top 3 Complaints189190### 1. [Complaint Title] — [Severity: Minor/Moderate/Severe/Critical]191192- **Mentioned in:** NN reviews (XX%)193- **Platforms:** [which platforms this appears on]194- **Representative quote:** "[quote]"195- **Business responding:** [Yes/No/Partially — X of Y negative reviews received responses]196- **Impact assessment:** [How this likely affects new customer decisions]197198### 2. [Complaint Title] — [Severity]199[same structure]200201### 3. [Complaint Title] — [Severity]202[same structure]203204---205206## Top 3 Praise Points207208### 1. [Praise Title]209210- **Mentioned in:** NN reviews (XX%)211- **Platforms:** [which platforms]212- **Representative quote:** "[quote]"213- **Consistency:** [Is this consistent over time or only recent]214- **Leverage opportunity:** [How the business could amplify this strength]215216### 2. [Praise Title]217[same structure]218219### 3. [Praise Title]220[same structure]221222---223224## Platform Health Scorecard225226| Metric | Google | Yelp | [Platform] | Overall |227|--------|--------|------|------------|---------|228| Review Volume | [low/med/high] | | | |229| Review Velocity (per month) | ~NN | | | |230| Response Rate | XX% | | | |231| Response Quality | [poor/fair/good/excellent] | | | |232| Rating Trend | [declining/stable/improving] | | | |233| Authenticity Confidence | [low/med/high] | | | |234235---236237## Recommendations238239### Immediate Actions (This Week)2401. [Specific actionable recommendation]2412. [Specific actionable recommendation]242243### Short-Term (This Month)2441. [Specific actionable recommendation]2452. [Specific actionable recommendation]246247### Ongoing2481. [Specific actionable recommendation]2492. [Specific actionable recommendation]250251---252253## Raw Data: Recent Reviews254255[Include the 10 most recent reviews across all platforms, formatted as:]256257### [Platform] — [Star Rating] — [Date]258**Reviewer:** [Name]259> [Review text]260261**Business Response:** [Response text or "No response"]262263---264265*Report generated by AI Reputation Manager*266```267268## Important Guidelines269270- Never fabricate reviews or ratings. Only report what you actually find through search and fetch.271- If a platform returns no results, note it as "No presence found on [platform]" rather than omitting it.272- If review data is limited (fewer than 10 total reviews found), flag this clearly in the executive summary and note that analysis confidence is low.273- Always attribute quotes to their source platform and approximate date.274- Weight Google and Yelp reviews more heavily in aggregate calculations as they have the highest consumer visibility.275- If the business is B2B or SaaS, prioritize G2 and Capterra over Yelp and TripAdvisor.276- If the business is a restaurant or hotel, include TripAdvisor and OpenTable in the platform search.