SKILL.md

name	hr-kpi
description	Help HR managers, people analytics teams, and HR business partners understand, select, calculate, and act on HR KPIs and workforce metrics. Use when asked to build an HR KPI dashboard, choose strategic HR KPIs, analyze turnover rate, benchmark cost per hire, explain HR metrics, create an HR report for leadership, measure training ROI, track recruiting efficiency, interpret HR data, or any HR performance measurement and workforce analytics task, or define what HR metrics to track.
metadata	author version Tuan Duc Tran 1.0.1

HR KPIs and metrics

Comprehensive HR KPI knowledge for HR managers, people analytics practitioners, and HR business partners — from understanding 150+ workforce metrics and industry benchmarks to building dashboards, analyzing data with AI, and presenting insights to leadership.

Supported tasks

• Explaining HR KPIs and workforce metrics in plain language for HR teams and business stakeholders
• Selecting 5-10 strategic KPIs aligned to organizational goals and priorities
• Calculating and interpreting KPIs across recruiting, retention, compensation, training, and employee relations
• Benchmarking HR metrics against industry standards (SHRM, Gallup, Mercer, ATD)
• Building HR KPI dashboards using tools like Notion, Google Sheets, Power BI, or Tableau
• Analyzing turnover trends, cost per hire, engagement levels, and workforce composition
• Using AI (ChatGPT, Claude, Gemini, Perplexity) to analyze HR data and generate action plans
• Writing executive HR reports and quarterly leadership summaries
• Designing prompts to extract HR insights from raw workforce data
• Understanding DEI measurement, compliance metrics, and organizational health indicators
• Identifying early warning signals from HR data before they become business problems
• Connecting HR metrics to business outcomes and strategic goals

Why HR KPIs matter

Tracking HR KPIs is not about measuring everything. It is about measuring the right things at the right time.

Organizations that lack a structured HR measurement system commonly face:

• wasted recruiting budgets on unoptimized hiring pipelines
• high turnover that drains organizational knowledge and inflates replacement costs
• low engagement that reduces productivity, morale, and retention
• skill gaps that erode market competitiveness
• weak performance management that makes it hard to identify top and low performers
• legal exposure from unmonitored labor compliance indicators
• misaligned HR strategy that cannot be defended with data
• DEI blind spots in hiring, promotion, and compensation decisions

Core principle: Focus on 5-10 strategic KPIs aligned to current organizational goals rather than tracking all 150 metrics simultaneously. More metrics does not equal better decisions.

The 8 HR KPI categories

1. HR Department

Measures the efficiency, cost, and structure of the HR function itself.

Key metrics include:

• HR Expense / Total Revenue (%) — HR cost as a share of revenue
• HR Expense per Employee — Average HR spend per headcount
• HR Headcount Ratio — Total FTEs per HR employee (global benchmark: ~100:1)
• Total HR Headcount — Total number of HR team members
• Span of Control: HR — Number of direct reports per HR manager
• Management Levels: HR — Number of management layers within HR
• Organizational Structure: HR — Centralized versus decentralized HR model
• Total Revenue per HR Employee — Revenue generated per HR staff member
• % Workforce Unionized — Proportion of employees in a union

2. Benefits and Compensation

Measures the cost, competitiveness, and delivery of pay and benefits programs.

Key metrics include:

• Average Base Salary — Average base pay by role or level
• Average Compensation — Total compensation including salary, bonus, and commission
• Benefits Expense per Employee — Benefits cost per headcount
• Healthcare Expense per Covered Employee — Medical insurance cost per covered employee
• Labor Expense / Revenue (%) — Total labor cost as a share of revenue
• Salaries / Operating Expense (%) — Payroll as a percentage of operating costs
• Unit Cost: Enroll in Benefits — Cost to process one benefits enrollment
• Unit Cost: Request / Process Salary Change — Cost to process one salary adjustment

Industry benchmarks (2024-2025):

• Benefits expense: 30-40% of total HR costs (US market, Mercer)
• Labor cost / revenue: 50-60% in services; 20-30% in manufacturing
• Average cost per hire: ~$5,475 USD for non-executive roles; ~$35,879 USD for executive roles (SHRM 2025)

3. Employee Relations

Measures the volume, cost, and resolution speed of workforce disputes and claims.

