Skip to content

Dashboard templates

Retail · HR

Retail business with warehouse, customer care, livestream, marketing and office teams. P&L by channel plus average headcount, terminations, payroll cost, overtime, recruiting and revenue per employee.

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

For owners and HR leads at retail shops with warehouse, customer service, livestream and marketing teams. The "Staff productivity" dashboard shows net revenue per employee and payroll cost over net revenue. The "Headcount and attrition" and "Payroll cost and recruiting" dashboards track average headcount, attrition rate, overtime and time to hire, while the profit and loss dashboards show how much of that revenue is profit. Needs channel, product, order, order line and employee data.

Use this template to

  • Decide whether to hire for sale season based on revenue per employee.
  • Keep payroll cost under a set share of net revenue.
  • Track overtime for the livestream and warehouse teams at peak times.

8 ready-made dashboards

Staff productivity

Retail net revenue against average headcount and payroll cost.

  • Net revenue per employee
  • Payroll cost to net revenue
  • Net revenue
  • Payroll cost
  • Monthly net revenue per employee
  • Monthly payroll cost over revenue

Headcount and attrition

Average headcount, new hires, leavers and attrition rate by department.

  • Average headcount
  • New hires
  • Terminations
  • Turnover rate
  • Headcount movement by department
  • Attrition rate by department
  • Monthly leavers by department

Payroll cost and recruiting

Payroll, overtime, absence costs and recruiting effectiveness.

  • Payroll cost
  • Overtime hours
  • Absence rate
  • Offer acceptance rate
  • Monthly payroll cost by department
  • Weekly overtime hours by department
  • Recruiting by department

Profit and loss overview

Actual revenue down to profit after marketplace fees, returns and ads.

  • Net revenue
  • Contribution margin
  • Net profit after fees and ads
  • Net margin
  • From revenue to profit
  • Weekly profit after fees by channel
  • Weekly orders by channel

Sales channels

Compare channels by revenue, fees, return rate, profit and margin.

  • Profit and loss by channel
  • Return rate by channel
  • Profit after fees and ads by channel
  • Cancellation rate by channel
  • Weekly net revenue

Products

SKUs ranked by profit; loss-making SKUs in red; COGS coverage shows which SKUs have no cost yet.

  • Profit by SKU (biggest losses first)
  • Gross profit after fees by category
  • Units sold by SKU
  • Monthly COGS by SKU

Advertising

Spend by platform and campaign, platform-reported ROAS, and the gap between reported and actual revenue by channel.

  • Ad spend
  • Blended ROAS
  • Platform-reported ROAS
  • Ad-reported vs actual revenue gap
  • Ad platform reported vs actual revenue by channel
  • Campaigns
  • Spend by ad platform
  • Monthly platform ROAS by campaign

Data health

Quality test results with row numbers in the Excel file; COGS coverage and unsettled fees.

  • COGS coverage
  • Provisional fee rate
  • Data quality checks
  • COGS coverage by SKU

Ask Si as soon as the build finishes

  • “How did payroll cost to net revenue change compared with last month?”
  • “What is driving net revenue per employee this quarter?”
  • “Show absence days by month for the last six months.”
  • “Where is absence rate highest this month, and why?”

38 defined metrics

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

MetricDefinitionUnit
Payroll cost to net revenuePayroll cost (salary, allowances, overtime, employer-paid insurance) divided by net revenue of the retail channels.= Payroll cost / Net revenueRatio (%)
Net revenue per employeeNet revenue of the retail channels in the period divided by average headcount for the period.= Net revenue / Average headcountCurrency
Absence daysNumber of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other).Count
Absence rateAbsence days divided by scheduled working days.= Absence days / hr_scheduled_daysRatio (%)
ApplicantsNumber of candidates who applied in the period (by application date).Count
Average headcountAverage number of active employees per day in the period.= hr_headcount_days / hr_snapshot_daysNumber
Average monthly cost per employeePayroll cost divided by the number of payslips (one employee-month each).= Payroll cost / hr_payslipsCurrency
New hiresNumber of employees with a start date in the period.Count
Offer acceptance rateOffers accepted divided by offers sent in the period.= hr_offers_accepted / Job offers sentRatio (%)
Job offers sentNumber of candidates sent a job offer in the period (by offer date).Count
Overtime hoursTotal overtime hours recorded in timesheets.Number
Payroll costTotal employer cost of personnel: base salary, allowances, overtime pay and employer-paid insurance. Payroll is recorded monthly, on the first day of the month.Currency
TerminationsNumber of employees whose last working day falls in the period, both voluntary and involuntary.Count
Average time to hire (days)Average number of days from application to offer date for hired candidates, by offer date.= hr_hire_days_total / hr_offers_acceptedNumber
Turnover rateTerminations in the period divided by average headcount for the period.= Terminations / Average headcountRatio (%)
Voluntary terminationsNumber of employees who resigned, with their last working day in the period.Count
Voluntary turnover rateVoluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcountRatio (%)
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 marginProfit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenueRatio (%)
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
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
Ad-reported vs actual revenue gapAd-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenueCurrency
Provisional fee rateShare of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost)Ratio (%)
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
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Seller-paid shipping costOutbound shipping cost paid by the shop, allocated to lines by line revenue.Currency
Units soldTotal quantity of products in the order lines of valid orders.Count

Data you need

Required

channel, product, order, order_line, hr_employee

Add if you have it (unlocks more metrics)

product_cost, customer, cost, return, ad_performance_daily, hr_payroll, hr_attendance, hr_candidate

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 8 dashboards and 38 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 · HR with your own data

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