Top 18
Prep plan
Updated weekly · Last refresh Aug 30

TikTok Shop Data Analyst Interview Questions

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

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~24 min
Investigate User Engagement DeclineMedium
Recently asked

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

RetentionDiagnosisEngagement MetricsTikTok Shop
Investigate Daily Active User DropMedium

Assesses debugging of metric declines using segmentation, attribution, and root-cause analysis.

Data AnalysisTikTok Shop
Measure Influencer Feature SuccessMedium

Evaluates KPI selection, experiment thinking, and measurement design for product features.

TikTok Shop
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Optimizing Large-Scale SQLHard

Tests your ability to improve query performance using indexing, query plans, and data modeling.

large datasetsTikTok Shop
Cleaning Messy Data for AnalysisMedium

Assesses your data preparation skills and judgment when working with imperfect marketing data.

analytical skillsdata cleaningTikTok Shop
Dashboard for Campaign ConversionMedium

Assesses metric design, instrumentation, and dashboard structure for campaign performance.

Conversion Ratedata visualizationdashboard designTikTok Shop
7-Day Rolling Active UsersMedium
Practice
Recently asked
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
Calculate 30-Day User RetentionHard
Practice
Recently asked
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
SQL for Recruitment Conversion by DepartmentMedium
Practice
Practice drill

Calculate UiPath hiring conversion rates by department using LEFT JOIN, conditional aggregation, and date filtering.

Conversion Ratesql queryData AnalysisUiPath
3
Behavioral & Leadership11 questions · ~88 min
Data vs Stakeholder IntuitionMedium
Recently asked

Tests conflict resolution and influence when a candidate must defend data-driven recommendations against stakeholder intuition.

Influence Without AuthorityConflict ResolutionStakeholder ManagementTikTok Shop
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~8 min
Prioritize Categories for PromoMedium

Tests product prioritization and data-driven decision making under budget constraints.

TikTok Shop

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.