Skip to content

Business Excel & Job Interview Challenges · Exercise 7 of 10 · Excel for work · Advanced · 30 min · Premium

Marketing Campaign ROI

Measure six campaigns: cost per lead, cost per customer and ROI that cope with a campaign that produced nothing, then find the best one and the blended ROI.

What you will practise: Calculate marketing efficiency ratios per campaign, protect them against campaigns with no leads or no spend, and combine totals into a blended ROI.

Premium

This is a Premium exercise

Premium members can open this exercise and practise it in the spreadsheet.

Upgrade to PremiumAlready a member? Open exercise

Open exercise