Skip to content
Skills Library
Marketing & content · Analysis

comment-to-topic

/comment-to-topic

Analyze scraped social media comments (小红书, 抖音, etc.) to extract content topic recommendations, user pain points, debate maps, and reusable material. Trigger when user has scraped comment/note data (JSON, CSV, Excel) and needs structured analysis for content planning. Keywords: 评论分析, 选题, 选题库, 评论区, topic extraction, comment analysis, content planning, 用户需求分析, 痛点分析.

Licence
MIT
Last repository change
06.07.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
3
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 06.07.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

Analyze scraped social media comments (小红书, 抖音, etc.) to extract content topic recommendations, user pain points, debate maps, and reusable material. Trigger when user has scraped comment/note data (JSON, CSV, Excel) and needs structured analysis for content planning. Keywords: 评论分析, 选题, 选题库, 评论区, topic extraction, comment analysis, content planning, 用户需求分析, 痛点分析.

Original author description

Analyze scraped social media comments (小红书, 抖音, etc.) to extract content topic recommendations, user pain points, debate maps, and reusable material. Trigger when user has scraped comment/note data (JSON, CSV, Excel) and needs structured analysis for content planning. Keywords: 评论分析, 选题, 选题库, 评论区, topic extraction, comment analysis, content planning, 用户需求分析, 痛点分析.

How it works

  1. Overview
  2. Process
  3. Guidelines
Original SKILL.md headings · 154 lines, 990 words
SKILL.md preview
---
name: comment-to-topic
description: |
  Analyze scraped social media comments (小红书, 抖音, etc.) to extract
  content topic recommendations, user pain points, debate maps, and
  reusable material. Trigger when user has scraped comment/note data
  (JSON, CSV, Excel) and needs structured analysis for content planning.
  Keywords: 评论分析, 选题, 选题库, 评论区, topic extraction, comment
  analysis, content planning, 用户需求分析, 痛点分析.
---

# Comment-to-Topic

## Overview

Transform scraped social media comments into structured content topic recommendations.

**Core principle**: Every recommendation must be traceable to specific user comments. No "I think this is a good topic" — only "X users said Y, therefore Z is a valid topic."

**Outputs**: Pain point inventory, debate maps, topic recommendation cards with evidence, user persona segments, material library, and analytical insights.

## Process

### Phase 1 — Data Ingestion

1. Read the target directory structure. Identify data format (JSON, CSV, Excel, or mixed).
2. Open 2-3 sample files to discover the schema. Note available fields: note title, note content, comment text, comment likes, reply structure, user info, timestamps, image references.
3. Count total notes and estimate total comments.
4. Record the discovered schema — reference it throughout later phases.
5. If data exceeds context capacity, process in batches of 5-7 notes. Write intermediate findings to a temp file after each batch. Merge all intermediate findings before Phase 3.

### Phase 2 — Comment Classification

Read every comment and classify each into one of six signal types:

| Signal | Pattern | Content Value |
|--------|---------|---------------|
| 高频提问 | "有没有推荐…""怎么才能…""能不能出一期…" | Direct tutorial topic |
| 场景追问 | "男生可以用吗""学生党有平替吗""适合送妈妈吗" | Segment-specific topic |
| 对立观点 | Two users disagree on the same point | Debate / 破误区 content |
| 决策问题 | "在哪里买""多少钱""怎么选" | High-conversion content |
| 情绪表达 | "受够了""崩溃""终于找到了" | Empathy / 共鸣 content |
| 故事叙述 | User shares detailed personal experience | Case study material |

For each classified comment, record:
- **Original text** (verbatim — never paraphrase)
- Signal type
- Emotion tag (anger / frustration / confusion / desire / relief / humor / etc.)
- Scene tag if identifiable (commuting / dorm / office / kitchen / etc.)
- Identity tag if identifiable (student / parent / professional / beginner / etc.)
- Like count (resonance proxy)

### Phase 3 — Pattern Extraction

After classifying all comments, extract patterns across the full dataset:

**3a. Frequency**: Which signal types dominate? Which pain points recur across different notes? Cluster by concept, not by word — "迷茫""不知道方向""不知道自己适合什么" may be one concept.

**3b. Debate Mapping**: Identify topics where users hold opposing views. For each debate: state both sides with representative comments. Rate intensity (mild ↔ heated).

**3c. Gap Identification**: Questions that existing content doesn't answer. Scenarios no one covers. Decision-stage queries with no good resources.

**3d. User Segmentation**: Group commenters by identifiable traits. For each segment: what they care about, what language they use, what they struggle with.

### Phase 4 — Topic Generation

Generate topic recommendations following these rules:

**Rule 1 — Evidence required.** Each recommendation includes 1-3 verbatim supporting comments. No evidence, no topic.

**Rule 2 — User language.** Use phrasing from actual comments, not editorial vocabulary. If users say "我真的受够了", the topic shouldn't be "关于XX的深度思考".

**Rule 3 — Topic type must be explicit.**

| Type | When | Example |
|------|------|---------|
| 破误区 | Common misconception with opposing evidence | 《试错不是免费的:没钱的人怎么成长》 |
| 教程 | Repeated "how to" questions | 《夏天清爽香水推荐:从评论区扒出来的真需求》 |
| 共鸣 | Strong emotional resonance | 《没人兜底的人,怎么给自己兜底》 |
| 对比/测评 | Users debate competing options | 《5款vibe coding工具实测:评论区吵翻了的那个到底行不行》 |
| 深度 | Multi-layered topic worth exploring | 《不想上班 ≠ 适合创业》 |

