Support online 08:00-24:00 (UTC+8) - manual top-ups are usually done within 1 hour once details are complete, and night orders are handled after 8:00 the next morning

See pricing →
My orders Log in ZH Support
Home Top-up Skills Guides My orders

6 张为输出物示意（按真实产物版式重排），不是成品截图。

Requires

What you need before running this pack. Miss one and it cannot do the work.

  • Python python3 runs on your machine — one command, and it does not touch your files
  • Report / exported CSV You export a CSV or JSON from the platform admin as the input

Picked most often by

Who buys it most, by role. Click a role to see only that role's skills.

Ads Operations Finance & cost

Similar skills

View all →
◫

亚马逊账号申诉包（POA / 视频验证 / 资金解冻）

跨境卖家收到亚马逊业绩通知后，判清 12 类违规中的哪一类、算出 9 类必备材料里自己缺哪几件、生成中英双语三段式 POA，并在提交前用 11 项闸门把驳回理由提前跑一遍。
Amazon Operations Owner / operator Account appeals & compliance
¥349 Al
Details Get it
◫

欧盟合规包：上架前的四关自查（GPSR / PPWR / EPR / 欧代）

把 listing 文本与你自己填的合规底账，逐条对着 GPSR / PPWR / EPR / WEEE / 电池法 / 宣称类的 19 条条款过一遍，判「必改 / 建议改 / 需人工
Amazon DTC store (Shopify) Multi-platform Operations +4
¥349 Al
Details Get it

What is included

  • ✓ report-adapter — report-adapter（第 1 关：认表与映射）
  • ✓ funnel-breakdown — funnel-breakdown（第 2、3 关：漏斗拆解 + 预算与出价）
  • ✓ negative-builder — negative-builder（第 4 关：否定清单 + 总行动表）

Who it is for

  • ✓ People who need steady output in a fixed scene (Ads / Operations)
  • ✓ You already have assets — you need structure
  • ✓ Want to set it up once and reuse it, instead of re-explaining every time

Not for

  • – Want full automation with no input at all
  • – One-off use, no reuse planned
  • – Platform-specific ad console actions (do those manually)
Amazon Ads Operations Finance & cost Ads & traffic Data & reports
Try saying this

Use “广告诊断包（ACOS / CPC / 不出单）” to make me Web pages — I will paste the input below.

Copy this line to your agent to start
  • Versionv0.1.0
  • Updated2026-10-24
  • OutputWeb pages

About this skill

把 Amazon Ads / Google Ads / Meta 导出的广告报表映射成同一套列，拆成「曝光→点击→转化→回本」四段，算出钱漏在哪一段、漏了多少、出价上限是多少，并输出可直接照着加的否定清单与按优先级排的行动表。四关全部离线、纯标准库、确定性输出。

Sample output

Real input → real output, unpolished
真实输出节选｜examples/01-high-acos-no-orders/after/diagnosis.md Output 
# 广告诊断：钱掉在哪一段

数据期间：2026-10-01 ~ 2026-10-14（14 天）

本报告由 `skills/funnel-breakdown/scripts/funnel.py` 从你的报表算出来，每个数字都能在 `after/funnel.csv` 里找到同一行。它回答一个问题：**这段花费是在哪一段掉掉的**——不是给你 10 条通用建议。

## 口径先说清楚（不成立的前提）

| 项 | 本次用的值 | 错了会怎样 |
|---|---|---|
| 回本线 ACOS | 30.00%（= 你填的毛利率） | 填错，第三段的「超出回本线」金额全错；这个数要你自己按产品毛利填，不是平台给的 |
| CTR 参考线 | 0.35% | 只是量级参考，不是平台承诺值；你店铺历史中位数更准 |
| CVR 参考线 | 8.00% | 同上 |
| 销售额口径 | 报表里的销售额列 | 归因窗口不同（7 天 / 14 天）会让 ACOS 差十几个百分点，两期对比前必须一致 |

## 合计漏斗

| 段 | 指标 | 本期 | 参考线 | 缺口 |
|---|---|---|---|---|
| 曝光 → 点击 | CTR | 0.299%（点击 1576 / 曝光 527000） | 0.35% | +0.051 个百分点 |
| 点击 → 订单 | CVR | 6.03%（订单 95 / 点击 1576） | 8.00% | +1.97 个百分点 |
| 订单 → 回本 | ACOS | 52.31%（花费 2578.00 / 销售额 4928.00） | 30.00% | +22.31 个百分点 |
| 参考 | CPC / 客单价 | 1.6358 / 51.87 | - | - |

