The Promotions dashboard is a Power BI report that compares planned and completed brand promotions in the selected period: how much of the promotion plan the field force completed, how the plan is fulfilled by month and by brand, and how promotions are spread across target groups and employees.
Where to find it
Power BI Reports → CRM Analytics Report → Promotion
-
On the Dashboard, click Power BI Reports.
-
Open the CRM Analytics report. Go to the Promotion 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 | Promotions (Promotion tab of the CRM Analytics Report) |
| Business Goal | Show how promotional activity is executed in the field: compare planned and completed promotions and evaluate them across employees, brands and target groups. |
| Business Value | Helps management control how the promotion plan is fulfilled, find gaps between planned and completed promotions and follow brand-focused engagement over time. Supports control over marketing execution, helps find underperforming brands and aligns field force activity with the marketing strategy. |
| Main Users | Product Managers, Marketing Managers, Regional Managers, Sales Managers, CRM Administrators |
| Key Decisions Supported | Promotional strategy adjustments, brand prioritization, monitoring of employee promotional activity, target group engagement, marketing execution control, finding brands or territories with insufficient promotional activity |
What's on the dashboard
- KPI cards at the top left. See KPI cards below.
- Promotions by Brand PL/AC chart under the cards: completed promotions (AC) for each brand and the deviation from the plan (ΔPL%). Green shows the part above the plan, red shows the part below the plan.
- Promotions Dynamics: planned (PL) and completed (AC) promotions by month and in total, with the deviation from the plan (ΔPL%) and from the previous year (ΔPY%).
- Promotions by Target and Brand: the number of promotions by year and month with trend arrows. Use the Target, Brand and Employee buttons to group the rows by target group, by brand or by employee.
- Detailed Promotions Overview Table: total planned promotions, completed promotion count and promotion plan completion percentage by supervisor, employee and employee direction, with totals.
- Pivot Table Builder on the left: select the check boxes to choose which fields the Detailed Promotions Overview Table shows: year, quarter, month, supervisor, employee, employee direction, employee direction ID, brand, category, target group or visit type.
- Report filters on the left: the period mode (All Periods, Current Year or Current Month), Year, Quarter, Month, Day, Supervisor, Employee, Employee position, Employee direction, Target group, Category, Visit Type and Brand. 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 |
|---|---|
| Total Planned Promotions | The total number of promotions planned for the selected period, taken from the call plans. Compare it with Completed Promotion Count. |
| Promotion Plan Completion % | The share of the promotion plan completed: completed promotions divided by planned promotions in the selected period. The card is blank when there is no promotion plan. |
| Completed Promotion Count | The number of promotions delivered during completed calls in the selected period. One call can include several promotions, and each of them is counted. |
| Promotions per Visit | The average number of promotions per call: promotions divided by unique calls in the selected period. Shows how many brands are promoted during an average call. |
Important: The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls and promotions may not appear yet.