Missed Opportunities Analysis
Complete analysis of all data
Key Insights & Recommendations
Overview
Monthly Trend
Calls by Day of Week
Calls by Shift
30-Day Rolling Averages
Rolling 30-Day Trend
Smoothed averages to see true trends without daily noiseCurrent Period Summary
When Are We Missing Calls?
Peak Loss Hours (Heatmap)
Bubble size = call volumeCoverage & Capacity Analysis
Coverage Issues by Shift
No truck vs ETA issuesCoverage Issues by Hour
When are trucks unavailable?Coverage Gap Summary
Quote Outlier Analysis
Large Quote Impact
Heavy truck quotes and other outliers that may skew your averagesDuty Type Deep Dive
Duty Types by Time of Day
Are we missing Heavy calls at night because trucks are unavailable?Duty Type Analysis
Why Are We Missing Calls?
Top Loss Reasons
By Service Type (Duty)
Loss Reasons Trend Over Time
Top 5 reasons by monthFinancial Impact
Quote Analysis by Duty Type
Price Sensitivity Analysis
Where does price become a barrier?Quote Value Distribution
Dispatcher Analysis
Calls by Dispatcher
Customer Types
Dispatcher Performance Breakdown
Callback Opportunities
Callback Potential Distribution
High-Value Callback Opportunities
Callback 6+ with quote valueCompany/Account Analysis
Top Companies - Missed Opportunity Breakdown
Which accounts are we struggling to service?Lost Revenue Analysis
Lost Revenue by Reason
Which reasons cost us the most money?Revenue Loss Breakdown
Week-over-Week Trends
Weekly Performance Trend
Last 12 weeksWeek-over-Week Comparison
Are we improving or getting worse?Winnable Opportunities
Winnable Score Distribution
How many opportunities are high-priority?What is "Winnable"?
The Winnable Score identifies missed calls most likely to convert on follow-up. It's calculated from:
- Callback Potential (40%) - Dispatcher's rating of likelihood to call back
- Non-Price Reason (30%) - Calls lost for ETA/coverage reasons are more winnable than price objections
- Quote Value (20%) - Higher value jobs are worth more follow-up effort
- Recency (10%) - More recent calls may still need service
High (70+): Priority callbacks - these customers are likely to convert
Medium (50-69): Worth following up when time permits
Low (<50): Lower probability of conversion