Back to Dashboard

Data Warehouse

Complete metrics library for your practice. Select a category to explore.

Revenue Metrics

Track all revenue-related performance indicators

Daily Revenue Today
$8,450
+12.3%
vs yesterday Avg: $7,200
Weekly Revenue This Week
$52,340
+8.7%
vs last week Target: $50K
Monthly Revenue MTD
$186,520
+15.2%
vs last month Goal: $200K
YTD Revenue Year to Date
$2.14M
+22.8%
vs last year On track
Top Provider Revenue This Month
$68,400
+9.4%
Dr. Brown 37% of total
Top Service Revenue This Month
$72,100
+11.2%
Dermal Fillers 39% of total
Cash Payments This Month
$124,850
+6.8%
67% of revenue Industry: 60%
Average Ticket This Month
$385
+4.3%
vs last month Benchmark: $350
Revenue Per Hour Top 25%
$485
+12.4%
vs last month Industry: $420

Patient Metrics

Track patient acquisition, retention, and lifetime value

New Patients This Month
47
+18%
vs last month Goal: 50
Returning Patients This Month
312
+8%
vs last month 87% of visits
Active Patients Total
1,847
+5.2%
Last 12 months Growing steadily
Average LTV Strong
$3,240
+14%
vs last year Industry: $2,800
High-Value Patients LTV > $5K
284
+22%
15% of patients 62% of revenue
Retention Rate 12-Month
78%
+3%
vs last year Benchmark: 75%
Churn Rate Monitor
4.2%
-0.8%
Monthly rate Industry: 5%
At-Risk Patients Action Needed
12
-3
from yesterday $14K at risk

Appointment Metrics

Monitor scheduling efficiency and appointment outcomes

Scheduled Today Live
24
+4
vs avg daily Capacity: 28
Completed This Week This Week
89
+12%
vs last week 94% completion
No-Show Rate Good
3.2%
-1.1%
vs last month Industry: 5%
Cancellation Rate This Month
8.4%
-2.3%
vs last month Industry: 10%
Utilization Rate Optimal
86%
+5%
vs last month Target: 85%
Avg Appointment Duration This Month
42 min
+2 min
vs last month Target: 45 min
Open Slots Today Fill Now
3
$1,450
potential revenue Avg: 4 slots
Same-Day Rebooking This Month
68%
+5%
vs last month Target: 72%

Provider Metrics

Evaluate provider performance and productivity

Dr. Brown - Revenue Top Performer
$68,400
+12%
This month $520/hr
Dr. Chen - Revenue This Month
$52,800
+8%
This month $465/hr
NP Jones - Revenue This Month
$38,500
+15%
This month $385/hr
Total Hours Worked This Month
384 hrs
+24 hrs
All providers Capacity: 420
Patients Seen This Month
486
+42
vs last month 1.3 pts/hr
Consultation Conversion All Providers
45%
-3%
vs last month Target: 50%
Rebooking Rate All Providers
68%
+5%
vs last month Target: 72%
Patient Satisfaction Excellent
4.8
+0.2
out of 5.0 Industry: 4.5

Service Metrics

Analyze service performance and revenue contribution

Dermal Fillers - Revenue #1 Service
$72,100
+11%
This month 39% of revenue
Neurotoxin - Revenue #2 Service
$58,200
+8%
This month 31% of revenue
Skin Treatments - Revenue #3 Service
$32,400
+18%
This month 17% of revenue
Neurotoxin - Volume #1 Volume
186
+12%
treatments/mo 38% of appts
Injectables Mix % of Total
70%
+3%
of revenue Industry: 65%
Non-Injectables Mix % of Total
30%
-3%
of revenue Industry: 35%
Avg Filler Price Per Session
$685
+5%
vs last month Market: $650
Avg Neurotoxin Price Per Session
$312
+3%
vs last month Market: $300

Inventory Metrics

Monitor stock levels, costs, and margins

Product Sales This Month
$18,450
+22%
vs last month 10% of revenue
Low Stock Items Action Needed
4
Reorder
items below min $2,400 needed
Cost of Goods This Month
$42,800
-3%
vs last month 23% of revenue
Gross Margin Healthy
77%
+2%
vs last month Industry: 72%
Injectable Margin This Month
82%
+1%
vs last month Target: 80%
Retail Product Margin This Month
45%
0%
vs last month Target: 50%
Inventory Turnover Quarterly
4.2x
+0.4x
vs last quarter Target: 4x
Waste/Expiry Loss Low
$840
-35%
This month 0.5% of COGS

Marketing Metrics

Track lead generation and marketing ROI

New Leads This Month
124
+28%
vs last month Goal: 100
Lead Conversions This Month
47
+18%
38% conversion Industry: 30%
Cost Per Acquisition Efficient
$85
-12%
vs last month Industry: $120
Google Ads Leads #1 Source
52
+35%
42% of leads $68 CPA
Instagram Leads #2 Source
38
+45%
31% of leads $52 CPA
Patient Referrals #3 Source
24
+12%
19% of leads $0 CPA
Marketing Spend This Month
$8,200
+15%
4.4% of revenue Budget: $10K
Marketing ROI Strong
6.2x
+0.8x
vs last month Target: 5x

Membership Metrics

Track subscription performance and recurring revenue

Active Members Total
284
+18
vs last month 15% of patients
Monthly Recurring Revenue Growing
$42,600
+12%
vs last month 23% of revenue
Membership Churn Low
2.1%
-0.5%
Monthly rate Industry: 4%
Plan Upgrades This Month
12
+4
+$1,800 MRR 4.2% rate
Plan Downgrades This Month
3
0
-$450 MRR 1.1% rate
Avg Revenue/Member Monthly
$150
+$8
vs last month Industry: $125
New Signups This Month
24
+8
vs last month Goal: 20
Member LTV High
$7,140
+15%
vs non-members 2.2x higher