Key metrics include:

• Total Employee Relations Expense — Total ER department cost
• Total ER Claims Volume — Total number of labor claims in the period
• ER Claims per ER Employee — Claims handled per ER team member
• Cycle Time: ER Claim — Average days to resolve one claim
• Unit Cost: Employee Relations Claim — Cost to process one labor claim
• Number of Labor Disputes — Total workplace disputes filed in the period
• Employee Relations Headcount Ratio — ER staff relative to total workforce

4. HR Generalists

Measures the efficiency of day-to-day HR administrative operations.

Key metrics include:

• HR Generalists Headcount Ratio — HR generalists relative to total workforce
• Cycle Time: Interview Scheduling — Hours from candidate contact to confirmed interview
• Cycle Time: HRIS Record Maintenance — Minutes to update one employee record
• Cycle Time: Salary Action — Business days to process one salary adjustment
• Unit Cost: Change Home Address — Cost to update one employee address in HRIS
• Unit Cost: Interview Scheduling — Cost to schedule one interview session

5. Human Capital Management

Measures workforce composition, stability, and long-term talent investment.

Key metrics include:

• Annual Salary Increase (%) — Average pay increase rate by role or department
• Average Employee Tenure — Mean length of service across the workforce
• Turnover Rate — Total separations as a percentage of average headcount
• Voluntary Turnover Rate — Employee-initiated departures
• Involuntary Turnover Rate — Employer-initiated separations
• First-Year Turnover Rate — Separations within the first 12 months of hire
• Turnover Rate by Position — Turnover broken down by role or department
• Part-Time and Temp Employees (%) — Non-permanent workforce proportion
• Permanent Full-Time Employees (%) — Core workforce stability indicator
• Productive Hours / Total Hours Worked (%) — Effective utilization rate
• HCM Expense per Employee — Total human capital investment per headcount

Industry benchmarks (2025-2026):

• Global voluntary turnover: ~13% annually (Mercer 2025)
• By industry: Insurance 8.2% | Technology 12% | Retail 26.7% | Hospitality ~74%
• First-year turnover: 26% average (SHRM); 17% leave within the first 6 months
• Replacement cost per employee: 50-200% of annual salary for that role
• 75% of voluntary turnover is preventable (Work Institute 2025)

6. Recruiting and Hiring

Measures the speed, cost, and quality of the talent acquisition process.

Key metrics include:

• Cost per Hire — Total recruiting cost divided by number of hires
  • Benchmark: ~$5,475 USD non-executive; ~$35,879 USD executive (SHRM 2025, +14% vs 2019)
• Time to Fill — Business days from requisition open to offer accepted
  • Benchmark: 42 days average (SHRM); 60-90 days for senior roles
• Time to Start — Days from job posting to employee first day
• % Positions Filled Internally — Internal mobility rate; target >20% reflects strong development culture
• % Positions Filled Externally — External market hiring rate
• Number of Requisitions Filled — Total successful hires in the period
• Total New Hires — Gross new headcount added in the period
• Average Requisition Days on Hold — Pipeline stall time by seniority level
• Recruiting Expense per Employee — Recruiting cost relative to total headcount
• Unit Cost: Job Application Processing — Cost to process one application
• Unit Cost: Create Job Requisition — Cost to open one headcount request

7. Training and Development

Measures the investment, efficiency, and reach of learning and development programs.

Key metrics include:

• Training Expense per Employee — Annual L&D spend per headcount
  • Benchmark: $1,200-$1,700 USD per employee per year (ATD Report 2025)
• Training Expense / Labor Expense (%) — L&D investment as a share of total payroll
• Training Expense / Revenue (%) — L&D investment relative to revenue
• Training Days per Year — Annual training days allocated per employee
• Cycle Time: New Hire Training — Days to complete onboarding training program
• Cycle Time: Transfer or Promotion — Processing time for internal mobility decisions
• New Hires Trained per T&D Employee — Training capacity per L&D team member
• Succession Planning Headcount Ratio — Percentage of workforce in succession plans
• Unit Cost: Enroll in Training — Cost to register one employee in a training course
• Unit Cost: Performance Appraisal — Cost to conduct one performance review cycle

8. DEI, Compliance, and Workforce Health

