Occupancy and Idle Time: Busy Minutes, Hourly Occupancy, Overloaded and Underused Hours, a Weighted Day Figure and a Line Chart
Lessons in this course
- First Response Time: Minutes from Message to First Human Reply, a Target Check, Average, Median and Share Within TargetFree
- Resolution Time by Topic: Hours from Open to Close, a Resolution Target, AVERAGEIFS per Topic and the Longest Case Locked
- Service Levels by Channel: Target Lookup per Channel, a Met-or-Missed Flag, Attainment with COUNTIFS and a Warning Rule Locked
- Volume by Hour: Weekday Averages, Share of the Week, the Peak Hour with INDEX/MATCH, the Busiest Day and a Column Chart Locked
- Staffing Requirement: Workload Hours, Agents Needed at a Target Occupancy, the Roster Gap and Shortage Highlighting Locked
- Occupancy and Idle Time: Busy Minutes, Hourly Occupancy, Overloaded and Underused Hours, a Weighted Day Figure and a Line Chart Locked
- Deflection to Help Content: Self-Served Sessions, Self-Service Rate, Contacts Avoided and the Cost Avoided Locked
- Help-Content Priorities: Share of Contacts by Topic, Rank, Contacts a New Article Could Avoid and the Top-Three Concentration Locked
- Sentiment Before and After: Score Change per Case, a Threshold for Real Change, Outcome Labels, the Average Change and the Share Improved Locked
- Reply Speed and Sentiment: Speed Bands with COUNTIFS, Average Sentiment Change per Band, CORREL and a Column Chart Locked
- Escalation Rate by Topic: Rate, Target Check, Escalations Above Target with MAX, the Weighted Overall Rate and an Above-Average Rule Locked
- What Escalations Cost: Cost per Case from Tier-1 and Tier-2 Minutes, Total Cost by Reason, Avoidable Escalations and the Weighted Average Locked
- Cost per Contact by Channel: Labour and Tool Cost, Cost per Contact, an Index versus Phone, the Blended Cost and a Bar Chart Locked
- Cost per Resolution: Contacts per Resolved Case, Cost per Resolution, Savings at a Target, a Rank and the Total Opportunity Locked
- Agent Productivity and Quality: Cases per Hour, Team Rates, a Review-Weighted Quality Score and a Fair Coaching Flag Locked
- First-Contact Resolution and Reopens: a 1/0 Flag with IF and AND, FCR Rate, Reopen Rate, Messages per Case by Topic and Long Threads Locked
- Weekly Volume Forecast: SLOPE and FORECAST.LINEAR, a Campaign Uplift, Agents Needed from the Forecast and a Trend Chart Locked
- Is the Gain Real? Paired Differences, an Average with its 95 % Margin of Error (CONFIDENCE.T), a Paired T-Test and a Verdict Locked
- What-If Grid: Monthly Care Cost for Every Deflection Rate and Cost per Contact, a Heat Map, Net Saving, Break-Even and Scenario Count Locked
- Final Project: Social Care Scorecard by Month with SLA Attainment, Escalation Rate, Cost per Contact, a Cap Flag and a Combo Chart Locked