Export ATS recruiting metrics for a pipeline velocity and funnel report
domain: recruiting-general · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Query the ATS reporting or applications API to retrieve all applications created within the reporting period, including their current stage and timestamps for each stage transition
Calculate time-in-stage for each application by computing the difference between consecutive stage change timestamps
Aggregate by job, department, or recruiter to compute metrics: average time-to-hire, stage conversion rates, offer acceptance rate, and source-of-hire breakdown
For Greenhouse, use the Harvest API GET /v1/applications endpoint with created_before and created_after filters; include the 'prospect=false' parameter to exclude prospects
Output the aggregated metrics to a dashboard tool (e.g., via the Google Sheets API, a BI tool webhook, or a direct database write)
Known gotchas
Stage transition timestamps are not always available as first-class fields; some ATS platforms only expose the current stage, requiring you to derive historical data from activity logs or webhooks captured in real time
Applications that were archived or deleted do not appear in list API results even if they fall within the reporting period, which can undercount funnel volume; use a webhook-based event log for complete data
Conversion rate calculations are skewed if the reporting period cuts off active applications mid-funnel; restrict the analysis to applications that have reached a terminal stage (hired, rejected, withdrew) within the period
Give your agent this knowledge — and 15,500+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?