Activation Performance Metrics & Data Model Blueprint
N.B. This analysis should provide insights into whether certain sources of hire contribute to better candidate experience and retention. Consider including sentiment analysis of candidate feedback for more nuanced insights.
📄 Prompt Template
Define an executive-ready KPI framework and data model to measure crisis team activation effectiveness for [CompanyName]. Specify metric definitions, formulas, and targets across TTA, TTCN, EOC Time-to-Full-Staff, First Operational Workaround, and Customer At-Risk Revenue within [Timeframe]. Deliver: (1) a KPI dictionary table; (2) a dimensional data model (Mermaid ERD) showing fact tables and conformed dimensions (Incident, Site, Role, Channel, Customer Tier); (3) a SQL-ready schema for ingestion from [DataSources]; (4) BI dashboard wireframe for [BIPlatform]; and (5) a governance section referencing [RTO]/[RPO] and audit trails. Include alert thresholds and color banding rules, sampling frequency, and data quality checks. Provide example queries for weekly executive reports and operational real-time views.