Skip to main content

Sales overview

Underwrite with real-time data from SMB's payments and shopping platforms

Our sales feature offers data sourced from a linked company's commerce connections, allowing you to access valuable insights through aggregated metrics and a comprehensive breakdown of sales transactions from prominent eCommerce, POS, and payment platforms.

Use cases

The primary use case for this feature is revenue analysis. Evaluate historical revenue streams with real-time transactions, order, and payout information. Lenders use these data points to evaluate the stability, growth patterns, and sustainability of the borrower's income.

Feature components

Feature enrichments

Metrics

Our metrics include a set of pre-calculated ratios and metrics focused on commerce and sales data that help lenders assess merchant health and evaluate the credit risk of a company. The following table details which metrics are calculated and their formulas:

MetricDescriptionHow that's translated to Codat data
Revenue
RevenueThe gross revenue for a selected period.Revenue = SUM(orderlines.quantity * orderlines.unitPrice) for the specified period
Revenue growthThe percentage change in revenue between the present period’s value and the previous period's value.Revenue growth % change = ((b-a)/a) * 100 compared to the previous period.
a. previous month's revenue,
b. current month's revenue.
Orders
Number of ordersThe number of orders for a specific period.Number of orders = COUNT(orders) for that period
Order valueThe sum of the values of all orders over a specific period.Value of orders = SUM(orders.totalAmount) for that period
Average order valueThe average order value over a specified period.Average order value = a / b for that period.
a. order value,
b. COUNT(orders).
Refunds
Number of refundsThe number of orders where the totalRefund field is NOT NULL.Number of refunds = COUNT(orders) for the selected period where totalRefund > 0 for the selected period
Value of refundsThe sum of all refunds over a specified period.Value of refunds = SUM(orders.totalRefund) for the selected period, always expressed as a negative value
Refund rateThe number of refunds compared with the number of orders over a specific period.Refund rate = a / b for that period.
a. number of refunds,
b. number of orders.
Customer retention
Existing customersCOUNT of unique customers where they have placed orders in the specified period AND any previous periodExisting customers = COUNT(customers) who placed orders in the specified period and any previous period
New customersCOUNT of unique customers where they have placed orders in the specified period AND NONE in any previous period.New customers = COUNT(customers) who placed orders in the specified period only
Total customersSUM of Existing and New customers.Total customers = a + b.
a. new customers,
b. existing customers.
Retention rateThe percentage of existing customers within the period compared to the total customers at the end of the previous period.Retention rate = (a/(b + c)) * 100
a. COUNT(customers): current period's existing customers, i.e. customers who have placed their very first order before the current period
b. COUNT(customers): previous period's existing customers, i.e. customers who have placed their very first order before the previous period
c. COUNT(customers): previous period's new customers, i.e. customers who have placed their very first order in the previous period
Repeat rateThe percentage of existing customers to total customers over the specified period.Repeat rate = (a / a + b) * 100
a. COUNT(customers): current period's existing customers, i.e. customers who have placed their very first order before the current period
b. COUNT(customers): current period's new customers, i.e. customers who have placed their very first order in the current period
Lifetime value
Lifetime valueThe revenue a business can expect from a paying customer during their time as a paying customer.Lifetime value = a * b * c
a. Average order value for that period
b. COUNT(orders) / COUNT(customers): average number of orders per customer, for that period
c. Average customer lifespan: average difference in days between the last and first orders in a specified period, for all customers.

Supported outputs

You can retrieve the data read and enriched by the feature by calling the sales endpoints of our API.

For example, recurring revenue-based lenders seeking to evaluate month-on-month growth can utilize the Get commerce revenue metrics endpoint.

type RevenueGrowth {
month: string;
growthRate: number;
}

const now = new Date();
// Convert date to dd-mm-yyyy format
let formattedDate = `${now.getUTCDate().toString().padStart(2, '0')}-`;
formattedDate += `${(now.getUTCMonth() + 1).toString().padStart(2, '0')}-`;
formattedDate += `${now.getUTCFullYear()}`;

const revenueResponse = await lendingClient.sales.metrics.getRevenue({
companyId: companyId,
connectionId: connectionId,
numberOfPeriods: 12,
periodLength: 1,
periodUnit: PeriodUnit.Month,
reportDate: formattedDate,
includeDisplayNames: true // Make accessing data easier
});

if (revenueResponse.statusCode != 200) {
throw new Error("Could not get revenue report")
}

// Revenue metrics contain two components: zeroth element is revenue and
// the first element is growth percentage compared to previous period.
const growthMonthOnMonth: RevenueGrowth[] = revenueResponse.commerceReport.reportData.map(x => ({
month: x.itemDisplayName,
growthRate: x.components[1].measures[0].value
}));

const growthRateAverage = growthMonthOnMonth.reduce((total, next) => total + next.growthRate) / growthMonthOnMonth.length;

if(growthRateAverage < growthRateThreshold){
console.log('Prospective borrower does not qualify for a loan')
}

Get started

Once you have the Lending API enabled, configure your instance to work with our sales feature.

Configure data sources

Follow the respective guides to set up and enable commerce integrations that will serve as a data source for the feature:

Enable data types and sync schedule

See how to enable data types and ensure the following data types have been switched on:

  • Customers commerce-customers
  • Disputes commerce-disputes
  • Locations commerce-locations
  • Orders commerce-orders
  • Payment methods commerce-paymentMethods
  • Payments commerce-payments
  • Products commerce-products
  • Product categories commerce-productCategories
  • Transactions commerce-transactions

Configure the solution to refresh data when you need it by setting a synchronization frequency. We recommend setting it to a daily or a monthly sync.

Configure webhooks

We recommend you configure webhook consumers with the following event types to manage your data pipelines. These webhooks send a message for each dataType separately.

  • DataSyncStatusChangedToError

    This means an issue has occurred when syncing the specified data type. Resolve the issue and initiate the sync for this dataset again.

  • DatasetDataChanged

    This means data has been updated for the specified data type. This can include new, updated, or deleted data. You should then refresh the data in your platform.



Was this page useful?
👏
👍
🤔
👎
😭