/DuolingoAnalysis

Wrangling & Modeling of Duolingo Data (48-hour Analysis Challenge)

Primary LanguageJupyter Notebook

Duolingo Data Analysis (48-hour Challenge)

At the end of 2018, Duolingo conducted a survey of its users. The survey asked a series of questions about demographics (e.g., country, age, employment status), and motivation (e.g., primary reason for studying a language). The goal was to develop user segments (or personas) to inform marketing efforts and product development.

This dataset contains some results from the survey as well as users included in it. Collection occurred from August 1st, 2018 to November 5th, 2018. The data required cleaning and reformatting.

Objectives:

  1. Explore the data
  2. Use quantitative methods to identify a set of user segments/personas
  3. Identify any actionable product or marketing insights

This report shall cover a high-level summary of the methods, a description of proposed use personas, key visualizations, and recommendation for product changes and marketing campaigns. Find the compiled pdf here (w/more visuals).

The principal audience is those with technical backgrounds, but not necessarily data scientists.


Key Visuals

key visualizations

Wrangling - duolingo_analysis.r

Used tidyverse and some other packages for visualizations. The survey data itself required relatively light cleaning, mainly just creating a category for missing data. Every question had some missing answers, so the way that this was dealt with was adding a new category called "No Response". This helped in visualizing the data and will also help when modeling it. The field future_contact had some missing values that were defaulted to "No" as to avoid harassing customers. The other_resources category was turned from a list into a number representing how many other resources they used, as this was more interpretable than the various categories. The only numeric column in the Survey data was time_spent_seconds, which had a number of outliers. These outliers (negatives times and completion times of up to a week) were identified and replaced by the median value (due to a non-Normal distribution) and composed about 3% of the data.

There were a number of duplicate surveys (around 74, or 0.1% of the data), and deduplication was not trivial---some surveys were drastically different from others, despite coming from the same user. I imagine this issue may arise from users sharing an account (only likely if it's a subscription account) or, more likely, a single user accidentally starting the survey and exiting, then later deciding to take it for real. For this latter "reason", I resolved the duplicate user_id's by choosing the entries that had the longer completion time and removing the other.


The usage statistics had many more inconsistencies. There were more erroneous and missing values, such as users having "streaks" that lasted 16 years (despite Duolingo being founded in 2011) and users making negative lesson progress. Erroneous and missing values were treated by replacing them with a sensible value, whether it was the median or some lower bound (i.e., highest_crown_count being set to 0). I decided to actually drop the daily_goal variable, as more than half of all users were missing it, and it would have likely confounded the analysis more than helped.

There were around 75 duplicate usage entries, which was quite odd, as one would have thought a single user could not have multiple duolingo_start_date's or lessons_completed. These duplicates were resolved by preferring the usage entry with the most lessons completed. Both de-duplication decisions were heuristically made after manually viewing the duplications (lines 117 and 124 in duolingo_analysis.r).

Exploration & Takeaways

Through visualizations I honed in on how well Duolingo fares with different audiences. From the upper left plot, it is clear that a subscription to the language learning application is increasingly popular as user age increases; however, the user base is primarily millennials and younger Gen X'ers. Users least likely to subscribe to Duolingo were young, low-income students from countries where English-speaking is widespread, which presents us with a target audience. Duolingo should try and incentivize 18-54 year olds in English-speaking countries to try their application, and then keep them active with the "crown" microcurrency in addition to highly incentivizing the maintenance of a streak, as those statistics are correlated with subscriptions. Of course, these users need a real incentive to actually start using the app.

Users who were learning from multiple outside resources were also more likely to purchase a subscription, so a good start is providing a good reason to begin learning in the first place. From looking over the other_resources column, it's evident that travel is a large motivator. Duolingo could perhaps organize collaborations with travel companies such that low-income users could get discounts if they happened to achieve a moderate amount of activity over a long period of time. This would have a ripple effect, as friends would wish to travel together and thus learn together (another motivator in itself!).

Modeling - duolingo_analysis.ipynb

I performed statistical analysis in both R and Python, as I'm more familiar with statistical analysis in the former, and machine learning and modeling in the latter. I generated correlation scatter matrices and plots and found that there was a subset of variables that correlated relatively strongly with one another, e.g., highest_course_progress, highest_crown_count, n_active_days. They were primarily activity indicators, and not overall novel or surprising in any way.

I used mutual information and sequential feature selection in order to rank individual variables as well as subsets of variables. After determining a subset of meaningful variables, I built two boosted models (RandomForeset & AdaBoost}) that had an F1-score of around 62%, although the precision and accuracy were 70%+ (not exactly impressive, given class imbalance within the data). Despite this, the trained model presented two variables as having high feature importance: n_lessons_started, longest_streak. This echoes the importance of incentivizing daily activity from users (and given the Duolingo Owl's threatening emails, he knows this).

Clustering

We can see that a lot of these variables make sense for predicting whether someone is a subscriber. They effectively demonstrate that subscribers use the service more than non-subscribers, and that they typically are older (i.e., not a student and have disposable income). This echoes what we've seen in our visual analysis. Can we further break down the user base, though?

I used hierarchical clustering on the full training data in order get a sense for user personas. I selected my cut-off to create 3 clusters, as that would provide more insight than the presumable "active" and "inactive" split that 2 clusters would show.

Analysis of Clusters

We overall come up with 3 separate user groups that we can roughly characterize as follows:

CLUSTER ONE:

  • Long time users — this is by far the biggest distinction of this cluster
  • Most likely to have a subscription! (by 16%)
  • Very dedicated users - longer streaks, utilizing more outside resources, earning more crowns
  • Middle-aged with disposable income (most likely to be employed full time)
  • Disproportionately from countries where English is relatively uncommon: Russia, Japan, Taiwan

CLUSTER TWO:

  • Largest Cluster
  • Primarily low-income students (least likely to purchase subscription)
  • Do not frequently use Duolingo (low activity)
  • Disproportionately from (relatively) english-speaking countries (Germany, US, Great Britain)
  • Generally younger, with least amount of income

CLUSTER THREE:

  • Casual users (more active than student, less active than the dedicated users)
  • From an even mix of countries
  • Least likely to have taken the placement test
  • Wide spread of ages
  • Seems to be everyone who doesn't fit well into clusters one or two

Conclusions

These clusters echo the visual analysis. Cluster 2 is by far the largest (at around 3000, relative to the other clusters being 1300), and is composed of low-income millennials from English-speaking countries. If Duolingo is able to organize a collaboration with travel agencies that would allow these users to access the same opportunities as cluster 1 (with disposable income), that could create a larger volume of daily users and increase subscription rates. Thanks for reading!