Transactions and Statistics (Sales Compensation)
This dashboard provides an overview of all transactions included in the calculation of the selected Compensation Plan with the possibility to further filter on specific compensation record or transaction date.
The dashboard is for Sales Agents, Sales Managers as well as Sales Compensations administrators. Sales Agents can see only their own data, Sales Managers can see details for all their reports (based on the “Reports To“ field in the Seller Master table) and SC Admins have unlimited selection.
Dashboard Settings
You can set the following fields:
Seller(s) – Allows you to select a Seller group. If left empty, the whole salesforce is selected (based on permissions). It is pre-selected and read-only for Sales Agents. Only reporting agents can be selected by Sales Managers.
Compensation Plan Currency – Allows you to select a currency from those in which plans were created. If a currency is selected, it limits the possible selection in the other inputs. If nothing is selected, the dashboard uses Datamart Source Currency.
Compensation Plan Type(s) – Allows you to select one or more Compensation Plan Types: Individual, Group or SPIFF. If left empty, all types are selected.
Compensation Plan Status(es) – Allows you to select one or more Compensation Plan States. If left empty, all states are selected. See also a note below.
Compensation Plan(s) – Allows you to select one or more Compensation Plans for a sales person of the selected Compensation Plan Type. If left empty, all plans are selected.
Compensation Record(s) – Allows you to select one or more Compensation Records associated with a given Compensation Plan. If left empty, all records are selected.
Date from/to – Defines time range for the dashboard. If left empty, there is no date filtering.
Note on Compensation Plan Status
Sales Agents: They can see ONLY statuses “Approved“ and “Superseded“ if those are applicable for “their” plans. They cannot delete all possible values (Approved and Superseded if any).
Sales Managers (as they have Manage Plans user role) and Administrators: They are NOT limited to any selection and they can leave the field blank which acts as “no filter”.
The input is pre-populated to “Approved“ by default for all roles.
Portlets
Transactions Statistics
Statistical overview of the selected scope from Compensation Plans in a form of several tiles. The following information is represented:
|
|
Note: There are as many Baseline rows in the tile as there are different baseline fields in the scope, e.g. Quantity, Invoice Price.
Transaction List
A list of selected columns from source transactions that were used as calculation baseline for the selected scope.
Date
Seller ID
Seller Name
Customer ID
Product ID
Baseline – There are as many Baseline columns as there different Baseline Types in all the CORs listed in this table.
Compensation Records
Provides information about attributes for Compensation Records. It can contain just one line if the analysis is focused on one specific condition from the Compensation Plan.
The “ID” column is an active link leading directly to the full detail of the Compensation Record, similarly for “Compensation Plan ID” which leads to the full detail of the Compensation Plan. The SC Administrator can follow the link and see a context that was not available on the dashboard. An example is “Calculation Baseline“ showing raw transaction data for the selected Compensation Record.
ID of the Compensation Record
Name of the Compensation Record
Label of the Compensation Record
Seller ID
Seller Name
Compensation Plan ID
Compensation Plan
Compensation Plan Type
This table is affected by the Date From/To Filters, which means that if there is an overlap of the record validity dates with the currently defined dates, then the record will be displayed in the table.
Tip: Use Group By option on a column you would like to aggregate.