House ads conversion by language
Now that you've ruled out natural fluctuations across the day of the week a user saw our marketing assets as they cause for decreasing house ads conversion, you will take a look at conversion by language over time. Perhaps the new marketing campaign does not apply broadly across different cultures.
Ideally, the marketing team will consider cultural differences prior to launching a campaign, but sometimes mistakes are made, and it will be your job to identify the cause. Often data scientists are the first line of defense to determine what went wrong with a marketing campaign. It's your job to think creatively to identify the cause.
This exercise is part of the course
Analyzing Marketing Campaigns with pandas
Exercise instructions
- Create a new DataFrame
house_ads
by isolating the rows frommarketing
wheremarketing_channel
equals'House Ads'
. - Run your
conversion_rate()
function on thehouse_ads
DataFrame grouping bydate_served
andlanguage_displayed
. - Use the
plotting_conv()
function onconv_lang_df
to display your results.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Isolate the rows where marketing channel is House Ads
house_ads = ____
# Calculate conversion by date served, and language displayed
conv_lang_channel = ____
# Unstack conv_lang_channel
conv_lang_df = pd.DataFrame(conv_lang_channel.unstack(level=1))
# Use your plotting function to display results
____