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
Dashboard templates
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.
Retail net revenue against average headcount and payroll cost.
Average headcount, new hires, leavers and attrition rate by department.
Payroll, overtime, absence costs and recruiting effectiveness.
Actual revenue down to profit after marketplace fees, returns and ads.
Compare channels by revenue, fees, return rate, profit and margin.
SKUs ranked by profit; loss-making SKUs in red; COGS coverage shows which SKUs have no cost yet.
Spend by platform and campaign, platform-reported ROAS, and the gap between reported and actual revenue by channel.
Quality test results with row numbers in the Excel file; COGS coverage and unsettled fees.
Versioned definitions, shared by dashboards, Si, reports and MCP.
| Metric | Definition | Unit |
|---|---|---|
| Payroll cost to net revenue | Payroll cost (salary, allowances, overtime, employer-paid insurance) divided by net revenue of the retail channels.= Payroll cost / Net revenue | Ratio (%) |
| Net revenue per employee | Net revenue of the retail channels in the period divided by average headcount for the period.= Net revenue / Average headcount | Currency |
| Absence days | Number of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other). | Count |
| Absence rate | Absence days divided by scheduled working days.= Absence days / hr_scheduled_days | Ratio (%) |
| Applicants | Number of candidates who applied in the period (by application date). | Count |
| Average headcount | Average number of active employees per day in the period.= hr_headcount_days / hr_snapshot_days | Number |
| Average monthly cost per employee | Payroll cost divided by the number of payslips (one employee-month each).= Payroll cost / hr_payslips | Currency |
| New hires | Number of employees with a start date in the period. | Count |
| Offer acceptance rate | Offers accepted divided by offers sent in the period.= hr_offers_accepted / Job offers sent | Ratio (%) |
| Job offers sent | Number of candidates sent a job offer in the period (by offer date). | Count |
| Overtime hours | Total overtime hours recorded in timesheets. | Number |
| Payroll cost | Total 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 |
| Terminations | Number 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_accepted | Number |
| Turnover rate | Terminations in the period divided by average headcount for the period.= Terminations / Average headcount | Ratio (%) |
| Voluntary terminations | Number of employees who resigned, with their last working day in the period. | Count |
| Voluntary turnover rate | Voluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcount | 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 margin | Profit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenue | Ratio (%) |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | 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 |
| Ad-reported vs actual revenue gap | Ad-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 revenue | Currency |
| Provisional fee rate | Share of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost) | Ratio (%) |
| 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 |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
| Seller-paid shipping cost | Outbound shipping cost paid by the shop, allocated to lines by line revenue. | Currency |
| Units sold | Total quantity of products in the order lines of valid orders. | Count |
channel, product, order, order_line, hr_employee
product_cost, customer, cost, return, ad_performance_daily, hr_payroll, hr_attendance, hr_candidate
Upload an Excel file or connect a source with: channel, product, order, order_line, hr_employee.
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 8 dashboards and 38 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