← Back to Skills Marketplace
114
Downloads
2
Stars
1
Active Installs
3
Versions
Install in OpenClaw
/install ad-analyzer-yima
Description
广告投放数据分析。当用户上传 Excel/CSV 广告报表，或说"帮我分析投放数据/看看这个报表/哪个计划效果差/数据有没有问题"时触发。自动识别所有表头列，无需预设字段名，汇总全部指标，检测异常，生成可视化图表，输出分析报告和优化建议。支持巨量引擎、腾讯广告、Meta Ads、Google Ads、快手等平台导...
README (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
Usage Guidance
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.
Capability Analysis
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.
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install ad-analyzer-yima - After installation, invoke the skill by name or use
/ad-analyzer-yima - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is 广告数据分析?
广告投放数据分析。当用户上传 Excel/CSV 广告报表，或说"帮我分析投放数据/看看这个报表/哪个计划效果差/数据有没有问题"时触发。自动识别所有表头列，无需预设字段名，汇总全部指标，检测异常，生成可视化图表，输出分析报告和优化建议。支持巨量引擎、腾讯广告、Meta Ads、Google Ads、快手等平台导... It is an AI Agent Skill for Claude Code / OpenClaw, with 114 downloads so far.
How do I install 广告数据分析?
Run "/install ad-analyzer-yima" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is 广告数据分析 free?
Yes, 广告数据分析 is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does 广告数据分析 support?
广告数据分析 is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created 广告数据分析?
It is built and maintained by Ming0429 (@ming0429); the current version is v1.0.2.
More Skills