Prompt lesson · 25 prompts
Recruitment Data Analysis prompts for Recruitment Coordinators
25 ready-to-use prompts from our AI for Recruitment Coordinators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Applicant Tracking Analysis
Use this when you need to analyze the flow of applicants through your recruitment process to identify bottlenecks and improve efficiency.
Role You are an HR analytics expert specializing in recruitment process optimization. Your goal is to help me identify bottlenecks and drop-off points in my applicant tracking system and provide actionable recommendations to streamline the process.
Context you provide
- {{applicant_data}}: The data or export from your applicant tracking system, including stage timestamps and applicant counts.
- {{stage_definitions}}: The stages in your recruitment process (e.g., applied, screened, interviewed, offered).
- {{time_period}}: The time period for analysis (e.g., last quarter, last 6 months).
Instructions
- If any of the required context is missing, ask me for it before proceeding.
- Analyze the applicant flow data to calculate the average time spent at each stage and the drop-off rate between stages.
- Identify the top 3 bottlenecks or stages with the highest drop-off rates.
- For each bottleneck, suggest specific, actionable improvements to reduce delays and improve conversion.
- Provide a summary of the overall efficiency of the process, highlighting areas of strength.
Output format Provide a structured report with the following sections: Executive Summary, Stage-by-Stage Analysis (including time and drop-off rates), Top Bottlenecks, Recommendations, and Next Steps. Use clear headings, bullet points, and tables where appropriate. Keep the tone professional and data-driven.
Guardrails
- Do not invent data; base all analysis solely on the provided information.
- If data is incomplete, flag assumptions and suggest what additional data would improve the analysis.
- Stay focused on recruitment process analysis; do not provide general HR advice.
Example
- {{applicant_data}}: "CSV export from ATS with columns: applicant_id, stage, timestamp"
- {{stage_definitions}}: "Applied, Phone Screen, Interview, Offer"
- {{time_period}}: "Last quarter"
Open this prompt Analysis · Intermediate
Application Conversion Rate Analysis
Use this when you need to calculate and analyze conversion rates at each stage of your recruitment process to identify bottlenecks and improve efficiency.
Role You are a recruitment funnel analyst. Your goal is to help me understand conversion rates at each stage of my hiring process and identify where we lose candidates so I can improve efficiency.
Context you provide
- {{stage_data}}: The number of applicants at each stage of your recruitment process (e.g., applied, screened, interviewed, offered).
- {{time_period}}: The time period for the analysis (e.g., last month, last quarter).
- {{target_metrics}}: Any target conversion rates you want to compare against (optional).
Instructions
- If any required context is missing, ask me for it before proceeding.
- Calculate the conversion rate between each consecutive stage (e.g., from applied to screened, screened to interviewed).
- Identify stages with significantly lower conversion rates compared to the average or your target metrics.
- For each low-performing stage, suggest specific strategies to improve conversion, such as better screening criteria, improved communication, or streamlined processes.
- Provide a summary of the overall funnel efficiency and highlight any stages that are performing well.
Output format Present the analysis in a structured report with: Overview, Conversion Rate Table (stage-to-stage rates), Key Findings, Recommendations, and Next Steps. Use tables and bullet points for clarity. Keep the tone professional and actionable.
Guardrails
- Do not fabricate data; use only the numbers provided.
- If data is incomplete, clearly state assumptions and suggest what additional data would help.
- Focus only on conversion rate analysis; do not provide unrelated recruitment advice.
Example
- {{stage_data}}: "Applied: 1000, Screened: 500, Interviewed: 200, Offered: 50"
- {{time_period}}: "Last quarter"
- {{target_metrics}}: "Screen rate: 60%, Interview rate: 50%, Offer rate: 30%"
Open this prompt Analysis · Intermediate
Candidate Experience Analysis
Use this when you need to assess the candidate experience throughout your recruitment process to identify pain points and enhance the overall journey.
Open this prompt Analysis · Intermediate
Candidate Quality Analysis
Use this when you need to assess the quality of candidates based on metrics like qualifications and experience to determine the effectiveness of your recruitment strategies.
Open this prompt Analysis · Intermediate
Candidate Screening Analysis
Use this when you need to evaluate and optimize your candidate screening methods for better hiring outcomes.
Open this prompt Analysis · Intermediate
Candidate Sourcing Analysis
Use this when you need to determine which sourcing channels yield the best candidates and improve your sourcing strategy.
Open this prompt Analysis · Intermediate
Candidate Sourcing Analysis
Use this when you need to evaluate the effectiveness of different sourcing channels to attract qualified candidates.
Open this prompt Analysis · Intermediate
Cost per Hire Analysis
Use this when you need to calculate and optimize the cost per hire at each recruitment stage.
Open this prompt Analysis · Intermediate
Diversity and Inclusion Analysis
Use this when you need to evaluate diversity and inclusion metrics in your candidate pool to ensure equal opportunities and identify improvement areas.
Open this prompt Analysis · Intermediate
Employee Turnover Analysis
Use this when you need to understand why employees leave and develop strategies to improve retention.
Open this prompt Analysis · Intermediate
Offer Acceptance Rate Analysis
Use this when you need to measure and understand offer acceptance rates to improve your offer strategies.
Open this prompt Analysis · Intermediate
Predictive Hiring Analysis
Use this when you need to forecast hiring needs and identify potential recruitment challenges using historical data.
Open this prompt Analysis · Advanced
Recruitment Benchmarking Analysis
Use this when you need to compare your recruitment metrics against industry benchmarks or internal targets to assess competitiveness and identify areas for improvement.
Open this prompt Analysis · Intermediate
Recruitment Cost Analysis
Use this when you need to analyze recruitment costs across channels and strategies to optimize your budget.
Open this prompt Analysis · Intermediate
Recruitment Data Cleaning Strategy
Use this when you need to clean recruitment data by identifying and removing inconsistencies, errors, and duplicates.
Open this prompt Planning · Intermediate
Recruitment Data Collection System
Use this when you need to design a system to collect and extract recruitment data from various sources.
Open this prompt Creating · Advanced
Recruitment Data Organization Framework
Use this when you need to categorize and structure recruitment data for easier analysis and screening.
Open this prompt Planning · Intermediate
Recruitment Data Reporting
Use this when you need to turn recruitment data into a clear, actionable report for stakeholders.
Open this prompt Analysis · Intermediate
Recruitment Data Visualization Plan
Use this when you need to create visualizations to uncover patterns and insights in recruitment data.
Open this prompt Analysis · Intermediate
Recruitment Diversity Analysis
Use this when you need to analyze the diversity of your applicant pool and identify potential biases.
Open this prompt Analysis · Intermediate
Recruitment Funnel Analysis
Use this when you need to visualize and analyze your recruitment funnel to identify bottlenecks and improve efficiency.
Open this prompt Analysis · Intermediate
Recruitment Performance Analysis
Use this when you need to evaluate the effectiveness of recruitment campaigns or initiatives to improve hiring outcomes.
Open this prompt Analysis · Intermediate
Source of Hire Analysis
Use this when you need to identify which recruiting sources yield the best candidates and where to focus your efforts.
Open this prompt Analysis · Intermediate
Time-to-Fill Analysis
Use this when you need to measure how long it takes to fill positions and identify bottlenecks in your recruitment timeline.
Open this prompt Analysis · Intermediate
Time-to-Hire Analysis
Use this when you need to calculate the average time from job posting to acceptance and identify ways to speed up hiring.
Open this prompt Analysis · Advanced