Tabellab

Compliant Claims: A Review Register with Status, Risk Weights, Open Risk and Live Items on Hold

Lesson 12 of 20 Lab 🔒 Locked

Lessons in this course

  1. The New-Patient Funnel: Enquiry Sources, Booking Rate and Show RateLabFree
  2. Cost per New Patient: Cost per Enquiry, per Booking and per Attended Patient by SourceLab Locked
  3. Speed to First Reply: Booking Rate by Response Time, Index and Bookings ForgoneLab Locked
  4. Missed Calls and After-Hours Enquiries: Missed Rate, Rank and New Patients LostLab Locked
  5. Appointment Reminders and No-Shows: Show Rate by Method and Extra Visits to Reach a TargetLab Locked
  6. First-Year Value of a New Patient: Revenue, Contribution and the Highest Affordable Acquisition CostLab Locked
  7. Service-Line Mix: Share of New Patients, Total Contribution, Rank and Weighted AverageLab Locked
  8. Recall Reminders: Contact Coverage, Booking Rate, Recall Rate and Revenue from Recalled VisitsLab Locked
  9. Capacity and Empty Slots: Fill Rate, Spare-Capacity Weeks and Where Marketing Can HelpLab Locked
  10. Local Listing Performance: Views, Actions, Action Rate and Bookings per 100 Actions by SiteLab Locked
  11. Referral Partners: Change, Share, Attended Rate and the Concentration of the Top ThreeLab Locked
  12. Compliant Claims: A Review Register with Status, Risk Weights, Open Risk and Live Items on HoldLab Locked
  13. Privacy-Safe Reporting: Small-Cell Suppression, Combined Groups and Aggregate-Only TablesLab Locked
  14. Attribution: Tracked vs Self-Reported Sources, Agreement and Blended CreditLab Locked
  15. Waiting Time: Show Rate by Wait Band, Weighted Average Wait and Working Days with NETWORKDAYSLab Locked
  16. Trend and Forecast: Moving Average, Linear Trend, Seasonal Gaps and FORECAST.LINEARLab Locked
  17. Budget Allocation with Capacity Limits: Expected Patients, Unused Budget and Room to AddLab Locked
  18. Testing Changes: Pooled Rate, Standard Error, z Value, p-Value and the People Needed per GroupLab Locked
  19. Data Quality: Reconciling Marketing Counts with the Practice System and Finding Untracked PatientsLab Locked
  20. Final Project: A Quarterly Patient-Acquisition Scorecard with Rates, Cost, Return and StatusLab Locked