The Creator Campaign ROI Tracker

Know which creators made you money: all-in costs, revenue by source and contribution ROI by creator

<aside> 🚀 FREE STRATEGY CALL Want to grow your product through viral reach? We help teams across iGaming, mobile apps, AI products, and SaaS build creator-led organic distribution generating tens of millions of views at CPMs starting from $0.03.

<aside> 🚀 Book a free strategy call

</aside>

On the call you'll receive:

Viral-reach gap analysis for your product
Creator-led formats already working in your niche
Estimated install / brand-lift potential at scale </aside>

HOW THE TRACKER WORKS: Four sheets in one spreadsheet. Sheet 1 adds up what every creator really cost. Sheet 2 matches every order to the creator who drove it. Sheet 3 turns that into contribution ROI and one decision per creator: scale, repeat, test or pause. Sheet 4 shows revenue by day, so you can see when a video actually sold. Build it in Google Sheets or Excel with the columns and formulas below.

WHO IT'S FOR: Founders, eCom managers and growth leads at DTC brands and apps who pay creators and need to know who is worth paying again.

THE RULES

All-in cost. A creator's cost is everything you paid to get the video out: fee, product, shipping, usage rights and any boosting. Not only the fee.
Margin, not revenue. Judge creators on what is left after product and order costs, not on the sales total.
One matching rule. Every order is credited to one source by the same rule, every time.
Missing is not zero. A creator with no tracked orders gets "no data", not "0 revenue", until you have checked the tracking.

THE NUMBERS THAT MATTER

Metric	Formula	What it tells you
All-in creator cost	Fee + product + shipping + usage rights + boosting + other fees	What the creator really cost
Attributed revenue	Sum of orders matched to the creator	What the creator sold
ROAS	Attributed revenue / all-in cost	Sales per dollar spent. Looks good, can still lose money
Contribution margin %	(Revenue - product cost - shipping - payment fees - discounts - returns) / revenue	How much of each sale you keep
Contribution	Attributed revenue x contribution margin %	Money left from the creator's sales
Contribution ROI	(Contribution - all-in cost) / all-in cost	Profit per dollar spent on the creator
Break-even ROAS	1 / contribution margin %	The ROAS a creator needs just to not lose money

Why ROAS alone misleads: with a 60% contribution margin, break-even ROAS is 1 / 0.6 = 1.67x. A creator at 1.5x ROAS looks profitable on a sales screenshot and still loses money.

SHEET 1 - ALL-IN CREATOR COST SHEET

Creator	Fee	Product sent	Shipping	Usage rights	Boosting	Other	All-in cost
							`=SUM(B2:G2)`

Fill in:

Product sent: your cost of the product, not the retail price.
Usage rights: what you paid to reuse the video in ads or on your site.