Evaluate Last-Mile Product Metric Changes
Company: Walmart Labs
Role: Data Analyst
Category: Analytics & Experimentation
Difficulty: medium
Interview Round: Technical Screen
You are a Principal Data Analyst supporting Walmart Last Mile delivery products. The customer journey includes browsing or cart entry, selecting delivery, seeing available delivery slots, delivery fees, and estimated arrival time, placing the order, fulfillment by a store or fulfillment center, driver assignment, and final delivery.
Answer the following product analytics case as if you were advising a product and operations leadership team:
1. A core metric, such as delivery checkout conversion rate, changed materially last week. How would you diagnose what happened? Describe the clarifying questions, funnel decomposition, segmentation, hypotheses, validation steps, and how you would separate a real business change from a data or instrumentation issue.
2. The team is launching a new last-mile feature, for example a delivery-slot recommendation or improved ETA promise experience. Design a metrics framework to evaluate whether the feature is successful. Include adoption metrics, customer experience metrics, operational metrics, business impact metrics, and guardrail metrics.
3. Suppose there is no reliable historical benchmark and the feature was not launched through a clean randomized A/B test. Propose an analysis plan to estimate impact anyway. Describe the analytical dataset, proxy metrics, likely confounders, selection bias risks, and possible causal or quasi-experimental approaches.
4. Explain how you would communicate the result to senior executives and turn the analysis into a product or business recommendation.
Quick Answer: This question evaluates product analytics, experimentation design, causal inference, instrumentation validation, and executive communication competencies in the context of last-mile delivery metric changes.