What goes in a recruiting funnel dashboard in Metabase?

A recruiting funnel dashboard shows how candidates move from application or sourcing into interviews, offers, and accepted hires. Build it from ATS data synced into a database, with stage history as the backbone.

Which cards belong on this dashboard?

• Open applications by current stage
• Stage-to-stage candidate conversion rate
• Median time in stage by stage
• Applications created vs. advanced by week
• Stale applications by recruiter and stage
• Source-to-offer conversion by source

What data does this dashboard need?

• Applications with created_at, job, current stage, status, source, recruiter, and hiring manager.
• Application stage history with entered_at, exited_at, and ordered stage mapping.
• Interviews and offers tied to applications.
• Job attributes such as department, location, role family, and seniority.

How do you build it?

1. Sync ATS or HRIS data into a database, then connect that database to Metabase.
2. Create reusable models for jobs or requisitions, applications, stage history, interviews, offers, sources, workers, and organizations as needed.
3. Create one saved question per card, using consistent metric definitions and permissioned models.
4. Add dashboard filters for department, location, role family, recruiter, hiring manager, source, and date range.

Example card SQL

SELECT
  s.stage_name,
  s.stage_order,
  COUNT(DISTINCT h.application_id) AS applications_reached
FROM modeled_stages s
LEFT JOIN modeled_application_stage_history h
  ON h.stage_id = s.stage_id
GROUP BY s.stage_name, s.stage_order
ORDER BY s.stage_order;

Related

Dashboards

Integrations

Metrics

Analytics

FAQ