Measures equity, legal risk exposure, and overall organizational health.

Key metrics include:

• Representation metrics — Demographic breakdown across hiring, promotion, and leadership
• Pay equity indicators — Compensation gaps across gender, ethnicity, and level
• Compliance adherence rate — Percentage of labor law and policy requirements met
• Engagement scores — Employee survey results aligned to Gallup Q12 or equivalent
• Absenteeism rate — Unplanned absence days as a percentage of scheduled work days
• OSHA incident rate — Workplace safety incident frequency

Global engagement benchmarks (Gallup 2026):

• Global employee engagement: 20%
• US employee engagement: 31%

Key prompts

KPI selection and strategy

1. "Which 5-10 HR KPIs should [a 200-person SaaS company / a retail chain / a manufacturing plant] prioritize right now based on [our growth stage / retention challenges / cost pressure]?"
2. "Help me build a quarterly HR KPI scorecard for [our HR business partner team] to present to [the CEO and CFO]."
3. "What are the most important leading indicators versus lagging indicators in [HR KPI measurement]?"
4. "How do I choose between tracking [voluntary turnover rate] and [first-year turnover rate] for our retention strategy?"
5. "What HR KPIs matter most to [a CFO / CEO / Board] compared to what HR teams typically track internally?"

Turnover and retention analysis

1. "Our voluntary turnover rate is [X]%. How does this compare to [the technology / retail / healthcare] industry benchmark?"
2. "What are the most common root causes of [high first-year turnover] in [B2B SaaS / customer service / manufacturing] companies?"
3. "Design a 90-day action plan to reduce [voluntary turnover in our engineering department] from [X]% to [Y]%."
4. "What is the true cost of replacing one [mid-level engineer / customer success manager] in our organization?"
5. "How do I identify which department or role has the highest retention risk before resignations increase?"

Recruiting metrics and efficiency

1. "Our Time to Fill is [60 days]. What are the most common causes and how can we reduce it to [40 days]?"
2. "How do I calculate [Cost per Hire] including both direct and indirect recruiting costs?"
3. "What does a healthy [internal fill rate] look like, and how does it reflect our development culture?"
4. "Which recruiting KPIs should I include in a monthly [talent acquisition report] for leadership?"
5. "How do I benchmark our [recruiting funnel conversion rates] against industry standards?"

HR dashboard design

1. "Design an HR KPI dashboard for [a 500-person company] using [Google Sheets / Notion / Power BI] with a focus on [retention and recruiting]."
2. "What is the difference between a weekly operational HR dashboard and a monthly executive HR report?"
3. "Which 5 KPIs should appear on every [CEO-facing HR summary]?"
4. "How do I visualize [turnover trends by quarter and department] in a way that is easy for non-HR executives to understand?"
5. "What data sources do I need to connect to calculate [Cost per Hire, Time to Fill, and Training ROI] automatically?"

AI-assisted HR analytics

1. "I have this HR data: [paste data]. Analyze the turnover trend and identify the top 3 risks."
2. "Help me write an executive summary for our Q[X] HR report in under 150 words based on this data: [paste data]."
3. "What AI prompt should I use to get [Claude / ChatGPT / Gemini] to benchmark my HR KPIs against industry data?"
4. "How can I use [Perplexity] to find current HR benchmarks for [my industry] quickly?"
5. "Design a monthly AI-assisted HR analytics workflow for a small HR team of [3-5 people] without a dedicated data analyst."

Compensation and benefits

1. "How do I calculate and interpret [labor cost as a percentage of revenue] for [our type of business]?"
2. "What benefits KPIs matter most when evaluating [employee satisfaction with our total compensation package]?"
3. "How do I measure the ROI of increasing [healthcare benefits] on [employee retention and productivity]?"
4. "What pay equity metrics should we track to reduce compensation gaps across [gender and seniority levels]?"
5. "How do I present [compensation benchmark data] to leadership to support a [salary band revision]?"

AI-assisted HR KPI workflows

Workflow 1 — Turnover analysis

Use this prompt structure when analyzing voluntary turnover data:

I am an HR Manager at a [industry] company with [X] employees.
My data:

- Voluntary turnover rate (first half of year): [X]%
- First-year turnover rate: [X]%
- Department with highest turnover: [department name]

