Hello!
I am trying to create a way to track our recruitment conversion rates (for a large program where participants apply to be part of). I know it should be possible, but not sure how to configure it all.
Here are the key elements:
- We have an existing airtable base where all prospective program participants apply via a form. A required field as part of the application form is "how did you hear about our program." There is a drop down list of options they can select from.
- Once an application comes into the view, we review and have new fields that we complete, such as: application ranking (single select), checkbox to offer interview, application status (interview offered, contract signed etc).
- I want to then be able to understand from each source (eg. newsletter, job fair, referral etc.), which applicants went on the following:
- Number of applicants
- Number of interviews
- Number of offers
- Number completed placements
The goal is that this will help us better understand what source we should be investing more or less into, based on the quality of applicants we are receiving form each. So ideally id like to figure out a way to have information like, 60% of those who applied heard about our program via our website, and of those, 80% were offered an interview, 60% were offered.
All help welcome! Thank you!!