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