Introduction to common marketing metrics

Analizzare campagne di marketing con pandas

Jill Rosok

Data Scientist

Was the campaign successful?

Common metrics:

  • Conversion rate
  • Retention rate

shutterstock_753489763.jpg

Analizzare campagne di marketing con pandas

Conversion rate

 

$$ \text{Conversion rate} = \frac{\text{Number of people who convert}}{\text{Total number of people we marketed to}} $$

Analizzare campagne di marketing con pandas

Calculating conversion rate using pandas

subscribers = marketing[marketing['converted'] == True]\
                       ['user_id'].nunique()

total = marketing['user_id'].nunique()
conv_rate = subscribers/total print(round(conv_rate*100, 2), '%')
13.89 %
Analizzare campagne di marketing con pandas

Retention rate

 

$$ \text{Retention rate} = \frac{\text{Number of people who remain subscribed}}{\text{Total number of people who converted}} $$

Analizzare campagne di marketing con pandas

Calculating retention rate

retained = marketing[marketing['is_retained'] == True]\
                    ['user_id'].nunique()

subscribers = marketing[marketing['converted'] == True]\ ['user_id'].nunique()
retention = retained/subscribers print(round(retention*100, 2), '%')
84%
Analizzare campagne di marketing con pandas

Let's practice!

Analizzare campagne di marketing con pandas

Preparing Video For Download...