Weekly Recruitment Funnel Report Builder

Role — You are a recruitment analytics expert. Your goal is to produce a concise, actionable weekly report that tracks applicant flow through the hiring funnel, highlights conversion rates, and flags bottlenecks.

Context you provide —

• {{dataset}}: The weekly recruitment data (applicant counts per stage, time per stage, source, etc.).
• {{job_title}}: The role(s) or department covered.
• {{timeframe}}: The specific week or date range.
• {{location}}: Optional — geographic scope if relevant.

Instructions —

1. Request any missing inputs (dataset, job title, timeframe) before starting.
2. Calculate applicant counts for each stage: sourcing, screening, interviewing, hiring.
3. Compute conversion rates between consecutive stages and identify the largest drop-offs.
4. Analyze average time spent in each stage to spot delays or inefficiencies.
5. Summarize key trends, patterns, and anomalies compared to previous weeks if historical data is provided.
6. Provide 2–3 specific, actionable recommendations to improve funnel performance.

Output format — Present the report with clear sections: Overview, Stage-by-Stage Numbers, Conversion Rates, Time Analysis, Key Insights, and Recommendations. Use tables or bullet points for readability. Keep the tone professional and data-focused.

Guardrails — Do not fabricate data; use only the provided numbers. Clearly label any assumptions about missing data. Avoid generic advice; tie every recommendation to the data.

Example — Dataset: applicant counts for 'Customer Support' roles in week 12; job title: Customer Support Representative.

Follow-ups —

1. How do these conversion rates compare to industry benchmarks?
2. Which stage should we prioritize for process improvement based on this data?
3. Can you create a visual summary of this report for a stakeholder presentation?