Tabellab

Customer Service for Online Shops: Contacts per Order, Contact Reasons, Response & Resolution Times, Handling Workload, Saved Replies, Refund vs Replacement Costs, Peak Staffing & Dashboard

Run the numbers behind the service desk of a fictional online home goods shop in 20 hands-on labs – contacts per 100 orders, contact reasons, response and resolution times, handling workload, staffing by weekday, arrival patterns, saved replies, late deliveries, refund versus replacement costs, a goodwill budget, cost per contact, satisfaction, quality checks, peak planning, backlog recovery and a final service dashboard – with 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

Customer service in an online shop is a numbers job. In 20 hands-on labs you work with one fictional home goods shop and calculate contacts per 100 orders by day, week and channel, rank contact reasons, compare average and median first-response times, measure first-contact resolution and turn handling minutes into workload hours. You then plan staff hours by weekday and for a sale week, size the morning backlog, price late deliveries, refunds and replacements, track a goodwill budget, work out cost per contact and per order, read satisfaction and quality-check results, clear a backlog and finish with a Red/Amber/Green service dashboard.

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. 30 Days of Service: Where Did We Fall Behind?LabFree
  2. Contact Rate: Contacts per 100 Orders by WeekLab Locked
  3. Contact Reasons: Why Do Customers Get in Touch?Lab Locked
  4. Response Times: Target, Median and AverageLab Locked
  5. Resolution: Contacts per Case and First-Contact FixesLab Locked
  6. Handling Time: Minutes per Reason → Workload HoursLab Locked
  7. Staffing: Hours Needed vs Shift Hours by WeekdayLab Locked
  8. Arrival Pattern: Contacts by Hour and the Morning BacklogLab Locked
  9. Saved Replies: Usage, Edits and Minutes SavedLab Locked
  10. Self-Service: Help-Page Views vs ContactsLab Locked
  11. Late Deliveries: Order-Status Contacts by CarrierLab Locked
  12. Refund, Replacement or Partial Refund: The CostLab Locked
  13. The Goodwill Budget: Vouchers and Shipping RefundsLab Locked
  14. Cost per Contact and per OrderLab Locked
  15. Satisfaction Scores by Channel and ReasonLab Locked
  16. Quality Checks: Sampled Replies on a ChecklistLab Locked
  17. Peak Planning: Sale Week Hours, Temps or OvertimeLab Locked
  18. Backlog Recovery: Days to Clear Open TicketsLab Locked
  19. Monthly Trend: Twelve Months of Service KPIsLab Locked
  20. Final Project: The Service DashboardLab 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