Market Sizing and Opportunity Assessment Questions

TAM/SAM/SOM estimation approach (BI Analyst perspective)

Definitions

• TAM: Total revenue opportunity (all US companies × price if everyone bought).
• SAM: Segment of TAM the product can serve (US mid-market companies needing task-management SaaS).
• SOM: Realistic share you can capture in near-term (first 3 years) given GTM constraints.

Top-down approach

1. Start from macro counts: # of US businesses by employee size (Census, BLS, SBA).
2. Apply incidence rates for software adoption and category fit (Gartner, Forrester).
3. Multiply by target ARPA (annual recurring price per account).

Bottom-up approach

1. Start from internal/customer data or benchmark conversion funnels (lead → trial → paid).
2. Estimate reachable accounts via channels (sales capacity, marketing pipeline), ACV, churn.
3. Scale using go-to-market capacity and market penetration targets.

Data sources to consult

• US Census Business Dynamics, BLS, SBA size breakdowns
• Dun & Bradstreet / ZoomInfo firmographics
• Gartner/Forrester reports on collaboration/task-management SaaS adoption
• IDC / Statista for ARPU benchmarks
• Internal CRM and conversion metrics, LinkedIn Sales Navigator for TAM validation

Back-of-envelope calculations (explicit assumptions + sensitivity)

1. TAM (top-down)

• Assumption: 6M US businesses; mid-market = 5–999 employees is ~200k (SBA/D&B). Assume every mid-market company buys task SaaS at $6,000 ARR average.
• TAM = 200,000 × $6,000 = $1.2B.
• Sensitivity: ARPA $4k–$8k → TAM $800M–$1.6B; company count ±20% → $640M–$1.92B.

2. SAM (refined top-down / category fit)

• Assumption: Of 200k mid-market, 60% are knowledge-work (marketing, engineering, ops) likely to adopt → 120k. Accessibility (US-focused product features) 80% → 96k.
• SAM = 96,000 × $6,000 = $576M.
• Sensitivity: category rate 50–70%, accessibility 60–90% → SAM range ~$360M–$756M.

3. SOM (bottom-up, 3-year achievable)

• Assumptions: SMB sales model with inside sales: one AE can close 25 new accounts/year at $6k ACV. Initial GTM hires = 8 AEs → new bookings/year = 200 accounts = $1.2M ARR new. With 20% churn, net adds ~160 → Year3 ARR ≈ $1.2M × 3 ≈ $3.6M (conservative growth & compounding ignored). Alternatively, aim for 1% penetration of SAM by year 3: 0.01 × $576M = $5.76M.
• Choose SOM = $4–6M in first 3 years.
• Sensitivity: AE productivity 15–35 accounts → SOM $2.4M–$5.6M; hiring scale ±50% scales SOM similarly.

How I’d present as a BI Analyst

• Dashboard with filters: company size, industry, geography, ARPA scenarios.
• Inputs editable: adoption %, ARPA, AE productivity → live recalculation of TAM/SAM/SOM and sensitivity bands.
• Data layers: census baseline, firmographic samples (ZoomInfo), internal funnel KPIs to switch between top-down and bottom-up views.

Datasets required

• Internal
  • Historical GMV, orders, AOV, cancellations, repeat rate, customer LTV by city/region
  • Marketing spend & channel-level CAC, conversion funnels, promo performance
  • Fulfillment/operational metrics: delivery times, cost per order, warehouse utilization
  • Partner/supply metrics: onboarding time, SKU fill rates, supplier capacity
  • Pricing/cost structure (COGS, local taxes, shipping)
• External
  • Population, demographics, income, density (census/municipal)
  • Competitor presence & share (store locations, delivery coverage)
  • Consumer demand signals: search trends, category-level spend, foot traffic (SafeGraph/Google Mobility)
  • Local regulations, permit timelines, tax rates
  • Logistics data: road network, average delivery times, fuel/courier rates
  • Macroeconomic indicators and unemployment

Top-line analyses & thresholds

• TAM & reachable market: population × category penetration rate → target GMV ≥ X (e.g., covers fixed costs + target margin within 12 months)
• Unit economics per order: Contribution margin = AOV − variable cost − fulfillment − average promo. Threshold: positive contribution within 6 months and payback CAC ≤ 12 months.
• Break-even analysis: fixed launch + operating costs / contribution margin → required orders per month; threshold: attainable given demand forecasts and marketing plan.
• Supply-side feasibility: supplier coverage ≥ 90% SKU availability; delivery SLA achievable for ≥ 80% of target zip codes.
• Sensitivity/scenario modeling: best/likely/worst for demand, CAC, fulfillment cost to assess risk.

Monitoring dashboard (post-launch)

• Top row (health): Daily GMV, orders, AOV, conversion rate, active customers, new vs. repeat
• Unit economics card: CAC, contribution margin per order, payback period (rolling 30d)
• Supply & ops: fulfillment rate, on-time delivery %, average delivery time, cost per delivery
• Customer funnel: site visits → add-to-cart → checkout → purchase, by channel
• Geography map: heatmap of orders, delivery success by ZIP, underserved zones
• Alerts & targets: KPIs vs. forecast with automated thresholds (red/yellow/green), anomaly detection on traffic or fulfillment drops
• Drill-downs: cohort LTV, promo lift analysis, channel ROI
  Implementation notes
• Automate ETL daily; include ability to adjust model inputs (CAC, penetration) for scenario replay; share executive summary widget for weekly leadership reviews.