--- title: "Calculating ROI and reporting programs" description: "ROI: be explicit about what you count ROI = (Attributable gross profit − Total campaign cost) ÷ Total campaign cost × 100 - Attributable gross profit…" url: https://optimizeall.com/learn/influencer-marketing-for-brands/roi-and-reporting updated: 2026-10-05 --- Influencer Marketing Strategy · Measurement and ROI · lesson 13 of 15 · 11 min # Calculating ROI and reporting programs ## ROI: be explicit about what you count **ROI = (Attributable gross profit − Total campaign cost) ÷ Total campaign cost × 100** - **Attributable gross profit:** revenue attributed to the campaign × gross margin (or contribution margin after variable costs). - **Total campaign cost:** creator fees, product and shipping, agency or management time, tools, paid amplification and discounts given via codes. Use gross profit rather than revenue so the result reflects real business return. ## Worked ROI example (illustrative) A UAE home fragrance brand's campaign: - Creator fees: AED 30,000 - Product and shipping: AED 3,000 - Paid amplification: AED 12,000 - Tools and management: AED 5,000 - **Total cost: AED 50,000** Tracked revenue (codes + UTMs): AED 140,000. Gross margin: 55%. Attributable gross profit = AED 77,000. ROI = (77,000 − 50,000) ÷ 50,000 × 100 = **54%**. ROAS on tracked revenue = 140,000 ÷ 50,000 = **2.8**. State clearly that this uses tracked (last-touch) sales only. If the brand also saw a lift in direct sales and branded search, present that as additional evidence with its method, not added directly to ROI unless measured through a test. ## Creator-level unit economics Break results down by creator: | Creator | Cost | Tracked orders | Gross profit | Cost per order | Creator ROI | |---|---|---|---|---|---| | A | AED 8,000 | 160 | AED 14,000 | AED 50 | 75% | | B | AED 12,000 | 60 | AED 5,300 | AED 200 | −56% | | C | AED 5,000 | 110 | AED 9,700 | AED 45 | 94% | (Illustrative figures.) Before cutting Creator B, check other objectives: did B's content become the best-performing paid ad? Did B deliver strong reach in a new market? Judge each creator against the job they were hired to do. ## Content value When creator content is reused in ads, measure: - Ad CPA or ROAS using creator content vs brand-produced content. - Number of usable assets per creator. - Estimated production cost saved (what equivalent assets would have cost) – a reasonable secondary metric when clearly labeled as an estimate. ## Lifetime value perspective Customers acquired through creators may have different repeat-purchase behavior from customers acquired through discounts or ads. Where your data allows, compare **LTV of creator-acquired customers** with other channels over several months. Heavy discount codes can attract lower-LTV customers; trusted recommendations can attract loyal ones. Your own data will tell you which applies. ## The program report A strong report for leadership or clients: 1. **Executive summary:** objective, headline results against targets, key decision. 2. **Results by objective:** reach/lift, engagement quality, conversions, content performance. 3. **Financials:** total cost, attributable gross profit, ROI and ROAS, with methods stated. 4. **Creator league table:** results against each creator's job. 5. **Content insights:** which hooks, formats and messages worked, with examples. 6. **Audience insights:** comments themes, questions and objections raised by audiences. 7. **Learnings and recommendations:** which creators to renew, which to replace, what to test next. 8. **Appendix:** tracking methods, attribution caveats, data sources. ## Using insights to improve - Renew and deepen partnerships with creators who hit their objectives. - Share learnings with creators (what worked in their content) to improve the next round. - Feed audience questions into product pages, FAQs and ad copy. - Update your vetting scorecard weights based on what predicted success. ## Hands-on: ROI sheet formulas ```text B2 Creator fees B3 Product and shipping B4 Paid amplification B5 Tools and management B6 Discounts given via codes B7 Tracked revenue B8 Gross margin % B10 Total cost =SUM(B2:B6) B11 Attributable GP =B7*B8 B12 ROI % =(B11-B10)/B10 B13 ROAS =B7/B10 B14 Break-even revenue =B10/B8 ``` Add a creator table with `=gross_profit/cost-1` per row, and conditional formatting that flags any creator below break-even so you check their other job (reach or ad content) before cutting them. Label every figure "tracked (last-touch)" unless it comes from a lift test. ## A one-slide executive summary Leaders often read only the first slide, so make it stand alone: the objective in one line, three headline numbers against target (for example tracked orders, ROI on gross profit and ad CPA with creator content), one chart, and the single decision you are asking for, such as "renew creators A and C for Q1, replace B, and test Spark Ads with two new hooks". Put methods and caveats in the appendix, not in the headline. ## Common mistakes - Using revenue instead of gross profit in ROI. - Excluding product, amplification or management costs. - Cutting creators on sales alone when hired for another job. - Reports without recommendations. ## Video lecture: Calculating ROI and reporting creator programs Lecture coming soon · 12 chapters · about 8 minutes. Read the full transcript below. 1. ROI and reporting 2. Honest ROI 3. Revenue vs profit 4. Example 1 5. Example 2: UAE home fragrance 6. Creator league table 7. Watch me: ROI sheet 8. Two more lenses 9. The 8-part report 10. Insights → next round 11. Mistakes + recap 12. Try this now ## Lecture transcript ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ## Key takeaways - ROI = (attributable gross profit − total campaign cost) ÷ total cost; include all costs and state attribution methods. - Break results down by creator and judge each against the job they were hired to do. - Measure content value in ads and, where possible, the LTV of creator-acquired customers. - Report with an executive summary, financials, creator league table, insights and clear recommendations. ## Try it Build an ROI calculation and creator league table for a real or illustrative campaign, then write three recommendations based on the results. - [Previous: Tracking creator performance](https://optimizeall.com/learn/influencer-marketing-for-brands/tracking-creator-performance) - [Next: Disclosure and regulatory compliance](https://optimizeall.com/learn/influencer-marketing-for-brands/disclosure-compliance) - [All lessons of Influencer Marketing Strategy](https://optimizeall.com/learn/influencer-marketing-for-brands)