Bolt Product Growth Analyst Interview Questions

The questions to prepare for a Bolt Product Growth Analyst interview. Questions from real interview reports rank first. Updated weekly.

More Behavioral & Leadership questions with a free account

More Strategy questions with a free account

Calculate 30-Day User Retention

Medium

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregations

Bolt

Build Monthly Retention Cohort Table

Hard

Build a monthly customer retention cohort table using CTEs, date math, and conditional aggregation.

Window FunctionsDate FunctionsAggregations

Bolt

More SQL & Data Manipulation questions with a free account

Evaluate CAC, LTV, and Payback

Medium

Assess whether a new acquisition channel is efficient by comparing CAC, LTV, and payback period.

CACDiagnosisLTV

Bolt

More Metrics questions with a free account

Create a free account to unlock this list and practice real interview questions.

Investigating Surge Pricing Driver Churn

Medium

Tests ability to diagnose pricing-related churn drivers and propose actionable analyses.

Bolt

More Product Sense questions with a free account

Handling Missing Data for Demand

Medium

Tests practical data preprocessing choices for modeling driver demand reliably.

predictive modelingdata integrity

Bolt

More Statistics & Probability questions with a free account

Design Test for New Feature

Medium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B Testing

Bolt

Open any question for its full solution and discussion.