Automated PracticeQ Walk-In vs Booked Utilization
Every Monday, WebRun opens PracticeQ, pulls last week's completed appointments, splits them into walk-ins and booked visits by hour and chair, logs the utilization breakdown to a Google Sheet, and sends you the week's busiest and slowest windows over Telegram.
How do I track walk-in versus booked appointment utilization?
WebRun reviews last week's completed PracticeQ appointments every Monday, splits them into walk-ins and pre-booked visits by hour and chair, and logs the full utilization breakdown to a Google Sheet. It then sends you the week's busiest and slowest windows over Telegram, so staffing and booking decisions are based on real usage patterns.
- Slow hours and packed hours are visible every Monday morning
- Walk-in share versus booked share is tracked without manual counting
- Chairs sitting empty show up before they become a pattern
Built for IV hydration clinics · medspa IV bars · infusion therapy clinics · multi-location drip clinics
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
practiceq.comin a real browser with your saved login - no setup, no API keys. -
1
PracticeQ - pull last week's completed appointments
practiceq.com
WebRun opens PracticeQ to pull last week's completed appointments. - Open PracticeQ and pull every completed appointment from the past 7 days
- Tag each visit as walk-in or pre-booked
- Record the chair or room and the hour each visit started
Done when Every visit from last week is tagged walk-in or booked with its hour and chair.
-
2
Google Sheets - log utilization by hour and chair
google.com
WebRun opens Google Sheets to log utilization by hour and chair. - Log each visit as a row with its type, hour, and chair
- Build a utilization total for each hour of the day across the week
- Calculate the walk-in share versus booked share for the week
Done when A full week of utilization by hour and visit type sits in the sheet.
-
3
Telegram - send you the week's trend
telegram.org
WebRun opens Telegram to send you the week's trend. - Send a summary of the busiest and slowest hours from the week
- Include the walk-in versus booked split as a percentage
- Flag any chair that sat empty most of the week
Done when You have the week's utilization trend in Telegram.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change my booking rules or pricing?
No. It only reads last week's completed appointments and reports the utilization pattern. Any change to hours, pricing, or booking rules is a decision you make yourself.
How does it tell walk-ins from booked visits?
It reads how each appointment was created in PracticeQ, whether it was scheduled ahead of time or added as a same-day walk-in, and tags it accordingly before totaling the week.
Can I see a longer trend than one week?
Yes. Each week's totals land as new rows in the same Google Sheet, so you can compare week over week once a few runs have logged.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.