Admin Operations Dashboard

Overview

The Admin Operations Dashboard gives platform administrators a real-time view of business metrics, system health, and performance data. Track MRR, subscriber growth, churn rates, and monitor system latency, data integrity, and automated load test results.

Accessing the Dashboard

1. Log in with an admin account
2. Navigate to /admin/operations/overview for business metrics
3. Navigate to /admin/operations/health for system health

Overview Page

Revenue Metrics

• MRR (Monthly Recurring Revenue): Current monthly revenue from active subscriptions
• Active Subscribers: Companies with active paid subscriptions
• Trialing: Companies in their 30-day free trial period
• Churn Rate: Percentage of subscribers who canceled in the last 30 days

Growth Metrics

• New Companies (30d): Sign-ups in the last 30 days
• Net Growth: New sign-ups minus cancellations
• Retention Rate: Percentage of subscribers who stayed active

Lead Pipeline

• Total Leads: All leads in the database
• Contacted: Leads you've reached out to
• Converted: Leads that became customers
• Conversion Rate: Percentage of contacted leads that converted

Monthly Trend Chart

12-month view showing:

• New sign-ups per month
• Cancellations per month
• Net growth
• Active subscribers at month-end

System Health Page

System Status Cards

• DB Response: Database query latency (healthy < 2000ms)
• API Latency: API endpoint response time (healthy < 5000ms)
• Data Integrity: Checks for orphaned records and data issues
• Active Users: Currently logged-in platform users

Record Counts

View total counts for all major data types:

• Companies
• Users
• Tickets
• Jobs
• Invoices
• Leads

Data Integrity Checks

Automated checks that run on every page load:

• Orphaned company members: Members with no matching user account (warning)
• Orphaned invoices: Invoices with no matching company (error)

Load Test Results Table

Weekly automated load tests show:

• Run Date: When the test ran
• Duration: How long the test ran (seconds)
• Virtual Users: Peak concurrent users simulated
• Avg Response: Average API response time (ms)
• P95 Response: 95th percentile response time (ms)
• Error Rate: Percentage of failed requests
• Passed: Whether the test met performance thresholds
• Summary: Notes about the test run

Load tests run automatically every Sunday at midnight CT via GitHub Actions.

Recent System Logs

The 5 most recent system health events:

• Type (info, warning, error)
• Message describing the event
• Source (which part of the system logged it)
• Timestamp

Refreshing Data

Click the Refresh button (top-right on Health page) to reload all metrics and checks. Overview metrics are calculated on every page load.

Understanding Load Tests

Load tests simulate real user traffic to ensure the platform can handle growth:

• Ramps to 50 virtual users over 2 minutes
• Tests key contractor routes: dashboard, tickets, jobs, invoices
• Measures response times and error rates
• Results stored in database for historical tracking
• Runs weekly to catch performance regressions early

A passing test means the platform handled the load with acceptable response times and no errors.

Questions

Q: What's a good churn rate? A: For SaaS, under 5% monthly churn is excellent, 5-10% is acceptable, above 10% needs attention.

Q: Why does data integrity show warnings? A: Warnings indicate orphaned records - data that references deleted records. These should be cleaned up but won't break the app.

Q: What if a load test fails? A: Check the summary for details. Common causes: slow database queries, API endpoint regressions, or infrastructure issues. Use the P95 response time to identify bottlenecks.

Q: Can I run a load test manually? A: Currently load tests run automatically via GitHub Actions. Contact a developer to trigger a manual run if needed.