Aggregating by date

The marketing team wants to know whether there is any difference in the conversion rate based on when in the month, your users saw an ad. In this exercise, you will practice .groupby() again, this time looking at how metrics have evolved.

This exercise is part of the course

Analyzing Marketing Campaigns with pandas

View Course

Exercise instructions

Group the marketing DataFrame by date_served and count the number of unique users per day.
Isolate converted users in marketing while grouping by date_served and counting the number of unique converted users per day.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Group by date_served and count unique users
total = ____

# Group by date_served and count unique converted users
subscribers = ____

# Calculate the conversion rate per day
daily_conversion_rate = subscribers/total
print(daily_conversion_rate)

Edit and Run Code