Analytics & Dashboards Guide
Understand your clinic’s performance with data visualizations. Create custom dashboards to track metrics that matter most to your business.Getting Started
Access analytics by clicking Analytics from the main menu. You’ll find:- Dashboards - Pre-built and custom analytics views
- Reports - Detailed data exports and analysis
- Widgets - Individual metrics and charts
Pre-Built Dashboards
Start with templates designed for common use cases.Revenue Dashboard
Track money coming in: Metrics shown:- Total revenue (this month, this year)
- Revenue by service type
- Revenue by provider
- Daily/weekly revenue trend
- Average transaction value
- Top-performing services
- Understand revenue trends
- Identify best-performing services
- Track seasonal patterns
- Forecast monthly revenue
Appointments Dashboard
Monitor scheduling and patient flow: Metrics shown:- Total appointments (today, this week, this month)
- Appointments by provider
- Appointments by service
- No-show rate
- Cancellation rate
- Average wait time
- Busiest hours/days
- Optimize scheduling
- Identify understaffed times
- Monitor no-show patterns
- Improve patient flow
Patient Dashboard
Analyze patient data: Metrics shown:- New patients (this month)
- Patient retention rate
- Total active patients
- Patients by location
- Appointments per patient
- Patient lifetime value
- Churn rate (patients who left)
- Understand patient base growth
- Measure retention success
- Track patient acquisition
- Identify at-risk patients
Staff Performance Dashboard
Evaluate team productivity: Metrics shown:- Appointments per provider
- Revenue per provider
- Patient satisfaction by provider
- Utilization rate (booked vs. available time)
- Earnings/commission by provider
- Top rated providers
- Recognize high performers
- Identify training needs
- Ensure fair workload
- Calculate commissions
Billing Dashboard
Monitor financial health: Metrics shown:- Outstanding balances
- Days sales outstanding (DSO)
- Payment methods breakdown
- Invoice aging report
- Write-offs and adjustments
- Payment failure rate
- Improve collection rates
- Reduce outstanding debt
- Identify payment issues
- Forecast cash flow
Creating Custom Dashboards
Build dashboards tailored to your needs.Creating a Dashboard
- Go to Analytics
- Click Create Dashboard
- Name it (e.g., “Daily Operations”)
- Click Create
Adding Widgets
Add metrics/charts to dashboard:- Click Add Widget
- Choose widget type:
- Metric - Single number (Total Revenue = $50,000)
- Line Chart - Trends over time
- Bar Chart - Comparisons
- Pie Chart - Breakdown/distribution
- Table - Detailed data
- Select data source (Revenue, Appointments, etc.)
- Set filters (date range, location, etc.)
- Customize display (colors, labels)
- Click Add
Widget Types Explained
Metric Widget Shows single important number:- Example: “Total Revenue This Month: $50,000”
- Good for KPIs
- Displayed prominently
- Example: Daily revenue trend
- X-axis: Time
- Y-axis: Value
- Good for spotting trends
- Example: Revenue by provider
- X-axis: Categories
- Y-axis: Values
- Good for comparisons
- Example: Appointments by service type
- Shows percentages
- Good for composition
- Rows and columns of data
- Sortable and filterable
- Good for detailed analysis
Filtering Data
Refine what displays in widgets:- Open dashboard
- Set filters at top:
- Date Range - This week, month, year, custom
- Location - Specific clinic or all
- Provider - Specific staff or all
- Service - Specific service or all
- Filters apply to all widgets
- Compare time periods
- See individual location performance
- Track specific provider metrics
- Analyze specific services
Arranging Dashboard
Customize layout:- Click Edit on dashboard
- Drag widgets to reorder
- Resize widgets (large, medium, small)
- Priority widgets up top
- Less important details lower
- Click Save Layout
- Top: Most important KPIs (big metrics)
- Middle: Trends and performance
- Bottom: Details and supporting data
Key Metrics Explained
Revenue Metrics
Total Revenue- All money received for services/products
- Best measure of business size
- Which services generate most income
- Helps with pricing and marketing
- Which providers generate most revenue
- Helps with commission calculations
- Revenue divided by number of transactions
- High value = larger visits/packages
- Comparing this period to last
- Shows business momentum
Appointment Metrics
Total Appointments- Number of appointments scheduled/completed
- Indicator of patient demand
- Percentage of booked appointments patient misses
- High rate = operational issue
- Affects scheduling efficiency
- Percentage of appointments cancelled
- By patient or by clinic
- Affects revenue predictability
- Percentage of available time that’s booked
- 80%+ is healthy
- Below 60% means underutilization
- Time from appointment start to seeing provider
- Higher wait = patient dissatisfaction
- Target: Under 15 minutes
Patient Metrics
New Patients- New patients acquired this period
- Growth indicator
- Percentage of patients who return
- Higher is better
- Typical: 70-85%
- Total revenue from average patient
- Guides acquisition spending
- Percentage of patients who stop coming
- Inverse of retention rate
- Lower is better
- How often patients return
- Service quality indicator
Financial Metrics
Outstanding Balance- Total money patients owe you
- Affects cash flow
- Average days to collect payment
- Lower is better
- Healthy: 15-30 days
- How long invoices have been unpaid
- 30/60/90+ days breakdown
- Percentage of charges you can’t collect
- Affects profitability
- Breakdown by cash, card, check, etc.
- Helps with payment processing
Analyzing Data
Comparing Periods
See how you’re doing vs. last period:- Create dashboard
- Add metric widget
- Set filter: “This month”
- Note the number
- Change filter: “Last month”
- Compare the numbers
Identifying Trends
Spot patterns over time:- Add line chart widget
- Set X-axis: Time (daily, weekly, monthly)
- Set Y-axis: Metric (revenue, appointments)
- Look for:
- Upward/downward trends
- Seasonal patterns
- Unusual spikes or dips
Benchmarking
Compare your performance:- Track your KPIs monthly
- Compare to industry benchmarks
- Set targets for improvement
- Monitor progress toward targets
- Medical practices: 20-40% profit margin
- Aesthetic clinics: 40-60% profit margin
- Therapy: 50-70% profit margin
Drilling Down
Go from summary to details:- See high-level metric (e.g., $50K revenue)
- Click on it to drill down
- View breakdown by service
- Click on service to see patients
- Understand what’s driving numbers
Advanced Analytics Features
Advanced Widget Filtering
Advanced Widget Filtering
Combine multiple filters for powerful insights:
- Date range filtering - Custom periods, rolling windows, year-over-year
- Multi-select filtering - Include/exclude multiple values
- Relative date filtering - Last 30 days, current quarter, YTD, etc.
- Segment filtering - By location, provider, service category, patient type
- Complex logic - AND/OR combinations of filters
Custom Calculations & Formulas
Custom Calculations & Formulas
Create calculated metrics:
- Derived metrics - Calculate new KPIs from existing data
- Ratios - Profit margin, revenue per appointment, etc.
- Percentages - % of total, % change over time
- Averages & sums - Aggregate data in custom ways
- Conditional calculations - IF/THEN logic for metrics
Cohort Analysis
Cohort Analysis
Compare groups of patients or periods:
- Patient cohorts - Track groups by start date, acquisition source, etc.
- Retention cohorts - See if patients acquired in Jan vs Feb retain differently
- Spending cohorts - Track spending patterns across patient segments
- Service cohorts - Compare outcomes across different service types
Predictive Analytics & Forecasting
Predictive Analytics & Forecasting
Project future trends:
- Trend projection - Predict revenue based on growth rate
- Seasonal forecasting - Account for seasonal ups/downs
- Churn prediction - Identify at-risk patients likely to leave
- Growth forecasting - Project patient growth or service demand
- Capacity planning - Predict staffing needs
Data Export for External BI Tools
Data Export for External BI Tools
Export dashboards and reports to external tools:
- CSV/Excel export - Raw data for spreadsheet analysis
- API export - Programmatic access to data
- Direct BI tool integration - Connect to Tableau, Power BI, Looker
- Scheduled exports - Automatic daily/weekly data exports
- Webhook integration - Send data to external systems
Comparative Analysis & Benchmarking
Comparative Analysis & Benchmarking
Compare across dimensions:
- Location comparison - How do clinics perform vs each other?
- Provider comparison - Which providers are most productive?
- Service comparison - Revenue, profitability, and volume per service
- Period comparison - Month-over-month, year-over-year
- Internal benchmarking - Compare current performance to targets
Segmented Reporting
Segmented Reporting
Break down metrics across multiple dimensions:
- Multi-dimensional analysis - View by service AND location AND provider
- Hierarchical breakdowns - Drill from category > service > appointment
- Cross-tabulation - Row/column analysis
- Pivot tables - Flexible data reshaping
- Custom segments - Create segments based on business logic
Reports
Export detailed data for analysis:Creating a Report
- Go to Analytics > Reports
- Click Create Report
- Select report type:
- Revenue Report
- Appointment Report
- Patient Report
- Inventory Report
- Billing Report
- Set filters and date range
- Click Generate
- Download as CSV or Excel
Using Reports
Reports useful for:- Monthly review with management
- Year-end accounting
- Comparing locations
- Detailed analysis
- Sharing with accountant
Sharing Dashboards
Share with team members:- Open dashboard
- Click Share
- Enter email addresses
- Set permission level:
- View - Can see only
- Edit - Can modify dashboard
- Send
Alerts & Notifications
Get notified of important changes:Setting Alerts
- Go to Settings > Alerts
- Create alert:
- Metric (e.g., Daily Revenue)
- Condition (e.g., Falls below $1000)
- Action (Email me)
- Save
- Revenue below target
- No-show rate above 10%
- Inventory below minimum
- Outstanding balance above threshold
Tips for Effective Analytics
Focus on Key Metrics
Don’t track everything. Choose 5-10 metrics that:- Directly impact your business
- You can act on
- Align with goals
- Daily revenue
- New patients
- No-show rate
- Average transaction value
- Patient retention
Review Regularly
- Daily: Revenue, appointments, no-shows
- Weekly: Staffing metrics, outstanding balance
- Monthly: Retention, profitability, trends
- Quarterly: Year-over-year comparisons
Act on Insights
Data only matters if you change behavior: “No-show rate is 15%” → Implement reminder SMS → Rate drops to 8% “Revenue down 20%” → Analyze by service → Promote underperforming serviceCreate Goals
Set targets and track progress:- Increase daily revenue 10%
- Reduce no-show rate to under 10%
- Achieve 80% patient retention
- Add 5 new patients per week
Common Dashboards to Build
”Morning Briefing”
- Today’s appointments
- No-shows from yesterday
- Outstanding balances
- Key metrics vs. goal
”Provider Performance”
- Revenue by provider
- Appointments per provider
- Patient satisfaction by provider
- Earnings/commissions
”Financial Health”
- Revenue trend
- Outstanding balance
- Payment failures
- DSO (days to collect)
“Operational Efficiency”
- Utilization rate
- Wait times
- No-show rate
- Staff productivity
Troubleshooting
“Widget shows no data”- Check date range includes data
- Verify filter selections
- Make sure data exists for metric
- Try different time period
- Verify filters applied correctly
- Check if this includes refunds/credits
- Make sure tax is/isn’t included
- Double-check data source
- Verify you have admin access
- Check feature enabled for your plan
- Contact support if issue persists
Related Features
- Billing - See transactions and payments
- Appointments - Track scheduling data
- Inventory - Monitor product sales
- Patient Records - Understand patient base
- Staff Management - Monitor provider performance
