Why has the on-time delivery rate for RappiMart orders fallen below 80% in Mexico City this quarter?

Introduction

The on-time delivery rate for RappiMart orders falling below 80% in Mexico City this quarter is a critical issue that demands immediate attention. This metric directly impacts customer satisfaction, retention, and the overall success of our quick-commerce model. To address this problem, I'll employ a systematic approach to identify, validate, and resolve the root cause while considering both short-term fixes and long-term strategic implications.

Step 1

Clarifying Questions (3 minutes)

• Looking at the timing, I'm thinking there might be a seasonal factor at play. Has there been any significant change in order volume or patterns compared to previous quarters?

Why it matters: Seasonal fluctuations could explain temporary dips in performance. Expected answer: Order volumes have increased by 20% compared to last quarter. Impact on approach: If confirmed, we'd need to focus on scalability and capacity issues.

• Considering potential system changes, have there been any recent updates to the order routing algorithm or delivery partner assignment system?

Why it matters: Technical changes often have unintended consequences on performance metrics. Expected answer: A new version of the routing algorithm was deployed two weeks ago. Impact on approach: If true, we'd prioritize investigating the algorithm's impact and potential rollback.

• Thinking about external factors, has there been any significant change in traffic patterns or road conditions in Mexico City recently?

Why it matters: External factors can significantly impact delivery times and are often overlooked. Expected answer: No major changes reported, but there's been an increase in road construction projects. Impact on approach: If confirmed, we'd need to adjust our routing and ETA calculations accordingly.

• Considering potential data issues, has there been any change in how we measure or define "on-time delivery" for RappiMart orders?

Why it matters: Metric definition changes can lead to apparent performance drops without actual service degradation. Expected answer: No changes to the metric definition or measurement system. Impact on approach: If changes were made, we'd need to recalibrate our analysis based on the new definition.