Skip to content

Dashboard templates

Retail · Data & analytics

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.

Use this template to

  • Send leadership a KPI board with that month's test pass rate.
  • Catch duplicate order IDs across marketplaces before revenue is counted twice.
  • See which teams use dashboards to prioritize the next analysis requests.

3 ready-made dashboards

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

Data reliability

Are pipelines running reliably, is data as fresh as promised, and how many quality checks pass.

  • Run success rate
  • Freshness breaches
  • Check pass rate
  • Average run duration (minutes)
  • By data table
  • Weekly failed runs by domain
  • Failed checks by type

Requests and usage

How many analysis requests departments send, how fast the data team delivers, and how often dashboards are viewed.

  • Analysis requests
  • Average request lead time (days)
  • Dashboard views
  • Departments viewing dashboards
  • By department
  • Views by dashboard
  • Weekly new analysis requests

Ask Si as soon as the build finishes

  • “How did departments viewing dashboards change compared with last month?”
  • “What is driving average request lead time (days) this quarter?”
  • “Show average run duration (minutes) by month for the last six months.”
  • “Where is check pass rate highest this month, and why?”

28 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Departments viewing dashboardsNumber 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 requestsNumber
Average run duration (minutes)Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runsNumber
Check pass ratePassed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checksRatio (%)
Dashboard viewsTotal dashboard views by users across departments in the period.Count
Delivered requestsDelivered requests with a delivery date in the period (by delivery date).Count
Failed checksData quality checks with a standardized result of fail in the period.Count
Failed runsPipeline runs with a standardized status of failed (including errors and timeouts), by start date.Count
Freshness breachesSuccessful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours).Count
Pipeline runsData loading pipeline runs started in the period, including successful, failed and skipped runs.Count
Data quality checksData quality checks run in the period (freshness, completeness, uniqueness, validity).Count
Analysis requestsAnalysis and report requests that departments submitted to the data team in the period (by submission date).Count
Run success rateSuccessful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs)Ratio (%)
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
Cost of goods soldQuantity 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 coverageShare 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_totalRatio (%)
Contribution marginNet 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 costCurrency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
Return costReturn shipping cost borne by the shop. Does NOT include refunds to buyers (already deducted in net revenue).Currency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Seller-paid shipping costOutbound shipping cost paid by the shop, allocated to lines by line revenue.Currency

Data you need

Required

channel, order, order_line, da_pipeline_run

Add if you have it (unlocks more metrics)

product, product_cost, customer, cost, return, ad_performance_daily, da_dataset, da_quality_check, da_request, da_dashboard_view

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: channel, order, order_line, da_pipeline_run.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 3 dashboards and 28 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Retail · Data & analytics with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes