View sales data
View sales data - Beta testing
Note that sales data visuals are still in beta testing across all integrations and hasn't been fully released yet.
If you're interested in participating in the beta testing of this feature, contact your sales representative.
The Codat Portal allows you to view sales data from a commerce platform and assess merchant health. It exposes some of the key insights lenders need to assess the credit risk of a company using commerce data. It provides graphical displays of commerce data and pre-calculated metrics used to help assess the performance of a company. At a glance you will see what works and what doesn't, providing the opportunity to advise your customers / prospects on what they can do to improve their performance.
This feature is only available on the Client Portal. Make sure you have the following datatypes enabled to sync:
- Commerce - Company Info
- Commerce - Transactions
- Commerce - Orders
- Commerce - Disputes
- Commerce - Products
- Commerce - Payments
- Commerce - Customers
Formulas for calculating sales metrics
Select Help? from the top navigation of the Codat portal to view the formulas used to calculate key metrics.
What metrics are available?
The page is divided into two sections:
- Sales: shows a breakdown of the overall sales activity of the merchant.
- Business insights: provides an overview of the key aspects of merchant health such as discount/chargeback rates.
It also provides values for the Balance and Settlement period.
Balance is the company’s account’s current balance that is available to be transferred or paid out by the payments system, and it does not include pending or reserved funds.
Settlement period is the average number of days between payouts.
Note
Balance and Settlement period are at a company level and are not affected by the date range you select.
Sales
On entering the page, the Gross sales and Net sales graphs are displayed. The Sales section gives you an overview for a company linked on Codat’s commerce integrations. It shows the total sales volume for the store. The Gross sales and Net sales are provided where Net sales accounts for discounts and refunds.
All metrics and graphs are produced for the date range you selected.
The Sales section provides the following metrics:
- Discounts
- Refunds
- No. orders
- Avg. net sales
The following table lists which metrics are provided, their formulas, and where applicable provide examples, for the Sales section:
Metric | Formula |
|---|---|
Balance | Balance data supported by Codat’s commerce-info data type are:
|
Settlement Period | Average value of time between payouts: a/(b -1) a. sum of the days from earliest payout to latest payout b. count of the number of transactions |
Gross sales | Gross sales of an order: (Order.orderLineItems.quantity * Order.orderLineItems.unitPrice) Gross sales of all orders: SUM(Gross sales of an order) for all orders |
Net sales | Net sale of an order: (Order.orderLineItems.quantity * Order.orderLineItems.unitPrice) - (Order.totalDiscounts + Order.totalRefunds) Net sale of all orders: SUM(Net sale of an order) for all orders |
Discounts | SUM(Order.totalDiscount) for all orders |
Refunds | SUM(Order.totalRefund) for all orders |
No. Orders | COUNT(Order.id) for all orders |
Avg. net sale | Net sales of all orders / COUNT(Order.id) for all orders |
Business insights
The Business insights section provides the following metrics:
- Discount rate
- Dispute rate
- Refund rate
- Chargeback rate
All metrics and graphs are produced for the date range you selected.
On entering the page, the New vs existing customers graph is displayed.
You can also select Top products by revenue and Top payment methods by revenue to gain further insights into the buying habits of the company’s customers.
The following table lists which metrics are provided, their formulas, and where applicable provides examples, for the Business insights section:
Metric | Formula |
|---|---|
Discount rate | (b / a )* 100 = X in percentage a. count of all orders b. count the number of orders with discounts, i.e. any order where totalDiscount is non-zero or has a non-null value |
Dispute Rate | “What percentage of X is Y?” where X is Transaction and Y is Disputes. ((Count of Dispute) / (Count of all Transactions on Account)) * 100 |
Refund rate | (b / a) * 100 = X in percentage a. count of all orders b. count the number of orders with refunds i.e. any order where totalRefund is non-zero or has a non-null value |
Chargeback Rate | ((Count of Dispute where status is lost) / (Count of all Transactions on Account)) * 100 |
New vs existing customers The order revenue generated in a given month, split by customers who have had an order made in any previous month, and those who have not. | All order revenue where the createdDate falls within the given month, split by:
|
Top products by revenue |
|
Top payment methods by revenue |
|
Updated 8 months ago