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

Pinterest Data Analyst Interview Questions

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

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~64 min
Top Saved Pin Categories QueryMedium
Practice

Use joins, date filtering, aggregation, and ROW_NUMBER to find the three most-saved Pin categories for new Pinterest users.

Date FunctionsGroup ByAggregationsPinterest
Week-Over-Week Retention With PandasMedium

Tests ability to compute retention metrics with Pandas using engagement and user metadata on Pinterest.

RetentionData WranglingTime SeriesPinterest
SQL Rolling Average and RankingHard
Practice
Recently asked
Practice drill

Use CTEs and window functions to calculate 7-day transaction averages and rank Loft users within each region.

Window FunctionsRankingRunning TotalsLoftArcadisCgi Nederland
30-Day Moving Average of BookingsMedium
Practice
Practice drill

Build a daily series and compute a 30-day trailing moving average of task bookings using window functions.

Window FunctionsData WranglingAggregationsTaskRabbitRBC
More SQL & Data Manipulation questions with a free account
2
Metrics3 questions · ~26 min
KPIs for Pinterest Ads HealthEasy

Tests ability to choose and justify KPIs for advertising performance and system health on Pinterest.

KPILeading IndicatorsDiagnosisPinterest
Diagnose a Sudden DAU DropHard

Investigate whether an 8.2% DAU decline is driven by product breakage, logging issues, or normal seasonal patterns.

DAU/MAUDiagnosisTime SeriesPinterest
Cohort Engagement for Seasonal PlanningMedium

Tests metric design for engagement that matches Pinterest user intent and seasonality.

User SegmentsCohort AnalysisEngagement MetricsPinterest

Sign up to see every question

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

Get my prep plan
3
Behavioral & Leadership6 questions · ~52 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~26 min
Success Metrics for Visual SearchMedium

Tests product sense for selecting measurable outcomes and metrics for a Pinterest feature launch.

MetricsFeature PrioritizationUser NeedsPinterest
A/B Test for Related PinsMedium

Tests experiment design, metric selection, and causal thinking for Pinterest recommendations.

experiment designGuardrail MetricsA/B TestingPinterest
Spot Emerging Trends for AdvertisersHard

Evaluates how you translate data signals into actionable trend insights for Pinterest advertisers.

Market TrendsPinterest
The finish line: interview-readyComplete all 17 questions plus 2 hands-on drills to finish this plan.