SKILLEMALL.ai

AF ali-promotion-roi

Analyze Alibaba International (alibaba.com) promotion ROI - evaluates total promotion spend vs. actual completed orders and revenue. Use when the user asks about Alibaba 国际站推广投入产出, 推广 ROI, 阿里广告效果分析, 标准推广/全站推广效果对比, 月度推广总结, or wants to know how much each completed order costs (CPO). Reads pre-loaded data from MySQL via sql-linker-cli (tables: alibaba_intl_orders + alibaba_intl_promotion_daily). Does NOT load data - that requires separate ingestion scripts.

ClawHub Agent Skills author: CoderHanS v1.0.2 MIT-0 6 files body ≈ 1 063 tokens Open the sourceclawhub.ai analyzed 2 d ago

Analyze Alibaba International (alibaba.com) promotion ROI - evaluates total promotion spend vs. actual completed orders and revenue. Use when the user asks…

As a process F 60/100 · Will not run — References files that are not bundled: scripts/alibaba_intl/load_orders.py

AnalyzerMySQLData and analyticstype and topics are labelled automatically from the skill text
JSON
Technical rating
A
95/100
safety, quality, tests
Safety 60%
100
Quality 40%
88
Run on models
none yet
Process rating
F
60/100
Will not run
References files that are not bundled: scripts/alibaba_intl/load_orders.py
Tools and files w 18
0
Failures and branches w 10
0
Running it twice w 4
30
the three weakest of ten parameters · all ten

How to improve

  1. The text references files that are not there: add them or drop the references.
For the model run — optional
  • Your own cases (evals/evals.json, 4–6 real requests with expected answers): the full check would then run those instead of a model-drafted suite.
  • A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.

Guard findings · 0

✓ No critical or high findings

Files scanned: 6. Evidence is masked. Grey chips explain why severity was lowered.

Against the Agent Skills spec

  • warning missing-ref reference to a missing file: scripts/alibaba_intl/load_orders.py

Process rating: all ten parameters 60/100

Will not run. References files that are not bundled: scripts/alibaba_intl/load_orders.py
  • 0Tools and files. 1 referenced file(s) missing: scripts/alibaba_intl/load_orders.py
  • 0Failures and branches. Linear process with no failure handling
  • 30Running it twice. 1 mutating operations with no state check
  • 60Result and completion. Output format stated, no completion criterion
  • 70Inputs and preconditions. Inputs and preconditions are listed
  • 100Steps. 20 steps
  • 100When it triggers. States when to use and when not to
  • 100Consistency. Name and required fields are in place
  • 100Execution cost. Instruction body is 1063 tokens
  • 100Progress reporting. Reports progress

Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.

Quality signals

  • +5Description has no quoted example phrases that should trigger the skill
  • +4Description does not say when NOT to use the skill (false activations)
  • +1No license
  • +2Single-language instructions
  • +3Description length 458: enough signal without eating the budget
  • +4Structure: 10 headings
  • +3Step-by-step instructions: 20 items
  • +3Output format is stated explicitly
  • +4Has examples (2 code blocks)
  • +4Reference files are cited in the instructions (2 of 2)
  • +3All 2 scripts are documented

Quality base 70; lint remarks subtract, signals add up to 100. Result: 88.

External checks

ClawHub: clean
This skill is a read-only Alibaba promotion ROI reporter that clearly discloses its database access, though users should notice it automatically approves DB credential use through sql-linker-cli.
LLM: benign (high) · VirusTotal: · 22 Jul 2026