Skip to content

Dashboard templates

Technology · HR

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.

Use this template to

  • Plan hiring around a target ARR per employee.
  • Know what share of MRR goes to payroll each month.
  • Track voluntary attrition by department to keep engineers.

6 ready-made dashboards

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

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

MRR overview

Average MRR, new, expansion and churned MRR, and paying customers of a subscription software company.

  • Average MRR
  • Net new MRR
  • Average paying accounts
  • Average revenue per account (ARPA)
  • MRR movement by segment
  • Month-end MRR by segment
  • Net new MRR by plan

Retention and trials

Churned customers, lost MRR, trial conversion rate and product usage.

  • Logo churn rate
  • Churned MRR
  • Trial conversion rate
  • Daily active users (average)
  • Retention by plan
  • Monthly churned MRR by plan
  • Trial conversion rate by plan
  • Weekly daily active users

Billing and collections

Subscription invoice amounts issued and collection rate by segment and billing cycle.

  • Invoiced amount
  • Invoice collection rate
  • Collection rate by segment
  • Amount invoiced by billing cycle
  • Monthly amount invoiced by segment

Ask Si as soon as the build finishes

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

33 defined metrics

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

MetricDefinitionUnit
ARR per employeeAnnual 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 headcountCurrency
Payroll cost to MRRPayroll 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_totalRatio (%)
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 (%)
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_snapshotsCurrency
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_daysNumber
Average MRRAverage 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_countCurrency
Average paying accountsNumber of accounts with positive MRR, averaged over the month-end snapshots in the period.= tech_paying_account_snapshots / tech_snapshot_countNumber
Churned accountsAccounts with at least one churn event (subscription cancellation) in the period.Count
Churned MRRTotal MRR lost from customers cancelling their subscriptions in the period, as a positive number.Currency
Invoice collection rateAmount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amountRatio (%)
Contraction MRRTotal MRR decrease from retained customers (fewer seats, plan downgrades) in the period, as a positive number.Currency
Expansion MRRTotal MRR increase from existing customers (more seats, plan upgrades) in the period.Currency
Invoiced amountTotal amount of subscription invoices issued in the period (by issue date).Currency
Logo churn rateChurned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accountsRatio (%)
Net new MRRNew MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRRCurrency
New MRRTotal MRR from subscriptions that start paying in the period (events of type new), by effective date.Currency
Trial conversion rateTrials converted to paid divided by trials started in the period.= Trials converted / Trials startedRatio (%)
Trials convertedSubscriptions that started a trial in the period and converted to paid (up to the data cut-off date).Count
Trials startedSubscriptions that started a trial in the period (by trial start date).Count

Data you need

Required

account, subscription, mrr_movement, mrr_snapshot, hr_employee

Add if you have it (unlocks more metrics)

plan, invoice, usage_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: account, subscription, mrr_movement, mrr_snapshot, 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 6 dashboards and 33 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 Technology · HR with your own data

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