Automated RamSoft Referral Volume Tracking
Every Monday, WebRun opens RamSoft PowerServer, tallies completed studies from the prior week grouped by referring provider and facility, appends the results to a Google Sheet referral dashboard, calculates week-over-week volume changes, and posts a top-and-bottom-movers summary to the business development team in Slack.
How do I automatically track referring provider study volume trends from RamSoft each week?
WebRun opens RamSoft PowerServer every Monday, tallies the prior week's completed studies by referring provider and facility, updates a Google Sheet referral volume dashboard with week-over-week changes, and posts a top-and-bottom-movers digest to the business development team in Slack so growing relationships are recognized and declining ones get timely attention.
- Business development sees which referring relationships are growing and which are declining every Monday
- The rolling Google Sheet builds a multi-month referral trend line for strategic planning
- No manual data pulling from RamSoft is needed to produce the weekly referral report
Built for teleradiology group business development teams · radiology practice administrators · imaging center marketing coordinators · hospital radiology service line managers
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
www.ramsoft.comin a real browser with your saved login - no setup, no API keys. -
1
RamSoft - pull prior-week studies by referring provider
ramsoft.com
WebRun opens RamSoft to pull prior-week studies by referring provider. - Open RamSoft PowerServer and pull completed studies for the prior calendar week
- Group the study count by referring provider name and by referring facility
- Capture the modality breakdown for each top referrer to understand service mix
Done when Prior-week study counts by referring provider and facility are captured with modality breakdown.
-
2
Google Sheets - update referral volume dashboard
google.com
WebRun opens Google Sheets to update referral volume dashboard. - Append the weekly volume totals for each referring provider to the referral dashboard sheet
- Calculate the week-over-week change for each provider as a percentage and absolute count
- Highlight providers who grew by more than 20 percent and those who declined by more than 20 percent
Done when The referral dashboard is updated with this week's volumes and week-over-week change percentages.
-
3
Slack - post top and bottom movers to business development team
slack.com
WebRun opens Slack to post top and bottom movers to business development team. - Post a digest to the business development Slack channel listing the top five growers and the top five decliners by volume change
- Include last week's study count and the change percentage for each
- Add a link to the Google Sheet dashboard for the full referral breakdown
Done when The business development team has this week's referral mover list in Slack.
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 include any patient information in the Slack digest?
No. The Slack digest contains only aggregate study counts by referring provider and facility name. No patient identifiers, diagnoses, or report content appear in the Slack message.
How far back does it look for the week-over-week comparison?
WebRun compares the prior calendar week against the same week one period before, using the study-completion dates in RamSoft. You can also configure the comparison period to be the same week from the prior month or the prior year during setup.
Can we add a target volume goal for each referring provider?
Yes. Add a target column to the Google Sheet during setup and WebRun will include each provider's attainment percentage in the weekly digest so the business development team can prioritize outreach based on gap to goal.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.