1. Learn
    2. /
  2. Projects
    3. /
  3. Analyzing Marketing Campaigns with pandas
  • 1

    Pandas

    Free

    In this chapter, you will review pandas basics including importing datasets, exploratory analysis, and basic plotting.

  • 2

    Exploratory Analysis & Summary Statistics

    In this chapter, you will learn about common marketing metrics and how to calculate them using pandas. You will also visualize your results and practice user segmentation.

  • 3

    Conversion Attribution

    In this chapter, you will build functions to automate common marketing analysis and determine why certain marketing channels saw lower than usual conversion rates during late January.

  • 4

    Personalization A/B Test

    In this chapter, you will analyze an A/B test and learn about the importance of segmentation when interpreting the results of a test.

Initializing

Exercise

Comparing language conversion rate (I)

The marketing team wants to determine how effective the campaign was on converting English speakers.

In this exercise, you will isolate the data for English speakers and calculate the conversion rate much like in the previous exercises. Remember, the formula for conversion rate is:

$$ \displaystyle\frac{\mbox{Number of people who convert}}{\mbox{Total number of people who we market to}} $$

Once you have the conversion rate for English speakers, you can compare it to the overall conversion rate to gain a sense of how effective the marketing campaign was among this group compared to the overall population.

Instructions

100 XP
  • Using the marketing DataFrame, include only the rows where language_displayed is English.
  • Calculate the total number of users in the english_speakers DataFrame.
  • Calculate the number of conversions in the english_speakers DataFrame.