Data Table Manager
n8n-io/n8n
Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.
分析单篇、系列、周度或月度自媒体数据并形成可执行复盘。用于读取平台后台截图、CSV、表格、公开链接或用户提供的数据，计算关注效率和深度互动，比较同平台基线，归因选题、标题、封面、开头、结构、发布时间、标签和行动，并输出加码、改包装、再适配、停止或继续收集样本的决策。
Install Self Media Content Analytics
$ npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install yanhua1010/self-media-content-workflow self-media-content-analytics --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/yanhua1010/self-media-content-workflow.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/self-media-content-analytics .claude/skills/self-media-content-analytics && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "self-media-content-analytics" agent skill from https://github.com/yanhua1010/self-media-content-workflow/tree/main/skills/self-media-content-analytics into .claude/skills/self-media-content-analytics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "self-media-content-analytics", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/yanhua1010/self-media-content-workflow/tree/main/skills/self-media-content-analyticsType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install yanhua1010/self-media-content-workflow self-media-content-analytics --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/yanhua1010/self-media-content-workflow.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/self-media-content-analytics .agents/skills/self-media-content-analytics && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "self-media-content-analytics" agent skill from https://github.com/yanhua1010/self-media-content-workflow/tree/main/skills/self-media-content-analytics into .agents/skills/self-media-content-analytics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "self-media-content-analytics", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install yanhua1010/self-media-content-workflow self-media-content-analytics --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/yanhua1010/self-media-content-workflow.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/self-media-content-analytics .cursor/skills/self-media-content-analytics && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "self-media-content-analytics" agent skill from https://github.com/yanhua1010/self-media-content-workflow/tree/main/skills/self-media-content-analytics into .cursor/skills/self-media-content-analytics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "self-media-content-analytics", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/yanhua1010/self-media-content-workflow.git --path skills/self-media-content-analytics--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install yanhua1010/self-media-content-workflow self-media-content-analytics --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/yanhua1010/self-media-content-workflow.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/self-media-content-analytics .gemini/skills/self-media-content-analytics && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "self-media-content-analytics" agent skill from https://github.com/yanhua1010/self-media-content-workflow/tree/main/skills/self-media-content-analytics into .gemini/skills/self-media-content-analytics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "self-media-content-analytics", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install yanhua1010/self-media-content-workflow self-media-content-analyticsInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/yanhua1010/self-media-content-workflow.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/self-media-content-analytics .github/skills/self-media-content-analytics && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "self-media-content-analytics" agent skill from https://github.com/yanhua1010/self-media-content-workflow/tree/main/skills/self-media-content-analytics into .github/skills/self-media-content-analytics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "self-media-content-analytics", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install yanhua1010/self-media-content-workflow self-media-content-analytics --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/yanhua1010/self-media-content-workflow.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/self-media-content-analytics .opencode/skills/self-media-content-analytics && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "self-media-content-analytics" agent skill from https://github.com/yanhua1010/self-media-content-workflow/tree/main/skills/self-media-content-analytics into .opencode/skills/self-media-content-analytics/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "self-media-content-analytics", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
self-media-content-analytics- GitHub stars
- 576
- Token cost
- ~326 tokens
- SKILL.md length
- 68 words
- Files
- 7 (incl. references, assets)
- Skills in repo
- 10
- Repo updated
- First seen
- Licence
- MIT
At a glance
分析单篇、系列、周度或月度自媒体数据并形成可执行复盘。用于读取平台后台截图、CSV、表格、公开链接或用户提供的数据，计算关注效率和深度互动，比较同平台基线，归因选题、标题、封面、开头、结构、发布时间、标签和行动，并输出加码、改包装、再适配、停止或继续收集样本的决策。
- Works in 5 steps: 校验数据 → 给出核心结论 → 做归因 → …
- Tasks that involve CSV and tabular files
- SKILL.md covers 数据来源, 分析流程, 复盘层级 and 输出
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Self Media Content Analytics is an agent skill from yanhua1010/self-media-content-workflow. 分析单篇、系列、周度或月度自媒体数据并形成可执行复盘。用于读取平台后台截图、CSV、表格、公开链接或用户提供的数据，计算关注效率和深度互动，比较同平台基线，归因选题、标题、封面、开头、结构、发布时间、标签和行动，并输出加码、改包装、再适配、停止或继续收集样本的决策。
Its SKILL.md is about 330 tokens, which your agent loads only when the skill is triggered. The skill folder holds 9 other files, including reference files and assets (for example `agents/openai.yaml`, `assets/content-review-template.md` and `assets/metrics-ledger-template.md`).
It sits in Documents & Office, covering CSV and tabular files. The repository describes itself as: 通用、模块化的自媒体内容生产与经营 Skills / A modular, tool-agnostic self-media content skill suite. The licence is MIT.
When your agent uses it
- Tasks that involve CSV and tabular files
Example prompts
- “/self-media-content-analytics”
Workflow steps
5 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit 6cb1f1f. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Self Media Content Analytics loads about 326 tokens when it runs, and up to ~692 if it reads all its reference files. Until then it costs about 41 tokens; SKILL.md has 68 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from yanhua1010/self-media-content-workflow at commit 6cb1f1f, republished under its MIT licence (© yanhua1010). 68 words, ~326 tokens.
Download SKILL.mdSave it as
.claude/skills/self-media-content-analytics/SKILL.md (or your agent's skills folder). This skill also uses 6 other files; get the full folder from GitHub.- name
- self-media-content-analytics
- description
- 分析单篇、系列、周度或月度自媒体数据并形成可执行复盘。用于读取平台后台截图、CSV、表格、公开链接或用户提供的数据，计算关注效率和深度互动，比较同平台基线，归因选题、标题、封面、开头、结构、发布时间、标签和行动，并输出加码、改包装、再适配、停止或继续收集样本的决策。
内容数据复盘
数据来源
优先使用：
- 用户提供的平台后台截图和导出文件。
- 已认证连接器或用户自有账号的只读统计接口。
- 内容任务卡、注册表和历史复盘。
- 公开内容链接，仅用于公开指标和结构观察。
不要估算平台没有提供的数据。读取自有账号数据不等于授权修改账号或发布内容。
需要持续记录时，从 metrics-ledger-template.md 创建原始指标台账。若项目已有数据库、表格或分析系统，继续使用现有系统，不重复建账。
分析流程
1. 校验数据
检查平台、内容、发布日期、观察窗口、字段定义、缺失值和异常值。区分曝光、阅读或播放、互动、关注、转化和制作成本。
2. 给出核心结论
说明表现相对自身基线如何、最值得注意的信号是什么，以及哪些结论不能成立。
3. 做归因
按证据强弱检查：
- 选题和目标受众。
- 标题和封面。
- 开头 3 秒或第一屏。
- 结构、证据和信息密度。
- 发布时间、标签、合集和行动。
- 热点、投流、商单和账号体量等外部因素。
相关性不等于因果。没有对照或样本不足时写“待验证”。
4. 做同类比较
只比较同平台、同内容类型和相近时间窗口。优先使用中位数、P75、每千浏览新关注、深度互动率和制作时间。跨平台原始播放量不能直接排名。
完整指标定义见 metrics.md。
5. 形成决策和实验
结论归入：加码、改包装、改主页或系列、平台再适配、停止、样本不足。
每次只设计一个主要实验变量，写清假设、改动、成功标准和观察窗口。
复盘层级
- 单篇复盘：使用 content-review-template.md。
- 周复盘：使用 weekly-review-template.md。
- 月复盘：使用 monthly-review-template.md。
输出
交付：
- 核心结论。
- 数据质量和基线说明。
- 归因及证据强度。
- 可复制因素和不可归因因素。
- 3 到 5 条可执行动作。
- 待验证假设和唯一实验。
商单与自然内容分开分析。样本不足时不调整长期内容比例。
© yanhua1010, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 6 other files (references, assets) in skills/self-media-content-analytics of yanhua1010/self-media-content-workflow.
- SKILL.md
- agents/openai.yaml
- assets/content-review-template.md
- assets/metrics-ledger-template.md
- assets/monthly-review-template.md
- assets/weekly-review-template.md
- references/metrics.md
Open the folder on GitHubat commit 6cb1f1f
Compare with similar skills
Self Media Content Analytics next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Self Media Content Analytics this skillyanhua1010/self-media-content-workflow | 576 | — | ~326 | Automated safety check: Pass | MIT | |
| Data Table Managern8n-io/n8n | 207k | — | ~2.3k | Automated safety check: Pass | Custom licence | |
| Instrument Data To Allotropeaws-samples/amazon-bedrock-agents-healthcare-lifesciences | 274 | 2 repos | ~2.7k | Automated safety check: Pass | Apache-2.0 | |
| Abuse Hunternexu-io/harness-engineering-guide | 664 | — | ~1.9k | Automated safety check: Pass | MIT | |
| Intelligence Requirements BuilderTracecatHQ/tracecat | 3.8k | — | ~6k | Automated safety check: Pass | MIT | |
| Markitshift-labs-ai/markit | 1.3k | — | ~299 | Automated safety check: Pass | MIT |
Similar skills
- Official
- Official
Instrument Data To Allotrope
aws-samples/amazon-bedrock-agents-healthcare-lifesciences
Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.
Abuse Hunter
nexu-io/harness-engineering-guide
Detect and investigate bulk registration abuse on SaaS platforms.
Intelligence Requirements Builder
TracecatHQ/tracecat
Turns a vague, high-level stakeholder ask into a structured set of intelligence requirements for a CTI team, complete with Essential Elements of Information, collection guidance, success criteria…
Markit
shift-labs-ai/markit
Convert files and URLs to Markdown. An agent skill from shift-labs-ai/markit.
Sector Analyst
tradermonty/claude-trading-skills
This skill should be used when analyzing sector rotation patterns and market cycle positioning.
More from yanhua1010/self-media-content-workflow
All 10 skills in this repoSelf Media Video Publisher
yanhua1010/self-media-content-workflow
把已确认终稿的视频成片发布到 YouTube、抖音、视频号、小红书等平台。用于用户说“发视频、同步发布、上传 YouTube、发到抖音视频号小红书、定时发布”等场景。按平台核对视频版本、封面、字幕、标题描述和 AI/版权声明，生成逐平台发布包；经用户逐平台授权后，才通过运行时可用的官方 API、填表助手或上传工具上传为私密、草稿或定时，从不一键群发。没有上传能力时交付手动发布包。
Self Media Content Workflow
yanhua1010/self-media-content-workflow
通用自媒体内容生产与经营工作流。用于自媒体内容创作、选题策划、热点或竞品研究、多平台改写、短视频脚本、数字人视频、动画解说视频、YouTube 与抖音视频号小红书多平台视频发布、发布包、公众号草稿、内容数据分析、周复盘、月复盘和继续未完成任务。负责识别请求类型，调用创作简报、内容策略、热点竞品、平台文案、短视频与视频制片、视频发布、数据复盘和交付归档模块，并管理方向确认、标题确认、终稿确认和发布…
Self Media Short Video
yanhua1010/self-media-content-workflow
把已确认的母题或文案转成可直接拍摄、录屏或交给视频工具制作的视频方案，也支持在用户确认肖像与声音权利并完成平台手动上传后制作数字人视频，以及用合成配音和 AI 绘制画面制作无真人出镜的动画解说视频（科普、历史、品牌故事）。用于视频号、抖音、小红书视频、YouTube 横屏视频和 Shorts 的口播稿、前 3…
Self Media Wechat Publisher
yanhua1010/self-media-content-workflow
把已确认的公众号终稿 Markdown 排版并写入微信公众号草稿箱。用于用户说"发布到公众号、写入草稿箱、公众号排版、换个排版主题、发小绿书图片消息"等场景。自动上传封面与文内图片，支持多主题与自定义 CSS、多账号和 server 模式。只创建草稿不群发，凭据只通过环境变量提供，未安装适配工具时交付手动发布包。
Self Media Content Brief
yanhua1010/self-media-content-workflow
为单篇或多平台自媒体创作澄清需求并生成可确认的创作简报。用于用户只给一句话选题、一个链接、一份素材、一个产品或模糊创作要求，需要确认目标受众、内容目标、核心判断、角度、深度、调性、证据、禁区和平台差异时。纯数据分析、已确认方向后的改稿和细节微调不使用此 Skill。
Self Media Content Delivery
yanhua1010/self-media-content-workflow
将自媒体创作里程碑保存成文件，管理版本、核验路径、生成完整发布包并更新内容索引。用于保存平台第一版完整成稿、多平台合集、短视频脚本、分镜、定稿、发布包和复盘报告，或用户说“保存一下、整理交付、归档、生成发布清单”时。标题微调、删一句和临时候选不单独保存新版本。
Related
Categories
Questions about Self Media Content Analytics
What does Self Media Content Analytics do?
分析单篇、系列、周度或月度自媒体数据并形成可执行复盘。用于读取平台后台截图、CSV、表格、公开链接或用户提供的数据，计算关注效率和深度互动，比较同平台基线，归因选题、标题、封面、开头、结构、发布时间、标签和行动，并输出加码、改包装、再适配、停止或继续收集样本的决策。. Self Media Content Analytics is an agent skill from yanhua1010/self-media-content-workflow.
When should I use Self Media Content Analytics?
Self Media Content Analytics fits situations like: tasks that involve CSV and tabular files.
How do I install Self Media Content Analytics in Claude Code?
Run `npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a claude-code`. Or copy the skill folder (skills/self-media-content-analytics in yanhua1010/self-media-content-workflow) into .claude/skills/self-media-content-analytics in your project. Claude Code loads it when a task matches its description.
How do I install Self Media Content Analytics in Codex?
Run `npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a codex`. Or copy the skill folder (skills/self-media-content-analytics in yanhua1010/self-media-content-workflow) into .agents/skills/self-media-content-analytics in your project. Codex loads it when a task matches its description.
Can I use Self Media Content Analytics in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add yanhua1010/self-media-content-workflow --skill self-media-content-analytics -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/self-media-content-analytics, .gemini/skills/self-media-content-analytics, .github/skills/self-media-content-analytics and .opencode/skills/self-media-content-analytics in your project.
What does Self Media Content Analytics need to run?
SKILL.md names no scripts, command-line tools or credentials: Self Media Content Analytics is instructions for the agent only.
Does Self Media Content Analytics access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Self Media Content Analytics safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Self Media Content Analytics use?
Self Media Content Analytics is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Self Media Content Analytics use?
About 326 tokens (SKILL.md is roughly 1.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 366 tokens, read only when the agent opens those files.
What are the alternatives to Self Media Content Analytics?
Skills that share tags, products or a category with Self Media Content Analytics: Data Table Manager (n8n-io/n8n, 207k stars), Instrument Data To Allotrope (aws-samples/amazon-bedrock-agents-healthcare-lifesciences, 274 stars), Abuse Hunter (nexu-io/harness-engineering-guide, 664 stars) and Intelligence Requirements Builder (TracecatHQ/tracecat, 3.8k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Self Media Content Analytics?
yanhua1010 (a GitHub user) maintains it in yanhua1010/self-media-content-workflow, which has 576 GitHub stars. The repository holds 10 skills in this directory. The repository was last updated on October 11, 2026.
Source: yanhua1010/self-media-content-workflow on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.