cohort / retention analysis
Budget: $30 – $250 USD
Company A is an Ed-Tech Company and is looking to grow our Monthly Active Users (MAU). Your job is to create a model that forecasts our MAU each month for 2023 and 2024.
MAU is a function of new users who create a free account in that month (we call this a
“sign up”) and returning users who created an account previously and are returning to Company A in
that month. Company A has roughly 60M MAU when averaged over each of the last 12 months*.
We’d like you to build the model cohorted by year of sign up. Please model the following
cohorts: 2019 and prior (this includes 2019, 2018, 2017, etc - we’re bucketing these for
simplicity), 2020, 2021, 2022, 2023, and 2024. Each of these cohorts represents the number of
sign ups in that year (e.g. in 2020 we had roughly 50M sign ups). You should model the
retention rate for each of these cohorts in each month (e.g. not all of the 50M sign ups from
2020 will use Quizlet in Jan’23).
For each sign up cohort, we’d also like you to forecast two geos: the US and international. Our
MAU base is roughly ⅔ US and ⅓ international today, but we’re growing faster internationally.
Your final Excel output should include (at a minimum - not exhaustive):
● Sign Ups, Retention Rate, and MAU by cohort and geo, aggregated by month, quarter,
and year for Jan 2023 - Dec 2024. Please make this a dynamic model.
-Company A had about 170mm sign ups in 2019 and prior, 50mm sign ups in 2020, 60mm sign ups in 2021 and 60mm sign ups in 2022
MAU is a function of new users who create a free account in that month (we call this a
“sign up”) and returning users who created an account previously and are returning to Company A in
that month. Company A has roughly 60M MAU when averaged over each of the last 12 months*.
We’d like you to build the model cohorted by year of sign up. Please model the following
cohorts: 2019 and prior (this includes 2019, 2018, 2017, etc - we’re bucketing these for
simplicity), 2020, 2021, 2022, 2023, and 2024. Each of these cohorts represents the number of
sign ups in that year (e.g. in 2020 we had roughly 50M sign ups). You should model the
retention rate for each of these cohorts in each month (e.g. not all of the 50M sign ups from
2020 will use Quizlet in Jan’23).
For each sign up cohort, we’d also like you to forecast two geos: the US and international. Our
MAU base is roughly ⅔ US and ⅓ international today, but we’re growing faster internationally.
Your final Excel output should include (at a minimum - not exhaustive):
● Sign Ups, Retention Rate, and MAU by cohort and geo, aggregated by month, quarter,
and year for Jan 2023 - Dec 2024. Please make this a dynamic model.
-Company A had about 170mm sign ups in 2019 and prior, 50mm sign ups in 2020, 60mm sign ups in 2021 and 60mm sign ups in 2022