**Rule 4 — Each card must include:**
- Recommended title + 2 alternatives
- Core angle (what unique perspective you bring)
- Opening hook (derived from a real comment)
- Target reader segment
- Resonance level (high / medium / low — based on comment frequency and emotion intensity)
- Source comments (verbatim, with like counts)

### Phase 5 — Material Extraction

Separately extract reusable material:

- **Gold Quotes**: Comments usable directly as hooks, subtitles, or openers. Must have strong emotion, specific scene, or memorable phrasing.
- **Data Points**: "X out of Y comments mentioned…", "The most-liked comment (Z likes) said…"
- **Counter-arguments**: Opposing viewpoints for article nuance, each citing original comment.

### Phase 6 — Output Assembly

Generate output files in `analysis/` subdirectory of the data project. See `references/output-templates.md` for exact templates.

```
[project_dir]/
├── analysis/
│   ├── 00-overview.md
│   ├── 01-pain-points.md
│   ├── 02-debate-map.md
│   ├── 03-topic-recommendations.md
│   ├── 04-user-personas.md
│   ├── 05-material-library.md
│   └── 06-insights.md
```

### Phase 7 — Quality Validation

Before finalizing, check each topic recommendation:

- [ ] Has ≥1 verbatim supporting comment
- [ ] Uses user language, not editorial language
- [ ] Targets a specific reader segment (not "everyone")
- [ ] Offers a clear angle (not just a subject)
- [ ] Opening hook could stop someone mid-scroll

Remove or revise any recommendation that fails ≥2 criteria.

## Guidelines

### On Authenticity

**Never paraphrase user comments.** When you translate "我真的受够了每次洗完还有一股腥味" into "用户反映清洁效果不佳", you lose the emotional texture that makes content resonate. Store verbatim. Analyze structurally. Quote authentically.

### On Batch Processing

If total comments exceed single-pass capacity:
1. Process notes in batches of 5-7
2. After each batch, write intermediate findings to `analysis/_batch_[n].md`
3. After all batches, merge intermediates and run pattern extraction on the combined set
4. Delete intermediate files after merge

### On Accumulating Across Runs

When running this Skill multiple times:
1. Each run's output goes into a dated subdirectory: `analysis/20260620/`
2. Maintain a cumulative `insights-ledger.md` in the project root
3. Track which topics have been written and published — mark as consumed
4. New runs reference previous insights to distinguish emerging vs. persistent themes

### On Cross-Platform Data

When analyzing comments from multiple platforms:
- Same-signal comments from different platforms reinforce each other
- 抖音 comments: more emotional, fragmented, impulse-driven
- 小红书 comments: more scene-specific, detailed, decision-oriented
- Note the platform source for each comment in analysis

### On Prioritization

When there are too many potential topics, prioritize by:
1. Frequency × Emotion intensity (most signals, strongest feelings)
2. Debate presence (topics with opposing views generate more engagement)
3. Specificity (concrete scenarios beat abstract themes)
4. Gap score (how poorly existing content covers this)
Files in this package (3)
  • SKILL.md 8 KB
  • references/analysis-framework.md 8 KB
  • references/output-templates.md 5 KB

Versions

The database has no other skills named comment-to-topic.

Database snapshot: 13.11.2026 · package version 87c002316390 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 96social-media-operator
    自媒体运营全能助手 — 小红书、公众号、抖音、私域流量一站式运营指南。当你需要写爆款文案、规划内容日历、分析数据、制定涨粉策略时使用。
  • 100xiaohongshu-auto-posting
    Automates the complete Xiaohongshu (XHS / Little Red Book) content operation workflow: pain-point topic collection → style case collection → topic selection → content writing → publishing → performance tracking. Use when user mentions xiaohongshu auto posting, xhs auto post,…
  • 100crawling-social-media
    Downloads and extracts content from social media platforms. Use when user wants to crawl, download, or extract videos/content from Bilibili, YouTube, TikTok, Douyin, Instagram, Twitter, Xiaohongshu. 下载视频、抓取视频、爬取内容、提取视频、下载B站视频、下载抖音视频、下载YouTube视频、视频采集。
  • 95social-content-market-research
    Build evidence-backed market research for social-content ecosystems such as Xiaohongshu (XHS, RedNote, 小红书), Douyin (抖音), TikTok, Bilibili, WeChat Channels (视频号), or similar platforms. Use for content-track / niche research (赛道研究), creator-landscape mapping, audience × problem ×…
  • 100social-content-strategy
    When the user wants to plan a social media content strategy, decide what to post, or figure out topic clusters and content mix. Also use when the user mentions 'content strategy,' 'what should I post,' 'content ideas,' 'topic clusters,' 'content pillars,' 'content planning,'…
  • 100xiaohongshu
    Operate Xiaohongshu / RED through the user's paired browser device: login, recommendations, filtered search, note/comment/profile inspection, content planning, image/video/long-article publishing, scheduling, product binding, comments/replies, likes, and favorites. Use for 小红书,…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.