LEADERSHIP DASHBOARD

Train Cancellation → Bus Booking Recovery Analysis

Week of June 21-27, 2025

---

📊 EXECUTIVE SUMMARY

KEY FINDING: Our platform successfully recovers train cancellation customers through bus bookings, generating higher revenue per customer.

---

🚨 TRAIN CANCELLATION BREAKDOWN

Daily Cancellation Impact

Primary Cancellation Reasons

• Waitlisted Tickets (WL): 56,401 bookings
• Remote Location Waitlist (RLWL): 25,174 bookings
• Reservation Against Cancellation (RAC): 23,305 bookings
• Specific Reason: "Ticket is still in waitlisted/RAC" → 6,690 customers

---

💰 REVENUE IMPACT ANALYSIS

Financial Recovery

🏆 KEY INSIGHT: Bus Bookings Generate Higher Revenue

• Average Bus Ticket: ₹991.54
• Average Lost Train Ticket: ₹923.27
• Revenue Premium: ₹68.27 per converted customer (+7.4%)

---

🚌 BUS ECOSYSTEM PERFORMANCE

Operator Diversification

• Total Bus Operators Used: 204 unique operators
• Average Operators per Day: ~29 operators
• Market Coverage: Comprehensive route alternatives available

Customer Journey Timeline

• Conversion Window: Within 2 days of train cancellation
• Peak Conversion Days: June 22 & 25 (3.2% & 3.7% rates)
• Fastest Recovery: Same-day bookings preferred

---

📈 STRATEGIC INSIGHTS

✅ WHAT'S WORKING

1. Revenue Optimization: Bus bookings generate 7.4% higher revenue per customer
2. Platform Stickiness: 3.4% of affected customers stay within ecosystem
3. Alternative Availability: 204 bus operators provide comprehensive coverage
4. Quick Recovery: Customers convert within 48 hours

⚠️ IMPROVEMENT OPPORTUNITIES

1. Low Conversion Rate: Only 3.4% of cancelled train customers convert to bus
2. Daily Volatility: Conversion rates vary from 1.9% to 3.7%
3. Customer Retention: 96.6% of cancelled customers potentially lost to competitors

💡 UNTAPPED POTENTIAL

• 8,888 customers (96.6%) cancelled trains but didn't book buses
• Potential Additional Revenue: ₹8.82 Crores if conversion rate reaches 100%
• Potential Additional Revenue: ₹88.2 Lakhs if conversion rate reaches 10%

---

🎯 LEADERSHIP ACTION ITEMS

IMMEDIATE (Next 7 Days)

1. 🚨 Proactive Communication: SMS/Email alerts to waitlisted customers about bus alternatives
2. 💸 Conversion Incentives: Special discounts for train-cancelled customers booking buses
3. 📱 UX Enhancement: One-click train-to-bus rebooking feature

SHORT-TERM (Next 30 Days)

1. 🤖 AI Recommendations: Auto-suggest bus alternatives when train booking fails
2. 🎁 Retention Campaign: Cashback offers specifically for conversion journeys
3. 📊 Route Mapping: Identify top cancelled train routes for bus capacity planning

STRATEGIC (Next Quarter)

1. 🔄 Seamless Integration: Platform that treats train+bus as unified travel options
2. 🤝 Operator Partnerships: Preferential agreements with key bus operators
3. 📈 Conversion Optimization: Target 10% conversion rate (potential ₹88L additional revenue)

---

🚨 RISK & OPPORTUNITY ASSESSMENT

🎯 OPPORTUNITY VALUE

• Current Recovery: ₹12.15L revenue from 317 customers
• 10% Conversion Target: ₹1.00Cr+ potential revenue
• Market Leadership: First-mover advantage in train-bus conversion

---

📞 IMMEDIATE NEXT STEPS

Week 1 Priorities

• Design proactive notification system for waitlisted train customers
• Create special conversion discount campaign (suggest: 15% off bus bookings)
• Implement train-to-bus conversion tracking dashboard

Executive Decision Required

• Budget Allocation: Marketing spend for conversion campaigns
• Product Priority: Train-to-bus UX enhancement timeline
• Partnership Strategy: Bus operator preferential agreements

---

🎯 BOTTOM LINE

We're successfully converting train cancellations into higher-value bus bookings, but we're only capturing 3.4% of the opportunity. A focused conversion strategy could unlock ₹88+ Lakhs in additional revenue.

---

Analysis Period: June 21-27, 2025 | Data Sources: dwh.trains_olap, dwh.bus_olap | Customers Analyzed: 9,205 train cancellations