roi-calculator · Ad Spend ROI Calculator
Campaign performance computation for content marketing: feed in raw spend data, get the full metric set — CTR, CPC, CPM, CPE, conversion rate, CPA, revenue, ROAS, net profit, ROI — benchmarked against industry standards.
Two modes: single-campaign deep dive (Mode A) and multi-campaign comparison (Mode B, ranked by ROI descending). Missing fields gracefully skip their dependent metrics instead of fabricating numbers.
Example invocation: "Calculate this campaign's ROI: spent 5000, 100K impressions, 3000 clicks, 120 orders at 199 each."
Full brief
Positioning
roi-calculator is a computation and evaluation tool for ad performance: raw spend data in, structured metric report out, answering "was the money well spent." It computes and benchmarks; it does not infer attribution or forecast future performance.
Core capabilities
- Full metric computation: CTR, CPC, CPM, CPE, conversion rate, CPA, revenue, ROAS, total cost, profit, ROI — formulas built in. Metrics whose denominators are missing or zero are labeled "insufficient data, skipped," never invented.
- Industry benchmarking: key metrics are compared against industry baselines, yielding directional verdicts (expensive / cheap / beating / trailing) instead of isolated numbers.
- Two modes:
- Mode A — single-campaign analysis: one dataset, complete metric card.
- Mode B — multi-campaign comparison: multiple datasets ranked by ROI descending, separating efficient from wasteful spend.
Workflow
- Gather campaign data (any subset works; completeness not required)
- Pick a mode: single deep dive or multi-way comparison
- Receive the structured report: raw inputs → computed metrics → benchmark comparison → verdict
Inputs & outputs
| Input field | Key | Required? |
|---|---|---|
| Ad spend | ad_spend | Core; zero/missing switches to organic mode |
| Impressions | impressions | Optional |
| Clicks | clicks | Optional |
| Engagements | engagements | Optional (likes + comments + shares) |
| Conversions | conversions | Optional |
| Avg. order value | avg_order_value | Optional |
| Production cost | production_cost | Optional, excluded by default |
Output: structured Markdown performance report.
Boundaries with adjacent skills
- skill-publish-analytics: attributes content performance across timing, tags, formats, and follower growth — content-review oriented.
- skill-data-tracker: long-term metric logging and growth-trend analysis — asset oriented.
- roi-calculator (this): financial accounting of individual or grouped campaigns — money-efficiency oriented.
Fit
- E-commerce operators auditing the true return on paid traffic and seeding campaigns
- Agencies producing data-backed wrap-up reports for clients
- Creators pricing brand deals and reviewing partnership outcomes
Before you start
- No API key needed; purely local computation.
- Accuracy precondition: truthful inputs. Skipped fields are disclosed explicitly and don't affect the credibility of computed metrics.
roi-calculator is part of the Aiglade Skill library. Invoke it from the Aiglade chat box in plain language.