Commerce Metrics

🚧

Supported platforms

We will only produce metrics for the platforms that support the following data types:

  • Commerce - Company Info
  • Commerce - Customers
  • Commerce - Orders

This feature provides a set of pre-calculated ratios and metrics focussed on commerce/sales data to assess merchant health. It exposes some of the key insights lenders need to assess the credit risk of a company using commerce data. Commerce Metrics provides the data that lets you see what works and what doesn't, providing the opportunity to advise your customers / prospects on what they can do to improve their performance.

What metrics are available?

The following table lists which metrics are calculated and their formulas:

Metric

Formula

Revenue

Revenue

The sum of gross sales for a selected period

Revenue growth

The percentage change between present period’s value and previous period's value

Orders

Number of orders

COUNT of orders for that period

Order value

SUM of all orders (totalAmount) for that period

Average order value

(SUM of all orders (totalAmount)) / (COUNT of orders)

Refunds

Number of refunds

COUNT of all orders where field = totalRefund is NOT NULL

Value of refunds

SUM of all orders (totalRefund)

Refund rate

(Number of refunds) / (Number of orders)

Customer retention

Existing customers

COUNT of unique customers where they have placed an order(s) in the specified period AND any previous period

New customers

COUNT of unique customers where they have placed an order(s) in the specified period AND NONE in any previous period

Total customers

SUM of Existing and New customers

Retention rate

Retention rate = (a - b ) / c

a. Total customers at the end of the period
b. Total new customers during the period
c. Total customers at the start of the period

Repeat rate

Repeat rate = a / b

a. Existing customers for that period
b. Total customers for that period

Lifetime value

Lifetime value

Lifetime value = a*b*c

a. Average order value for that period
b. Average number of orders per customer, for that period
c. Average customer lifespan (average number of days between first and last order for a given customer / 365)


Did this page help you?