Dataford
Top 13
Prep plan
Updated weekly · Last refresh Sep 18

Smartsheet Product Growth Analyst Interview Questions

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

13questions
~2htotal time
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
A/B Testing & ExperimentationStart here. 3 questions · ~27 min
Measure Onboarding Message ImpactMedium

Design an A/B test to determine whether a new onboarding message changes downstream user behavior without harming key guardrails.

ExperimentationConversion RateA/B TestingSmartsheet
Handling Novelty in ExperimentsHard

Tests experimental design skills to prevent novelty bias in long-running product tests.

Smartsheet
More A/B Testing & Experimentation questions with a free account
2
Product Sense3 questions · ~27 min
Improving Smartsheet Viral LoopMedium

Assesses product growth strategy for strengthening virality in Smartsheet collaboration features.

Smartsheet
More Product Sense questions with a free account
3
More topics7 questions · ~62 min
Calculate 30-Day User RetentionHard
Practice

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

Window FunctionsDate FunctionsAggregationsSmartsheet
Evaluate CAC, LTV, and PaybackMedium

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

CACDiagnosisLTVSmartsheet
Optimizing Self Serve Channel MixMedium

Approach for allocating acquisition spend and attention across self serve channels using unit economics, attribution, and LTV quality.

channel mixGrowth StrategyoptimizationSmartsheet
Cohort Analysis for RetentionMedium

Evaluates statistical thinking for measuring retention dynamics using cohort methods.

Data Analysisuser retentionCohort AnalysisSmartsheet
Investigate User Engagement DeclineMedium

Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.

RetentionDiagnosisEngagement MetricsSmartsheet
More questions with a free account

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. 2 drills · ~20 min
Second Highest Value in SQLEasy
Practice
Practice drill

Find the second highest distinct CRP value from completed trials using a join and DENSE_RANK window function.

aggregationsql queriesIQVIASmartsheetEnova International
Consecutive Activity Days QueryMedium
Practice
Practice drill

Identify each user's consecutive website activity streaks using date arithmetic and SQL window functions.

Window FunctionsDate FunctionsData ManipulationIntuit Management ConsultancyChewyAllstate
The finish line: interview-readyComplete all 13 questions plus 2 hands-on drills to finish this plan.