Daily marketing reach by channel
In this exercise, you'll determine how many users are seeing the marketing assets each day. This is crucial to understand how effective our marketing efforts have been over the past month.
You'll use .groupby()
and .nunique()
to calculate daily users.
This exercise is part of the course
Analyzing Marketing Campaigns with pandas
Exercise instructions
- Group the
marketing
DataFrame by'date_served'
and count the number of unique user IDs present in theuser_id
column.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Group by date_served and count number of unique user_id's
daily_users = ____.____(['____'])['____'].____()
# Print head of daily_users
print(daily_users.____)