PracHub
QuestionsPremiumCoachesLearningGuidesInterview Prep
|Home/Analytics & Experimentation/DoorDash

Allocate Support Cost and Diagnose Decline

Last updated: Mar 29, 2026

Quick Overview

This question evaluates operational analytics competencies including cost allocation and attribution for support work, root-cause diagnosis of KPI regressions, and metric design for complaint-driver identification and prevention.

  • hard
  • DoorDash
  • Analytics & Experimentation
  • Analytics Engineer

Allocate Support Cost and Diagnose Decline

Company: DoorDash

Role: Analytics Engineer

Category: Analytics & Experimentation

Difficulty: hard

Interview Round: Technical Screen

You are the analytics partner for the Customer Support team at a food-delivery company. You have the following data: agents(agent_id, monthly_salary, productive_hours, tenure, locale), tickets(ticket_id, created_at, resolved_at, issue_type, severity, channel, order_id, merchant_id, courier_id, csat, reopened_flag, escalated_flag), and ticket_touches(ticket_id, agent_id, minutes_spent, action_ts). 1) Design a fair method to allocate salary cost or performance-based compensation across support agents using completed complaint tickets. Explain how you would adjust for ticket difficulty, multiple agents touching the same ticket, quality, and gaming risk. 2) A core support KPI suddenly declines. Explain how you would determine whether the drop is caused by instrumentation changes, seasonality, queue mix, staffing, or a real operational issue. 3) Complaint volume is rising because merchants prepare the wrong order, couriers pick up the wrong bag, or couriers deliver to the wrong customer. What metrics would you track, how would you identify the main driver, and what preventive interventions would you recommend?

Quick Answer: This question evaluates operational analytics competencies including cost allocation and attribution for support work, root-cause diagnosis of KPI regressions, and metric design for complaint-driver identification and prevention.

Related Interview Questions

  • Evaluate Biker Feature Success - DoorDash (hard)
  • How would you test product changes? - DoorDash (hard)
  • How to test bike delivery? - DoorDash (medium)
  • Investigate LA successful orders drop - DoorDash (easy)
  • How would you diagnose a completed orders drop? - DoorDash (easy)
DoorDash logo
DoorDash
Oct 12, 2025, 12:00 AM
Analytics Engineer
Technical Screen
Analytics & Experimentation
2
0

You are the analytics partner for the Customer Support team at a food-delivery company. You have the following data: agents(agent_id, monthly_salary, productive_hours, tenure, locale), tickets(ticket_id, created_at, resolved_at, issue_type, severity, channel, order_id, merchant_id, courier_id, csat, reopened_flag, escalated_flag), and ticket_touches(ticket_id, agent_id, minutes_spent, action_ts). 1) Design a fair method to allocate salary cost or performance-based compensation across support agents using completed complaint tickets. Explain how you would adjust for ticket difficulty, multiple agents touching the same ticket, quality, and gaming risk. 2) A core support KPI suddenly declines. Explain how you would determine whether the drop is caused by instrumentation changes, seasonality, queue mix, staffing, or a real operational issue. 3) Complaint volume is rising because merchants prepare the wrong order, couriers pick up the wrong bag, or couriers deliver to the wrong customer. What metrics would you track, how would you identify the main driver, and what preventive interventions would you recommend?

Solution

Show

Submit Your Answer to Earn 20XP

Sign in to leave a comment

Loading comments...

Browse More Questions

More Analytics & Experimentation•More DoorDash•More Analytics Engineer•DoorDash Analytics Engineer•DoorDash Analytics & Experimentation•Analytics Engineer Analytics & Experimentation
PracHub

Master your tech interviews with 8,000+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.