Enter Campaign Inputs
Example Data Table
Use this sample campaign row to understand how each field maps into profitability and efficiency outputs.
| Creator | Total Cost | Clicks | Orders | Net Revenue | Net Profit | ROI | ROAS |
|---|---|---|---|---|---|---|---|
| Beauty Micro Creator A | $3,950.00 | 1,260 | 68 | $7,956.00 | $1,023.60 | 25.91% | 2.01x |
| Fitness Mid Creator B | $6,480.00 | 2,340 | 121 | $14,217.50 | $3,469.63 | 53.54% | 2.19x |
| Fashion Macro Creator C | $11,900.00 | 3,890 | 149 | $18,102.00 | $2,581.20 | 21.69% | 1.52x |
Formula Used
1. Total campaign cost
Total Cost = Influencer Fee + Production Cost + Gifting Cost + Ad Spend + Affiliate Payout + Shipping Cost + Discount Cost + Tool Cost
2. Attributed orders
Attributed Orders = Manual Orders, if entered. Otherwise, Attributed Orders = Link Clicks × Conversion Rate
3. Revenue build
Base Revenue = Attributed Orders × Average Order Value
Repeat Revenue = Attributed Orders × Repeat Purchase Rate × Repeat Order Value
Gross Revenue = Base Revenue + Repeat Revenue + Other Attributable Value
4. Net revenue and profit
Refund Value = Gross Revenue × Refund Rate
Net Revenue = Gross Revenue − Refund Value
Gross Profit = Net Revenue × Gross Margin
5. Final profitability
Net Profit = Gross Profit + Earned Media Value − Total Cost
ROI = Net Profit ÷ Total Cost × 100
6. Efficiency metrics
ROAS = Net Revenue ÷ Total Cost
CPM = Total Cost ÷ Impressions × 1,000
CPC = Total Cost ÷ Clicks
CPA = Total Cost ÷ Attributed Orders
How to Use This Calculator
- Enter every direct campaign cost, not only the creator fee.
- Add awareness metrics such as impressions, reach, engagements, and clicks.
- Type a conversion rate if you want order volume estimated from clicks.
- Enter manual attributed orders instead when platform or survey attribution is stronger.
- Provide average order value, gross margin, refund rate, and repeat behavior assumptions.
- Add earned media value or other attributable value only when your team consistently values them.
- Press Calculate ROI to display results above the form and compare profitability, efficiency, and scale quality.
- Use the CSV or PDF buttons to export the result set for reports, budget reviews, or creator scorecards.
Frequently Asked Questions
1. What does ROI measure here?
ROI measures profit relative to total campaign cost. This version uses gross profit, refund impact, and earned media value so the number reflects more than simple top-line revenue.
2. When should I use manual attributed orders?
Use manual orders when post-purchase surveys, promo codes, platform analytics, or blended attribution offer a stronger signal than click-based conversion estimates.
3. Why include gross margin instead of revenue alone?
Revenue can make weak campaigns look healthy. Gross margin filters out product cost intensity so profit-focused decisions become more accurate.
4. Is earned media value real revenue?
No. Earned media value is an estimated exposure benefit. Include it only if your team uses a consistent valuation method and reviews profit with and without it.
5. What is a good ROAS for creator campaigns?
A good ROAS depends on margins, repeat behavior, and growth goals. Lower ROAS may still work for high-margin brands or strong customer lifetime value.
6. Should discount cost be counted separately?
Yes. Discounts reduce effective profitability. Recording them separately helps you compare creators fairly, especially when one partnership depends on heavy offers.
7. How do I compare creators of different sizes?
Use both profitability and efficiency metrics. ROI, CPA, CPM, CTR, and engagement rate together show whether scale is helping or hiding weak conversion quality.
8. Can this calculator handle awareness-only campaigns?
Yes, partly. Enter earned media value and upper-funnel metrics to benchmark awareness efficiency, but profit metrics will remain limited without attributable revenue assumptions.