All templates

Automated Oral Surgery Provider Utilization Digest

Every Monday, WebRun opens DSN Software and pulls last week's procedure counts, chair time, and case mix for each oral surgeon, compiles the data into a provider utilization digest in Google Sheets with trend comparisons, and posts a summary to the practice manager's Slack channel.

Runs on WebRun · Strict Lockdown policy
Every Monday at 7:00 AM WebRunorchestrates each step
1 DSN Software pull per-surgeon procedure and chair-time data
2 Google Sheets build utilization digest with trend lines
3 Slack post weekly summary to practice manager
In short

How do I get a weekly provider utilization report for my oral surgery practice?

WebRun pulls last week's procedure counts and chair time from DSN Software every Monday for each oral surgeon, compiles a utilization digest with four-week trend comparisons in Google Sheets, and posts a summary to the practice manager in Slack. Surgeons with a utilization dip of more than 10 percent are flagged automatically for review.

  • Per-surgeon utilization percentages available before the Monday management meeting
  • Utilization dips flagged automatically so underperformance is caught in the same week
  • Four-week trend lines built automatically without manual spreadsheet work

Built for oral surgery practice managers · OMS group practice administrators · oral and maxillofacial surgery directors

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.dsn.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    DSN Software - pull per-surgeon procedure and chair-time data
    dsn.com
    WebRun in DSN Software: pull per-surgeon procedure and chair-time data
    WebRun opens DSN Software to pull per-surgeon procedure and chair-time data.
    • Open DSN Software and navigate to the production or provider reporting module
    • Pull last week's data for each surgeon: procedure count, total chair time, case types, and cancellation rate
    • Compare to the prior four-week average for each metric to surface trends

    Done when Per-surgeon procedure counts, chair time, and case mix for last week are pulled with four-week trend comparisons.

  3. 2
    Google Sheets - build utilization digest with trend lines
    google.com
    WebRun in Google Sheets: build utilization digest with trend lines
    WebRun opens Google Sheets to build utilization digest with trend lines.
    • Append last week's utilization data as a new row per surgeon in the provider digest sheet
    • Calculate chair utilization percentage (booked chair time divided by available chair time)
    • Flag any surgeon whose utilization fell more than 10 percent below their four-week average

    Done when The provider utilization digest is updated with last week's data, utilization percentages, and trend flags.

  4. 3
    Slack - post weekly summary to practice manager
    slack.com
    WebRun in Slack: post weekly summary to practice manager
    WebRun opens Slack to post weekly summary to practice manager.
    • Post a weekly digest summary to the practice manager Slack channel with each surgeon's utilization percentage
    • Highlight any surgeon flagged for a utilization dip with the percentage change
    • Include a link to the full Google Sheet for detailed review

    Done when Practice manager has last week's provider utilization summary with trend flags and a sheet link in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.dsn.com
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
Utilization digest · Slack
OutputWhat each run produces - A Google Sheet row per surgeon with last week's utilization data, chair time, and trend flags, plus a Slack digest summary for the practice manager.
Spreadsheet row
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does the digest include patient names or clinical details?

No. The digest reports aggregated metrics only: procedure counts, chair time, utilization percentages, and case type mix per surgeon. No patient-identifiable information is included in the Slack summary or Google Sheet.

How far back does the trend comparison go?

WebRun compares last week's numbers to the prior four-week rolling average for each surgeon, so the trend line reflects recent patterns rather than outlier weeks.

What counts as a utilization dip worth flagging?

Any surgeon whose chair utilization falls more than 10 percent below their four-week average is flagged in the Slack digest, giving the practice manager a specific data point to discuss.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.