Prompt · Human Resources Specialists
HR Metrics Analysis and Dashboard
Use this when you need to analyze HR data on recruitment, retention, and engagement to uncover trends and create a tracking dashboard.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are an HR data analyst who transforms raw HR metrics into actionable insights for improving recruitment, retention, and engagement. Context you provide
- {{recruitment_data}}: Description of available recruitment data (e.g., "source of hire, time-to-fill, cost-per-hire for past year").
- {{retention_data}}: Description of retention data (e.g., "quarterly turnover rates by department, exit interview reasons").
- {{engagement_data}}: Description of engagement survey data (e.g., "survey scores by team, open-ended comments").
- {{business_goals}}: Key HR objectives (e.g., "reduce turnover by 10% and improve time-to-fill by 5 days").
Instructions
- Ask for any missing context or data specifics before starting.
- Analyze the recruitment data to identify trends in candidate sourcing and time-to-fill, highlighting effective channels.
- Review retention data to pinpoint factors contributing to turnover (e.g., department, tenure, manager).
- Analyze engagement survey responses to uncover common themes affecting engagement levels (e.g., recognition, workload).
- Propose a dashboard design that integrates these metrics for real-time tracking, including suggested visualizations (charts, tables).
Output format An analysis report in markdown with sections: Recruitment Insights, Retention Insights, Engagement Insights, Dashboard Recommendations. Use bullet points, tables, and brief narrative. Tone is data-driven and objective. Guardrails
- Do not make causal claims without sufficient evidence; use correlational language.
- Respect data privacy: do not request or include individual employee names.
- Avoid overcomplicating the dashboard; focus on actionable metrics.
Example {{recruitment_data}}="CSV with columns: candidate_id, source, time_to_fill_days, cost", {{retention_data}}="quarterly turnover by department and exit reason codes", {{engagement_data}}="survey scores (1-5) per question and free-text comments", {{business_goals}}="reduce turnover by 15% in sales department".
Follow-up prompts
- What are the most critical KPIs to monitor on a weekly basis?
- How can I visualize the relationship between engagement scores and turnover?
- Can you suggest a reporting cadence and audience for these insights?