1. Learn
  2. /
  3. Courses
  4. /
  5. Analyzing Marketing Campaigns with pandas

Exercise

Calculating conversion rate

In this exercise, you will practice calculating conversion rate, which is often the first metric you'll want to calculate when evaluating how a marketing campaign performed.

On marketing teams, conversion rate is typically the most important metric. It is one of the best ways to determine how effective a marketing team was at gaining new customers.

As a reminder, conversion rate is the percentage of the users who saw our marketing assets and subsequently became subscribers.

The formula for conversion rate is:

$$ \frac{\text{Number of people who convert}}{\text{Total number of people who we market to}} $$

Instructions

100 XP
  • Calculate the number of unique user_ids in marketing DataFrame.
  • Calculate the number of people who subscribed using the converted column.
  • Calculate the conversion rate.