Top 24
Prep plan
Updated weekly · Last refresh Oct 17

Zulily Marketing Analytics Specialist Interview Questions

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

24questions
~4htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions · ~38 min
Compare Monthly User Retention CohortsMedium
Practice

Calculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.

Window FunctionsDate FunctionsAggregationsZulily
Choosing the Right SQL JoinMedium

Explain how to join two datasets in PostgreSQL and justify when INNER JOIN or LEFT JOIN is the right choice.

JoinsData ManipulationsqlZulily
Top 10% Customers by ValueMedium
Practice

Write a SQL query to identify the top 10% of customers based on their total purchase value over the last 90 days at Zulily. Use completed purchases only. ...

Date FunctionsRankingGroup ByZulily
More SQL & Data Manipulation questions with a free account
2
Metrics10 questions · ~95 min
Compare CAC Against LTVMedium

Calculate CAC and compare it with LTV to decide whether an acquisition campaign is economically viable.

CACcampaign viabilityLTVZulily
Search Placement vs Conversion CostHard

Tests your ability to optimize marketing spend using unit economics and performance tradeoffs.

cost analysisZulily
ROAS and Budget ReallocationMedium

Tests paid search performance evaluation and practical budget allocation using ROAS.

campaign performanceZulily
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
Behavioral & Leadership8 questions · ~76 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~19 min
A/B Testing With Limited DataMedium

Assesses A/B testing fundamentals and how you approach experiment design and analysis under uncertainty.

analyticsZulily
Incremental Lift Experiment DesignHard

Tests experimental design and causal inference using incremental lift for paid social.

experiment designincremental liftZulily
The finish line: interview-readyComplete all 24 questions to finish this plan.