AEIOUY

At Aspen Analytics we speak about the recruiting workflow in terms of AEIOUY, where:

A stands for applicants
E stands for candidates that have been evaluated by a recruiter
I stands for candidates that have had at least one interview with a hiring manager
O stands for candidates whom have been extended an offer of employment opportunity
U stands for candidates that have been rejected or disqualified in some stage of the recruiting workflow
Y stands for the candidates that have said yes; they have formally accepted the job offer

Attrition

The rate in which employees and or contractors leave the active workforce.

Calculation:

CNT([HRIS.Employee.Exit_Date] <> EMPTY) / CNT([HRIS.Employee.Exit_Date] = EMPTY)

Job Abandonment

The percentage of requisitions that have been successfully opened but whose efforts, for one reason or another, have been permanently stopped and no hire is made

Calculation:

CNT([IF Posted.Date <> EMPTY AND DATEDIFF([Cancelled.Date] – [Posted.Date ]) > 30])

Sponsored Advertisement

A marketed message that is specifically placed and timely presented to optimize candidate attraction

Calculation:
CNT([REQ_ID.Finance.Sponsored])

Interviewee

A candidate who has been interviewed by a hiring manager

Calculation:
OPTION 1: SUM([ATS.Candidate.Interview_Binary])
OPTION 2: CNT([ATS.Candidate.Interview_Binary]=1)