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:

# 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

{
  "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:

{
  "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:

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

Optional Demographics

{
  "demographics": {
    "residents": 52,
    "business_owners": 18,
    "property_owners": 10,
    "elected_officials": 2,
    "advocacy_groups": 3
  }
}

Output Options

{
  "output_options": {
    "include_quotes": true,
    "max_quotes_per_sentiment": 5,
    "include_commitments": true,
    "output_format": "markdown"
  }
}

Output Format

Markdown Report Structure

# 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:

{
  "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)