Calculating ROI and reporting programs

0:00 ROI and reporting

A marketing manager once presented a creator campaign with a return of three hundred percent. The CFO asked one question: is that revenue or profit? It was revenue. And it didn't include the product, the shipping, the amplification or the agency fee. The real number was closer to break-even. In this lesson, you'll learn to calculate influencer ROI honestly, break results down by creator, value content used in ads, and build a report that leads to decisions. By the end, you'll have a set of spreadsheet formulas and an eight-part report structure.

0:40 Honest ROI

Why be this strict? Because credibility is your budget. If finance trusts your numbers, you get more money next quarter. Here's the formula. ROI equals attributable gross profit minus total campaign cost, divided by total campaign cost, times a hundred. Attributable gross profit is attributed revenue times your gross margin, or contribution margin after variable costs. Total campaign cost includes creator fees, product and shipping, agency or management time, tools, paid amplification and the discounts given through codes. Using gross profit instead of revenue is the single biggest honesty upgrade most teams can make.

1:21 Revenue vs profit

Here's an analogy. Revenue is like the price tag on a house you sold. Gross profit is what's left after you pay off what the house cost you. Nobody brags about the sale price without mentioning the mortgage. And ROAS, return on ad spend, is revenue divided by cost. It's useful for comparing with paid media, but it isn't profit either. A ROAS of two point eight can be a loss if your margin is thirty percent. So always report both, and always state the attribution method, for example tracked last-touch sales from codes and UTMs only.

2:03 Example 1

A simple example. Total campaign cost is twenty thousand dollars. Tracked revenue is sixty thousand dollars, and gross margin is forty percent. Gross profit is sixty thousand times zero point four, which is twenty-four thousand. ROI is twenty-four thousand minus twenty thousand, divided by twenty thousand. That's four thousand over twenty thousand, or twenty percent. ROAS is sixty thousand over twenty thousand, which is three. Notice how different those two numbers feel. A ROAS of three sounds amazing. An ROI of twenty percent is decent, and honest.

2:41 Example 2: UAE home fragrance

Now a realistic scenario, illustrative numbers. A UAE home fragrance brand's campaign. Creator fees thirty thousand dirhams. Product and shipping three thousand. Paid amplification twelve thousand. Tools and management five thousand. Total cost fifty thousand. Tracked revenue from codes and UTMs, one hundred forty thousand dirhams. Gross margin fifty-five percent, so attributable gross profit is seventy-seven thousand. ROI is seventy-seven minus fifty, over fifty: fifty-four percent. ROAS is two point eight. The report states clearly that this uses tracked last-touch sales only. The lift in direct sales and branded search goes in a separate section, with its method, and isn't added into ROI unless it was measured with a test.

3:29 Creator league table

Next, creator-level unit economics. Break results down by creator. Imagine three creators. Creator A cost eight thousand, drove a hundred sixty tracked orders, cost per order fifty, ROI seventy-five percent. Creator B cost twelve thousand, sixty orders, cost per order two hundred, ROI negative fifty-six percent. Creator C cost five thousand, a hundred ten orders, ROI ninety-four percent. Is Creator B out? Not yet. Before cutting anyone, ask what job they were hired for. Did B's content become the best-performing paid ad? Did B deliver strong reach in a new market? Judge each creator against their job.

4:11 Watch me: ROI sheet

Watch me build the ROI sheet from the lesson. In B2 through B6, I enter the costs: creator fees, product and shipping, paid amplification, tools and management, and discounts given via codes. B7 is tracked revenue, and B8 is gross margin as a percentage. Now the formulas. B10, total cost, equals the sum of B2 to B6. B11, attributable gross profit, equals B7 times B8. B12, ROI, equals B11 minus B10, divided by B10, formatted as a percentage. B13, ROAS, equals B7 divided by B10. And B14, break-even revenue, equals B10 divided by B8. That last one is gold in planning meetings. It tells everyone how much tracked revenue you need just to stand still. Then I add conditional formatting on the creator table to flag anyone below break-even, so we check their other job before cutting.

5:11 Two more lenses

Two more value lenses. Content value: when creator content runs in ads, measure ad cost per acquisition and ROAS with creator content versus brand-produced content, count usable assets per creator, and, clearly labeled as an estimate, the production cost you saved. And lifetime value: customers acquired through creators may repeat-purchase differently from those acquired through discounts or ads. Heavy discount codes can attract bargain hunters. Trusted recommendations can attract loyal customers. Where your data allows, compare the lifetime value of creator-acquired customers with other channels over several months. Your own data decides which is true for you.

5:53 The 8-part report

Now the report itself, in eight parts. One, an executive summary: objective, headline results against targets and the key decision. Two, results by objective. Three, financials: total cost, gross profit, ROI and ROAS, with methods stated. Four, the creator league table, judged against each creator's job. Five, content insights: which hooks, formats and messages worked, with examples. Six, audience insights: comment themes, questions and objections. Seven, learnings and recommendations: renew, replace, test next. And eight, an appendix with tracking methods, attribution caveats and data sources. If your report doesn't end with recommendations, it's a scrapbook, not a report.

6:36 Insights → next round

Here's how to use insights to improve the next round, because the report is only worth the decisions it drives. Renew and deepen partnerships with creators who hit their objectives, and consider ambassador terms with better rates. Share learnings with creators: tell each one what worked in their content, like the hook that held attention or the demo that drove clicks. Feed audience questions and objections from comments into your product pages, FAQs and ad copy. And update your vetting scorecard weights based on what actually predicted success. If audience fit mattered more than production quality, change the weights. Each campaign should make the next one cheaper and better.

7:23 Mistakes + recap

Common mistakes, then a recap. Using revenue instead of gross profit. Leaving out product, amplification or management costs. Cutting creators on sales alone when they were hired for another job. Adding unmeasured lift straight into ROI. And reports without recommendations. To recap: ROI uses attributable gross profit and total cost, with the method stated. Report ROAS alongside, never instead. Break results down by creator and judge each against their job. Value content and lifetime value where you can. And structure the report so it drives decisions.

8:00 Try this now

Try this now. Take a real or illustrative campaign. Build the ROI sheet with the formulas from the lesson, add a creator league table with conditional formatting, and write three recommendations based on the results: one creator to renew, one to change, and one test to run next. Then share the one-page summary with someone in finance and ask if they'd sign off on the numbers. Next module: compliance and crisis handling.