**合计超出回本线 1099.60**（= 花费 2578.00 − 销售额 4928.00 × 回本线 30%）。这是「按你自己填的回本线，这段广告多花了多少」。

## 钱掉在哪一段

- 第一段（曝光到点击）：把每条活动的 CTR 都拉到参考线，合计可少漏
真实输出节选｜examples/01-high-acos-no-orders/after/action-table.csv Output 
priority,type,target,segment,finding,action,expected_effect,evidence,source_gate
P1,主因,SP-Auto-CoffeeGrinder,第二段：点击到转化,花费 742.00、销售额 812.00、ACOS 91.38%，超出回本线 498.40（CTR 0.317% / CVR 3.64%）,先修点击到订单：核对落地页与搜索词是否对得上、价格与评论是否有竞争力；这一段修好前不要加预算,可回收约 316.88（按回本线折算的毛利口径，不承诺实际降幅）,"原始报表第 2,3 行",第 2 关 funnel.csv
P1,主因,SP-Manual-Phrase-BurrGrinder,第一段：曝光到点击,花费 556.00、销售额 552.00、ACOS 100.72%，超出回本线 390.40（CTR 0.107% / CVR 4.68%）,先修曝光到点击：换主图/改标题/挪位置，或把词换到更精准的匹配方式；这一段修好前不要加预算,可回收约 494.18（按回本线折算的毛利口径，不承诺实际降幅）,"原始报表第 6,7 行",第 2 关 funnel.csv
P1,主因,SP-ASIN-Competitor-ASINs,第二段：点击到转化,花费 402.00、销售额 196.00、ACOS 205.10%，超出回本线 343.20（CTR 0.538% / CVR 2.38%）,先修点击到订单：核对落地页与搜索词是否对得上、价格与评论是否有竞争力；这一段修好前不要加预算,可回收约 138.77（按回本线折算的毛利口径，不承诺实际降幅）,"原始报表第 8,9 行",第 2 关 funnel.csv
P1,出价,SP-Auto-CoffeeGrinder,第三段：转化到回本,CPC 1.5020，按回本线的出价上限 0.4931（超出 1.0089）,把该活动出价压到 0.4931 以内；压不动就先把这个活动的位置/匹配方式收窄,CPC 压到上限、其它条件不变时，ACOS 回落到回本线 30.00

Install guide

One column per agent, each with a check that proves it installed. If the check fails, it is not installed.

Claude Code

Install to .claude/skills/ppc-diagnosis/ 
mkdir -p .claude/skills
unzip ppc-diagnosis.zip -d .claude/skills/

How to verify Open a new session and ask it to list the installed skills — seeing this pack's name means it worked.

For a global install, swap .claude/skills/ for ~/.claude/skills/ so every project of this user sees it.

Codex

Install to ~/.codex/skills/ppc-diagnosis/ 
mkdir -p ~/.codex/skills
unzip ppc-diagnosis.zip -d ~/.codex/skills/

How to verify Open a new codex session and ask it to list available skills — this pack showing up means it is live.

Codex only reads ~/.codex/skills/, not the project folder; on another machine you place it again.

Cursor

Install to .cursor/rules/ppc-diagnosis.mdc 
mkdir -p .cursor/rules
cp ppc-diagnosis/SKILL.md .cursor/rules/ppc-diagnosis.mdc

How to verify In chat, @ that rule file and ask what the pack's first hard rule is — a correct answer means it loaded.

Cursor has no separate skills folder: rules belong to the project, so you place them again per project — the biggest difference from the other two.

If it will not installNot opening a terminal at all? Paste the whole SKILL.md into the chat. Same result, you just re-paste it each new session.

Full steps and common errors live in the pack's playbook.md; the guides section also has ordering and usage guides。

How to use

