Dataford
Top 25
Prep plan
Updated weekly · Last refresh Sep 25

Rokt Data Analyst Interview Questions

The questions to prepare for a Rokt Data Analyst interview. Questions from real interview reports rank first. Updated daily.

25questions
~4htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
Statistics & ProbabilityStart here. 10 questions · ~86 min
Evaluate Marketing Campaign Impact with A/B TestingHard

Determine if a 2.5% conversion increase from a marketing campaign is statistically significant using a two-proportion z-test.

ExperimentationCausal InferenceStatistical SignificanceRokt
Power Analysis for Experiment PlanningMedium

Reason about power analysis when planning an experiment and choosing sample size.

ExperimentationPower AnalysisSample SizeRokt
A/B Testing Experience and ImplementationEasy

Explain how you have designed and implemented A/B tests, including hypothesis setup, analysis, and decision making.

ExperimentationStatistical SignificanceA/B TestingRokt
More Statistics & Probability questions with a free account
2
Metrics11 questions · ~95 min
Measure Core Feature EngagementMedium

Define the metrics that show whether engagement in a core feature is improving.

RetentionDiagnosisEngagement MetricsRokt
Diagnose Funnel Drop-OffMedium

Analyze where users drop off in a product funnel and identify the biggest conversion leak.

AARRR FrameworkFunnel AnalysisConversion RateRokt
Classify Leading vs Lagging MetricsEasy

Explain how to distinguish early directional metrics from outcome metrics, using a clear KPI framework tied to product decisions.

Lagging IndicatorsKPIsLeading IndicatorsRokt
More Metrics 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
3
More topics4 questions · ~35 min
Cleaning and Preparing Messy DataEasy

Tests data cleaning rigor and preparation practices to ensure reliable analysis at Rokt.

Data WranglingETLQualityRokt
SQL, Python, or R ExperienceEasy

Tests hands-on data analysis tooling proficiency relevant to Rokt’s data workflows.

JoinsData WranglingRokt
More questions with a free account
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Business SQL for Ops InsightsMedium
Practice
Practice drill

Aggregate Rokt campaign delivery events to calculate volume and success rates, including campaigns with no matching events.

JoinsData Analysisbusiness problemRokt
7-Day Rolling Average ExportsMedium
Practice
Practice drill

Calculate a 7-day rolling average of Adobe Acrobat document exports using a window function.

Data AnalysisAggregationsAbbottAdobeOOura Ring
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
The finish line: interview-readyComplete all 25 questions plus 3 hands-on drills to finish this plan.