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 Material Manager dashboard is a Power BI report that shows how promotional materials and samples are distributed and used: by employee, by supervisor, by material and in customer calls. The dashboard has two versions. The old version shows how many materials employees used in calls. The new version also shows the stock of materials in employee storage and how much of it remains. Use the dashboard to analyze promo materials, not to issue or manage them.
Where to find it
Power BI Reports → CRM Analytics Report → Material Manager
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the Material Manager tab at the bottom of the report.
Note: You see the dashboard only if your role has access to Power BI reports. Your permissions may also limit which employees, customers and materials you see.
At a glance
| Section | Description |
|---|---|
| Dashboard / Tab Name | Material Manager |
| Business Goal | Provide visibility into promotional material distribution and monitor usage of marketing materials and samples across field force activities, from the stock in employee storage to the materials left after distribution. |
| Business Value | Helps management control distribution of promotional materials, monitor material allocation by employee, material and customer segment, and improve transparency of marketing resource usage. The new version shows the full path of materials: how many each employee received, used, distributed and still has. This helps plan deliveries before stock runs out, find employees with unused stock, redistribute materials and improve coordination between marketing and field force operations. |
| Main Users | Product Managers, Marketing Managers, Sales Managers, CRM Administrators, Supply/Operations Managers |
| Key Decisions Supported | Promotional material distribution planning, inventory and allocation control, replenishment planning, redistribution of unused stock, material usage analysis by employee, material and HCP specialization, optimization of marketing support resources, and promotional campaign support management. |
What's on the dashboard
The dashboard opens in the new version. The button of the active version is white.
- Period selector: All Periods, Current Year or Current Month. The selected period appears under the dashboard title. See Period selector below.
- Report filters on the left: Year, Quartal, Month, User direction, Supervisor, Employee, Employee position, Visit Type, Promo and Promo type. You can select more than one value in each filter. All filters affect all data on the dashboard.
- Pivot Table Builder: the list of fields under the filters. Select a field to add it as a column to the table, or clear it to hide the column. The fields include Year, Quarter, Month, Day, Supervisor, Employee, Employee Direction, Visit Type, Visit Status, HCP, HCP Id, HCP Category, HCP Specialization, Promo-material Units Type, Promo-material Type, Promo-material Name and Promo Tag. Scroll the list to see all fields.
-
Detailed table: the columns you selected in the Pivot Table Builder and four material quantities:
- Materials in Storage Quantity: the quantity of materials that the employee received to their storage.
- Materials Used Quantity: the quantity of materials recorded in customer calls.
- Materials Distributed Quantity: the quantity of materials distributed from the employee's storage during customer calls.
- Materials Remaining Quantity: the quantity of materials left in storage after distribution, as of the latest date of the selected period.
The Total row at the bottom sums every column. Scroll the table down to see more rows, and to the right to see all columns. To sort the table, click a column header.
- Last update: the date and time of the latest data refresh.
Buttons on the dashboard
| Button | What it does |
|---|---|
| Info | Opens the user guide for this dashboard in the Proxima knowledge base in a new browser tab. |
| Notify Employee | Sends a notification to the selected employee. |
| Old version | Switches the dashboard to the old version: the Detailed Promo-material Table with the materials used in calls. |
| New version | Switches the dashboard to the new version: the detailed table with storage, usage, distribution and remaining quantities. |
| Question mark (?) | Appears above the table when you hover the mouse over it. Hover over the icon to see a description of the table. |
| Filter icon | Appears above the table when you hover the mouse over it. Shows which filters affect the table. |
| Focus mode icon | Opens the table on the full screen. To return to the dashboard, click Back to report. |
| More options (...) | Opens more actions for the table, for example sorting or exporting data, if your role allows it. |
Old version and new version
To switch between the versions, click Old version or New version in the top right corner of the dashboard.
In the old version, the dashboard shows the Detailed Promo-material Table. By default, it lists the materials each employee used in calls: Promo-material Type, Promo-material Name, Promo-material Units Type and Materials Used Quantity.
The new version shows not only the materials used in calls, but also the stock in employee storage. To see what the table of the new version shows, hover the mouse over it, and then hover over the question mark icon (?) that appears above it. A tooltip with the description opens.
| Element | Old version | New version |
|---|---|---|
| Materials used in calls | Yes | Yes |
| Materials in storage | No | Yes |
| Materials distributed from storage | No | Yes |
| Materials remaining in storage | No | Yes |
| Default columns | Year, Supervisor, Employee, Promo-material Type, Promo-material Name, Promo-material Units Type | Year, Supervisor, Employee, HCP Specialization |
| Day filter | Yes | No |
| Main question it answers | Which materials and how many did employees use in calls? | How many materials did employees receive, use and distribute, and how many do they still have? |
Use the old version to see which materials employees use in calls. Use the new version to control stock: find employees who are running out of materials and employees who have unused stock.
Period selector
The period selector is a quick way to choose the period: All Periods, Current Year or Current Month. When you choose Current Year or Current Month, it overrides the Year, Quartal and Month filters. To filter by a specific year, quarter or month, select All Periods first.
Important: The table reflects the selected period and the current filters. The remaining quantity is calculated up to the latest date of the selected period, so it shows the stock balance, not the quantity left from this period only. The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls and materials may not appear yet.
Learn more
- Material Manager Dashboard: Promotional Material Distribution Analytics
- Material Manager Dashboard: Elements
- Material Manager Dashboard: Filters
- Detailed Promo-material Table
- Version Selector
- Material Manager Dashboard: Pivot Table Builder
- Material Manager Dashboard: Detailed Table
- Material Manager Dashboard: KPI Calculation Logic
- Dashboard: Material Manager (all articles)