alchaincyf/huashu-skills / huashu-data-pro
huashu-data-pro
Verified数据分析与办公提效全能助手。覆盖数据处理、分析洞察、报告撰写、PPT制作、数据可视化的端到端工作流。 始终从专家视角出发,帮用户多想一步。遇到不确定的问题主动与用户确认。 支持:Excel数据分析、投放数据复盘、ROI测算、数据可视化、报告生成、PPT制作、公式生成。 当用户提到"分析数据"、"做报告"、"做PPT"、"Excel"、"投放分析"、"ROI"、"复盘"、 "周报"、"月报"、"数据处理"、"图表"、"可视化"、"汇报"、"表格"、"公式"时使用此技能。
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 6.9 KB |
| references/ad-analytics.md | markdown | 1.4 KB |
| references/html-templates.md | markdown | 16.4 KB |
| references/report-style-gallery.md | markdown | 9.5 KB |
| references/visual-design-system.md | markdown | 18.1 KB |
| references/workflows.md | markdown | 6.6 KB |
| scripts/build_pptx.js | script | 6.9 KB |
| scripts/html2pptx.jsexecutable | script | 33.7 KB |
| scripts/read_excel.py | script | 3.8 KB |
| scripts/read_pptx.py | script | 7.4 KB |
references/ad-analytics.md
View on GitHub# 投放/广告分析领域知识
> 投放优化师视角的速查手册。分析广告/投放数据时参考。
## 核心指标公式
| 指标 | 公式 | 健康值参考 |
|------|------|-----------|
| ROI | GMV ÷ 消耗 | >3.0(自播),>2.0(达人) |
| 转化率 | 订单数 ÷ 点击数 | >2%(信息流) |
| CPM | (消耗 ÷ 展现) × 1000 | <30元(一般品类) |
| 客单价 | GMV ÷ 订单数 | 因品类而异 |
| 消耗占比 | 千川消耗 ÷ GMV | <18%(品牌自播) |
| 实收GMV | GMV × (1-退货率) | — |
| 退货率 | 退货数 ÷ 订单数 | <30%(美妆),<45%(服饰) |
## 分析维度
| 维度 | 切入点 |
|------|--------|
| 时间 | 日/周/月趋势、同比环比、时段分布 |
| 渠道 | 千川/自然流/达人分销对比 |
| 素材 | 口播/剧情/产品展示效果对比 |
| 人群 | 年龄/性别/地域转化差异 |
| 商品 | SKU/品类/价格带表现 |
## 数据分析黄金法则
1. **AI生成公式,Excel验证数字** — AI不是计算器,复杂计算让它出公式,在Excel中跑
2. **退货率必须纳入ROI** — 不扣退货的ROI是假ROI
3. **异常值要问为什么** — 不只报「异常」,要尝试解释原因
4. **同比比环比有意义** — 广告数据有周期性,环比波动可能只是周末效应
5. **关注边际效益** — 消耗翻倍但ROI不变,说明在吃量而非优化
6. **分层看数据** — 整体ROI健康可能掩盖某品类在亏损
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| canvas-designanthropics/skillsCreate beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| docxanthropics/skillsUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pdfanthropics/skillsUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pptxanthropics/skillsUse this skill any time a .pptx or .potx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx or .potx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates (.potx), layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx or .potx filename, regardless of what they plan to do with the content afterward. If a .pptx or .potx file needs to be opened, created, or touched, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |