Airtable: understand your hiring funnel

Understand in depth your hiring funnel.

The process

Try It for Yourself

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à!

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à!

Read more
Create My First Report
see all Airtable use cases
The Advantages

Key Benefits

Eliminate the need for expensive third-party connectors and laborious copy-pasting.

Seamlessly import, organize, filter, and manipulate your Airtable data. Analyze it alongside data from other sources, and build custom Airtable dashboards and reports.

View and organize your Airtable data within a familiar spreadsheet interface.

Seamlessly import, organize, filter, and manipulate your Airtable data. Analyze it alongside data from other sources, and build custom Airtable dashboards and reports.

Feel confident in knowing that your data is always accurate and up-to-date.

Thanks to real-time cloud-based updates, any changes to your data made from within Airtable are automatically reflected in your Actiondesk spreadsheet.

Save time to analyze your data and make better decisions for your business
Create My First Report
Learn More

Our Use Cases

Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.