Katkat
Back

Size an Opportunity and Present It with Clear Visuals

PinterestData Scientist · Onsite
MediumData ScientistOnsiteAnalytics & Experimentation

Last updated

Tests your ability to size an ambiguous product opportunity using top-down and bottom-up estimation, stress-test core assumptions with sensitivity analysis, and design executive-ready visuals to guide strategic investment decisions.

Scenario

Pinterest is considering developing an automated "Shop the Look" feature powered by computer vision. This feature automatically detects shoppable items in user-uploaded Fashion and Home Decor Pins, tagging them with interactive hotspots that link directly to retailer product pages with affiliate checkout.

Leadership wants to evaluate whether this initiative justifies dedicating a cross-functional team of 10 engineers and data scientists for the next two quarters. You are tasked with sizing the annual incremental revenue opportunity, evaluating uncertainty, and presenting your findings to the VP of Product.

Tasks

1. Sizing Framework

  • Top-down estimate: Size the total addressable market (TAM) and serviceable obtainable market (SOM) using macro metrics (e.g., overall social commerce spend, Pinterest's market share, vertical penetration in Home/Fashion).
  • Bottom-up estimate: Construct an operational funnel based on user engagement metrics: Monthly Active Users (MAU) -> category surface engagement -> Pin impressions with hotspots -> hotspot click-through rate (CTR) -> merchant site conversion rate -> average order value (AOV) -> Pinterest take rate / affiliate cut.
  • Reconcile disparities between your top-down and bottom-up numbers.

2. Sensitivity and Risk Analysis

  • Identify the 2–3 most volatile assumptions in your bottom-up model.
  • Detail how you would run a sensitivity analysis (e.g., parameter ranges for CTR and retailer conversion rates) and define bear, base, and bull scenarios.
  • Address cannibalization: How might this feature impact standard promoted pin ad revenue?

3. Executive Visual Presentation

  • Propose a visual narrative (using 2–3 specific chart types) to present the findings to senior leadership.
  • Explain how your charts communicate uncertainty, trade-offs, and go/no-go investment thresholds without overwhelming the audience with statistical jargon.

Hints

Hint 1

Start by establishing the boundary conditions: clarify whether revenue is purely affiliate commission or also accounts for increased user engagement leading to incremental ad impressions.

Hint 2

For the bottom-up model, anchor conversion rates and click-through rates against existing benchmarks like Pinterest Lens or standard Promoted Pins.

Hint 3

When selecting executive visuals, consider using a tornado diagram for parameter sensitivity and a waterfall or bridge chart to walk leaders from gross market potential to net realized revenue.

Follow-up questions

  • How would you design a phased pilot or offline evaluation to de-risk the most uncertain parameters before committing the full 10-person team?
  • If the bottom-up model predicts $30M in incremental affiliate revenue but ad auction modeling suggests $10M in cannibalized ad spend, how do you frame the net business case?
  • Post-launch, how would you design an experiment to isolate the true causal lift of hotspot tags versus organic intent to shop?