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.
- 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
- The New-Patient Funnel: Enquiry Sources, Booking Rate and Show RateFree
- Cost per New Patient: Cost per Enquiry, per Booking and per Attended Patient by Source Locked
- Speed to First Reply: Booking Rate by Response Time, Index and Bookings Forgone Locked
- Missed Calls and After-Hours Enquiries: Missed Rate, Rank and New Patients Lost Locked
- Appointment Reminders and No-Shows: Show Rate by Method and Extra Visits to Reach a Target Locked
- First-Year Value of a New Patient: Revenue, Contribution and the Highest Affordable Acquisition Cost Locked
- Service-Line Mix: Share of New Patients, Total Contribution, Rank and Weighted Average Locked
- Recall Reminders: Contact Coverage, Booking Rate, Recall Rate and Revenue from Recalled Visits Locked
- Capacity and Empty Slots: Fill Rate, Spare-Capacity Weeks and Where Marketing Can Help Locked
- Local Listing Performance: Views, Actions, Action Rate and Bookings per 100 Actions by Site Locked
- Referral Partners: Change, Share, Attended Rate and the Concentration of the Top Three Locked
- Compliant Claims: A Review Register with Status, Risk Weights, Open Risk and Live Items on Hold Locked
- Privacy-Safe Reporting: Small-Cell Suppression, Combined Groups and Aggregate-Only Tables Locked
- Attribution: Tracked vs Self-Reported Sources, Agreement and Blended Credit Locked
- Waiting Time: Show Rate by Wait Band, Weighted Average Wait and Working Days with NETWORKDAYS Locked
- Trend and Forecast: Moving Average, Linear Trend, Seasonal Gaps and FORECAST.LINEAR Locked
- Budget Allocation with Capacity Limits: Expected Patients, Unused Budget and Room to Add Locked
- Testing Changes: Pooled Rate, Standard Error, z Value, p-Value and the People Needed per Group Locked
- Data Quality: Reconciling Marketing Counts with the Practice System and Finding Untracked Patients Locked
- Final Project: A Quarterly Patient-Acquisition Scorecard with Rates, Cost, Return and Status Locked
Learner reviews
Be the first to review this course.