MKG logo
Login

How does the 'Quote Score' dashboard work?

With the 'Quote Score' dashboard, you analyze which share of the selected quote lines has led to an order. You compare results per relationship, salesperson, and month and investigate reasons why an order was not obtained.

 

General Function

In the Quote Score dashboard, a scoring analysis is made based on the sales quotes. At a glance, you get all quote values per relationship or per salesperson, divided into 'Order' and 'No Order'.

 

Target Group

  • Salespeople

 

Where in MKG?

  1. Open the module Sales Dashboard.
  2. If the dashboard is not displayed immediately: click the hamburger
    in the top right corner of the button bar and select the option 'Forms' » 'Dashboard'.
  3. Click the Views button
    and select Sales Quote Scoring Analysis (8011).

 

Main Components

  • A division between order and no order.
  • A monthly graph with both results, score percentage, and trend line.
  • Relationship and salesperson tables with total, order, no order, score, and share in obtained orders.
  • An overview of rejection reasons with value and share.
  • A period choice, a choice for the score basis, and filters for sales group, year, quarter, and month.

 

Display and Use

You choose a period based on the date when the quote line became historical. Option lines are excluded. The score can be calculated based on total prices, quantities, or number of lines. By default, the dashboard uses total prices.

The score is the share with order result within the selected total. With a basis of 0, the score becomes 0. You can select multiple filter values, relationships, salespeople, or rejection reasons to limit the linked analyses.

 

Please note!
The percentage for rejection reasons remains based on total prices, even when you set the score to quantities or lines. Also check the chosen period: the stored start date is after the stored end date. Costs, discounts, and VAT are not displayed separately.

 


 

Technical Explanation

 

Data Sources

  • Primary data source: dashboard_vofr.
  • Indirectly consulted data sources: Sales Quotes (vofh), Salespeople (verk), and Relations (rela).

Selection and Interaction

The source filter limits vofr_dat_historisch with DateFrom and DateTo and requires vofr_is_optie = false. The parameter ScoreType offers values 1, 2, and 3 and is set to 1 by default.

The stored values are January 1, 2025, for DateFrom and December 31, 0001, for DateTo. These do not form an ascending period and must be adjusted for a usable selection.

The relationship, salesperson, and rejection reason tables support multiple filter selection. The rejection reason overview selects only lines for which Result = false. The monthly graph groups Date by month and year and includes regression line indicator1 with display name "Trend".

Calculated Fields

  • Result description: describes the result of the quote line.
    Calculation: gives ‘{Order}’ when Result = true; otherwise ‘{No Order}’.
  • Seller: provides the salesperson name for the salesperson analysis.
    Calculation: gives ‘{- No salesperson}’ when vofh_num.verk_num.verk_naam is an empty string; otherwise, this name is adopted.
  • Reason rejected<: provides the rejection reason or a substitute designation.
    Calculation: gives ‘{- Not rejected}’ at vfst_status = 30. Otherwise, at 0 in t_vofr_vfra, ‘{- No reason}’ is shown, and in other cases, _desc_t_vofr_vfra.
  • Sales quote: combines quote and line number.
    Calculation: combines vofh_num and vofr_num with a space and slash in between.
  • DateFrom: provides the start date for the period indication.
    Calculation: adopts Parameters.DateFrom.
  • DateTo: provides the end date for the period indication.
    Calculation: adopts Parameters.DateTo.
  • Relation: makes the relation recognizable in the relation overview.
    Calculation: combines vofh_num.rela_num.rela_naam with vofh_num.rela_num in parentheses.
  • MKGDataDashboardTitle: provides an empty text value.
    Calculation: returns an empty string.
  • Result: determines whether the line counts as an order.
    Calculation: gives true when vfst_status = 30; otherwise false.
  • Value order: provides the score value for obtained orders.
    Calculation: gives Value when Result = true; otherwise 0.
  • Value no order
    Provides the score value for lines without an order.
    Calculation: gives Value when Result = false; otherwise 0.
  • Value: determines the contribution of each line according to the chosen score basis.
    Calculation: uses vofr_totaalprijs_av at Parameters.ScoreType = 1, vofr_order_aantal at 2, and the value 1 at 3. Other values give a missing value.
  • ScoreType: describes the chosen score basis.
    Calculation: translates Parameters.ScoreType 1 to ‘{prices}’, 2 to ‘{quantities}’, and 3 to ‘{lines}’. Other values give a missing value.
  • Date: provides the date for time analyses.
    Calculation: adopts vofr_dat_historisch.
  • Score %: determines the share that led to an order.
    Calculation: divides the sum of Value order by the sum of Value. If the total is 0, 0 is returned.

Additional Percentage Calculations

The relationship and salesperson tables calculate for the column % of 'Order' the share of Value order in the respective table total. This is a different measure than Score %.

The column % of 'No Order' in the rejection reasons overview calculates the share of vofr_totaalprijs_av per reason. The 'No Order' column, on the other hand, uses Value and thus follows the chosen score basis.

Result description, Sales quote, and MKGDataDashboardTitle are not linked to visible dashboard components.

 

Add to 'My Dashboards'

Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. In this way, you create your own cockpit from the data in your database. How to add dashboards can be read in How to set up 'My Dashboards'