关于 07-marketing-report-global
面向营销人员的周期性报告技能,可依据目标、历史数据或行业基准分析渠道表现。报告按结论、证据和行动建议组织,并包含诊断、漏斗与后续计划。
主要功能
- 01收集周期、数据与渠道信息
- 02按目标或基准比较指标
- 03汇总各营销渠道表现
- 04分析转化漏斗与问题根因
- 05提出含负责人和期限的行动
- 06提供月报与周报结构
适用场景
- 01汇总每月广告与自然流量表现
- 02检查周度 KPI 是否达标
- 03定位营销转化漏斗瓶颈
- 04制定下月目标和预算计划
安装
复制下面的命令,在终端中运行。
$
npx skills add https:/ / github.com/ minhnv0807/ ai-business-skills --skill 07-marketing-report-global安装后在 Claude Code 中输入/07-marketing-report-global确认已加载。
详细介绍
营销报告(全球)
信息收集
报告前最多询问 4 个问题:
- 报告周期? 周(哪一周,起止日期)还是月(月/年)?
- 有哪些可用数据? 请提供:广告支出、消息、潜在客户、预约、客户、收入。如果数据不完整,请注明缺少哪些数据,以便询问。
- 是否设定目标? 本周期承诺达成哪些 KPI?(收入、潜在客户、CPMess、ROAS)。如果没有,则使用行业基准。
- 正在投放哪些渠道? Meta Ads、TikTok Ads、Google Ads、自然渠道(TikTok、Facebook、Email/SMS)。请列出所有渠道。
核心原则
“阅读 5 分钟,就知道下一步该做什么”
每份报告都必须依次回答以下 4 个问题:
- 结果如何? — 是否达到目标?(1 句话)
- 哪些方面有效? — 保留、扩大规模(2-3 点)
- 哪些方面无效? — 修正、找出根本原因(2-3 点)
- 下一步做什么? — 提供具体建议,并注明截止日期和负责人
呈现顺序
Insight FIRST -> Numbers AS PROOF -> Action RECOMMENDATIONS
不要只罗列数字,让读者自行得出结论。始终先说明洞察,再用数字作为证据。
3 种比较方式
每项指标都必须至少与以下 3 种方式中的 1 种进行比较:
| 方式 | 含义 | 示例 |
|---|---|---|
| 与目标比较 | 是否达到承诺的 KPI | CPMess 目标为 $1.20 — 实际为 $1.10(达标) |
| 与上一周期比较 | 与上月/上周相比是上升还是下降 | 上月 CPMess 为 $1.40 -> 本月为 $1.10(-21%) |
| 与行业基准比较 | 优于还是低于市场平均水平 | 美妆行业 CPMess 为 $1.00-$1.60 — 我们为 $1.10(表现良好) |
输出结构
标题
# Marketing Report — [Month X/YYYY] or [Week X: DD/MM-DD/MM]
Author: [Name]
Date: [YYYY-MM-DD]
Status: [Hit Target / Missed Target / Exceeded Target]
1. 执行摘要(只读本节也足够)
## 1. Executive Summary
**Conclusion:** [1 sentence — hit/missed target, main reason]
**Key metrics:**
| Metric | Target | Actual | vs Target | vs Prior |
|--------|--------|--------|-----------|----------|
| Revenue | [X] | [X] | [+/-X%] | [+/-X%] |
| Total MKT spend | [X] | [X] | [+/-X%] | [+/-X%] |
| ROAS | [X] | [X] | [+/-X%] | [+/-X%] |
| New customers | [X] | [X] | [+/-X%] | [+/-X%] |
| Avg CPMess | [X] | [X] | [+/-X%] | [+/-X%] |
**3 highlights:**
1. [Best thing this period — with data]
2. [Biggest issue — with data]
3. [Opportunity/risk to watch]
2. 渠道详情
2.1 Meta Ads
### Meta Ads
**Insight:** [1-2 sentences — channel doing well/poorly, reason]
| Metric | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Total | vs Target | vs Prior Mo | vs Benchmark |
|--------|------|------|------|------|-------|-----------|-------------|--------------|
| Spend | | | | | | | | |
| Impressions | | | | | | | | |
| Clicks | | | | | | | | |
| CTR | | | | | | | | |
| Messages | | | | | | | | |
| CPMess | | | | | | | | |
| Leads | | | | | | | | |
| CPL | | | | | | | | |
**Top 3 high-performing ads:**
| # | Ad name / Creative | Spend | Messages | CPMess | CTR | Note |
|---|--------------------|-------|----------|--------|-----|------|
| 1 | | | | | | |
| 2 | | | | | | |
| 3 | | | | | | |
**Bottom 3 ads (turn off/fix):**
| # | Ad name / Creative | Spend | Messages | CPMess | CTR | Issue |
|---|--------------------|-------|----------|--------|-----|-------|
| 1 | | | | | | |
| 2 | | | | | | |
| 3 | | | | | | |
2.2 TikTok Ads
(结构与 Meta Ads 相同 — 如果目标是流量,将 CPMess 替换为 CPV,并添加视频完播率)
2.3 Google Ads
(结构相同 — 将消息替换为转化,并添加质量得分)
2.4 自然渠道(自然内容)
### Organic
**Insight:** [1-2 sentences]
| Metric | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Total | vs Prior Mo |
|--------|------|------|------|------|-------|-------------|
| Posts published | | | | | | |
| Total reach | | | | | | |
| Total engagement | | | | | | |
| Avg ER | | | | | | |
| New followers | | | | | | |
| Top content (reach) | | | | | | |
**Top 3 posts/videos:**
| # | Content | Platform | Reach | ER | Saves | Shares | Note |
|---|---------|----------|-------|-----|-------|--------|------|
| 1 | | | | | | | |
| 2 | | | | | | | |
| 3 | | | | | | | |
2.5 Email / SMS
### Email / SMS
| Metric | Actual | vs Benchmark |
|--------|--------|--------------|
| Campaigns sent | | |
| Open rate | | [Industry avg: 15-25%] |
| Click rate | | [Industry avg: 1-3%] |
| Unsubscribe rate | | [<1% is good] |
| Email revenue | | |
3. 转化漏斗
## 3. Conversion Funnel
| Step | Volume | Conv rate | vs Prior | vs Benchmark | Rating |
|------|--------|-----------|----------|--------------|--------|
| Impression | [X] | — | [+/-X%] | — | |
| Click | [X] | [X%] | [+/-X%] | [Avg: 1-2%] | [Good/Bad/Avg] |
| Message / Lead | [X] | [X%] | [+/-X%] | [Avg: 15-25%] | |
| Qualified Lead | [X] | [X%] | [+/-X%] | [Avg: 50-60%] | |
| Booking | [X] | [X%] | [+/-X%] | [Avg: 50-60%] | |
| Customer | [X] | [X%] | [+/-X%] | [Avg: 30-40%] | |
| Revenue | [X] | — | [+/-X%] | — | |
**Bottleneck:** [Identify which step has lowest conversion — that's the issue to fix]
4. 自动诊断
## 4. Diagnosis: What's good — What's bad — Why
### Working well (KEEP + SCALE)
| # | Finding | Numbers | Reason | Action |
|---|---------|---------|--------|--------|
| 1 | [e.g., UGC video creative low CPMess] | [CPMess $0.90 vs avg $1.20] | [Natural format, strong hook] | Scale: +30% budget, shoot 5 more UGC |
| 2 | | | | |
| 3 | | | | |
### Not working (FIX URGENTLY)
| # | Issue | Numbers | Root cause | Severity | Action |
|---|-------|---------|------------|----------|--------|
| 1 | [e.g., Booking->Show low] | [28% vs target 40%] | [No 24h reminder, no deposit] | High | Auto reminder + collect $5 deposit |
| 2 | | | | | |
| 3 | | | | | |
### Unclear (MONITOR FURTHER)
| # | Observation | Numbers | Hypothesis | Validation method | Timeline |
|---|-------------|---------|------------|-------------------|----------|
| 1 | [e.g., CTR dropping over 4 weeks] | [2.1% -> 1.4%] | [Ad fatigue] | Swap creative, monitor 1 week | 7 days |
5. 行动建议
## 5. Action Recommendations
| # | Action | Goal | Deadline | Owner | Status |
|---|--------|------|----------|-------|--------|
| 1 | [e.g., Shoot 5 new UGC for Meta Ads] | CPMess <$1.00 | [DD/MM] | [Name] | Not started |
| 2 | [e.g., Set up auto reminder 24h] | Booking->Show >40% | [DD/MM] | [Name] | Not started |
| 3 | [e.g., Test TikTok Ads $200/wk] | New channel, CPMess <$1.40 | [DD/MM] | [Name] | Not started |
| 4 | | | | | |
| 5 | | | | | |
**Priority:** Number by impact level — do 1 + 2 first, 3 + 4 + 5 next week.
6. 下月计划
## 6. Plan for [Month X+1]
### Targets
| Metric | This Mo (actual) | Next Mo (target) | Increase | Basis |
|--------|------------------|------------------|----------|-------|
| Revenue | [X] | [X] | [+X%] | [Why this is achievable] |
| MKT spend | [X] | [X] | [+/-X%] | |
| ROAS | [X] | [X] | [+X] | |
| New customers | [X] | [X] | [+X%] | |
| CPMess | [X] | [X] | [-X%] | |
### Weekly plan
| Week | Focus | Budget | Main KPI |
|------|-------|--------|----------|
| Week 1 | [e.g., Launch new creative + A/B test] | [X] | [CPMess <$1.20] |
| Week 2 | [e.g., Scale winners + cut losers] | [X] | [ROAS >3x] |
| Week 3 | [e.g., Push BOFU + retarget] | [X] | [Close rate >40%] |
| Week 4 | [e.g., Wrap up + prep next month] | [X] | [Hit revenue target] |
### Budget allocation
| Category | Amount | % | Note |
|----------|--------|---|------|
| Meta Ads | [X] | [X%] | |
| TikTok Ads | [X] | [X%] | |
| Google Ads | [X] | [X%] | |
| Content production | [X] | [X%] | UGC, video shoot, design |
| Tools & software | [X] | [X%] | |
| **Total** | **[X]** | **100%** | |
7. 图表规格(供设计团队使用)
如果报告需要向利益相关者(老板、客户)展示,请创建以下图表:
| # | 图表 | 类型 | X 轴 | Y 轴 | 备注 |
|---|---|---|---|---|---|
| 1 | 按周统计的收入与支出 | 折线图(2 条线) | 第 1-4 周 | USD | 2 种颜色:绿色(收入)、红色(支出) |
| 2 | 转化漏斗 | 漏斗图 | 漏斗步骤 | 数量 | 展示次数 -> 客户 |
| 3 | 按周统计的 CPMess | 柱状图 | 第 1-4 周 | USD | 添加目标线(虚线) |
| 4 | 预算分配 | 饼图 | — | % | 按渠道划分(Meta、TikTok、Google、内容) |
| 5 | 本月与上月 | 分组柱状图 | 指标 | 数值 | 2 种颜色:绿色(本月)、灰色(上月) |
推荐工具: Google Sheets/Looker Studio(免费)、Canva(演示文稿)。
每周报告模板(精简版)
每周报告比月度报告更短 — 仅保留第 1、4、5 部分:
# Weekly Report [X]: [DD/MM-DD/MM/YYYY]
## Quick results
| Metric | Wk Target | Actual | vs Last Wk | Rating |
|--------|-----------|--------|------------|--------|
| Spend | | | | |
| Messages | | | | |
| CPMess | | | | |
| Leads | | | | |
| Bookings | | | | |
| Customers | | | | |
| Revenue | | | | |
## Good / Bad
- GOOD: [1-2 points]
- BAD: [1-2 points]
## Next week actions
| # | Task | Owner | Deadline |
|---|------|-------|----------|
| 1 | | | |
| 2 | | | |
| 3 | | | |
相关技能
- 03-performance-review-global — 汇总成报告前,深入分析各渠道
- 10-reverse-kpi-global — 根据本月结果重新计算下月目标
- 00-marketing-plan-global — 下月计划是主计划的更新版本
- 13-data-analysis-global — 需要深入分析数据以找出根本原因时使用
质量检查清单
交付报告前请检查:
- 包含执行摘要 — 1 分钟阅读即可了解全貌
- 洞察优先,数据佐证 — 不要只罗列数据而不给出结论
- 每项指标至少有 1 个比较基准(与目标 / 上期 / 行业基准对比)
- 包含每周数据(不只是月度总数)
- 列出表现最好的 3 个广告 + 表现最差的 3 个广告(附具体数据)
- 包含转化漏斗 — 指出瓶颈所在
- 诊断分析要找到根本原因,而不只是描述现象
- 行动建议要注明截止日期和负责人 — 避免泛泛而谈
- 包含下月计划,并列出目标和预算
- 没有未经来源核实的数据(每个数据都来自仪表盘或具体报告)
- 图表(如有)需明确说明设计团队所需的规格
- 报告总长度:5 分钟内可读完 — 删除冗余内容
评论
支持 Markdown