Dataford
Top 33
Prep plan
Updated weekly · Last refresh Aug 30

TikTok Business Analyst Interview Questions

The questions to prepare for a TikTok Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

33questions
~4htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 3 drills · ~94 min
Find Duplicate Ad Clicks in WindowMedium
Recently asked

Tests ability to design deduplication logic for clickstream data.

Date Functionssqldata integrityTikTok
Optimize Slow Join QueriesHard
Recently asked

Tests SQL performance troubleshooting and join optimization for high-volume TikTok analytics queries.

Performance TuningJoinsquery optimizationTikTok
Basic Joins and Window FunctionsMedium
Practice
Practice drill

Join TikTok Shop tables, calculate creator GMV, and rank creators within each product category using ROW_NUMBER().

Window FunctionsJoinssqlTikTok
SQL With Window FunctionsMedium
Practice
Practice drill

Rank each active creator's public TikTok videos by January engagement using joins, aggregation, and ROW_NUMBER().

Window FunctionssqlTikTok
Calculate 30-Day User RetentionHard
Practice
Practice drill

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

Window FunctionsDate FunctionsAggregationsCurefitReachMobiIndeed
More SQL & Data Manipulation questions with a free account
2
Strategy4 questions · ~32 min
Allocate Promotional Budget to Max GMVHard
Recently asked

Tests strategic planning and prioritization using GMV-focused tradeoffs across categories.

Business ModelTikTok
Commercial Value of New Brand OnboardingMedium
Recently asked

Tests business case development and quantifying expected value for TikTok Shop growth.

product launchcustomer lifetime valueTikTok
More Strategy 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
Metrics8 questions · ~64 min
Assess TikTok LIVE HealthMedium
Recently asked

Tests ability to define health metrics that capture quality, engagement, and sustainability.

KPITikTok
Define Creator RetentionMedium
Recently asked

Tests metric design and cohort-based thinking for creator lifecycle analytics.

RetentionCohort AnalysisTikTok
Evaluate TikTok LIVE PerformanceMedium
Recently asked

Tests understanding of LIVE KPIs and how to translate them into business insights.

KPIEngagement MetricsTikTok
More Metrics questions with a free account
4
Behavioral & Leadership12 questions · ~96 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~8 min
Ad Frequency Experiment DesignHard
Recently asked

Tests experimental design and causal reasoning to balance monetization and user retention on TikTok.

experiment designRetentionA/B TestingTikTok
The finish line: interview-readyComplete all 33 questions plus 3 hands-on drills to finish this plan.