Fetching data from Raw_Data sheet…
Overall KPIs
Tasks Completed by Period
Cases
Tasks
Cases: received vs. completed. Tasks: total tasks completed. Grouped by day, week, or month — weekends are excluded from every bucket.
SLA% Daily Trend
SLA%
% Received
SLA%: daily same-day completion rate against target, scoped to Medical only when multiple departments are selected. % Received: same-day completed as a share of same-day received, per day.
Authorizations Outcome Split
Share of all authorization follow-ups in scope that landed as Approved, Denied, Cancelled, or are still Under Process.
QA Error Rate Trend
Error rate per QA reporting period (Medical dept, from qa_external), across whatever program(s) are in scope — same source as the QA tab's richer breakdown.
Automated Alerts
Cases & Tasks by Program
Program Summary
| Program | Received | Completed | Comp% | Tasks Done | Task Rate% | Avg SLA% | Days |
|---|
Authorizations by Program
Auth Summary
| Program | Submitted | Approved | Denied | Cancelled | Under Process | Follow Ups | Approval% | Denial% |
|---|
Prescription Transfers by Program
Rx Summary
| Program | Transfers | Delivered | Unsuccessful | Under Process | Follow Ups | Delivery% | Failure% |
|---|
Faxes by Program (Portal DET)
Faxes Summary
| Program | Received Faxes | Typed Cases | Docs Attached | Updated/Fwd | MDO Practice | Total Tasks |
|---|
DSD by Program (Document Support)
DSD Summary
| Program | Total Auth Forms |
|---|
Agents by Program
Allocated headcount per program, summed across every department in scope, from the allocation sheet.
Staffing by Department
Allocated headcount per department, summed across every program in scope, from the allocation sheet.
Staffing Matrix — Department × Program
Allocated · Effective
Allocated (Allocation Sheet)
Effective (Allocated − Leaves)
Medical department only — QA isn't audited for other departments.
Error Categories Breakdown
Total QA errors by category, across the selected program(s) and period — the longest bar is the most common mistake type.
Error Rate by Program
Of the tasks each program actually got audited, the share that came back with an error (Total Errors ÷ Total Audits).
Error Category Mix by Program
Same error categories, broken down per program — shows which mistake types are most common where, not just which program has more errors overall.
Error Rate Trend by Period
Error rate over time, per program, across every period on file — ignores the Period filter above so the trend stays visible even when a single period is selected.
QA Summary by Program
Program QA
| Program | Audits | Total Errors | Error Rate% | Top Category | Status |
|---|
Team Structure
Refresh
Pinch to zoom · Drag to pan
Team Headcount Summary
| Designation | Count |
|---|
Staff Count by Program
| Program | Staff Count |
|---|
Program Allocation Matrix
All Programs