Please:
1. Compare this to industry benchmarks
2. Identify 3-5 most likely root causes
3. Recommend 3 specific actions to improve within the next 90 days

Workflow 2 — HR dashboard design

Use this prompt structure when building a KPI dashboard from scratch:

Help me design an HR KPI Dashboard for a [company type].
Context:

- Size: [X] employees
- Priority areas: [recruiting / retention / training / cost control]
- Available tools: [Excel / Google Sheets / Notion / Power BI]

Please suggest:
1. 10 KPIs to track weekly
2. 5 KPIs for monthly leadership reporting
3. How to calculate each metric and where to source the data

Workflow 3 — Cost per hire calculation

Use this prompt structure when analyzing recruiting spend:

My recruiting data:

- Job advertising spend: [amount] per month
- Recruiter or headhunter fees: [amount] per hire
- Internal HR time on recruiting: [X] hours per week
- HR salary: [amount] per month
- Successful hires this quarter: [X]

Calculate my Cost per Hire and compare it to the benchmark for [industry].
Recommend 3 ways to reduce cost without sacrificing quality.

Workflow 4 — Executive HR report

Use this prompt structure when preparing a quarterly leadership presentation:

I need to present a Q[X] HR report to our CEO and CFO.
My data:
[paste data here]

Please help me:
1. Summarize the highlights in 3 sentences
2. Identify 2 risks requiring immediate action
3. Propose 3 KPI targets for next quarter
4. Write a concise executive summary slide (under 150 words)

HR KPI implementation tools

Tool	Best for	Key capability
Notion AI	Personal dashboards and small teams	Combines data tracking and AI analysis in one workspace
ChatGPT / Claude	Deep analysis and narrative reporting	Upload CSVs, analyze trends, generate action plans
Google Sheets + Gemini	Automated KPI calculations	Smart formulas and instant data summaries
Power BI / Tableau	Executive-level visualization	Real-time dashboards for leadership teams
Perplexity	Industry benchmark research	Fast market comparison and current data retrieval

Common HR measurement mistakes

Tracking too many KPIs at once

Monitoring 30-50 KPIs simultaneously leads to analysis paralysis. Focus on 5-10 strategic metrics tied to current organizational goals and review the full list quarterly to adjust priorities.

Measuring outputs instead of outcomes

Tracking number of training hours delivered is not the same as measuring whether employee performance improved. Connect activity metrics to business outcome indicators wherever possible.

Ignoring leading indicators

Most HR teams report on lagging indicators like turnover rate after people have already left. Build early warning systems using leading indicators like manager effectiveness scores, internal mobility rates, and engagement pulse data.

Benchmarking without industry context

A 15% annual turnover rate is a red flag for a law firm but may be below average for a retail chain. Always benchmark against your specific industry vertical and company size band.

Collecting data without acting on it

KPI dashboards that are reviewed but not connected to decisions or initiatives do not generate value. Each tracked metric should have an owner, a target, and a review cadence with clear accountability.

Quick-start checklist

• Identify 5 strategic KPIs aligned to your current organizational goal
• Connect data sources (HRIS, payroll, ATS, LMS) to your tracking system
• Build an executive dashboard with a monthly reporting cadence
• Benchmark your metrics using SHRM, Gallup, ATD, and Mercer data
• Use AI tools to analyze trends and generate action items from your data
• Review and update your KPI set every quarter as priorities evolve

Tips

• Start with turnover, cost per hire, and time to fill — these three metrics give the clearest signal of HR effectiveness and are easy to benchmark.
• When presenting HR KPIs to the CFO or CEO, always translate metrics into financial impact: the cost of one bad hire, the annual cost of a 5-point increase in turnover, or the revenue-per-employee ratio.
• Use AI tools like Claude or ChatGPT to analyze HR data files directly — paste or upload your dataset and ask for trend analysis, risk identification, and action recommendations.
• A voluntary turnover rate above your industry benchmark by more than 5 percentage points usually signals a culture, compensation, or management problem worth investigating immediately.
• DEI KPIs are most powerful when tracked over time across the full employee lifecycle: hiring, promotion, pay, retention, and leadership representation.
• The best HR KPI dashboards are the ones that leadership actually uses — design for the decision-maker's perspective, not for HR's internal tracking preferences.