Top 18
Company roadmap
Updated weekly · Last refresh Nov 6
P

Product Madness Interview Questions

The questions to prepare for Product Madness interviews, across all roles. Questions from real interview reports rank first. Updated daily.

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
Behavioral & LeadershipStart here. 10 questions · ~93 min
More Behavioral & Leadership questions with a free account
2
More topics8 questions · ~75 min
Top Spenders QueryHard
Practice

Use CTEs, aggregation, and percentile analysis to identify Ubisoft's top 5% of spenders in a defined period.

sql queryPProduct Madness
Define Metrics for New FeaturesMedium

Define a success metric for a new feature that captures real user value, not just raw usage.

MetricsFeature Prioritizationuser valuePProduct Madness
Design a Feature-Concept A/B StudyHard

Design an A/B test to compare two feature concepts, including hypothesis, metrics, power, and a pre-registered decision rule.

ExperimentationGuardrail MetricsA/B TestingPProduct Madness
Design Patterns ExperienceHard

Assesses practical experience selecting, implementing, and testing design patterns that improve maintainability without adding unnecessary complexity.

software designTestabilitydesign patternsPProduct Madness
Analyze Sudden Drop in MAUsHard

Diagnose a sudden monthly active user decline by validating the metric, isolating affected segments, and identifying likely product or data causes.

DAU/MAUDiagnosisuser engagementPProduct Madness
Rolling 30-Day Retention QueryHard
Practice

Calculate rolling 30-day retention for top-tier legal firms using date-range joins and aggregation.

Date FunctionsJoinssql queryPProduct Madness
Balance Revenue and User ExperienceEasy

Approach for balancing monetization with user experience in a product decision.

User NeedsValue PropositionProduct VisionPProduct Madness
Trusting Small Experiment EffectsHard

Assess whether a statistically significant but small A/B test lift is credible, practically meaningful, and safe to ship.

Confidence IntervalsStatistical SignificancePower AnalysisPProduct Madness

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 1 drill · ~10 min
The finish line: interview-readyComplete all 18 questions plus 1 hands-on drill to finish this plan.