aiskillstore/marketplace / skills/aaron-he-zhu/roi-calculator
roi-calculator
VerifiedUse when the user asks to "calculate influencer ROI", "prove campaign value", or "what was our ROAS"; produces direct ROI/ROAS, earned media value, attribution-modeled revenue, LTV-based ROI, and a stakeholder-ready summary. Not for building the full slide/written report β use report-generator.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 11.9 KB |
| references/roi-templates.md | markdown | 12.3 KB |
| skill-report.json | config | 51.6 KB |
skill-report.json
View on GitHub{
"schema_version": "2.0",
"meta": {
"generated_at": "2026-07-12T13:51:34.400Z",
"slug": "aaron-he-zhu-roi-calculator",
"source_url": "https://github.com/aaron-he-zhu/aaron-marketing-skills/tree/main/influencer/measure/roi-calculator",
"source_ref": "main",
"model": "codex",
"analysis_version": "3.0.0",
"source_type": "community",
"content_hash": "b5ac97a21715532fba13425a37393d1e65dc40f099738210eca71b5506f0f9c6",
"tree_hash": "67e28a0c0c96693d949d5a303478be81b3982ad0310a7437e3be54c8bc34e30c",
"provenance": {
"model_effective": "codex",
"fallback_chain": [
{
"agent": "codex",
"outcome": "success"
}
],
"analysis_version": "3.0.0"
}
},
"skill": {
"name": "roi-calculator",
"description": "Calculates influencer campaign ROI, ROAS, earned media value, cost efficiency, attribution scenarios, and lifetime value impact from supplied campaign data.",
"summary": "Measure influencer campaign returns with transparent formulas, assumptions, comparisons, and recommendations.",
"icon": "π¦",
"version": "13.0.3",
"author": "aaron-he-zhu",
"license": "Apache-2.0",
"category": "data",
"tags": [
"roi-calculator",
"influencer-marketing",
"campaign-measurement",
"roas",
"marketing-analytics"
],
"supported_tools": [
"claude",
"codex",
"claude-code"
],
"risk_factors": [
"external_commands",
"filesystem",
"network"
]
},
"security_audit": {
"risk_level": "safe",
"is_blocked": false,
"safe_to_publish": true,
"analysis_status": "ok",
"summary": "Most static findings are false positives caused by Markdown links, code fences, placeholders, and ordinary marketing terms. Three findings confirm one underlying behavior: the skill uses shell substitution and invokes a repository-local Python scoring script.",
"remediation": [
{
"issue": "The repository-root fallback can select scripts from the current project instead of a trusted skill installation.",
"suggestion": "Require a validated plugin root and stop when it is unavailable instead of falling back to the current Git repository.",
"severity": "medium"
},
{
"issue": "The optional C3 workflow invokes a local Python scorer.",
"suggestion": "Request execution approval, verify the resolved script is inside the trusted installation, and pass validated file arguments without shell interpolation.",
"severity": "medium"
}
],
"risk_factor_evidence": [
{
"factor": "external_commands",
"evidence": [
{
"file": "references/roi-templates.md",
"line_start": 164,
"line_end": 177
},
{
"file": "SKILL.md",
"line_start": 20,
"line_end": 20
},
{
"file": "SKILL.md",
"line_start": 26,
"line_end": 28
},
{
"file": "SKILL.md",
"line_start": 28,
"line_end": 32
},
{
"file": "SKILL.md",
"line_start": 32,
"line_end": 34
},
{
"file": "SKILL.md",
"line_start": 34,
"line_end": 38
},
{
"file": "SKILL.md",
"line_start": 38,
"line_end": 39
},
{
"file": "SKILL.md",
"line_start": 39,
"line_end": 55
},
{
"file": "SKILL.md",
"line_start": 55,
"line_end": 56
},
{
"file": "SKILL.md",
"line_start": 56,
"line_end": 57
},
{
"file": "SKILL.md",
"line_start": 57,
"line_end": 58
},
{
"file": "SKILL.md",
"line_start": 58,
"line_end": 84
},
{
"file": "SKILL.md",
"line_start": 84,
"line_end": 84
},
{
"file": "SKILL.md",
"line_start": 86,
"line_end": 88
},
{
"file": "SKILL.md",
"line_start": 88,
"line_end": 90
},
{
"file": "SKILL.md",
"line_start": 90,
"line_end": 92
},
{
"file": "SKILL.md",
"line_start": 92,
"line_end": 94
},
{
"file": "SKILL.md",
"line_start": 94,
"line_end": 94
},
{
"file": "SKILL.md",
"line_start": 96,
"line_end": 104
},
{
"file": "SKILL.md",
"line_start": 104,
"line_end": 135
},
{
"file": "SKILL.md",
"line_start": 84,
"line_end": 84
},
{
"file": "SKILL.md",
"line_start": 84,
"line_end": 84
}
]
},
{
"factor": "filesystem",
"evidence": [
{
"file": "references/roi-templates.md",
"line_start": 3,
"line_end": 3
},
{
"file": "SKILL.md",
"line_start": 20,
"line_end": 20
},
{
"file": "SKILL.md",
"line_start": 45,
"line_end": 45
},
{
"file": "SKILL.md",
"line_start": 49,
"line_end": 49
},
{
"file": "SKILL.md",
"line_start": 60,
"line_end": 60
},
{
"file": "SKILL.md",
"line_start": 84,
"line_end": 84
},
{
"file": "SKILL.md",
"line_start": 88,
"line_end": 88
},
{
"file": "SKILL.md",
"line_start": 94,
"line_end": 94
},
{
"file": "SKILL.md",
"line_start": 142,
"line_end": 142
},
{
"file": "SKILL.md",
"line_start": 143,
"line_end": 143
},
{
"file": "SKILL.md",
"line_start": 144,
"line_end": 144
},
{
"file": "SKILL.md",
"line_start": 145,
"line_end": 145
},
{
"file": "SKILL.md",
"line_start": 146,
"line_end": 146
},
{
"file": "SKILL.md",
"line_start": 147,
"line_end": 147
},
{
"file": "SKILL.md",
"line_start": 148,
"line_end": 148
},
{
"file": "SKILL.md",
"line_start": 149,
"line_end": 149
},
{
"file": "SKILL.md",
"line_start": 150,
"line_end": 150
},
{
"file": "SKILL.md",
"line_start": 154,
"line_end": 154
},
{
"file": "SKILL.md",
"line_start": 158,
"line_end": 158
},
{
"file": "SKILL.md",
"line_start": 159,
"line_end": 159
},
{
"file": "SKILL.md",
"line_start": 84,
"line_end": 84
}
]
},
{
"factor": "network",
"evidence": [
{
"file": "SKILL.md",
"line_start": 10,
"line_end": 10
},
{
"file": "SKILL.md",
"line_start": 13,
"line_end": 13
}
]
}
],
"static_findings": [
{
"id": "external_commands:references/roi-templates.md:164:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "references/roi-templates.md",
"line_start": 164,
"line_end": 177,
"snippet": "**Comparison result**: [above/below/equal/pending]. Use `pending` when the target is absent, stale, "
},
{
"id": "filesystem:references/roi-templates.md:3:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "references/roi-templates.md",
"line_start": 3,
"line_end": 3,
"snippet": "Fill-in templates for each methodology in [../SKILL.md](../SKILL.md) Instructions, plus the worked e"
},
{
"id": "blocker:references/roi-templates.md:21:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/roi-templates.md",
"line_start": 21,
"line_end": 21,
"snippet": "| Paid amplification | $[X] |"
},
{
"id": "blocker:references/roi-templates.md:85:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/roi-templates.md",
"line_start": 85,
"line_end": 85,
"snippet": "EMV estimates the equivalent paid media cost to achieve the same results."
},
{
"id": "blocker:references/roi-templates.md:173:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/roi-templates.md",
"line_start": 173,
"line_end": 173,
"snippet": "| Paid Social | $[X] | [source/date] | [yes/no] | [+/-X% or pending] |"
},
{
"id": "blocker:references/roi-templates.md:174:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/roi-templates.md",
"line_start": 174,
"line_end": 174,
"snippet": "| Paid Search | $[X] | [source/date] | [yes/no] | [+/-X% or pending] |"
},
{
"id": "blocker:references/roi-templates.md:266:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "references/roi-templates.md",
"line_start": 266,
"line_end": 266,
"snippet": "| Indicator | Influencer-Acquired | Organic | Paid Ads |"
},
{
"id": "external_commands:SKILL.md:20:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 20,
"line_end": 20,
"snippet": "> **Cross-discipline (paid ads):** this is the shared **return-math engine** for paid ads β [paid-me"
},
{
"id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 26,
"line_end": 28,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:28:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 28,
"line_end": 32,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:32:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 32,
"line_end": 34,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:34:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 34,
"line_end": 38,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:38:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 38,
"line_end": 39,
"snippet": "- **Reads**: campaign spend breakdown, results data (reach, impressions, engagements, clicks, conver"
},
{
"id": "external_commands:SKILL.md:39:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 39,
"line_end": 55,
"snippet": "- **Writes**: ROI calculation file at `memory/influencer/roi-calculator/YYYY-MM-DD-<topic>.md` conta"
},
{
"id": "external_commands:SKILL.md:55:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 55,
"line_end": 56,
"snippet": "- `~~social platform analytics` β reach, impressions, engagements, video views per platform for EMV "
},
{
"id": "external_commands:SKILL.md:56:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 56,
"line_end": 57,
"snippet": "- `~~ecommerce / analytics` β revenue, conversions, link clicks, and AOV for direct ROI and attribut"
},
{
"id": "external_commands:SKILL.md:57:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 57,
"line_end": 58,
"snippet": "- `~~CRM` β new-customer counts, repeat-purchase rate, and lifetime value for LTV-based ROI."
},
{
"id": "external_commands:SKILL.md:58:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 58,
"line_end": 84,
"snippet": "- `~~influencer database` β per-influencer fees and tier data for by-influencer ROI."
},
{
"id": "external_commands:SKILL.md:84:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 84,
"line_end": 84,
"snippet": "Declare goal, profile `roi-<goal>`, `scope: roi`, `assessment_time: forecast|actual`, campaign `roll"
},
{
"id": "external_commands:SKILL.md:86:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 86,
"line_end": 88,
"snippet": "ROI.I3 Fail emits `results-unverified`; report I1/I2/R1/R2 as low-confidence and do not make attribu"
},
{
"id": "external_commands:SKILL.md:88:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 88,
"line_end": 90,
"snippet": "For CVI, combine complete typed ACE results from [fit-scorer](../../discover/fit-scorer/SKILL.md), c"
},
{
"id": "external_commands:SKILL.md:90:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 90,
"line_end": 92,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:92:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 92,
"line_end": 94,
"snippet": "```"
},
{
"id": "external_commands:SKILL.md:94:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 94,
"line_end": 94,
"snippet": "Use the typed [`c3-rollup.schema.json`](../../../references/c3-rollup.schema.json) `components` form"
},
{
"id": "external_commands:SKILL.md:96:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 96,
"line_end": 104,
"snippet": "10. **Persist only with permission** β save under `memory/influencer/roi-calculator/` (or the paid p"
},
{
"id": "external_commands:SKILL.md:104:ruby-shell-backtick-execution",
"category": "external_commands",
"severity": "medium",
"pattern": "Ruby/shell backtick execution",
"file": "SKILL.md",
"line_start": 104,
"line_end": 135,
"snippet": "```markdown"
},
{
"id": "external_commands:SKILL.md:84:shell-command-substitution",
"category": "external_commands",
"severity": "medium",
"pattern": "Shell command substitution",
"file": "SKILL.md",
"line_start": 84,
"line_end": 84,
"snippet": "Declare goal, profile `roi-<goal>`, `scope: roi`, `assessment_time: forecast|actual`, campaign `roll"
},
{
"id": "external_commands:SKILL.md:84:template-literal-with-command-substitution",
"category": "external_commands",
"severity": "medium",
"pattern": "Template literal with command substitution",
"file": "SKILL.md",
"line_start": 84,
"line_end": 84,
"snippet": "Declare goal, profile `roi-<goal>`, `scope: roi`, `assessment_time: forecast|actual`, campaign `roll"
},
{
"id": "network:SKILL.md:10:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "SKILL.md",
"line_start": 10,
"line_end": 10,
"snippet": "homepage: \"https://github.com/aaron-he-zhu/aaron-marketing-skills\""
},
{
"id": "network:SKILL.md:13:hardcoded-url",
"category": "network",
"severity": "low",
"pattern": "Hardcoded URL",
"file": "SKILL.md",
"line_start": 13,
"line_end": 13,
"snippet": "metadata: {\"author\": \"aaron-he-zhu\", \"version\": \"17.0.0\", \"discipline\": \"influencer\", \"phase\": \"meas"
},
{
"id": "filesystem:SKILL.md:20:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 20,
"line_end": 20,
"snippet": "> **Cross-discipline (paid ads):** this is the shared **return-math engine** for paid ads β [paid-me"
},
{
"id": "filesystem:SKILL.md:45:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 45,
"line_end": 45,
"snippet": "- **Primary next skill**: [report-generator](../report-generator/SKILL.md)"
},
{
"id": "filesystem:SKILL.md:49:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 49,
"line_end": 49,
"snippet": "> Emit the standard shape from [skill-contract.md Β§Handoff Summary Format](../../../references/skill"
},
{
"id": "filesystem:SKILL.md:60:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 60,
"line_end": 60,
"snippet": "With zero integrations, supply the investment and results tables by hand and the skill still produce"
},
{
"id": "filesystem:SKILL.md:84:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 84,
"line_end": 84,
"snippet": "Declare goal, profile `roi-<goal>`, `scope: roi`, `assessment_time: forecast|actual`, campaign `roll"
},
{
"id": "filesystem:SKILL.md:88:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 88,
"line_end": 88,
"snippet": "For CVI, combine complete typed ACE results from [fit-scorer](../../discover/fit-scorer/SKILL.md), c"
},
{
"id": "filesystem:SKILL.md:94:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 94,
"line_end": 94,
"snippet": "Use the typed [`c3-rollup.schema.json`](../../../references/c3-rollup.schema.json) `components` form"
},
{
"id": "filesystem:SKILL.md:142:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 142,
"line_end": 142,
"snippet": "- [measurement-protocol.md](../../../references/measurement-protocol.md) β read ROI/CVI deltas again"
},
{
"id": "filesystem:SKILL.md:143:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 143,
"line_end": 143,
"snippet": "- [skill-contract.md](../../../references/skill-contract.md) β shared contract and Handoff Summary f"
},
{
"id": "filesystem:SKILL.md:144:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 144,
"line_end": 144,
"snippet": "- [state-model.md](../../../references/state-model.md) β memory tiers and save-path conventions."
},
{
"id": "filesystem:SKILL.md:145:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 145,
"line_end": 145,
"snippet": "- [CONNECTORS.md](../../../CONNECTORS.md) β free/keyless data recipe per connector category."
},
{
"id": "filesystem:SKILL.md:146:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 146,
"line_end": 146,
"snippet": "- C3 scoring: [c3-benchmark.md](../../../references/c3-benchmark.md), [c3/roi-campaign-benchmark.md]"
},
{
"id": "filesystem:SKILL.md:147:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 147,
"line_end": 147,
"snippet": "- [performance-analyzer](../performance-analyzer/SKILL.md) β supplies the results data this skill co"
},
{
"id": "filesystem:SKILL.md:148:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 148,
"line_end": 148,
"snippet": "- [report-generator](../report-generator/SKILL.md) β wraps these numbers into a full report."
},
{
"id": "filesystem:SKILL.md:149:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 149,
"line_end": 149,
"snippet": "- [budget-optimizer](../../plan/budget-optimizer/SKILL.md) β uses ROI output to reallocate spend."
},
{
"id": "filesystem:SKILL.md:150:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 150,
"line_end": 150,
"snippet": "- [campaign-planner](../../plan/campaign-planner/SKILL.md) β sets the ROI targets these results are "
},
{
"id": "filesystem:SKILL.md:154:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 154,
"line_end": 154,
"snippet": "**Primary**: [report-generator](../report-generator/SKILL.md) β turn the ROI numbers into a stakehol"
},
{
"id": "filesystem:SKILL.md:158:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 158,
"line_end": 158,
"snippet": "- [performance-analyzer](../performance-analyzer/SKILL.md) β go back for deeper performance breakdow"
},
{
"id": "filesystem:SKILL.md:159:path-traversal-sequence",
"category": "filesystem",
"severity": "high",
"pattern": "Path traversal sequence",
"file": "SKILL.md",
"line_start": 159,
"line_end": 159,
"snippet": "- [budget-optimizer](../../plan/budget-optimizer/SKILL.md) β feed by-influencer and by-tier ROI into"
},
{
"id": "filesystem:SKILL.md:84:standard-device-file-access",
"category": "filesystem",
"severity": "low",
"pattern": "Standard device file access",
"file": "SKILL.md",
"line_start": 84,
"line_end": 84,
"snippet": "Declare goal, profile `roi-<goal>`, `scope: roi`, `assessment_time: forecast|actual`, campaign `roll"
},
{
"id": "blocker:SKILL.md:20:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "SKILL.md",
"line_start": 20,
"line_end": 20,
"snippet": "> **Cross-discipline (paid ads):** this is the shared **return-math engine** for paid ads β [paid-me"
},
{
"id": "blocker:SKILL.md:96:system-reconnaissance",
"category": "blocker",
"severity": "low",
"pattern": "System reconnaissance",
"file": "SKILL.md",
"line_start": 96,
"line_end": 96,
"snippet": "10. **Persist only with permission** β save under `memory/influencer/roi-calculator/` (or the paid p"
}
],
"finding_verdicts": [
{
"id": "external_commands:references/roi-templates.md:164:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The backticks format the literal status value `pending` in Markdown. No shell or Ruby command is present."
},
{
"id": "filesystem:references/roi-templates.md:3:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The parent-directory sequence appears only in a relative Markdown link to SKILL.md. It does not construct or access a user-controlled filesystem path."
},
{
"id": "blocker:references/roi-templates.md:21:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line is a campaign budget template row for paid amplification. It does not inspect the host system."
},
{
"id": "blocker:references/roi-templates.md:85:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line defines earned media value using paid media costs. It contains no reconnaissance instruction."
},
{
"id": "blocker:references/roi-templates.md:173:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line is a placeholder row comparing influencer results with paid social. It does not query system information."
},
{
"id": "blocker:references/roi-templates.md:174:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line is a placeholder row comparing influencer results with paid search. It does not query system information."
},
{
"id": "blocker:references/roi-templates.md:266:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "Paid Ads is a marketing channel heading in a customer-quality table. No host discovery or reconnaissance occurs."
},
{
"id": "external_commands:SKILL.md:20:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.98,
"reason": "Backticks format a memory path, while parent-directory text belongs to Markdown links. The line does not invoke a command."
},
{
"id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The detected backticks are a Markdown code fence around a natural-language example. They are not Ruby execution syntax."
},
{
"id": "external_commands:SKILL.md:28:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The detected characters close a Markdown example block. No executable command is specified."
},
{
"id": "external_commands:SKILL.md:32:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is the opening fence for a plain-language prompt example. It is documentation, not shell execution."
},
{
"id": "external_commands:SKILL.md:34:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This line closes a Markdown prompt example. It contains no command interpreter or executable content."
},
{
"id": "external_commands:SKILL.md:38:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.98,
"reason": "The line describes campaign data inputs and formats a skill name in Markdown. It does not execute that name."
},
{
"id": "external_commands:SKILL.md:39:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.98,
"reason": "Backticks delimit a documented output path. The write behavior is permission-gated elsewhere and this line contains no command."
},
{
"id": "external_commands:SKILL.md:55:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The backticks label an optional social analytics connector category. They do not invoke a program."
},
{
"id": "external_commands:SKILL.md:56:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The backticks label an optional ecommerce analytics connector category. No executable syntax is present."
},
{
"id": "external_commands:SKILL.md:57:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The backticks format the CRM connector label in prose. The line does not run a command."
},
{
"id": "external_commands:SKILL.md:58:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The backticks format the influencer database connector label. No command execution is requested."
},
{
"id": "external_commands:SKILL.md:84:ruby-shell-backtick-execution",
"verdict": "confirmed",
"confidence": 0.96,
"reason": "The line explicitly resolves a repository root with shell substitution and invokes a local Python scoring script. The Git-root fallback may select project-controlled executable code.",
"severity": "medium"
},
{
"id": "external_commands:SKILL.md:86:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "Backticks format a result-state label in explanatory prose. No command appears on this line."
},
{
"id": "external_commands:SKILL.md:88:ruby-shell-backtick-execution",
"verdict": "confirmed",
"confidence": 0.94,
"reason": "Although Markdown backticks delimit the text, the content directs the agent to run python3 against a resolved local script. This is intentional external command execution.",
"severity": "medium"
},
{
"id": "external_commands:SKILL.md:90:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line opens a fenced block containing a mathematical formula. It is not an executable shell block."
},
{
"id": "external_commands:SKILL.md:92:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line closes the mathematical formula block. It contains no command."
},
{
"id": "external_commands:SKILL.md:94:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.98,
"reason": "Backticks format schema names and status values in documentation. No command is invoked on this line."
},
{
"id": "external_commands:SKILL.md:96:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.98,
"reason": "The backticks format a permitted output directory. This instruction requires authorization and does not contain an external command."
},
{
"id": "external_commands:SKILL.md:104:ruby-shell-backtick-execution",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line starts a fenced Markdown output example. It does not execute the example."
},
{
"id": "external_commands:SKILL.md:84:shell-command-substitution",
"verdict": "confirmed",
"confidence": 0.99,
"reason": "The AARON_SKILLS_ROOT assignment contains explicit $(git rev-parse ...) shell command substitution. It runs Git and then uses the resulting path for local script execution.",
"severity": "medium"
},
{
"id": "external_commands:SKILL.md:84:template-literal-with-command-substitution",
"verdict": "false_positive",
"confidence": 0.97,
"reason": "The line contains a shell assignment inside Markdown, not a programming-language template literal. Its real shell behavior is already captured by the command-substitution finding."
},
{
"id": "network:SKILL.md:10:hardcoded-url",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The URL is passive homepage metadata for the skill repository. There is no request, download, or data transmission."
},
{
"id": "network:SKILL.md:13:hardcoded-url",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The URL appears in package metadata as the project homepage. It does not initiate network access."
},
{
"id": "filesystem:SKILL.md:20:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.98,
"reason": "The parent-directory sequences occur in relative Markdown links to related skills. They are fixed documentation paths, not user-controlled traversal."
},
{
"id": "filesystem:SKILL.md:45:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The sequence is a fixed relative Markdown link to report-generator. It does not perform filesystem traversal."
},
{
"id": "filesystem:SKILL.md:49:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The sequence is a relative documentation link to a shared contract. No path is assembled from untrusted input."
},
{
"id": "filesystem:SKILL.md:60:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The sequence appears only in a fixed link to CONNECTORS.md. The line does not access arbitrary files."
},
{
"id": "filesystem:SKILL.md:84:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.95,
"reason": "The traversal sequence belongs to a fixed Markdown link to runtime documentation. The separate command execution on this line is covered by confirmed external-command findings."
},
{
"id": "filesystem:SKILL.md:88:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.98,
"reason": "The parent-directory segments are fixed links to related skill documentation. They are not derived from user input."
},
{
"id": "filesystem:SKILL.md:94:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The sequence is a fixed relative link to a schema file. It does not enable arbitrary path selection."
},
{
"id": "filesystem:SKILL.md:142:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed Markdown link to measurement protocol documentation. It is not runtime path traversal."
},
{
"id": "filesystem:SKILL.md:143:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed Markdown link to the shared skill contract. No untrusted path is accepted."
},
{
"id": "filesystem:SKILL.md:144:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed Markdown link to state model documentation. It does not read an arbitrary file."
},
{
"id": "filesystem:SKILL.md:145:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed Markdown link to CONNECTORS.md. It does not create a traversal primitive."
},
{
"id": "filesystem:SKILL.md:146:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The parent-directory segments appear in fixed links to benchmark and schema documents. No user-controlled path is used."
},
{
"id": "filesystem:SKILL.md:147:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed link to a sibling skill document. It does not access arbitrary filesystem content."
},
{
"id": "filesystem:SKILL.md:148:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed link to report-generator documentation. There is no uncontrolled traversal."
},
{
"id": "filesystem:SKILL.md:149:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed relative link to budget-optimizer documentation. It is not a runtime file operation."
},
{
"id": "filesystem:SKILL.md:150:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "This is a fixed relative link to campaign-planner documentation. No arbitrary path can be supplied."
},
{
"id": "filesystem:SKILL.md:154:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The sequence is a fixed Markdown link to a sibling skill. It does not cause filesystem access outside an intended package hierarchy."
},
{
"id": "filesystem:SKILL.md:158:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The sequence appears in a fixed link to performance-analyzer. It is documentation, not a user-controlled filesystem operation."
},
{
"id": "filesystem:SKILL.md:159:path-traversal-sequence",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The sequence appears in a fixed link to budget-optimizer. It does not provide arbitrary path traversal."
},
{
"id": "filesystem:SKILL.md:84:standard-device-file-access",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The command redirects Git error output to /dev/null. This standard sink does not expose or alter sensitive device data."
},
{
"id": "blocker:SKILL.md:20:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The phrase paid ads describes a marketing discipline. The line does not gather host or network information."
},
{
"id": "blocker:SKILL.md:96:system-reconnaissance",
"verdict": "false_positive",
"confidence": 0.99,
"reason": "The line requires permission before saving a report to a documented memory path. It contains no reconnaissance behavior."
}
],
"semantic_findings": [],
"critical_findings": [],
"high_findings": [],
"medium_findings": [
{
"title": "Ruby/shell backtick execution",
"description": "Declare goal, profile `roi-<goal>`, `scope: roi`, `assessment_time: forecast|actual`, campaign `roll",
"locations": [
{
"file": "SKILL.md",
"line_start": 84,
"line_end": 84
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "medium",
"confidence": 0.96,
"confidence_reasoning": "The line explicitly resolves a repository root with shell substitution and invokes a local Python scoring script. The Git-root fallback may select project-controlled executable code."
},
{
"title": "Ruby/shell backtick execution",
"description": "For CVI, combine complete typed ACE results from [fit-scorer](../../discover/fit-scorer/SKILL.md), c",
"locations": [
{
"file": "SKILL.md",
"line_start": 88,
"line_end": 90
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "medium",
"confidence": 0.94,
"confidence_reasoning": "Although Markdown backticks delimit the text, the content directs the agent to run python3 against a resolved local script. This is intentional external command execution."
},
{
"title": "Shell command substitution",
"description": "Declare goal, profile `roi-<goal>`, `scope: roi`, `assessment_time: forecast|actual`, campaign `roll",
"locations": [
{
"file": "SKILL.md",
"line_start": 84,
"line_end": 84
}
],
"review_kind": "capability",
"source_category": "external_commands",
"source_severity": "medium",
"confidence": 0.99,
"confidence_reasoning": "The AARON_SKILLS_ROOT assignment contains explicit $(git rev-parse ...) shell command substitution. It runs Git and then uses the resulting path for local script execution."
}
],
"low_findings": [],
"dangerous_patterns": [],
"files_scanned": 2,
"total_lines": 606,
"audit_model": "codex",
"audited_at": "2026-07-12T13:51:34.400Z",
"agent_auto_install_policy": "allowed",
"manual_install_policy": "allowed"
},
"content": {
"user_title": "Calculate Influencer Campaign ROI",
"value_statement": "Campaign teams often lack a consistent way to connect influencer spend with revenue, media value, and customer outcomes. This skill applies transparent formulas and records assumptions, evidence gaps, comparisons, and practical recommendations.",
"seo_keywords": [
"influencer ROI calculator",
"campaign ROAS analysis",
"earned media value",
"marketing attribution",
"customer lifetime value",
"influencer analytics",
"Claude",
"Codex",
"Claude Code"
],
"actual_capabilities": [
"Calculates profit, direct ROI, and ROAS from supplied investment and revenue.",
"Estimates impression-based and engagement-based earned media value with declared rates.",
"Calculates CPM, CPR, CPE, CPV, CPC, CPA, and CAC when required inputs exist.",
"Compares first-touch, last-touch, linear, time-decay, and position-based attribution scenarios.",
"Projects lifetime value impact and ranks returns by influencer or influencer tier.",
"Produces a concise summary with formulas, assumptions, evidence gaps, and recommendations."
],
"limitations": [
"Results depend on the accuracy and attribution quality of supplied campaign data.",
"Earned media value and lifetime value outputs are estimates, not guaranteed financial returns.",
"External benchmarks require compatible sources, dates, markets, windows, currencies, and attribution definitions.",
"Typed C3 scoring requires trusted repository scripts and related skill outputs that may be unavailable."
],
"use_cases": [
{
"title": "Review Campaign Profitability",
"description": "Calculate direct ROI, ROAS, profit, and cost efficiency after an influencer campaign.",
"target_user": "Influencer marketing manager"
},
{
"title": "Defend Marketing Investment",
"description": "Present return methods, assumptions, evidence gaps, and recommendations for a budget discussion.",
"target_user": "Marketing finance partner"
},
{
"title": "Compare Creator Value",
"description": "Rank creators and tiers by revenue return, budget share, and investment efficiency.",
"target_user": "Agency performance analyst"
}
],
"prompt_templates": [
{
"title": "Calculate Direct Return",
"prompt": "Calculate direct ROI and ROAS for [campaign]. Spend was [amount], attributed revenue was [amount], and the reporting period was [dates]. Show every formula.",
"scenario": "Begin with verified spend and revenue totals."
},
{
"title": "Measure Media Efficiency",
"prompt": "Calculate CPM, CPE, CPC, CPA, and EMV for [campaign]. Use these results: [metrics]. Use only these declared comparison rates: [rates and sources].",
"scenario": "Evaluate awareness and conversion efficiency."
},
{
"title": "Compare Attribution Models",
"prompt": "Model campaign revenue using first-touch, last-touch, linear, time-decay, and position-based attribution. Use this journey data: [touchpoints]. Explain the recommended model.",
"scenario": "Assess returns across a multi-touch customer journey."
},
{
"title": "Build a Complete ROI Assessment",
"prompt": "Analyze [campaign] using direct ROI, EMV, attribution, LTV, and creator-level returns. Mark missing evidence and incompatible benchmarks. Provide three decision-ready recommendations.",
"scenario": "Prepare an advanced assessment for planning and executive review."
}
],
"output_examples": [
{
"input": "Campaign spend was $25,000 and attributed revenue was $72,000.",
"output": "Profit is $47,000. Direct ROI is 188%, and ROAS is 2.88 to 1. The campaign is profitable on the supplied attribution basis."
},
{
"input": "Campaign spend was $18,000, impressions were 1,500,000, and the declared comparable CPM was $8.",
"output": "Impression-based earned media value is $12,000. The EMV multiple is 0.67. Treat this estimate as directional because it uses a declared media rate."
},
{
"input": "Three creators generated $40,000, $22,000, and $8,000 from fees of $10,000, $8,000, and $5,000.",
"output": "Creator one leads with 300% ROI. Creator two returns 175%, and creator three returns 60%. Review attribution quality before reallocating budget."
}
],
"best_practices": [
"Include every campaign cost and state the currency, reporting window, and attribution basis.",
"Provide source-dated comparison targets with compatible markets, cohorts, and cost definitions.",
"Separate direct revenue, estimated media value, and projected lifetime value in every conclusion."
],
"anti_patterns": [
"Do not combine earned media value with direct revenue as if both were collected cash.",
"Do not claim benchmark outperformance when the source or comparison basis is missing.",
"Do not project lifetime value without documented customer counts, value assumptions, and time horizons."
],
"faq": [
{
"question": "What data do I need for direct ROI?",
"answer": "Provide total campaign investment and attributed revenue. Include the currency, reporting period, attribution model, and revenue source."
},
{
"question": "Can the skill work without integrations?",
"answer": "Yes. You can supply campaign costs and results manually. Missing fields remain unknown rather than being invented."
},
{
"question": "How is ROAS different from ROI?",
"answer": "ROAS divides revenue by spend. ROI subtracts investment from revenue before dividing by investment."
},
{
"question": "Is earned media value the same as revenue?",
"answer": "No. Earned media value estimates comparable media cost. It should remain separate from direct or attributed revenue."
},
{
"question": "Can it compare creators or channels?",
"answer": "Yes. Comparisons require normalized costs, currencies, observation windows, attribution rules, and compatible performance data."
},
{
"question": "Does it create a full presentation?",
"answer": "No. It produces calculation tables and a concise summary. A separate reporting workflow can format a full presentation."
}
]
},
"file_structure": [
{
"name": "references",
"type": "dir",
"path": "references",
"children": [
{
"name": "roi-templates.md",
"type": "file",
"path": "references/roi-templates.md",
"lines": 444
}
]
},
{
"name": "SKILL.md",
"type": "file",
"path": "SKILL.md",
"lines": 162
}
]
}
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| canvas-designanthropics/skillsCreate beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| docxanthropics/skillsUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pdfanthropics/skillsUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| pptxanthropics/skillsUse this skill any time a .pptx or .potx file is involved in any way β as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx or .potx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates (.potx), layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx or .potx filename, regardless of what they plan to do with the content afterward. If a .pptx or .potx file needs to be opened, created, or touched, use this skill. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |