Tabellab
Marketing Analytics Intermediate

Social Customer Care: First-Response & Resolution Times, Volume & Staffing, Deflection, Sentiment, Escalation & Cost per Contact

Run social customer care by the numbers. You will turn timestamps into first-response and resolution times, test them against service levels per channel, read the volume by hour and convert it into agents, occupancy and idle time, measure how much help content deflects and what that saves, track sentiment before and after a reply and relate it to reply speed, count escalations and what they cost, work out the cost per contact and per resolution, check first-contact resolution and reopens, judge agents fairly with weighted quality scores, forecast weekly volume, test whether a new reply style really works, compare scenarios in a what-if grid and finish with a monthly care scorecard, in 20 hands-on labs with fictional data and every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the numbers behind social customer care through 20 interactive spreadsheet labs. You work for Lumenpath Broadband, a fictional home-internet provider whose customers write to it on social channels. In the labs you turn timestamps into first-response and resolution times, test them against service levels per channel, read the volume by hour and convert it into agents and occupancy, estimate how much help content deflects, track sentiment before and after a reply, count escalations and what they cost, and calculate the cost per contact and per resolution. Later labs cover first-contact resolution, fair agent scorecards, a weekly volume forecast, a significance test for a new reply style, a what-if grid and a final monthly scorecard with a chart. Every cell is checked as you type, and the 20-question exam leads to a certificate. All companies, cases and figures are fictional.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy