← 返回 Skills 市场
114
总下载
2
收藏
1
当前安装
3
版本数
在 OpenClaw 中安装
/install ad-analyzer-yima
功能描述
广告投放数据分析。当用户上传 Excel/CSV 广告报表，或说"帮我分析投放数据/看看这个报表/哪个计划效果差/数据有没有问题"时触发。自动识别所有表头列，无需预设字段名，汇总全部指标，检测异常，生成可视化图表，输出分析报告和优化建议。支持巨量引擎、腾讯广告、Meta Ads、Google Ads、快手等平台导...
使用说明 (SKILL.md)
广告数据分析 Skill
分析用户上传的广告报表，自动识别所有列，汇总指标，检测异常，生成图表，输出优化建议。
Setup
无需任何配置，开箱即用。支持 .xlsx / .xls / .csv，兼容 UTF-8 / GBK 编码。
Usage
用户上传文件后，将完整分析脚本保存为文件再执行。不要用 -c 内联方式运行，内联模式不支持多行缩进代码。
正确执行方式：
# 第一步：把 scripts/analyze.py 脚本保存到本地
# 第二步：执行
python3 analyze.py --file /path/to/report.xlsx --out ./charts
分析脚本说明
脚本位于 scripts/analyze.py，执行后自动完成以下步骤：
- 读取文件 — 自动识别 xlsx/xls/csv，自动尝试 utf-8/gbk 编码
- 识别列类型 — 自动区分日期列、维度列（文字）、指标列（数值），不预设列名
- 汇总指标 — 所有数值列的合计、均值、最大值、最小值
- 分组分析 — 按每个维度列分组汇总，自动排序
- 异常检测 — 均值 ±2 倍标准差自动标记异常行
- 生成图表 — 输出 5 张 PNG 图表
- 输出建议 — 基于数据给出具体优化方向
图表输出
| 文件名 | 内容 |
|---|---|
| chart_1_totals.png | 各指标总量柱状图 |
| chart_2_dim_compare.png | 主维度横向对比图 |
| chart_3_trend.png | 指标趋势折线图（有日期列时） |
| chart_4_correlation.png | 指标相关性热力图（指标≥3时） |
| chart_5_pie.png | 主维度占比饼图 |
Notes
- 必须保存为
.py文件执行，不支持python3 -c内联模式 - 完全动态识别列名，表头是什么分析什么，一列不漏
- 数据不外传，完全本地处理
- 编码自动识别，兼容国内广告平台导出文件
Examples
分析巨量引擎报表：
python3 analyze.py --file ~/Downloads/report.xlsx --out ~/Desktop/charts
分析腾讯广告 CSV：
python3 analyze.py --file ~/Downloads/tencent.csv --out ~/Desktop/charts
安全使用建议
This skill appears to do only local analysis and charting. Before running: (1) review the included scripts/analyze.py yourself (it is small and readable); (2) install the listed Python packages from trusted sources (pip) if needed; (3) run it locally on your machine (python3 analyze.py --file /path/to/report.xlsx --out ./charts) — the script writes PNGs to the output folder and prints reports to stdout; (4) avoid processing files containing sensitive secrets you don't want stored locally (the script will read the spreadsheet contents and save charts locally); (5) note that Excel macros are not executed by this script, but you should still avoid opening untrusted files in other applications. Overall, the skill is internally consistent and does not request network access or credentials.
功能分析
Type: OpenClaw Skill
Name: ad-analyzer-yima
Version: 1.0.2
The skill bundle is a legitimate advertising data analysis tool. The Python script (scripts/analyze.py) uses standard libraries like pandas, matplotlib, and seaborn to process local Excel/CSV files, detect anomalies, and generate visualization charts without any network activity, data exfiltration, or suspicious execution patterns. The instructions in SKILL.md are consistent with the code's functionality and emphasize local data processing.
能力评估
Purpose & Capability
Name/description (广告数据分析) match the included script and SKILL.md: the script loads Excel/CSV, auto-detects columns, computes summaries, detects anomalies, generates PNG charts and prints suggestions. Required binaries (python3) and the declared Python packages are appropriate for the stated functionality.
Instruction Scope
SKILL.md instructs the user to save and run scripts/analyze.py locally and the script's operations are limited to reading the provided file, computing analyses, and saving charts to the specified output directory. The instructions do not ask to read unrelated system files, environment variables, or to transmit data externally. The SKILL.md explicitly states data is processed locally, which aligns with the code.
Install Mechanism
There is no install spec (instruction-only), which minimizes risk. The SKILL.md metadata lists pip dependencies (pandas, openpyxl, xlrd, matplotlib, seaborn) — these are appropriate for Excel/CSV parsing and plotting; the user must install them locally. No downloads from untrusted URLs or archive extraction are present.
Credentials
The skill requests no environment variables, credentials, or config paths. The script does not access os.environ or other secrets; its file I/O is limited to the provided report and the specified output directory.
Persistence & Privilege
The skill does not request permanent presence (always:false) and does not modify other skills or system-wide configuration. It runs as a local script when invoked and writes outputs only to the provided output directory.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install ad-analyzer-yima - 安装完成后，直接呼叫该 Skill 的名称或使用
/ad-analyzer-yima触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.2
**New version adds automated data visualization and script-based analysis.**
- Added scripts/analyze.py for one-click automated广告报表分析 and图表生成功能.
- 现支持自动输出 5 张 PNG 图表（数据总量柱状图、维度对比、趋势线、指标相关性热力图、主维度饼图）.
- 增强依赖声明，集成 pandas、openpyxl、xlrd、matplotlib、seaborn.
- 强调仅支持保存为 .py 文件运行，内联 (python3 -c) 不再适用.
- 更新说明文档，细化分析流程与图表输出位置.
v1.0.1
- Added pip install requirements for pandas, openpyxl, and xlrd to improve compatibility with Excel/CSV file formats.
- No changes to core functionality, API, or usage.
- All analytics features and workflows remain the same.
v1.0.0
- Initial release of ad-analyzer-yima for ad campaign data analysis.
- Automatically detects all columns and aggregates all metrics in uploaded Excel/CSV ad reports.
- Identifies dimension, date, and numeric columns without preset field names; supports multiple ad platforms’ export formats.
- Performs anomaly detection, trend analysis, and groups data by dimensions for detailed reporting.
- Outputs a complete analysis report with findings and optimization suggestions, fully compatible with UTF-8/GBK encoding.
- No setup required; supports large files and does not transmit data externally.
元数据
常见问题
广告数据分析 是什么？
广告投放数据分析。当用户上传 Excel/CSV 广告报表，或说"帮我分析投放数据/看看这个报表/哪个计划效果差/数据有没有问题"时触发。自动识别所有表头列，无需预设字段名，汇总全部指标，检测异常，生成可视化图表，输出分析报告和优化建议。支持巨量引擎、腾讯广告、Meta Ads、Google Ads、快手等平台导... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 114 次。
如何安装 广告数据分析？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install ad-analyzer-yima」即可一键安装，无需额外配置。
广告数据分析 是免费的吗？
是的，广告数据分析 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
广告数据分析 支持哪些平台？
广告数据分析 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 广告数据分析？
由 Ming0429（@ming0429）开发并维护，当前版本 v1.0.2。
推荐 Skills