# Stakeholder Management Expert

> Use when summarizing stakeholder feedback from public meetings, open houses, or Indigenous consultations, categorizing themes and running sentiment analysis (support/opposition/neutral/mixed), generating prioritized response strategies, tracking commitments made during consultation, or preparing briefing notes on consultation outcomes.

- Skill: `reggiechan74/stakeholder-management-expert` (Agent Skill, multi-file: 19 files)
- Install (CLI): `npx skillmds@latest add reggiechan74/stakeholder-management-expert`
- Raw SKILL.md: https://api.skillmd.com/api/skills/reggiechan74/stakeholder-management-expert/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Product & Planning
- Author: reggiechan74 (https://skillmd.com/u/reggiechan74)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/reggiechan74/stakeholder-management-expert

---


## When to Use This Skill

Use this skill when you need to:

- **Summarize stakeholder feedback** from public meetings, open houses, or consultations
- **Analyze sentiment** (support, opposition, neutral, mixed) across comments
- **Categorize themes** and identify key concerns from unstructured feedback
- **Generate response strategies** for addressing stakeholder concerns
- **Track commitments** made during consultation processes
- **Prepare briefing notes** for senior management on consultation outcomes
- **Develop communication plans** for stakeholder engagement

## Key Capabilities

### 1. Feedback Analysis
- Theme categorization using keyword matching
- Frequency weighting to identify top concerns
- Sentiment analysis (support/opposition/neutral/mixed)
- Multi-category comment identification
- Question vs. statement classification

### 2. Strategic Response
- Response strategy generation by priority
- Tactical recommendations for each theme
- Commitment extraction and tracking
- Risk identification and mitigation

### 3. Reporting
- Executive summaries for decision-makers
- Detailed theme breakdowns with sample quotes
- Sentiment analysis visualization
- Commitments tracking matrix
- Response strategy recommendations

## Tools Available

### Consultation Summarizer (`consultation_summarizer.py`)

Analyzes stakeholder feedback and generates comprehensive summary with response strategy.

**Purpose:** Summarize public meeting feedback and develop response strategy

**Input:** JSON file with meeting info, comments, and theme categories

**Output:** Markdown or JSON report with:
1. Meeting attendance and demographics
2. Key themes and concerns (categorized, frequency-weighted)
3. Sentiment analysis (support, opposition, neutral)
4. Response strategy recommendations
5. Commitments tracking matrix

**Usage:**
```bash
# Basic usage (auto-generates output in Reports/)
python consultation_summarizer.py samples/sample_1_station_public_meeting.json

# Specify output file
python consultation_summarizer.py input.json --output report.md

# JSON output format
python consultation_summarizer.py input.json --format json --output results.json

# Verbose mode
python consultation_summarizer.py input.json --verbose
```

**Input Schema:** See `consultation_input_schema.json`

## Input Format

### Basic Structure
```json
{
  "meeting_info": {
    "meeting_date": "2025-10-15",
    "meeting_type": "public_meeting",
    "attendance": 85,
    "location": "Community Center, 123 Main Street",
    "project_name": "North Transit Station Project",
    "phase": "preliminary_design"
  },

  "comments": [
    "Concerned about traffic congestion during construction",
    "Property values will decline",
    "Support this project! We need better transit.",
    ...
  ],

  "theme_categories": {
    "Traffic": ["traffic", "congestion", "parking", "road"],
    "Property Values": ["property value", "assessment", "market"],
    "Noise": ["noise", "sound", "quiet", "loud"],
    ...
  },

  "priorities": {
    "Traffic": 1,
    "Property Values": 2,
    "Noise": 3
  }
}
```

### Theme Categories

Define categories and keyword patterns for classification:

```json
{
  "Traffic": ["traffic", "congestion", "parking", "road"],
  "Property Values": ["property value", "market", "taxes"],
  "Business Impact": ["business", "customer", "sales", "revenue"],
  "Safety": ["safety", "crime", "security", "emergency"],
  "Accessibility": ["access", "wheelchair", "bike", "pedestrian"],
  "Environmental": ["dust", "air quality", "pollution", "trees"],
  "Compensation": ["compensation", "damages", "payment"],
  "Communication": ["information", "notice", "update"]
}
```

### Priorities

Assign priority levels (1=highest, 5=lowest) for response strategy:

```json
{
  "Traffic": 1,
  "Construction Impact": 1,
  "Business Impact": 2,
  "Property Values": 2,
  "Noise": 3,
  "Accessibility": 3
}
```

### Optional Demographics
```json
{
  "demographics": {
    "residents": 52,
    "business_owners": 18,
    "property_owners": 10,
    "elected_officials": 2,
    "advocacy_groups": 3
  }
}
```

### Output Options
```json
{
  "output_options": {
    "include_quotes": true,
    "max_quotes_per_sentiment": 5,
    "include_commitments": true,
    "output_format": "markdown"
  }
}
```

## Output Format

### Markdown Report Structure

```markdown
# Stakeholder Consultation Summary

## North Transit Station Project

**Meeting Type:** Public Meeting
**Meeting Date:** 2025-10-15
**Location:** Community Center, 123 Main Street
**Project Phase:** Preliminary Design

## Attendance

**Total Attendance:** 85 people

### Demographic Breakdown
- Residents: 52 (61.2%)
- Business Owners: 18 (21.2%)
- Property Owners: 10 (11.8%)
...

## Overview Statistics

**Total Comments Received:** 85
**Categorized Comments:** 82 (96.5%)
**Themes Identified:** 10

### Sentiment Overview
**Overall Sentiment:** Moderate Opposition

- Support: 15
- Opposition: 42
- Neutral: 18
- Mixed: 10

## Key Themes and Concerns

| Rank | Theme | Comments | Percentage |
|------|-------|----------|------------|
| 1 | Traffic | 28 | 32.9% |
| 2 | Construction Impact | 22 | 25.9% |
| 3 | Business Impact | 15 | 17.6% |
...

### Top 3 Themes (Detailed)

#### Traffic (28 comments)
- "Very concerned about traffic congestion during construction..."
- "Traffic on Oak Avenue is already terrible..."
- "Traffic study is incomplete..."

## Response Strategy Recommendations

### High Priority

#### Traffic (28 comments)
**Strategy:** Prepare detailed traffic management plan and commit to mitigation measures

**Tactics:**
- Present traffic study with before/after analysis
- Commit to construction traffic routing away from residential streets
- Provide timeline for peak construction activities
- Establish complaint hotline for traffic issues

## Commitments Tracking Matrix

| Theme | Commitment | Responsible | Deadline | Status |
|-------|-----------|-------------|----------|--------|
| Traffic | No construction traffic on Main St | Project Team | Before construction | Pending |
...

## Recommended Next Steps
1. Circulate Summary
2. Implement High Priority Responses
3. Track Commitments
4. Follow-up Communication
5. Schedule Next Consultation
```

## Shared Utilities Used

This skill uses the following shared utility functions:

### From `Shared_Utils/stakeholder_utils.py`:
- `categorize_themes()` - Categorize feedback into themes
- `sentiment_analysis()` - Analyze sentiment (support/opposition/neutral)
- `frequency_weighting()` - Weight themes by frequency
- `generate_response_strategy()` - Generate response strategies
- `commitments_matrix()` - Extract and track commitments
- `extract_key_quotes()` - Extract representative quotes

### From `Shared_Utils/report_utils.py`:
- `format_markdown_table()` - Format data as markdown tables
- `eastern_timestamp()` - Generate Eastern Time timestamps

## Module Structure

```
stakeholder-management-expert/
├── SKILL.md                              # This file
├── consultation_summarizer.py            # Main calculator
├── consultation_input_schema.json        # JSON Schema validation
├── modules/
│   ├── validators.py                     # Input validation
│   ├── nlp_processing.py                 # Natural language processing
│   └── output_formatters.py              # Report formatting
└── samples/
    └── sample_1_station_public_meeting.json  # Sample input
```

## Examples

### Example 1: Transit Station Public Meeting

**Scenario:** Transit authority holds public meeting for new station. 85 attendees provide feedback.

**Input:**
```json
{
  "meeting_info": {
    "meeting_date": "2025-10-15",
    "attendance": 85,
    "project_name": "North Transit Station Project"
  },
  "comments": [
    "Concerned about traffic congestion during construction",
    "Support this project! We need better transit.",
    ...
  ],
  "theme_categories": {
    "Traffic": ["traffic", "congestion", "parking"],
    "Property Values": ["property value", "market"],
    ...
  }
}
```

**Analysis Results:**
- **Overall Sentiment:** Moderate Opposition
- **Top Theme:** Traffic (32.9% of comments)
- **Support vs. Opposition:** 15 support, 42 opposition
- **Response Strategies:** 10 strategies generated (prioritized)
- **Commitments Tracked:** 8 commitments identified

### Example 2: Infrastructure Project Workshop

**Scenario:** Highway expansion project holds workshop. Focus on business impacts.

**Key Findings:**
- Business Impact is top concern (45% of comments)
- Strong opposition (60% opposition, 20% support)
- Compensation questions dominate
- High priority response: Business liaison program

## Key Terms and Concepts

### Sentiment Categories
- **Support:** Positive sentiment toward project
- **Opposition:** Negative sentiment, concerns, objections
- **Neutral:** Questions, requests for information
- **Mixed:** Both positive and negative elements

### Priority Levels (1-5)
- **1 (Critical):** Immediate response required, high impact
- **2 (High):** Important concerns, significant stakeholder impact
- **3 (Medium):** Standard concerns, moderate impact
- **4 (Low):** Minor concerns, limited impact
- **5 (Very Low):** Informational, minimal response needed

### Response Strategy Components
- **Strategy:** High-level approach to addressing concern
- **Tactics:** Specific actions to implement strategy
- **Priority:** Urgency and importance level
- **Responsible Party:** Who will implement response

## Best Practices

### Theme Category Design
1. **Use clear, distinct categories** - Avoid overlap between themes
2. **Include comprehensive keywords** - Cover synonyms and variations
3. **Limit to 10-15 themes** - Too many dilutes analysis
4. **Test and refine** - Iterate based on uncategorized comments

### Priority Assignment
1. **Consider impact** - Frequency + severity
2. **Assess urgency** - Timeline constraints
3. **Evaluate resources** - Feasibility of response
4. **Align with project goals** - Strategic importance

### Commitment Tracking
1. **Document all commitments** - Even informal ones
2. **Assign responsibility** - Clear ownership
3. **Set deadlines** - Realistic timelines
4. **Track status** - Regular updates
5. **Communicate fulfillment** - Close the loop with stakeholders

### Response Strategy
1. **Acknowledge concerns** - Validate stakeholder input
2. **Provide factual information** - Counter misinformation
3. **Commit to specific actions** - Concrete steps
4. **Establish feedback mechanisms** - Ongoing communication
5. **Follow through** - Deliver on commitments

## Integration with Other Skills

This skill works well with:

- **Transit Station Site Acquisition Strategy** - Stakeholder feedback informs site selection
- **Expropriation Timeline Expert** - Consultation requirements and timelines
- **Briefing Note Expert** - Convert consultation summary to executive briefing
- **Agricultural Easement Negotiation** - Stakeholder concerns in rural areas

## Limitations

- **Keyword-based categorization** - May miss nuanced comments not matching keywords
- **Simple sentiment analysis** - No deep learning or context understanding
- **Manual priority assignment** - Requires human judgment for priorities
- **English language only** - No support for multilingual feedback
- **Text-only input** - Cannot analyze verbal feedback or body language

## References

- Ontario Environmental Assessment Act - Public Consultation Requirements
- IAP2 Public Participation Spectrum
- Best Practices in Stakeholder Engagement (Infrastructure Ontario)
- Transit Project Assessment Process (Metrolinx)