Global View dashboard provides customer performance via health score and revenue, pricing and selling opportunity, and overall customer summary.
Table of Contents | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Portlets
All of the tables/charts are based on Data Source Customer Insights Aggregated Data if not stated otherwise.
Info |
---|
Support for Data Readability |
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Displays some typical figures regarding a chosen customer or a group of customers.
Customer displays a list of [Customer ID,(Customer Name)] following a filter group. When no customer is selected, it is left empty.
Health Score Last 12M is re-calculated by the Trend L12M of the group. (Definition)
Pricing Opportunity = ∑ Pricing Uplift (Definition)
Selling Opportunity = ∑ Up Sell + ∑ Cross Sell (Definition)
L12M trends are calculated on the monthly basis. (Definition)
Info |
---|
Data are queried from Datamart. |
Anchor | ||||
---|---|---|---|---|
|
Shows relative sizes of customer classification based on Heath Score in the last 12 months.
Anchor | ||||
---|---|---|---|---|
|
Shows relative sizes of customer classification based on Revenue in the last 12 months.
Anchor | ||||
---|---|---|---|---|
|
Shows Customer's Health calculated based on the difference between two periods. For example, Current YTD and Previous YTD. (Health Score Definition)
It shows correlation between Health Score and revenue, gross margin, volume.
Info |
---|
|
Anchor | ||||
---|---|---|---|---|
|
For details on trends see Common Aspects of Dashboards (Customer Insights). (Trend Definition)
Anchor | ||||
---|---|---|---|---|
|
Shows a list of customers who can be targeted to sell at a higher price point, based on comparison to customers of the same segment. The top of the list represents the highest opportunity, these customers are under the average point in the customers set. The bottom of the list represents the lowest opportunity (hidden). (Pricing Opportunity Definition)
Pricing Uplift (Evaluate purchased products)
If the value > 0, customers have reached the revenue under the average point among the customers set, it indicates the value that customer should obtain to reach the average base.
If the value = 0, customers have reached the revenue above the average point among the customers set, they are good customers.
% Product Buying – Shows how many products (in % ) the customer purchased in the given period.
If the value = 100%, the customer purchased full products set presented in the given period. It correlates with Cross Sell Opportunity = 0.
If the value < 100%, the customer did not purchase the full products set presented in the given period. It means this customer must have Cross Sell Opportunity > 0.
Anchor | ||||
---|---|---|---|---|
|
Shows the total value which can be gained for products that the customer already bought and not bought in the given period. (Selling Opportunity Definition)
Cross Sell (Evaluate non-purchased products)
The value that the customer should spend by purchasing a product which they did not buy in the past, but other customers bought it.
If the value = 0, the customer bought full products set presented in the given period.
Revenue Increase (Evaluate purchased products)
The value that the customer should spend more by purchasing a product which they already bought in the past.
If the value = 0, the customer purchased products that all are above average point in the customers set.
Opportunity – This is the total additional value that can be obtained for the customer, evaluate for both purchased and non purchased products.
Anchor | ||||
---|---|---|---|---|
|
This portlet shows a list of “inactive” customers so that you can identify customers which are marked as active and for which there are no transactions in the chosen time period. For more details see Inactive Customer Classification Configuration.
Applied Filters
Customer(s)
Time filter
Not Applied Filters
Customer Rank
Customer Rank Bucket
KPI
Customer Class
Customer Health Score
Months Inactive
Code Block |
---|
Months Inactive = Current Month - Last Active Month |
Conditions | Results |
---|---|
If PP defined + No filter customer | Get list of customers defined by PP that have no transactions in the period. |
If PP defined + Filter customer | Get list of customers defined by PP that have no transactions in the period. |
If PP not defined + No filter customer | Get list of all customers in the master that have no transactions in the period. |
If PP not defined + Filter customer | Get list of all customers in the master that have no transactions in the period. |
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Portlets | User Inputs | |||||||
Customer(s) | Time Filter | Customer Rank + Customer Rank Bucket | KPI | Customer Class | Customer Health Score | Customer Base | ||
Summary | Customer Summary | X | X | X | X | X | ||
Pie Chart | Customers Performance by Health Score Last 12M | X | X |
|
| X | X | X |
Customers Performance by Revenue Last 12M | X | X |
|
| X | X | X | |
Table | Customer Health Summary | X | X | X | X | X | X | X |
Trends | X | X | X (*) | X | X | X | X | |
Pricing Opportunity | X | X | X (Ranked by Pricing Uplift descending) | X | X | X | ||
Selling Opportunity | X | X | X (Ranked by Opportunity descending) | X | X | X | ||
Inactive Customers |
(*): Only sorts out Customers/Products that have traded in the period, does not affect calculation results.