Exporting Application Data

 

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.

 

Export Scope

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

Column name Description
Candidate ID Candidate's ID
Candidate name candidate's first and last name
Gender Gender
Email address Email address
Birthday Birthday
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 channel Channel
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 

Column name  Description
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

  1. To create the application data export, go to the Recruiting section and select the Applications list.
  2. 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.
  3. 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.

 

Examples

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.

 

Comments

0 comments

Article is closed for comments.