Document toolboxDocument toolbox

Retail Dashboard

Owned by Sean De Souza
Jun 24, 2024
3 min read

These are temporary old definitions but new ones will come in the near future

Note: If a period is selected where targets have not been provided the performance % vs target will be skewed.

Targets only provided for date range:

Old metrics mapping to the new metrics:

 

  • Sales & Upgrades: New Contracts

  • Sales: New Accounts

  • Target total to date: New Contracts Target Total to Date

  • Variance: New Contracts Difference from Target

  • TV Sales: TV Contracts

  • %TV Sales : %TV Contracts

  • New customer: A customer is considered new if their first-ever account is new i.e. the first account should be in the downpayment period.

  • Existing customer: A customer is considered existing if their first account is not new i.e. the first his/her account is not in the downpayment period

  • New Accounts: The number of new payg accounts over a period of time. The period is determined by the downpayment date.

  • New Contracts: This is the count of contracts sold either at a package level, or product when they were sold individually not in a package. The period is determined by the downpayment date.

  • Contract Value: This is the monetary total contractual value of what has been sold. It is in local currency.

  • TV Contracts : the number of TV sales.

  • % TV Contracts :This is calculated for Sales as the number of Sales that had a TV in the bundle.

  • Date Filter: The date filter is synchronized across all tabs. The date filter for New Contracts and New Accounts is based on down payment date.

  • New Contracts Target Total to Date: The proportion of the target that should have been achieved by this day of the month. Eg. if the target is 30 and it is the 10th of June then the proportional target is 10.

  • New Contracts Difference from Target: The number above or below the target the number of Sales was. Green font is above and red is below.

  • % Target achieved to date: The percentage of the target the number of Sales and Upgrades total was. Green font is above and red is below.

  • % TVs target: The target percentage TVs as defined by the RM

  • % Target achieved (in % TVs section): the variation of actual TV % and the target

  • New Installs: The number of installations in the period selected by the filter. This includes only new sale installations.

  • No. Repossessions: the number of repossessions completed in the period selected by the filter.

  • % DP Only Defaulter : This metric shows the number of defaulters divided by the number of installations the period selected.

  • Agents with New Contracts in Period: Number of sales persons.

  • New Contracts by Package: The number of packages sold to customers.

  • Contract type: The pricing terms for a product or a package.

  • HPA (Hire Purchase Agreement): a contract type where the asset remains on the NGU’s books until the pay plan is completed, and revenue is recognized according to the payment schedule.

  • Contract length: number of days a customer needs to pay for so that the pay plan can be completed.

  • Credit type: The smallest whole unit of credit a customer can buy and be switched on under any circumstance. Examples would include: Days, Kg, kWh, MB, etc

  • Credit price: The price of one credit. For example, $0.20 per day, or $0.50 per kg gas. This is the former daily rate.

  • Downpayment credit amount: the amount of units of credit given to the customer when they pay the downpayment, they will use these credits before the next payment is due.

     

 

BBOXX