Calculate influencer marketing ROI by subtracting every included cost from the sales credited to the campaign, then dividing the remaining profit by the stated cost base. Start with net sales, subtract sold-product and order costs, then subtract creator fees, commissions, gifted products, labor, tools and content-reuse costs. Report the attribution rule beside the result. A revenue multiple alone does not tell you whether the campaign covered its costs.
Name the return before calculating it
Four numbers answer different questions:
| Measure | Calculation | What it tells you |
|---|---|---|
| Net sales | Gross product sales minus discounts and sales reversals | Sales value remaining after those adjustments |
| Gross profit | Net sales minus cost of goods sold | What remains after product costs |
| Contribution before campaign costs | Gross profit minus other variable order costs | What is available to cover the campaign and overhead |
| Campaign profit | Contribution before campaign costs minus campaign costs | What remains within this worksheet's scope |
The contribution line here excludes creator commissions because the campaign ledger below includes them. Another business may classify commissions as variable selling costs. Either approach works if each cost appears once and the label makes the boundary clear.
Shopify's sales-report definitions distinguish net sales from gross profit. Its Total sales figure also includes taxes, duties, shipping charges and fees. Check the exported field before treating it as product revenue.
Google Ads defines ROI using net profit relative to costs. Its example includes both product and advertising costs in the denominator. A marketing team may instead divide campaign profit by campaign spend. Show which denominator you use, and keep it unchanged across comparisons.
Fix the sales boundary first
Write down the eligible order dates, currency, attribution rule and final adjustment date before filling the worksheet. Choose a reporting window if you need to decide how long orders and later reversals should remain open.
For the hypothetical worksheet below, assume:
- All amounts are USD. Eligible orders arrive during the first 30 days after launch.
- A creator code receives credit first. Without a code, the last eligible creator-tagged click within seven days receives credit.
- The rule includes both organic creator links and the campaign's paid reuse links. Each order receives credit once.
- Only paid, fulfilled orders enter the calculation. Later adjustments remain linked to their original orders.
- The final adjustment cutoff is 60 days after the last eligible order. Chargebacks and reversals through that date are reconciled.
- Customers pay no shipping charge. Pass-through taxes are excluded. The example has no duties, chargebacks or repeat-purchase revenue.
These are worksheet assumptions, not platform defaults. Google Analytics describes attribution as assigning credit through rules or a model. Crediting an order to a creator does not establish that the order would disappear without the campaign.
Keep order IDs when reconciling reports. Shopify warns that combined discounts can put one order on multiple rows in its discount-code report. It also records reversals on the processing date, which can fall outside the original order period. Its sales reports can include pending, unpaid and canceled orders, and exclude chargebacks. Reconcile those differences before using an export in a campaign profit calculation.
Work down from sales to contribution
This hypothetical campaign has the following order economics. Product cost is the net cost for the included orders after relevant inventory adjustments. Fulfillment costs include packaging, outbound delivery and return handling.
| Hypothetical order ledger | Amount |
|---|---|
| Gross product sales | $30,000 |
| Discounts | -$3,000 |
| Sales reversals | -$2,000 |
| Net sales | $25,000 |
| Cost of goods sold | -$9,000 |
| Gross profit | $16,000 |
| Payment processing | -$750 |
| Fulfillment and return handling | -$1,750 |
| Contribution before campaign costs | $13,500 |
The contribution rate before campaign costs is $13,500 divided by $25,000, or 54%.
Do not subtract the discount again as a campaign expense. It already reduced net sales. Likewise, use the actual net product cost after inventory adjustments rather than assuming every returned item restores its full cost.
Add the campaign ledger
Modash's ROI guide identifies several costs marketers can miss, including product shipping, commissions and management time. Use an evidence column to make each entry traceable to an invoice, contract, shipment record or time log.
Here is the matching hypothetical campaign ledger. Every cost is assigned fully to this campaign; there are no agency fees or other campaign-specific charges in this example.
| Hypothetical campaign cost | Basis | Amount |
|---|---|---|
| Creator flat fees | Approved invoices | $4,000 |
| Affiliate commissions | Amount due after adjustments | $2,000 |
| Gifted products | 20 units at $30 cost | $600 |
| Gift shipping | Shipment records | $200 |
| Internal labor | 40 hours at $60 loaded hourly cost | $2,400 |
| Campaign software | Allocated subscription cost | $300 |
| Reuse rights | Agreed campaign charge | $800 |
| Reuse editing | Editor invoice | $400 |
| Paid distribution | Campaign media spend | $2,000 |
| Total campaign costs | Sum of these entries | $12,700 |
Gifted products use inventory cost, not their retail selling price. They are separate from the products sold to customers in the order ledger.
Loaded labor cost should follow your finance team's approved method, including relevant employment costs beyond wages. Salaried time belongs in this fully costed view even when the campaign requires no new hire. If you also prepare an incremental cash-spend view, label it separately.
Include costs incurred but not yet paid. For shared software, agency retainers or production costs, record the allocation method before comparing campaigns. Keep the full invoice total available so allocations across campaigns reconcile to it.
Calculate both denominators
The hypothetical campaign leaves $800 after its included costs. Two return percentages describe that same amount:
| Hypothetical result | Calculation | Result |
|---|---|---|
| Campaign profit | $13,500 minus $12,700 | $800 |
| Total included costs | $9,000 + $750 + $1,750 + $12,700 | $24,200 |
| ROI on total included costs | $800 / $24,200 × 100 | 3.3% |
| Return on campaign spend | $800 / $12,700 × 100 | 6.3% |
| Net-sales-to-campaign-cost multiple | $25,000 / $12,700 | 1.97× |
The last row reports sales per campaign dollar. Calling it 197% profit would ignore the costs needed to produce those sales.
These figures exclude unallocated company overhead, financing and income tax. Call the $800 campaign profit within the stated scope; do not present it as company net income. A positive attributed result also leaves the causal question open. Use incremental-impact measurement when the decision depends on how much additional business the campaign caused.
Keep reuse value and reuse costs together
If paid reuse sits inside the campaign, include its rights, editing and media costs, as the example does. Deduplicate its credited orders against organic creator sales. If another team owns that work, show a separate reuse calculation with an explicit cost allocation. Moving an invoice between teams cannot reduce the combined program's cost.
Do not add the estimated replacement value of creator content to sales revenue. Record assets used and any evidenced avoided expenditure separately. A hypothetical future production saving cannot pay an invoice today. Separate organic and paid creator results when you need to see which activity generated each result.
Close the worksheet before renewing
For each ledger row, store the campaign ID, cost category, supplier or employee, service date, amount, currency, allocation basis and evidence reference. Mark estimated costs so the final report can replace them with actuals.
Before approving the next campaign, ask finance and the campaign owner to confirm four items:
- Every included order appears once, with discounts and reversals reconciled.
- Every cost appears once, including labor and unpaid obligations.
- The numerator, denominator and attribution rule match the previous report.
- Any late refunds or missing invoices have a named owner and adjustment date.
Then replace the hypothetical ledger with one completed campaign's records. Resolve its missing costs before using the return percentage to set the next budget.
