Tabellab

Sentiment Before and After: Score Change per Case, a Threshold for Real Change, Outcome Labels, the Average Change and the Share Improved

Lesson 9 of 20 Lab 🔒 Locked

Lessons in this course

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