Self Media Content Analytics Agent Skill
分析单篇、系列、周度或月度自媒体数据并形成可执行复盘。用于读取平台后台截图、CSV、表格、公开链接或用户提供的数据，计算关注效率和深度互动，比较同平台基线，归因选题、标题、封面、开头、结构、发布时间、标签和行动，并输出加码、改包装、再适配、停止或继续收集样本的决策。
Install
one command, takes just this skill from the repositorynpx skills add https://github.com/yanhua1010/self-media-content-workflow --skill self-media-content-analyticsThe instruction itself
5 sections, as written by the author内容数据复盘
数据来源
优先使用：
- 用户提供的平台后台截图和导出文件。
- 已认证连接器或用户自有账号的只读统计接口。
- 内容任务卡、注册表和历史复盘。
- 公开内容链接，仅用于公开指标和结构观察。
不要估算平台没有提供的数据。读取自有账号数据不等于授权修改账号或发布内容。
需要持续记录时，从 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 条可执行动作。
- 待验证假设和唯一实验。
商单与自然内容分开分析。样本不足时不调整长期内容比例。
Other skills for the same job
different authors, same section of the catalogue
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like \"the xlsx in my downloads\") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.
Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.
MATLAB and GNU Octave numerical computing for matrix operations, data analysis, visualization, and scientific computing. Use when writing MATLAB/Octave scripts for linear algebra, signal processing, image processing, differential equations, optimization, statistics, or creating scientific visualizations. Also use when the user needs help with MATLAB syntax, functions, or wants to convert between MATLAB and Python code. Scripts can be executed with MATLAB or the open-source GNU Octave interpreter.
UMAP dimensionality reduction. Fast nonlinear manifold learning for 2D/3D visualization, clustering preprocessing (HDBSCAN), supervised/parametric UMAP, for high-dimensional data.
Creating interactive data visualisations using d3.js. This skill should be used when creating custom charts, graphs, network diagrams, geographic visualisations, or any complex SVG-based data visualisation that requires fine-grained control over visual elements, transitions, or interactions. Use this for bespoke visualisations beyond standard charting libraries, whether in React, Vue, Svelte, vanilla JavaScript, or any other environment.
Access AlphaFold 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), for drug discovery and structural biology.
How to use it
Take yanhua1010/self-media-content-analytics from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
The agent identifies a skill by the name field in its header. Two skills with the
same name cannot sit side by side — one of them will be ignored.