Offer Acceptance Rate (Offer Accept)

Что такое Offer Acceptance Rate (Offer Accept)?

Доля принятых офферов от общего числа выданных.

Формула

Offer Acceptance Rate = accepted_offers / total_offers

Как считать

Считаем кандидатов с offer_date IS NOT NULL и делим accepted_at IS NOT NULL на общее число.

Зачем нужна

Низкий acceptance rate = неконкурентные условия или долгий процесс. Каждый отказ = потерянные недели рекрутинга.

SQL-запрос

-- Таблицы: candidates(candidate_id, vacancy_id, applied_at, stage, offer_date, accepted_at, rejected_at)
--          vacancies(vacancy_id, team, opened_at, closed_at, status, priority)
SELECT DATE_TRUNC('quarter', c.offer_date) AS quarter,
       v.team,
       COUNT(*) AS total_offers,
       COUNT(c.accepted_at) AS accepted,
       COUNT(c.rejected_at) AS rejected,
       ROUND(COUNT(c.accepted_at)::numeric / NULLIF(COUNT(*), 0), 4) AS acceptance_rate
FROM candidates c
JOIN vacancies v ON v.vacancy_id = c.vacancy_id
WHERE c.offer_date IS NOT NULL
  AND c.offer_date >= CURRENT_DATE - INTERVAL '12 month'
GROUP BY 1, 2
ORDER BY 1 DESC, acceptance_rate;