Marketing

Marketing Funnel

You are the growth analyst for a subscription app. 40 campaigns ran across five channels last quarter. The CMO wants to see the funnel (click-through, conversion), what each customer cost, which campaigns paid for themselves, and which channel to double down on. Some campaigns won no customers, so watch for division by zero.

Deliverable: CTR, conversion, CAC (with errors handled) and ROAS columns, a channel table, the best channel, a live list of winning campaigns, highlighted ROAS and a spend-vs-revenue chart.

1. 1Click-through rate10 pts
2. 2Conversion rate10 pts
3. 3Cost per customer15 pts
4. 4Return on ad spend10 pts
5. 5Channel table20 pts
6. 6Best channel10 pts
7. 7Live list of winners15 pts
8. 8Highlight the winners5 pts
9. 9Spend vs revenue5 pts