The HCO Base Coverage Overview dashboard is a Power BI report that shows how the field force covers the healthcare organizations (HCOs) in employees' responsibility base during the selected period: how many organizations were covered, how many remain uncovered, how often they get calls and which employees reach their HCO base.
Where to find it
Power BI Reports → CRM Analytics Report → HCO
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the HCO tab at the bottom of the report.
Note: You see the dashboard only if your role has access to Power BI reports.
At a glance
| Section | Description |
|---|---|
| Dashboard / Tab Name | HCO Base Coverage Overview (HCO tab of the CRM Analytics Report) |
| Business Goal | Show how the field force covers healthcare organizations (HCOs) and how effectively employees work with their customer base during the selected period. |
| Business Value | Helps management monitor HCO engagement within the responsibility base of MR/RM employees, find uncovered organizations, compare call frequency by HCO category and type, and assess territory coverage strategies. Supports better allocation of field force effort and control over customer reach. |
| Main Users | Regional Managers, Sales Managers, Territory Supervisors, CRM Administrators, Product Managers |
| Key Decisions Supported | Coverage optimization, territory prioritization, follow-up on uncovered HCOs in employee responsibility zones, employee performance monitoring, call planning adjustments, customer engagement strategy |
What's on the dashboard
- KPI cards at the top. See KPI cards below.
- HCO Base chart: the HCO base and covered HCOs by month, with the covered assigned HCO percentage as a line.
- Employee HCO Coverage: the HCO base, covered HCOs and covered assigned HCO percentage for each employee, with a total row.
- Coverage Frequency by HCO Category: the average number of calls per covered organization. Use the Category and Type buttons to group the chart by HCO category or by HCO type.
- Detailed HCO Coverage Table: all metrics by employee, supervisor and employee direction, with totals.
- Pivot Table Builder on the left: select the check boxes to choose which fields the Detailed HCO Coverage Table shows, for example period, employee, area, region, settlement, organization, organization type and category, main organization or sales point.
- Report filters on the left: the period mode (All Periods, Current Year or Current Month), Year, Quarter, Month, Day, Supervisor, Employee, Employee direction, Employee position, Country, Area, Organization Type, Organization Category, Main Organization and Responsibility. By default, the dashboard shows the current month.
- Info: opens the user guide for this dashboard in the Proxima knowledge base in a new browser tab, with a full description of the dashboard, its filters and metrics.
- Notify Employee: sends a notification to the selected employee.
- Last update: the date and time of the latest data refresh.
KPI cards
To see what a card shows, hover the mouse over the card, and then hover over the question mark icon (?) that appears above it. A tooltip with the description of the metric opens.
| Card | What it shows |
|---|---|
| HCO Base | The number of unique HCOs (facilities, pharmacies) assigned to the selected employees, that is, the target base for coverage. It does not depend on calls. |
| Covered HCO (Any Owner) | The number of unique HCOs with at least one completed call in the selected period, no matter who made the call and whether the HCO is assigned to that employee. It can be higher than the assigned-only coverage. |
| HCO Visits | The number of completed calls to HCOs (healthcare organizations, pharmacies) in the selected period. Each call is counted once. |
| Uncovered HCO | The number of HCOs in the base that the responsible employee did not call in the selected period: the HCO base minus covered assigned HCOs. |
| Visits per Covered HCO | The average number of completed calls per covered HCO: HCO calls divided by the unique HCOs called in the selected period. Shows how often each organization gets a call. |
| Covered Assigned HCO % | The share of the HCO base with at least one completed call from the responsible employee in the selected period. The HCO base is the organizations assigned to the selected employees; calls by other employees do not count. |
Important: The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls may not appear yet.