Understand your hiring funnel with your Airtable data

Understand in depth your hiring funnel.

What do I get out of it?

Understand your hiring performance and get better.

How does it work?

Let's assume you're using this simple Applicant tracker template. Interviewers give a score from 0 to 4 to each interview and they're two types of interviews: phone interviews and onsite interviews.

You can build a simple pipeline report where you'll get per week:

  • Total # of interviews for each type of interview
  • For each type, the # of interviews for each score

Detailed tutorial

  1. Import the table "Applicants" into an Actiondesk sheet called "Airtable applicants". See how here.
  2. Add a calculated column called "Phone interview week" to return the week of the phone interview with the format "YYYY_WW" using the formula =YEAR(#Phone interview)&"_"&WEEKNUM(#Phone interview)
  3. Add a calculated column called "Onsite interview week" to return the week of the onsite interview with the format "YYYY_WW" using the formula =YEAR(#Onsite interview)&"_"&WEEKNUM(#Onsite interview)
  4. Create another sheet called "Pipeline report".
  5. In B3, write "Number of phone interviews", and in B4 to B8, write the 5 different scores: 0 – No hire ; 1 – Probably no hire ; 2 – Worth consideration ; 3 – Good candidate ; 4 – Please hire this person
  6. In C2, D2 and E2, write the list of the weeks you want the data for with the format "YYYY_WW". For instance: 2020_6 ; 2020_7 ; 2020_8
  7. Now in C3, write the formula =COUNTIF('Airtable applicants'!#Phone interview week, C2). Then, paste the formula to the right.
  8. In C4, write the formula =COUNTIFS('Airtable applicants'!#Phone interview week, C$2, 'Airtable applicants'!#Phone interview score, $B4). Then, paste the formula to the right and down.
  9. Just follow the same logic for Onsite interviews.

Et voilà!