Compute recruiting funnel metrics: conversion rates, time-in-stage, time-to-fill, source performance, interviewer calibration, pipeline diversity, quality of hire. Outputs analysis with benchmarks and identified bottlenecks. Reads pipeline.md and application.md files.
How this skill is triggered — by the user, by Claude, or both
Slash command
/ciromaciel-recruiting:funnel-analyticsThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Pure reasoning skill. Reads structured pipeline + application data and produces funnel analysis with actionable insights.
Pure reasoning skill. Reads structured pipeline + application data and produces funnel analysis with actionable insights.
Built for: Recruiter or recruiting lead running weekly / monthly / quarterly reviews of how the funnel is performing.
/report commandRead recursively:
clients/<cliente>/jobs/*/pipeline.md (snapshot of each vacancy)clients/<cliente>/jobs/*/candidates/*/application.md (per-candidate state + history)clients/<cliente>/jobs/*/reports/index.md (past reports for trend)Confirm:
Pipeline canonical stages:
Sourced → Applied → Screening → Phone → Technical → Onsite → Offer → Accepted → Hired
For the period, compute:
| Stage transition | N entered | N advanced | Pass rate | Benchmark | Status |
|---|---|---|---|---|---|
| Applied → Phone screen | 150 | 30 | 20% | 10-20% | 🟢 |
| Phone → Technical | 30 | 12 | 40% | 30-50% | 🟢 |
| Technical → Onsite | 12 | 6 | 50% | 40-60% | 🟢 |
| Onsite → Offer | 6 | 2 | 33% | 30-50% | 🟢 |
| Offer → Accepted | 2 | 2 | 100% | 80-90% | 🟢 |
| Stage transition | Healthy range |
|---|---|
| Sourced → Applied (outbound) | 5-15% |
| Applied → Phone screen | 10-25% |
| Phone → Technical | 30-50% |
| Technical → Onsite | 40-60% |
| Onsite → Offer | 25-50% |
| Offer → Accepted | 80-95% |
Outside these ranges → bottleneck or opportunity. Diagnose:
For the period:
Tabulate rejection reason codes for each stage:
| Stage | Top 3 reason codes | Volume |
|---|---|---|
| Phone screen | skills-gap (12) | level-mismatch (8) | comp-mismatch (5) |
| Technical | failed-assessment (8) | code-quality-concern (4) | comm-concern (2) |
| Onsite | level-mismatch (4) | judgment-concern (3) | culture-decompose (2) |
If "comp-mismatch" is high at phone screen → comp band is wrong vs market. If high at offer → calibration is wrong, not market.
For each interviewer in the period:
Identify outliers:
Recommend: shadow interviews for outliers, debrief facilitation, calibration training.
For each sourcing channel:
Output:
| Source | Candidates | Hires | Hire rate | Cost/hire | Quality (post-hire) |
|---|---|---|---|---|---|
| Referrals | 12 | 3 | 25% | $0 | High |
| Outbound LinkedIn | 80 | 2 | 2.5% | recruiter hours | Mixed |
| Inbound (careers page) | 60 | 1 | 1.7% | $0 | High |
| Agency | 8 | 1 | 12% | $25k | High |
| ... | | | | | |
Decisions:
⚠️ Only run if client has documented:
For each demographic dimension collected:
If drop-off rates differ significantly by demographic at a specific stage → that stage has bias signal. Investigate:
Do not report individual data, ever. Only aggregated, only above minimum cohort size (10+).
Cross-reference hires with performance data (from HRIS, 6-12 months post-hire):
Compute:
This is the highest-value analysis but the hardest to run. Most agencies don't have HRIS access — but if you do, this is the loop that improves the entire process.
Don't just report numbers. For each report:
Examples:
Write to clients/<cliente>/reports/<mode>-<YYYY-MM-DD>.md:
# Funnel Report — [Cliente] | [Period]
## Executive summary
[3-5 bullets — health snapshot + top issue]
## Volume + conversion
[full funnel table]
## Time metrics
[table]
## Reason code analysis
[table]
## [Mode-specific deep-dive section]
## Top insights
1. [...]
2. [...]
3. [...]
## Recommended actions
| Action | Owner | Due |
|---|---|---|
| [...] | [...] | [date] |
## Notes on data quality
- [Period had N applications — small sample, treat % with grace if <30]
- [Missing reason codes on N records — fix process going forward]
Append to clients/<cliente>/reports/index.md:
npx claudepluginhub ciro-maciel/ciromacielos --plugin ciromaciel-recruitingProvides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.