4 steps; the first run takes about 10 minutes
  1. 1
    开工前准备 | 要做 | 怎么做 | 为什么 | |---|---|---| | 导出两份报表 | 广告活动报表 + 搜索词报表，同一日期区间（`export-guide.md` 有逐屏步骤） | 只有活动报表能算漏斗、算不了否定词；只有搜索词报表反过来 | | 备份原始文件 | 下载的两个 CSV 原封不动存一份到桌面 | 后面要用 Excel 打开核对行号，别把百分比格式改坏 | | 填一个数：回本线（毛利率） | 拿你自己的成本算：售价 − 采购 − 头程 − FBA 费 − 佣金，除以售价 | 这份报告里「超出回本线」「出价上限」两列全由它决定，填错全错 | | 先确认列名 | 用记事本（不要用 Excel 另存）打开 CSV 看第一行 | 表头被改过，第 1 关会直接报「认不出这是哪家的报表」 | 目录约定（本文
  2. 2
    装配 **Claude Code**：复制到项目的 `.claude/skills/`（没有就先建）。 **Codex CLI**：复制到 `.codex/skills/`。 **没有 shell / 不装 agent**：不用装。直接按本文第 3 节的四条命令跑脚本；想用对话方式，就把 `skills/<名字>/SKILL.md` 依次贴进对话，并把产出自己写进 CSV（报告格式参考 `templates/diagnosis-report.md`）。 装完确认（一条动作）：新开一个对话，问 **「列出你现在可用的 skills」**，应看到 `report-adapter`、`funnel-breakdown`、`negative-builder`。看不到就是目录放错了，见第 4 节第 1 条。
  3. 3
    触发顺序 四关必须按顺序，原因不是习惯，是数据依赖： 1. **先 `report-adapter`（活动报表），再 `funnel.py`**：第 2 关只认统一列。跳过第 1 关直接喂原始报表，`funnel.py` 会报「读不到 campaign 列」；就算你手工改了列名，`7 Day Total Sales `（尾随空格）也大概率没改，ACOS 会整列空掉。 反例：一位同事用 Excel 把 `7 Day Total Sales ` 改成 `sales` 之后跑通了，但把「广告组粒度」的两行当成了两个活动，预算被算成两倍——数字看着正常，结论是反的。 2. **先 `funnel.py`，再 `budget_bid.py`**：预算和出价诊断都要用到「回本线 × 客单价 × CVR」这个上限，客单价与 CVR 来
  4. 4
    每一步的输入与输出 ### 第 1 关 report-adapter | 项 | 内容 | |---|---| | 输入 | 后台导出的原始 CSV（Amazon 活动报表 / 搜索词报表、Google 广告系列 / 搜索词报表、Meta 广告系列报表） | | 命令 | `python3 skills/report-adapter/scripts/adapt.py --input before/campaign-report.csv --out after/normalized-campaign.csv --out-report after/mapping-report.md` | | 中间产物 | 无（单步） | | 输出 | `after/normalized-campaign.csv`（18 列）+ `after/mapp

Reviews

Only verified buyers count; we do not edit, delete or pad them.
No reviews yet — buyers can review after purchase

This pack just launched and nobody has reviewed it yet. Once real buyers do, the stars, text and 1–5 distribution appear here; until then the rating shows an em dash instead of a made-up score.

Changelog

Updates are free while subscribed; a buyout includes later versions of this skill
v0.1.0 2026-10-24 按包内 manifest.json 上架

How to buy

Subscribe or buy outright — a buyout means no more subscription fees
Cancel anytime

Monthly

¥39 / mo

Try it for a month first

  • ✓ “广告诊断包（ACOS / CPC / 不出单）” — all files, samples and install instructions
  • ✓ Every skill unlocked while subscribed (including new releases)
  • ✓ Commercial licence: client work allowed, unlimited deliveries
  • ✓ Version updates pushed automatically, no repurchase
  • ✓ 1:1 support on Telegram, replies within 12 hours on business days
  • ✓ Cancel anytime, no next-period charge
Save 36% Most popular

Yearly

¥299 / yr

Pay for a year; prices are never converted to a monthly figure.

  • ✓ “广告诊断包（ACOS / CPC / 不出单）” — all files, samples and install instructions
  • ✓ Every skill unlocked while subscribed (including new releases)
  • ✓ Commercial licence: client work allowed, unlimited deliveries
  • ✓ Version updates pushed automatically, no repurchase
  • ✓ 1:1 support on Telegram, replies within 12 hours on business days
  • ✓ Cancel anytime, no next-period charge
One payment · founder price Founder price

Lifetime

¥899 / one-time

The founder price rises as the skill library grows.

  • ✓ “广告诊断包（ACOS / CPC / 不出单）” — all files, samples and install instructions
  • ✓ Every skill unlocked while subscribed (including new releases)
  • ✓ Commercial licence: client work allowed, unlimited deliveries
  • ✓ Version updates pushed automatically, no repurchase
  • ✓ 1:1 support on Telegram, replies within 12 hours on business days
  • ✓ No subscription or renewals — one payment, forever

No price conversion: yearly plans only show the saving, never a per-month figure. A buyout is one payment with no renewals.

FAQ

How do I install it into my agent?
Unzip the ZIP inside your project and put the folder into your agent skills directory (Claude Code: .claude/skills/, Codex: ~/.codex/skills/), then restart the session.
What does it depend on?
Just an agent that can read files. For images or video, connect your own generation tool; the skill ships with parameter templates.
Can I get a refund?
No no-reason refunds after digital delivery. If files are missing or broken, we verify within 48 hours and replace or refund.