Team productivity
ARR per employee and payroll cost against subscription revenue (MRR).
- ARR per employee
- Payroll cost to MRR
- Average MRR
- Average headcount
- Monthly ARR per employee
- Monthly payroll cost over MRR
- Payroll cost by department
Dashboard templates
Subscription software (SaaS) company with engineering, product, infrastructure, customer success and sales teams. MRR, churn and trials, plus average headcount, terminations, payroll cost, overtime, recruiting and ARR per employee.
Free plan with no time limit · No card required · Sample workspace ready in minutes
For HR managers at SaaS companies with engineering, product, infrastructure, customer success and sales teams. The "Team productivity" dashboard shows ARR per employee and payroll cost over MRR. The "Headcount and attrition" and "Payroll cost and recruiting" dashboards track attrition, voluntary attrition, payroll cost, overtime and time to hire. Needs account, subscription, MRR movement, MRR snapshot and employee data.
ARR per employee and payroll cost against subscription revenue (MRR).
Average headcount, new hires, leavers and attrition rate by department.
Payroll, overtime, absence costs and recruiting effectiveness.
Average MRR, new, expansion and churned MRR, and paying customers of a subscription software company.
Churned customers, lost MRR, trial conversion rate and product usage.
Subscription invoice amounts issued and collection rate by segment and billing cycle.
Versioned definitions, shared by dashboards, Si, reports and MCP.
| Metric | Definition | Unit |
|---|---|---|
| ARR per employee | Annual recurring revenue (ARR = average MRR x 12) divided by average headcount for the period. A standard productivity measure for SaaS companies.= Average MRR * 12 / Average headcount | Currency |
| Payroll cost to MRR | Payroll cost (salary, allowances, overtime, employer-paid insurance) divided by cumulative MRR for the period (sum of month-end MRR snapshots, one per month). Above 1 means payroll exceeds subscription revenue.= Payroll cost / tech_mrr_snapshot_total | Ratio (%) |
| 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 (%) |
| Average revenue per account (ARPA) | Average MRR per paying account = total MRR across snapshots divided by the number of paying-account occurrences in those snapshots.= tech_mrr_snapshot_total / tech_paying_account_snapshots | Currency |
| Daily active users (average) | Average number of active users per day in the period = total daily active users divided by the number of days.= tech_active_user_days / tech_usage_days | Number |
| Average MRR | Average monthly recurring revenue in the period = total MRR across month-end snapshots divided by the number of snapshot dates.= tech_mrr_snapshot_total / tech_snapshot_count | Currency |
| Average paying accounts | Number of accounts with positive MRR, averaged over the month-end snapshots in the period.= tech_paying_account_snapshots / tech_snapshot_count | Number |
| Churned accounts | Accounts with at least one churn event (subscription cancellation) in the period. | Count |
| Churned MRR | Total MRR lost from customers cancelling their subscriptions in the period, as a positive number. | Currency |
| Invoice collection rate | Amount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amount | Ratio (%) |
| Contraction MRR | Total MRR decrease from retained customers (fewer seats, plan downgrades) in the period, as a positive number. | Currency |
| Expansion MRR | Total MRR increase from existing customers (more seats, plan upgrades) in the period. | Currency |
| Invoiced amount | Total amount of subscription invoices issued in the period (by issue date). | Currency |
| Logo churn rate | Churned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accounts | Ratio (%) |
| Net new MRR | New MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRR | Currency |
| New MRR | Total MRR from subscriptions that start paying in the period (events of type new), by effective date. | Currency |
| Trial conversion rate | Trials converted to paid divided by trials started in the period.= Trials converted / Trials started | Ratio (%) |
| Trials converted | Subscriptions that started a trial in the period and converted to paid (up to the data cut-off date). | Count |
| Trials started | Subscriptions that started a trial in the period (by trial start date). | Count |
account, subscription, mrr_movement, mrr_snapshot, hr_employee
plan, invoice, usage_daily, hr_payroll, hr_attendance, hr_candidate
Upload an Excel file or connect a source with: account, subscription, mrr_movement, mrr_snapshot, 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 6 dashboards and 33 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