Recruitment Time in Stage

Question

Does anyone have a dashboard for time in each stage of the recruitment process including: Apply to phone screen, phone screen to interview, interview to offer, and offer to start?

Gina DiVenti · Accepted Answer

Have you explored the phase and state completion duration metrics? These are really great for tracking how long the candidates are in each phase and state.

We have also built custom calculations that measure the time difference between two Oracle dates (we had to explore different aggregation methods to make these accurate, so be careful to validate closely):

Avg (TIMESTAMPDIFF(SQL_TSI_DAY,"HCM - Talent Acquisition"."Job Application - Dates"."Job Application Submitted Date","HCM - Talent Acquisition"."Job Offer - Basic Information"."Accepted Date"))

If there isn't a date tracked in the system but a phase or state is changed, we have also had success using the date the phase or state is activated:

AVG(

CASE

WHEN "HCM - Talent Acquisition"."Recruiting History Event Type"."Event Type Name" = 'State Activated'

AND "HCM - Talent Acquisition"."Recruiting State"."State Name" = 'Selected for Offer'

THEN TIMESTAMPDIFF(

SQL_TSI_DAY,

"HCM - Talent Acquisition"."Job Application - Dates"."Job Application Submitted Date",

"HCM - Talent Acquisition"."Time"."Date"

)

ELSE NULL

END

)