KPI board
Key retail business metrics next to the reliability of the data behind them.
- Net revenue
- Contribution margin
- Valid orders
- Average order value
- Return rate
- Cancellation rate
- Blended ROAS
- Run success rate
- Check pass rate
- Freshness breaches
Dashboard templates
A retailer whose data team loads marketplace orders, ads, inventory and CRM into the warehouse. A key KPI board (revenue, orders, gross profit, returns, cancellations, ROAS) plus pipeline reliability, data quality, analysis requests and dashboard usage.
Free plan with no time limit · No card required · Sample workspace ready in minutes
For data leads at retail businesses bringing marketplace orders, ads, inventory and CRM into one place. The "KPI board" dashboard uses the retail pack's standard metrics directly: net revenue, orders, average order value, contribution margin, return rate, cancellation rate and ROAS. The "Data reliability" and "Requests and usage" dashboards show how often pipelines succeed, how many duplicate order ID checks pass and who views dashboards. Needs channel, order, order line and pipeline run log data.
Key retail business metrics next to the reliability of the data behind them.
Are pipelines running reliably, is data as fresh as promised, and how many quality checks pass.
How many analysis requests departments send, how fast the data team delivers, and how often dashboards are viewed.
Versioned definitions, shared by dashboards, Si, reports and MCP.
| Metric | Definition | Unit |
|---|---|---|
| Departments viewing dashboards | Number of distinct departments with at least one dashboard view in the period. | Count |
| Average request lead time (days) | Average days from when a department submits a request to when the data team delivers it, for requests delivered in the period.= da_request_lead_days_total / Delivered requests | Number |
| Average run duration (minutes) | Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runs | Number |
| Check pass rate | Passed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checks | Ratio (%) |
| Dashboard views | Total dashboard views by users across departments in the period. | Count |
| Delivered requests | Delivered requests with a delivery date in the period (by delivery date). | Count |
| Failed checks | Data quality checks with a standardized result of fail in the period. | Count |
| Failed runs | Pipeline runs with a standardized status of failed (including errors and timeouts), by start date. | Count |
| Freshness breaches | Successful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours). | Count |
| Pipeline runs | Data loading pipeline runs started in the period, including successful, failed and skipped runs. | Count |
| Data quality checks | Data quality checks run in the period (freshness, completeness, uniqueness, validity). | Count |
| Analysis requests | Analysis and report requests that departments submitted to the data team in the period (by submission date). | Count |
| Run success rate | Successful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs) | Ratio (%) |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| Cancellation rate | Cancelled orders divided by total orders.= cancelled_orders / all_orders | Ratio (%) |
| Cost of goods sold | Quantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS. | Currency |
| COGS coverage | Share of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_total | Ratio (%) |
| Contribution margin | Net revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return cost | Currency |
| GMV (gross merchandise value) | Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds). | Currency |
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Payment fees | Marketplace transaction fees and payment gateway fees, allocated to lines by line revenue. | Currency |
| Marketplace fees | Marketplace commission and service fees, allocated to lines by line revenue. | Currency |
| Return cost | Return shipping cost borne by the shop. Does NOT include refunds to buyers (already deducted in net revenue). | Currency |
| Return rate | Returned orders divided by valid orders.= returned_orders / Valid orders | Ratio (%) |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Seller-paid shipping cost | Outbound shipping cost paid by the shop, allocated to lines by line revenue. | Currency |
channel, order, order_line, da_pipeline_run
product, product_cost, customer, cost, return, ad_performance_daily, da_dataset, da_quality_check, da_request, da_dashboard_view
Upload an Excel file or connect a source with: channel, order, order_line, da_pipeline_run.
Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.
The build gives you 3 dashboards and 28 metrics; ask Si anytime.
Connectors with a setup guide that feed the entities this template needs. Excel always works.
Free plan with no time limit · No card required · Sample workspace ready in minutes