Comparing language conversion rate (II)
Next, you want to look at the conversion rate by the language that the marketing asset was shown in. While many of your users speak English, some prefer another language. Let's check to make sure marketing material translated well across languages.
You can analyze metrics by specific demographics using .groupby()
. Rather than looking at the overall conversion rate in the dataset, you instead group by language preference, which allows you to determine whether the marketing campaign was more effective in certain languages.
This exercise is part of the course
Analyzing Marketing Campaigns with pandas
Exercise instructions
- Group the
marketing
DataFrame bylanguage_displayed
and count the number of unique users in the dataset. - Group
marketing
bylanguage_displayed
again, this time calculating the number of unique users who converted. - Calculate the conversion rate for all languages.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Group by language_displayed and count unique users
total = ____
# Group by language_displayed and count unique conversions
subscribers = ____
# Calculate the conversion rate for all languages
language_conversion_rate = ____
print(language_conversion_rate)