Finance E-commerce Data Model

Computable Metrics

Metric
Description

Gross Revenue

Total sales revenue before any deductions.

Net Revenue

Sales revenue after discounts, returns, and refunds.

Gross Margin

Gross profit as a percentage of gross revenue.

Contribution Margin

Profit after variable costs, supporting fixed costs and profit.

Product-Level Profitability

Margin and profit by individual product.

Order Profitability

Margin and profit by each order.

Gross Merchandise Value (GMV)

Total merchandise sold value, regardless of returns or discounts.

Average Order Value (AOV)

Average value of an order before costs.

Customer Lifetime Value (CLV)

Projected revenue from a customer over their lifetime.

Repeat Purchase Contribution

Percentage of revenue from repeat customers.

Refund Rate

Percentage of orders or items refunded.

Return Costs

Total costs associated with returns.

Shipping Revenue

Total amount charged to customers for shipping.

Shipping Costs

Actual shipping spend.

Shipping Margin

Shipping revenue minus shipping costs.

Payment Transaction Costs

Fees charged by payment processors.

Payment Method Fee Analysis

Breakdown of transaction costs by payment method.

Discount Costs

Total discounts given, in value and as a percentage of sales.

Marketing Costs per Order

Average marketing cost allocated to each order.

CAC Payback Period

Time to recover customer acquisition costs.

Revenue per Customer Segment

Net revenue by customer segments (e.g., new vs returning).

Revenue per Product Category

Net revenue by product category.

Revenue per Region

Net revenue by region or geography.

Total Refunds

Total refunded amount and number of refund events.

Fraud Loss Rate

Share of revenue lost to fraud.

Inventory Holding Costs

Costs related to holding stock over time.

Stockouts Lost Revenue

Estimated lost revenue due to stockouts.

Inventory Turnover Rate

Frequency of inventory being sold and replaced.

On-Time Payment Rate

Percentage of payments received on time.

Average Payment Lead Time

Average time to collect payment after order confirmation.

Average Payment Collection Rate

Overall collection rate on payment requests.

Payment Failure Rate

Percentage of payment transactions that fail.

Total Transaction Costs

Sum of payment fees, refunds, and chargebacks.

Net Revenue after Payment and Logistics Costs

Final net revenue after subtracting payment and shipping costs.

Operating Cashflow from Orders

Cashflow directly attributable to fulfilled orders.

Data Model

Last updated

Was this helpful?