Financial Analytics For Ecommerce Industry
Revenue and Cost Sold Products
Shows retailer total revenue from customers during a specified period and its pattern comparing to previous periods. In a management dashboard, generally aggregated by month, as well can be shown by day, week, quarter, year. Aggregates total cost paid to suppliers and associated costs for packaging, transportation, storage of all the SKU positions sold over a specified period.
Business earnings after deducting the spending to suppliers, packaging, transportation and storage.
Shows the ratio of earnings compared to the costs.
Number of Orders
Shows a total number of orders during a specified period and the dynamic compared to previous periods. Generally aggregated by month, as well can be shown by day, week, quarter, year.
Number of Customers
Shows number of unique customers that made those orders presented in p5. It means in each order must be tracked customer id, which is a relatively easy task in ecommerce.
Aggregated number of orders that were refunded.
Shows the distribution in refund reasons – provides information what may be going wrong with the inventory or sales process.
Success Rate/Refund Rate/Out of stock Rate
Shows distribution of total orders successfully fulfilled, refunded and not fulfilled due to the shortage.
Aggregates total cost f of all the SKU positions – shows how much funds the Business had invested in inventory.