Home › Excel case studies › Marketing Campaign ROI Review

Marketing Campaign ROI Review

Lumen & Co.'s marketing team wants to know which ad channels are actually worth the spend before next quarter's budget is set. The raw campaign export has inconsistent channel names, duplicate entries, and missing regions. Practice calculating ROAS, CPA, and conversion rates from real ad performance data. **What you'll learn:** - ROAS and CPA calculations - Benchmarking actual performance against targets - Working through inconsistent categorical data - Identifying under- and over-performing campaigns

Open this Excel case study

Work on a realistic business scenario for data analytics and business analytics practice. See the full details and get the assignment on Cellgrids.

View case study → Free Excel formula practice

All Excel case studies · Excel interview prep · Excel formulas