##### Scenario Enterprise collaboration product “Share Workplace” is considering a freemium + subscription business model. ##### Question Size the annual revenue opportunity for the paid tier three years after launch. Given separate ARPU assumptions for paid and free cohorts, calculate total and cohort-level contribution margins. If marketing spend increases by 20 %, estimate its impact on subscriber count and profitability; state the assumptions you need. ##### Hints Structure the funnel (site visits → sign-ups → active → paid), keep unit economics visible, show step-by-step math clearly.

This question evaluates revenue forecasting, unit-economics modeling, cohort and funnel analysis, and marketing ROI estimation for a freemium/subscription product.

How do I approach Analytics & Experimentation interview questions?

Analytics & Experimentation questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master analytics & experimentation interviews.

What difficulty level is this interview question?

This is a medium difficulty Analytics & Experimentation question, commonly asked during Technical Screen rounds at Capital One.

What role is this question designed for?

This question is commonly asked for Data Scientist candidates at Capital One during technical interviews.

Estimate Revenue and Profitability for Share Workplace's Paid Tier

Freemium + Subscription Sizing, Margins, and Marketing Impact (Year 3)

Context

You are evaluating a freemium enterprise collaboration app ("Share Workplace") three years after launch. Users flow through a funnel from site visits to sign-ups, to actives, to paid subscriptions. Both free and paid cohorts monetize (subscriptions for paid; ads/upsell for free). Variable COGS apply to both cohorts, and the company spends on paid marketing to drive a portion of visits.

Assume reasonable funnel, monetization, cost, and marketing parameters where not provided. Show clear formulas and step-by-step math. Keep unit economics visible.

Tasks

Size the annual revenue opportunity for the paid tier in Year 3 (12 months ending month 36).
Using separate ARPU assumptions for paid and free cohorts, compute:
- Cohort-level contribution margins (paid and free, excluding marketing).
- Total contribution margin (including marketing spend).
If marketing spend increases by 20% at the start of Year 3, estimate the impact on:
- Subscriber count (paid) and free MAU in Year 3.
- Profitability in Year 3 and at steady-state.
- Clearly state any assumptions.

Hint: Structure the funnel (site visits → sign-ups → active → paid), keep unit economics visible, show math clearly.

Context

Assume reasonable funnel, monetization, cost, and marketing parameters where not provided. Show clear formulas and step-by-step math. Keep unit economics visible.

Tasks

Size the annual revenue opportunity for the paid tier in Year 3 (12 months ending month 36).

Using separate ARPU assumptions for paid and free cohorts, compute:

Cohort-level contribution margins (paid and free, excluding marketing).
Total contribution margin (including marketing spend).

If marketing spend increases by 20% at the start of Year 3, estimate the impact on:

Subscriber count (paid) and free MAU in Year 3.
Profitability in Year 3 and at steady-state.
Clearly state any assumptions.

Hint: Structure the funnel (site visits → sign-ups → active → paid), keep unit economics visible, show math clearly.

Estimate Revenue and Profitability for Share Workplace's Paid Tier

Quick Overview

Freemium + Subscription Sizing, Margins, and Marketing Impact (Year 3)

Context

Tasks

Solution

Submit Your Answer to Earn 20XP

Estimate Revenue and Profitability for Share Workplace's Paid Tier

Quick Overview

Freemium + Subscription Sizing, Margins, and Marketing Impact (Year 3)

Context

Tasks

Solution

Submit Your Answer to Earn 20XP