All-grades Coverage
82%
+4% vs last month
All-grades Doctors at Risk (14+ days no visit)
2
Need follow-up
Total Doctor Visits
1,234
+8% vs last month
Avg Visits/Doctor (All-grades)
3.6
Target: 4 visits / month
Coverage % by Grade
(visits completed ÷ total visits of doctors ) x 100%
Target line
Target coverage: A ≥ 85%, B ≥ 70%, C ≥ 55% (example
thresholds)
All-grades Target Achievement by Rep
% of All-grades visit target achieved in selected period
Rep Performance – Detail
Per-rep totals, unique doctors and A-grade achievement
| Rep | Territory | Total Visits | Unique Doctors | A-grade Visits | B-grade Visits | C-grade Visits |
|---|---|---|---|---|---|---|
| Rep 01 | Colombo North | 380 | 180 | 140 | 130 | 110 |
| Rep 02 | Kandy | 150 | 80 | 56 | 60 | 34 |
| Rep 03 | Galle | 120 | 70 | 40 | 60 | 20 |
Product Coverage by Grade
Rows: Products, Columns: Grades (A/B/C), Values: unique
doctors
Grade
All
A
B
C
Prod A
484
178
210
96
Prod B
425
142
198
85
Prod C
233
134
18
81
Prod D
406
112
109
185
Prod E
165
42
98
25
Prod F
206
72
94
40
OOS Events by Product
Bar height shows # of "Out of Stock" reports
Use to decide which products need distribution attention
first.
OOS Events by Territory
Concentration of stock issues by geography
Avg A-grade Target Achievement
92%
+5% vs last month
Reps On or Above Target
9
+2 vs last month
Reps Below 80% Target
4
Needs coaching
Total Visits (Team)
1,234
+8% vs last month
A-grade Target Achievement by Rep
% of A-grade visit target achieved in selected period
Rep Performance – Detail
Per-rep totals, unique doctors and A-grade achievement
| Rep | Territory | Total Visits | Unique Doctors | A-grade Visits | A-grade Target | Achievement % | Sprint Compliance |
|---|---|---|---|---|---|---|---|
| Rep 01 | Colombo North | 180 | 96 | 72 | 60 | 120% | 98% |
| Rep 02 | Kandy | 150 | 80 | 56 | 60 | 93% | 92% |
| Rep 03 | Galle | 120 | 70 | 40 | 60 | 67% | 78% |
Avg A-grade Doctors per Product
135
+6% vs last quarter
Best A-grade Coverage Product
Prod A
178 A-grade doctors
Lowest A-grade Coverage
Prod F
72 A-grade doctors
Total Detailing Calls
4,560
+9% vs last quarter
Product Coverage by Grade
Rows: Products, Columns: Grades (A/B/C), Values: unique
doctors
Prod A
178
210
96
Prod B
142
198
85
Prod F
72
94
40
A-grade Coverage by Product
Unique A-grade doctors detailed in selected period
Product Coverage – Detail
Per-product unique doctors by grade and total detailing
calls
| Product | A-grade Doctors | B-grade Doctors | C-grade Doctors | Total Detailing Calls |
|---|---|---|---|---|
| Prod A | 178 | 210 | 96 | 932 |
| Prod B | 142 | 198 | 85 | 754 |
| Prod F | 72 | 94 | 40 | 310 |
Total OOS Events
96
High
Chronic OOS Chemists
14
Need urgent follow-up
Worst Product by OOS
Prod C
28 OOS events
Worst Territory by OOS
Colombo North
24 events
OOS Events by Product
Bar height shows # of "Out of Stock" reports
Use to decide which products need distribution attention
first.
OOS Events by Territory
Concentration of stock issues by geography
Chronic OOS Chemists
Chemists with repeated "Out of Stock" for the same product
| Chemist | Territory | Product | # OOS Events | Last OOS Date | Status |
|---|---|---|---|---|---|
| HealthPlus Pharmacy | Colombo North | Prod C | 5 | 2025-11-10 | Chronic OOS |
| CityCare Chemist | Kandy | Prod A | 4 | 2025-11-06 | Chronic OOS |
| Sunrise Pharmacy | Galle | Prod B | 3 | 2025-11-03 | Improving |
Total Mileage
4,320 km
+5% vs last month
Avg Mileage per Rep
332 km
Slightly above plan
Highest Mileage Rep
Rep 02
520 km
Total Additional Expenses
LKR 245,000
Within budget
Mileage Over Time (Selected Rep)
Weekly total mileage logged from DCR
Rep:
Mileage (km)
Selected rep: Rep 01
Mileage vs Visits (By Rep)
Quick check of routing efficiency by rep
Rep Mileage & Additional Expenses
Filter by rep to see detailed fuel-related activity
Rep:
| Rep | Territory | Total Mileage (km) | Doctor Visits | Chemist Visits | Additional Expenses (LKR) |
|---|---|---|---|---|---|
| Rep 01 | Colombo North | 420 | 120 | 30 | 32,000 |
| Rep 02 | Kandy | 520 | 130 | 28 | 41,000 |
| Rep 03 | Galle | 390 | 110 | 25 | 29,000 |
Add doctor
Maintain doctor master: grade, locations, status &
remarks.
Master – Doctors
One row per doctor. Retired doctors will be hidden from
operational dashboards.
Sample data
| Doctor | Grade | Locations | Status | Primary Rep | Secondary Rep | Last Updated | |
|---|---|---|---|---|---|---|---|
| Dr. A Kumar | A | Colombo North Kandy | Active | Rep 03 – S. Perera | Rep 01 – H. Jayasuriya | 2025-11-08 | |
| Dr. B Fernando | A | Colombo South | Active | Rep 05 – I. Silva | — | 2025-10-31 | |
| Dr. D Nuwan | C | Galle | Retired | Rep 07 – D. Senanayake | — | 2025-09-12 |
Add chemist
Maintain chemist master used for stock-out and coverage
analytics.
Master – Chemists
All chemists that reps can select in DCR / chemist
reports.
Sample data
| Chemist | Territory | Channel | Status | Last OOS Date | OOS Count (90d) | |
|---|---|---|---|---|---|---|
| HealthPlus Pharmacy | Colombo North | Retail | Active | 2025-11-10 | 5 | |
| CityCare Chemist | Kandy | Retail | Active | 2025-11-06 | 4 | |
| Central Hospital Pharmacy | Colombo South | Hospital | Active | 2025-10-28 | 2 |
Add product
Maintain product master used in all detailing &
coverage views.
Master – Products
Product list used in DCR, chemist reports and analytics.
Sample data
| Product | Molecule | Category | Priority | Status | Launch Year | |
|---|---|---|---|---|---|---|
| Prod A | Molecule X | Cardio | Focus | Active | 2020 | |
| Prod B | Molecule Y | Diabetes | Focus | Active | 2019 | |
| Prod F | Molecule Q | Cardio | Support | Active | 2017 |