Business Analytics
Embedded business analytics using Metabase for operational dashboards across the platform hierarchy.
Overview
The Service Commerce Platform provides embedded business analytics using Metabase for operational dashboards. Analytics are scoped by the platform hierarchy: Tenant, Customer (MerchantOrg), and Merchant levels.
Scope: Operational metrics and reporting for tenants, customers, and merchants.
Out of Scope: Advanced analytics, data science, ML pipelines, external data integration.
Architecture
Tenant Level Analytics
Tenant managers see aggregated metrics across all customers (MerchantOrgs) in their tenant.
Dashboards
| Dashboard | Metrics |
|---|---|
| Customer Overview | Customer count, growth rate, churn |
| Revenue | Total revenue, revenue by customer, trends |
| Platform Metrics | Total merchants, appointments, transactions |
| Subscription | Billing metrics, plan distribution |
Key Metrics
- Total customers (MerchantOrgs)
- Total merchants across all customers
- Revenue by customer
- Platform-wide appointment volume
- Subscription and billing status
Customer Level Analytics (MerchantOrg)
Customer admins see aggregated metrics across all their merchants.
Dashboards
| Dashboard | Metrics |
|---|---|
| End Customer Growth | Total, new, churn rate |
| Appointments | Total, completed, cancelled, no-shows |
| Revenue | Total, by merchant, trends |
| Transactions | Volume, payment method distribution |
| Provider Utilization | Booking rate, hours worked |
Key Metrics
- End customer growth (total, new, churned)
- Appointment metrics (completed, cancelled, no-show rates)
- Revenue totals and trends
- Transaction volume
- Payment method distribution
- Provider utilization rates
Merchant Level Analytics
Merchants use the operational SCP interface directly. Limited embedded analytics for quick metrics.
Available Views
| View | Purpose |
|---|---|
| Today's Schedule | Appointments for current day |
| Week Overview | Upcoming week summary |
| Quick Stats | Today's revenue, appointments count |
Note
Merchants primarily use the operational SCP interface for day-to-day management. Full analytics are available at the Customer (MerchantOrg) level.
Metabase Integration
Setup
Each level has its own Metabase database connection with appropriate permissions:
Embedding
Dashboards are embedded using Metabase's signed embedding:
- Authentication - JWT tokens signed with Metabase secret
- Row-Level Security - Filters applied based on tenant/customer/merchant ID
- Iframe Embedding - Dashboards embedded in SCP UI
Context
| Context | Purpose |
|---|---|
BusinessIntelligenceContext | Metabase setup, dashboard configuration |
TenantContext | Tenant-level analytics setup |
CustomerContext | Customer-level analytics setup |
MerchantContext | Denormalized views for quick metrics |
Related Capabilities
- Tenant Management - Tenant configuration
- Platform Operations - Platform-wide operations
- Merchant Operations - Merchant-level operations