Worked example + reusable blank · illustrative inputs labelled
← QuickAds

Full-Cost Influencer Return Workbook

Use this to explain the economics of a completed or proposed campaign. The output is a transparent cost-and-return record with stated assumptions. It is a planning model, not a guarantee or an estimate of causal lift.

Worked example: why media ROAS is not the whole return

All figures are fictional. The campaign has $3,000 of attributed revenue. The assumed contribution margin is 60% after relevant non-campaign variable costs and before the campaign marketing costs listed below. Avoid subtracting a cost in both the margin and campaign table.

Cost item Fictional amount Basis / limitation
Creator contribution $900 Example agreed fee
Paid-use rights $200 Example campaign licence
Editing $200 Example paid production cost
Allocated internal effort $200 5 hours × assumed $40/hour; planning allocation
Media $1,000 Example platform spend
Total campaign marketing cost $2,500 Stated scope only
Calculation Example result
Media ROAS = attributed revenue ÷ media spend $3,000 ÷ $1,000 = 3×
Contribution before campaign costs = attributed revenue × margin $3,000 × 60% = $1,800
Modelled contribution after campaign costs $1,800 − $2,500 = −$700
Modelled campaign ROI −$700 ÷ $2,500 = −28%
Attributed revenue required to cover $2,500 at 60% margin $2,500 ÷ 60% = $4,166.67

The break-even revenue calculation assumes the stated margin and cost scope hold. It does not predict sales. Attributed revenue can include purchases that would have happened without the campaign.

Test the assumptions

Hold attributed revenue at $3,000 and campaign cost at $2,500, then change the assumed margin:

Margin assumption Contribution before campaign costs Modelled campaign ROI
40% $1,200 −52%
60% $1,800 −28%
80% $2,400 −4%

At 60% margin, including $200 of internal effort gives the stated −28% return. Excluding that allocation gives ($1,800 − $2,300) ÷ $2,300 = approximately −21.7%. Both must be labelled by cost scope; neither justifies hiding the time cost.

For a sensitivity scenario only, if 75% rather than all of the attributed revenue were additional business, contribution at the same margin would be $3,000 × 75% × 60% = $1,350 and the modelled return would be −46%. The 75% is an invented assumption, not an incrementality estimate. Replace it with credible evidence or leave incremental return unknown.

Enter your inputs

Input Value Source / date Actual, quoted, estimated or missing
Revenue and attribution window Enter your record Enter your record Enter your record
Attribution method / exclusions / refunds Enter your record Enter your record Enter your record
Margin definition and percentage Enter your record Enter your record Enter your record
Creator fees Enter your record Enter your record Enter your record
Rights Enter your record Enter your record Enter your record
Editing / production Enter your record Enter your record Enter your record
Internal hours and allocation rate Enter your record Enter your record Enter your record
Media Enter your record Enter your record Enter your record
Other included campaign costs Enter your record Enter your record Enter your record
Evidence for added business, if available Enter your record Enter your record Enter your record

Decision record

Calculate the model using your defined scope. Mark an unknown margin or incomplete cost record as insufficient for campaign ROI. Report associated pipeline or conversations separately when revenue is too early or uncertain. Where causal impact matters, plan a suitable comparison with measurement expertise; do not treat an attribution model as that comparison.

Your final output: “Under ___ cost and margin assumptions, attributed return is ___. Incremental return is ___ / unknown. The decision is ___ because ___. Before committing more budget, ___ will verify ___.”

Download the editable worksheet