Top 50
Prep plan
Updated weekly · Last refresh Nov 11

Shopee Marketing Analytics Specialist Interview Questions

The questions to prepare for a Shopee Marketing Analytics Specialist interview. Questions from real interview reports rank first. Updated daily.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 1 drill · ~53 min
SQL Top 3 Campaigns by MonthMedium
Practice

Rank Arby’s campaigns by monthly revenue using aggregation, date grouping, joins, and ROW_NUMBER().

Window FunctionsDate FunctionsRankingShopee
SQL Conversion Rate by ChannelMedium
Practice

Use a LEFT JOIN, conditional aggregation, and date filtering to calculate L.L.Bean conversion rates by channel and day.

Date FunctionsGroup ByAggregationsShopee
Daily or Regional AggregationsEasy
Practice
Practice drill

Calculate completed Shopee order counts and daily GMV using WHERE, GROUP BY, and SUM.

Date FunctionsGroup ByAggregationsShopee
More SQL & Data Manipulation questions with a free account
2
Metrics10 questions · ~86 min
Improve Product Funnel ConversionMedium

Explain how to improve a product funnel by defining the right conversion metric, breaking the funnel apart, and acting on the biggest drop offs.

AARRR FrameworkFunnel AnalysisConversion RateShopee
Diagnose Client Engagement DropMedium

Diagnose a sharp decline in client engagement and break it down into cohorts, funnel steps, and likely business drivers.

Leading IndicatorsDiagnosisEngagement MetricsShopee
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
Statistics & Probability3 questions · ~26 min
Correlation Versus Causation in MarketingEasy

Explain why an observed marketing relationship can be correlated without being causal, and how you would validate a true causal effect.

CorrelationHypothesis TestingCausal InferenceShopee
More Statistics & Probability questions with a free account
4
A/B Testing & Experimentation4 questions · ~34 min
Marketing Campaign A/B Test DesignMedium

Design a marketing campaign experiment with a pre-registered metric plan, power calculation, and ship rule that respects guardrails.

ExperimentationHypothesis TestingA/B TestingShopee
Designing an A/B Test for Feature ImpactMedium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B TestingShopee
More A/B Testing & Experimentation questions with a free account
5
Strategy4 questions · ~34 min
What You Know About ShopeeMedium

Evaluates understanding of Shopee’s market context and marketing footprint.

company knowledgeShopee
More Strategy questions with a free account
6
Behavioral & Leadership24 questions · ~205 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 1 hands-on drill to finish this plan.