This article explains how you can export important application data from Personio's Recruiting section in CSV or XLSX format and then use it for your own analyses. You can also import the exported data into your internal date warehouse, for example. The export contains all of your candidates' system- and custom attributes, the positions they applied for, and all data collected during the recruiting process (e.g., when candidates proceeded to the next phase of the application funnel).
Note you need to have edit rights for the Recruiting section to start the export. You can assign this right in Settings > ORGANIZATION AND PEOPLE > Employee Roles > Access rights > Recruiting.
The application data export contains the following data:
- Candidate attributes: all system and custom attributes of candidates configured in Settings > RECRUITING > Recruiting > Attributes.
- Application attributes: data on the application process (e.g., application channel, application date, disqualification reason, etc.).
- Phase attributes: the phase a candidate is currently in (system and custom phases), and the date on which they progressed to this phase.
- Position attributes: all attributes created in the Details of the respective position.
Overview of exported candidate-, application- and phase- attributes
|Candidate ID||Candidate's ID|
|Candidate name||candidate's first and last name|
|Email address||Email address|
|Available from||Date on which the candidate would be available to start|
|Expected salary||Candidate's salary expectations|
|Candidate location||Location where the candidate is located|
|Final phase||Last custom phase in which the candidates find themselves|
|Final phase date||Date on which candidates moved into the final phase|
|Final status||Last candidate status (processing applies to all custom phases)|
|Final status date||Date on which candidates were assigned the status|
|Previous employer||Last employer of the candidate|
|LinkedIn profile||Link to the candidate's LinkedIn profile|
|Preferred start date||Candidate's preferred start date|
|Application ID||ID for the application|
|Application date||Application date stored in the Profile tab of the candidate profile|
|Application tags||Application tags|
|Application disqualification reason||Reason for disqualification (withdrawal or rejection reasons configured in Settings > RECRUITING > Recruiting > Disqualification reasons)|
|Application disqualification note||Notes inserted manually when disqualifying a candidate (rejected or withdrew)|
|Days in current phase||Days for which the candidate has been in the current phase (at the time of export)|
|New||Date when new application entered|
|Screening||Date when candidate entered screening phase|
|Phone Interview||Date when candidate entered phone interview phase|
|1. Personal Interview||Date when candidate entered first personal interview phase|
|Assessment Center||Date when candidate entered assessment center phase|
|Coding case||Date when candidate entered coding case phase|
|2. Personal Interview||Date when candidate entered second personal interview phase|
|Final Decision||Date when candidate entered final decision phase|
|Waiting||Date when candidate entered waiting phase|
|New application||Date when candidate submitted a new application|
|Unassigned||Date when candidate entered the unassigned phase|
|Rejected||Date when candidate was rejected|
|Withdrawn||Date when candidate withdrew the application|
|Offer||Date when the candidate was made an offer|
|Accepted||Date when the candidate accepted the offer|
Overview of exported position attributes
|Position ID||ID for the position|
|Position name||Name of the position|
|Initially applied for position||Position the candidate applied for initially|
|Position creation date||Date on which the position was created|
|Position last time published||Date the position was last published on the career page|
|Position category||Category assigned to the position|
|Position subcompany name||(Sub)company assigned to the position|
|Position department name||Department assigned to the position|
|Position office name||Name of the office the position is assigned to.|
|Position employment type||Employment type for the position (permanent, freelance, …)|
|Position seniority||Level of experience required for the position|
|Position years of experience||Level of experience required for the position in years|
|Position work schedule||Work schedule of the position (full-time, part-time…)|
Create and Prepare the Export
- To create the application data export, go to the Recruiting section and select the Applications list.
- Click on Export to be taken to the export configuration options.
▶︎ File name: Give the export file a name of your choosing.
▶︎ File type: Choose between CSV and XLSX file format.
▶︎ Data columns: Select the data you want to incorporate into your export. The candidate ID is required and cannot be deselected.
▶︎ Start and end date: Define the period for which you wish to export data (can be maximum 3 months). Your selection will be applied to the reception date of an application.
- Next, click on Export to save the exported file to your computer.
Tip Process the exported file with a spreadsheet application such as Microsoft Excel or Google Sheets.
You can use the application data export to create your own reports for a detailed analysis of your recruiting processes. Depending on your settings, you can extract valuable information in addition to the data contained in the Hiring Speed system report. Analyze your time to respond or time to interview, evaluate reasons for rejecting candidates, and see trends in candidates' withdrawal.
Please refer to the download section in the article's sidebar to find a sample data set and sample calculations for these types of analyses:
- Disqualification Reasons: Find out why your candidates are disqualified from the application process, depending on your configured Disqualification Reasons.
- Time to Screening: Find out how long it took new candidates to be progressed to the Screening phase.
- Channel Conversion: Find out which of your recruiting channels is most successful.
- Referral Success Rate: Find out what percentage of successful applications can be attributed to referrals.
Note These analyses are merely examples of how you can use the data export for your individual purposes, using the formulas provided as templates. However, you may need to adjust them to the columns you have selected for your data export.