Tabellab
Marketing Analytics Intermediate

Healthcare Clinic Patient Acquisition: Enquiry Sources, Booking & Show Rates, Cost per New Patient, Recall Reminders, Service-Line Mix & Compliant Reporting

Turn clinic marketing into numbers a practice manager can act on. You will build the enquiry-to-visit funnel with booking and show rates, price a new patient by source, test how reply speed, missed calls and reminders change results, value a new patient over the first year and weigh the service-line mix, then run recall campaigns and check capacity before you add demand. Further labs cover local listings, referral partners, a claims review register, privacy-safe aggregate reporting with small-cell suppression, tracked versus self-reported sources, waiting times, trend forecasts, budgets with capacity limits, a simple two-group test and reconciliation with the practice system, and you finish with a quarterly scorecard. Aggregate, non-identifying data only, no medical advice, and rules differ by country: 20 hands-on labs, fictional Linnet Row Clinic Group data, 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

In this course you work through 20 hands-on spreadsheet labs for the marketing side of a clinic or practice. You start with the enquiry-to-visit funnel of Linnet Row Clinic Group, a fictional group of clinics, and calculate booking rates, show rates and the cost per new patient for every enquiry source. You then test how reply speed, missed calls and appointment reminders change the numbers, value a new patient over the first year, weigh the service-line mix and run recall reminders. Later labs cover capacity and empty slots, local listings, referral partners, a claims review register, small-cell suppression for privacy-safe reports, tracked versus self-reported sources, waiting times, trend forecasts, budgets with capacity limits, a two-group test and reconciliation with the practice system. A quarterly scorecard closes the course, and every formula is checked as you type. The course uses aggregate, non-identifying data only, gives no medical advice and notes that advertising and privacy rules differ by country. All companies, clinics and numbers 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. 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

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