The weekly numbers ritual
On Sunday evening, the owner exports appointments from the clinic software, pastes them into a spreadsheet that has grown over years and starts filtering. New patients this week. Total visits. Patient visit average for last month's new patients. Reactivations. Visits per chiropractor. Collections. The formulas mostly work, except when the export format changes or an associate's name is spelled differently.
Chiropractic coaching and practice management culture puts a lot of weight on these numbers, and many owners find them genuinely useful. The problem is not the numbers. It is that producing them takes an evening a week and relies on one person's spreadsheet.
Why built-in reports are not enough
Clinic software reports are designed to be general. They show appointments, revenue and perhaps new patients. The measures chiropractors talk about are more specific: PVA for a cohort of new patients over a period, reactivations defined by a gap since last visit, retention through a care plan. Each clinic defines them slightly differently, and the software cannot know your definition.
So the export and the spreadsheet become the real reporting system, and they are fragile.
What fragile reporting costs
- An evening a week of the owner's time.
- Numbers that shift when the spreadsheet breaks, which undermines trust in them.
- Associates who see their figures once a month, too late to act on.
- Arguments about definitions rather than about what to do next.
- Trends that are hard to see because each week's sheet is separate.
| Measure | Question it answers | Defined by |
|---|---|---|
| New patients | Is marketing bringing people in? | Your rule, e.g. first ever visit |
| Patient visit average | Do new patients stay for their care? | Your cohort and time window |
| Reactivations | Are lapsed patients coming back? | Your gap threshold |
| Plan completion | Do patients finish what they agreed? | Your plan records |
| Visits per practitioner | How is the diary loaded? | Attended appointments |
How we build the dashboard
- We start with your current spreadsheet and write down exactly how each figure is calculated, resolving any ambiguity with you.
- The system reads appointments, patients, invoices and payments from your clinic software each night, through its API or scheduled exports.
- Each measure is calculated using your written definition, the same way every time.
- The dashboard shows each figure for the clinic and per practitioner, by week and month, with trend lines.
- Associates can have their own view showing only their figures, if you want them to.
- Every figure can be clicked through to the list of patients or visits behind it, so any number can be checked.
- If a definition changes, it changes from a date and the history is kept, so trends remain honest.
We do not set targets or tell you what good looks like. The dashboard shows your numbers, calculated your way, without the Sunday evening.
What the owner gains
The numbers are there on Monday morning without anyone building them. Everyone sees the same figures calculated the same way. Associates can check their own progress during the week. And because each number links to the patients behind it, a dip in PVA leads straight to a list of the new patients who did not return, which is something you can act on.
Team meetings shift from 'are these numbers right?' to 'what are we doing about them?', which is the conversation you wanted to have.
Data quality improves as a side effect. When a figure looks wrong and you click through, you often find the cause is a mis-typed appointment type or a duplicate patient. Those get fixed at source, and every report after that is more accurate, including the ones inside your clinic software.
Sound familiar?
- Weekly stats are built in a spreadsheet from exports.
- Only the owner understands how the figures are calculated.
- The spreadsheet breaks when an export changes.
- Associates see their numbers late, if at all.
- You cannot easily click from a figure to the patients behind it.