Financial Analytics For Ecommerce

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.

revenue and cost sold products
margin value

Margin value

Business earnings after deducting the spending to suppliers, packaging, transportation and storage.

Margin Ratio

Shows the ratio of earnings compared to the costs.

margin ratio
number of orders

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.

number of customers
orders refunded

Orders Refunded

Aggregated number of orders that were refunded.

Refund Reasons

Shows the distribution in refund reasons – provides information what may be going wrong with the inventory or sales process.

refund reasons
success rate- refund rate - out of stock rate

Success Rate/Refund Rate/Out of stock Rate

Shows distribution of total orders successfully fulfilled, refunded and not fulfilled due to the shortage.

Inventory Value

Aggregates total cost f of all the SKU positions – shows how much funds the Business had invested in inventory.

inventory value
inventory days distribution

Inventory Days Distribution

Shows the distribution of a number of SKU by Inventory Days segment.

Sales Ecommerce Dasbhoard CTA