Weekly Recruitment Funnel Report Agent

Hiring managers want to know how their open roles are going, and building the report by hand eats a coordinator's Monday. When the week closes, this agent pulls applicants, screens, interviews, offers and hires for each role from the applicant tracking system. Before calculating anything, it checks for missing stage dates and duplicate candidates. It fixes what it can, such as merging an obvious duplicate, and lists the rest for the coordinator. It then calculates conversion between stages and time spent in each stage, and compares them with targets and the past four weeks. It drafts a report that highlights the biggest drop-off points and suggests where to act, such as a slow interview stage. The coordinator approves the report before it goes to hiring managers. Edge case: a role reopened after a hire is counted as a new requisition, so its numbers start fresh.