A free Claude skill by Audrey Campbell, MPH. Last reviewed November 2026.
Build your Claude dashboard
Five numbers that say how your practice is really doing, in one dashboard you can share. Claude walks you through it step by step, from which reports to export to how to update it each month.
Add the skill to Claude
About five minutes. Works on free and paid Claude plans.
Claude
Turn on file creation in Settings, Capabilities. Then Customize, Skills, the + button, Upload a skill, and pick this skill’s zip.
Claude Code
Run /plugin marketplace add audcampbell/aesthetic-ai-toolkit, then install build-your-claude-dashboard. You only get this one tool.
ChatGPT
Make a Project, open its settings and paste the skill into the instructions.
Any other AI
Paste the skill at the top of a new chat.
Export last month’s reports
Say “build my practice dashboard.” Tell Claude your booking or EMR system and it lists the exact reports and where to find them. Summary reports only, never patient lists.
- Sales summaryService revenue for the month.
- Appointments reportCompleted visits, and consults, filtered to appointments booked as a consult.
- Rebooking reportThe share of patients who left with their next visit booked.
- Membership reportNew memberships sold that month.
- Provider hoursHours worked, from your utilization report or payroll.
- Optional historyThe same reports for the last six to twelve months, for trend lines.
Answer a few questions
It asks about your practice first, then builds one small file of monthly totals with you. That file is all the dashboard ever needs.
- Your systems and Claude plan. So every step names your own menus and what your plan can do.
- Who should see it. Just you, your manager, your medical director or the team.
- What it should help you decide. Whether to hire, whether marketing works, which provider needs more bookings.
- Your goals, if you have them. It never makes goals up. The right goal depends on your market and your stage, and is best set with a consultant.
What you get back
A sample for a made-up practice, October against September.
“Consult conversion rose to 59.1%. Rebooking slipped to 25%.”
| KPI | September | October | How it’s figured |
|---|---|---|---|
| Rebooking rate | 27% | 25% | patients rebooked ÷ patients seen |
| Membership conversion | 6.0% | 7.1% | new memberships ÷ non-member patients seen |
| Consult conversion | 55.0% | 59.1% | consults that booked ÷ consults |
| Average ticket | $493.51 | $500.00 | service revenue ÷ appointments |
| Revenue per provider hour | $237.50 | $250.00 | service revenue ÷ provider hours worked |
- The dashboard itself, built in Claude, saved to your Artifacts, and shareable by link.
- Your monthly totals file, one row a month, ready for next month.
- Your report list, sharing steps for your plan, and a 20 to 30 minute monthly routine.
- An email to me, drafted for you, if you want help building the plan to move these numbers. You review it and send it yourself.
Want a dashboard that updates itself?
Built from exported reports, a Claude dashboard changes only when you add the new month. For one that pulls your EMR, payroll and accounting in automatically, by provider and by location, I suggest Illume, and I can connect you with them.
These five numbers tell you where you stand. Moving them takes a plan and your team behind it, and that’s where working with a consultant pays off.
Start with five
There are dozens of numbers you could track: membership penetration, client lifetime value, cancellation rate, cross-sell rate, retail. Some take complicated reports to get right. Five numbers, checked every month, beat thirty that nobody looks at.
Be honest about the limits. A dashboard is only as good as your data. If appointments aren’t closed out or consults aren’t booked as consults, it will look precise and be wrong. Setup takes one to two hours the first time, then 20 to 30 minutes a month.
How the math works
The skill runs these in code, never in its head, and notes where each number came from. If your system can’t separate member and non-member visits, it divides by new patients instead and says so.
- Rebooking rate
patients who left with their next visit booked ÷ patients seen - Membership conversion
new memberships sold ÷ non-member patients seen - Consult conversion
consults that booked a treatment ÷ consults completed - Average ticket
service revenue ÷ completed appointments - Revenue per provider hour
service revenue ÷ provider hours worked
Read the skill
The full instructions Claude follows. Copy them into ChatGPT or any other AI if you don’t use Claude.
Loading the skill…
Before you use it
- Totals only. No patient names, phone numbers or treatment details. Summary reports only.
- It doesn’t refresh itself. Built from exports, it changes when someone adds the new month.
- Claude’s menus and plans change often. The steps follow Anthropic’s help center as of November 2026.
- A planning tool, not financial or legal advice.