Influencer marketing spend is notoriously hard to measure because attribution is fragmented across platforms, discount codes get shared beyond the intended creator, and brands rarely account for hidden costs like product seeding, shipping samples, and content licensing fees. This skill builds a comprehensive ROI model for each creator partnership, giving ecommerce operators a clear picture of which influencers actually drive profitable sales versus those who merely generate vanity metrics.
| Decision | Strong | Acceptable | Weak |
|---|---|---|---|
| ---------- | -------- | ------------ | ------ |
| Attribution method | UTM + unique discount code | Discount code only | Platform self-reported |
| Cost tracking | All-in (seeding + shipping + commission + licensing) | Commission + fee only | Commission only |
| Comparison window | Normalized 30-day window | Full campaign duration | No normalization |
| ROAS benchmark | Category-specific target | Platform average | No benchmark |
| Assisted conversion credit | Partial credit via touch model | Last-click only | Ignored |
| Renewal decision | Data-driven ROI threshold | Gut feel + engagement | Follower count |
Collect for each creator: platform, follower count, views/impressions, clicks, attributed orders, attributed revenue, and the time period. Pull from your ecommerce backend (Shopify, WooCommerce) filtered by UTM source or discount code, not from creator or platform self-reported numbers.
For each creator record: product seeding cost (unit cost × quantity sent), shipping cost for samples, agreed commission amount or flat fee, any content licensing or usage rights fee, and agency/management fee if applicable. Sum these into Total Creator Cost (TCC).
Check whether the discount code appears on coupon aggregator sites (RetailMeNot, Honey, etc.). If code usage significantly exceeds the creator's reach, flag the creator as "leaky" and apply a leakage discount factor (typically 15–40%) to their attributed revenue.
Campaigns run for different durations. Divide all volume metrics (orders, revenue, impressions) by campaign days, then multiply by 30 to create a normalized monthly view that makes cross-creator comparison fair.
Identify customers who saw creator content (UTM touch) but converted through another channel within 30 days. Apply a 20% assisted conversion revenue credit to each relevant creator (adjustable based on your attribution philosophy).
Sort creators by Net Profit (descending). Flag creators above your ROAS threshold as "Renew," those within 20% below as "Test Again," and those significantly below as "Pause." Generate a ranked profitability table and a budget allocation recommendation for the next cycle.
Input:
Creator A (Micro, 45K followers, TikTok):
- Views: 180,000 | Clicks: 2,100 | Orders: 89 | Revenue: $8,010
- Costs: $120 product + $18 shipping + $450 flat fee + $0 licensing = $588 TCC
- Campaign: 21 days | Discount code clean (no leakage detected)
Creator B (Macro, 890K followers, Instagram):
- Views: 1,200,000 | Clicks: 4,800 | Orders: 156 | Revenue: $14,040
- Costs: $360 product (3 units) + $45 shipping + $3,500 flat fee + $1,000 licensing = $4,905 TCC
- Campaign: 28 days | Discount code found on 2 coupon sites (25% leakage factor applied)
Output:
| Metric | Creator A | Creator B |
|---|---|---|
| -------- | ----------- | ----------- |
| Adjusted Revenue | $8,010 | $10,530 |
| Gross Profit (60% margin) | $4,806 | $6,318 |
| Net Profit | $4,218 | $1,413 |
| ROAS | 13.6x | 2.1x |
| CPA | $6.61 | $31.44 |
| 30-day norm orders | 127 | 167 |
| Decision | ✅ Renew | ⚠️ Test Again |
Insight: Creator A delivers 6.5× more net profit per dollar spent despite 20× fewer followers. Creator B's high reach is negated by leakage, high licensing costs, and lower conversion rate.
Input:
Creator C (Mid-tier, 210K YouTube subscribers):
- Views: 95,000 | Clicks: 1,650 | Direct orders: 43 | Direct revenue: $6,450
- Costs: $280 product + $22 shipping + $800 flat fee + $500 licensing = $1,602 TCC
- Campaign: 45 days | Assisted conversions identified: 31 orders, $4,650 additional revenue
- Assisted credit rate: 20%
Calculations:
Decision: Renew. YouTube long-form drives strong late-funnel conversion. Increase budget for next cycle.
共 2 个版本