Ad-Campaign ROI Tracker in Excel: CPL, CAC and ROAS

<p>Stride Fitness Studios spent about ₹20 lakh on ads in its first quarter, across Meta, Google Search, YouTube and fitness creators, and its founder wants to know what that bought before the next budget is set. The agency's report says the ads are profitable, because the account's overall ROAS is comfortably above 1. Kavya Menon, Stride's marketing manager, has the week-by-week export and five lessons to find out. In your own personal workbook you build her ROI tracker from zero: totals and the four ratios every marketer is asked for (CPL, CAC, ROAS and ROI), per-row ratios that handle weeks with no leads honestly, an Excel Table with a channel map and XLOOKUP, SUMIFS by channel and by campaign, gross margin, break-even ROAS and a Cut, Keep or Scale verdict for every campaign. Every lesson then hands the same job to your AI (Copilot, ChatGPT, Claude or Gemini) and shows you exactly how to catch its mistakes: averaged ratios, CAC per lead, ROI mixed up with ROAS, profit without margin. In the capstone your AI builds the messier second quarter, subtotal rows and all, and you prove it right.</p>

Tools: Marketing Metrics (CPL, CAC, ROAS, ROI), Excel Formulas (SUM, SUMIFS, COUNTIF), IF and Division-by-Zero Handling, Excel Tables and XLOOKUP, Break-even and Profit Analysis, Conditional Formatting and Charts, AI Assistants for Excel