Important: This article describes the default version of the report that every customer gets at the start. If the report was later customized for your company, its appearance and functionality may differ, including how some metrics are calculated.
The Pharmacy Visits dashboard is a Power BI report that shows how the field force works with pharmacies in the selected period: how many pharmacies were called, in how many of them the audited drugs were in stock, and how each brand and drug (SKU) is present in the pharmacy network.
Where to find it
Power BI Reports → CRM Analytics Report → Pharmacy visits
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the Pharmacy visits 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 | Pharmacy Calls (Pharmacy visits tab of the CRM Analytics Report) |
| Business Goal | Show pharmacy coverage, product availability and brand penetration in pharmacies based on field force calls. |
| Business Value | Helps management evaluate how pharmacy calls contribute to product presence in pharmacies, monitor brand penetration and check SKU distribution across the pharmacy network. Supports control over pharmacy engagement, finds gaps in product availability and helps optimize pharmacy-focused commercial activities. |
| Main Users | Sales Managers, Regional Managers, Trade Marketing Managers, Product Managers, CRM Administrators |
| Key Decisions Supported | Pharmacy coverage optimization, brand penetration analysis, SKU distribution monitoring, finding pharmacies with missing stock, prioritizing pharmacy engagement, improving the pharmacy-focused commercial strategy |
What's on the dashboard
- KPI cards at the top. See KPI cards below.
- Brand Penetration in Pharmacies: the availability penetration percentage for each drug (SKU), that is, the share of visited pharmacies where the audited drug is in stock.
- Pharmacy Availability by Brand: visited pharmacies, visited pharmacies with stock and availability penetration percentage for each brand, with a total row. Click + next to a brand to see its drugs.
- Detailed Pharmacy Visits Table: visited pharmacies, visited pharmacies with stock, availability penetration percentage, pharmacy stock packs and pharmacy ordered packs by supervisor, employee and employee direction, with totals.
- Pivot Table Builder on the left: select the check boxes to choose which fields the Detailed Pharmacy Visits Table shows: year, quarter, month, day, supervisor, employee, employee direction, country, region, area, city, address, organization, main organization, category, brand or SKU.
- Report filters on the left: the period mode (All Periods, Current Year or Current Month), Year, Quarter, Month, Day, Employee, Employee direction, Employee position, Brand, Organization Type, Visit Type and Supervisor. 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 or a chart shows, hover the mouse over it, and then hover over the question mark icon (?) that appears above it. A tooltip with the description opens.
| Card | What it shows |
|---|---|
| Pharmacy Base Count | The number of unique pharmacies (organizations marked as points of sale) assigned to the selected employees. This is the pharmacy base for pharmacy calls. |
| Visited Pharmacies | The number of unique pharmacies with at least one completed call in the selected period. |
| Visited Pharmacies with Stock | The number of unique visited pharmacies where at least one audited drug has stock above zero packs. Shows drug availability in the pharmacy network. |
| Availability Penetration % | The share of visited pharmacies that have the audited drugs in stock: pharmacies with stock divided by pharmacies with a completed call. |
| Audited Brands | The number of unique drug brands with audit records in pharmacies in the selected period. |
| Audited SKUs | The number of unique drugs (SKUs) audited in pharmacies during calls in the selected period. |
Important: The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls and stock audits may not appear yet.
Learn more
- Pharmacy Calls Dashboard: Pharmacy Coverage and Product Availability
- Pharmacy Calls Dashboard Elements
- Pharmacy Calls Dashboard Filters
- Pharmacy Calls Dashboard - KPI Calculation Logic
- Pharmacy Availability by Brand
- Brand Penetration in Pharmacies
- Detailed Pharmacy Calls Table
- Pharmacy Calls Pivot Table Builder