bot-analysis

Analyze Excel chat data to classify conversations as resolved or unresolved.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/channel-io/sop-agent --skill bot-analysis
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: bot-analysis
Source: https://github.com/channel-io/sop-agent/tree/main/.agents/skills/bot-analysis
Command: npx skills add https://github.com/channel-io/sop-agent --skill bot-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill analyzes the bot's performance in customer support chats by preprocessing Excel chat data with Python to classify conversations as resolved (bot-only) or unresolved (manager-assisted), enabling data-driven improvements.

Core Features & Use Cases

  • Preprocesses Excel data and runs bot classification to label conversations as bot-participated and resolved or unresolved.
  • If clustering results exist, maps conversations to topics for per-topic performance insights.
  • Generates a comprehensive report including an executive summary, topic-level patterns, and bot behavior analysis.

Quick Start

Run the analysis pipeline on your Excel chat data to generate the summary and report.

Frequently Asked Questions about bot-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze customer-support bot performance from Excel chat data?

Customer-support bot performance is analyzed by preprocessing Excel chat data with Python to classify conversations as resolved or unresolved. The pipeline outputs a summary JSON file and a Markdown report detailing topic-level insights and overall bot metrics.

What is the best way to classify bot chat conversations as resolved or unresolved?

Classifying bot chat conversations as resolved or unresolved is best handled by running a Python preprocessing script that labels bot-only interactions as resolved and manager-assisted handoffs as unresolved. This automated classification enables data-driven improvements for your support bots.

Does bot performance analysis work with topic clustering results?

Yes, bot performance analysis works with topic clustering results. If clustering data exists in your dataset, the analysis pipeline maps conversations to specific topics, enabling you to generate per-topic performance insights and identify patterns in bot behavior within the final report.

Can I use Python scripts to preprocess Excel data for customer support topic analysis?

You can use Python scripts to preprocess Excel data for customer support topic analysis. The pipeline parses raw chat interactions, identifies bot participation, and structures the data required to classify resolutions and generate topic-level performance reports.

What outputs do I get from automating bot-performance analysis?

Automating bot-performance analysis yields a bot_analysis_summary.json containing raw metrics and a bot_performance_report.md featuring an executive summary, topic-level patterns, and bot behavior analysis. These outputs provide a comprehensive view of your chatbot's resolution rates and handoff trends.

Do I need existing clustering results to generate topic-level insights for my chatbot?

No, you do not need existing clustering results to run the base analysis, but the pipeline can utilize them if present. Applying clustering results allows the analysis to map conversations to topics and generate detailed per-topic performance insights for your customer-support bots.