Calculate influencer marketing ROI from matched orders, creator costs and customer contribution. Reconcile code and link overlap, include gifted products at cost, and distinguish attributed results from incremental sales.
Influencer marketing ROI is the contribution left from matched campaign orders after paying the complete creator campaign cost, divided by that cost. A defensible calculation includes gifted inventory, usage rights and labor, and counts an order only once when both a code and a link claim it.
Attributed influencer marketing ROI = (Attributed order contribution − Campaign cost) / Campaign cost
Order contribution = Net sales − Cost of products sold − Variable order costs
Net sales are after discounts and refunds, with sales tax excluded. Variable order costs here include customer shipping subsidies, payment fees and order handling. Campaign cost includes creator compensation and the company's resources used to deliver the campaign.
This is a campaign contribution measure before general corporate overhead. It is not net income for the company. The broader marketing ROI versus ROAS comparison explains why dividing sales by media spend answers a different question.
Start with attributed ROI because that is what linked sales exports can support. Google Analytics describes attribution as assigning credit across customer touchpoints. A credit allocation does not itself supply the counterfactual needed to call sales incremental. Use a separately designed comparison or holdout before claiming causal lift.
The order file needs order ID, order date, campaign ID, creator ID, net sales, product cost and variable order cost. Keep code and tracked-link indicators in separate columns. Refund rows need the original order ID so they reduce the correct campaign even when the refund arrives later.
The cost file needs campaign ID, creator ID, invoice or allocation reference, service dates, cost category and amount. Include unpaid accruals for work already delivered. A payment export alone can omit an outstanding creator invoice and distort the comparison between campaigns.
Use a stated purchase window and a stated refund cutoff. For this US retailer's example, orders qualify from September 1 through September 30, 2026, and refunds are included through October 15, 2026. Both creators use the same rules. These dates define an operating comparison, not a universal attribution standard.
If the commercial question is acquisition, separate new and existing customers. Customer acquisition cost uses a new-customer denominator; campaign ROI can include returning buyers, provided that treatment is explicit.
An order can arrive through a tracked link and use a creator's discount code. Adding the two reports double counts that order. Retain the underlying order ID and use the code and link fields as evidence about one sale.
| Matched order group | Unique orders | Sales before refunds (USD) |
|---|---|---|
| Code only | 70 | 70,000 |
| Link only | 50 | 40,000 |
| Both code and link | 20 | 20,000 |
| Deduplicated total | 140 | 130,000 |
The code report claims $90,000: $70,000 plus $20,000. The link report claims $60,000: $40,000 plus $20,000. Adding them produces $150,000, which exceeds the deduplicated $130,000 by the $20,000 overlap.
Use the same principle when reconciling an analytics export. Google's documentation explains how transaction IDs identify orders and prevent duplicate web purchase events. That feature does not resolve competing creator claims in your combined files; the campaign's allocation rule still has to do that.
Where two creators claim one order, choose a documented precedence rule or split its credit. Any fractions across all channels must add to no more than the whole order. Never give both creators full credit and then call their sum the company total.
The deduplicated sales are assigned to two creators. Product cost is net of recoverable inventory returned to stock; variable costs include any fees or handling that remain after a refund.
| Creator | Sales before refunds (USD) | Refunds (USD) | Net sales (USD) | Product cost (USD) | Variable order cost (USD) | Contribution (USD) |
|---|---|---|---|---|---|---|
| A | 80,000 | 4,000 | 76,000 | 30,000 | 6,000 | 40,000 |
| B | 50,000 | 5,000 | 45,000 | 18,000 | 4,000 | 23,000 |
| Total | 130,000 | 9,000 | 121,000 | 48,000 | 10,000 | 63,000 |
On a worksheet named Orders with the displayed columns A:G, enter these formulas in D2 and G2 and fill down:
=B2-C2
=D2-E2-F2
The campaign cost file supplies the other half. Gifts use actual company cost, not the retail price printed on the package. The cost of sending gifts to creators is separate from fulfilling customer orders above.
| Creator | Fee (USD) | Gift product cost (USD) | Gift shipping (USD) | Usage rights (USD) | Campaign labor (USD) | Total campaign cost (USD) |
|---|---|---|---|---|---|---|
| A | 14,000 | 2,000 | 500 | 1,500 | 2,000 | 20,000 |
| B | 10,000 | 1,500 | 500 | 1,000 | 2,000 | 15,000 |
| Total | 24,000 | 3,500 | 1,000 | 2,500 | 4,000 | 35,000 |
For costs in columns A:G on a worksheet named Costs, G2 is:
=SUM(B2:F2)
If the detailed file has multiple cost rows per creator, use SUMIFS to total the amount column against the creator ID. Microsoft documents SUMIFS as summing rows that meet multiple criteria, which also permits a campaign criterion when creators appear in several campaigns.
| Creator | Contribution (USD) | Campaign cost (USD) | Contribution after campaign cost (USD) | Attributed ROI |
|---|---|---|---|---|
| A | 40,000 | 20,000 | 20,000 | 100.0% |
| B | 23,000 | 15,000 | 8,000 | 53.3% |
| Total | 63,000 | 35,000 | 28,000 | 80.0% |
The total formula, using the two worksheets above, is:
=(SUM(Orders!G2:G3)-SUM(Costs!G2:G3))/SUM(Costs!G2:G3)
It returns 80.0%, rounded to one decimal place. The proof is $121,000 − $48,000 − $10,000 − $35,000 = $28,000, and $28,000 / $35,000 = 80.0%. Sum dollars before dividing; do not average creator percentages.
For other campaign types, content marketing ROI handles reusable production costs, while social media marketing ROI covers overlap across platforms and organic labor.
Covirage is not affiliated with Google or Microsoft.
Bring an order export with creator codes and links, returns, product costs and the campaign cost register. Covirage maps the columns, and its tools compute and check the contribution and ROI figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See how this supports customer profitability.
Yes. Include the company's actual cost of the products given away, plus their shipping and handling. Keep these campaign gifts separate from the cost of products sold to customers, so neither cost disappears or appears twice.
A code connects an order with a campaign under an attribution rule. It does not establish that the order would disappear without the campaign. Existing customers, shared codes and other marketing contacts can all affect the result.
Choose a window that fits the buying cycle, then keep it consistent across comparable campaigns. State the campaign dates, last eligible order date and return cutoff. Report later purchases separately instead of silently extending only the successful campaigns.