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 attributes and custom attributes and the positions they applied for, as well as all data collected during the recruiting process (e.g. when candidates proceeded to the next phase of the application funnel).

Please note that you will need to have editing rights for the Recruiting section to start the export. You can assign this right in Settings > Employee roles > Access rights > Recruiting.

 

Export Scope

The application data export contains the following data: 

  • Candidate attributes, i.e. all system and custom attributes of candidates 
  • Position attributes, i.e. all attributes created in the position details for the respective position 
  • Phase change data, i.e. the date on which a candidate progressed to a system or custom phase

Overview of exported candidate attributes (system 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
Final phase  Last custom phase in which the candidates find themselves
Final phase date Date on which candidates were 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
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 rejection reason Reason for rejection
Days in current phase

Days for which the candidate has been in the current phase (at the time of export)

 

Overview of exported job attributes 

Column name  Description
Position ID ID for the position
Position name Name of the position
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 location

Office/location assigned to the position

Position employment type Department assigned to the position
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 Employment type for the position 

 

Create and prepare 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. Your selection will be applied to the dates on which applications are received. The maximum period you are able to select is 12 months. 

Next, click on Export to save the exported file to your computer. We recommend that you 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, for example, extract valuable KPIs in addition to the data contained in the Hiring Speed system report, and then analyze your time to response or time to interview, for example, or evaluate reasons for rejecting candidates.

Please refer to the download section at the end of this article to find a sample data set and sample calculations for these types of analysis: 

  • 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. 

These analyses are merely examples of how you can use the data export for your individual purposes. Please note that you can use the formulas provided as templates. However, you may need to adjust them to the columns you have selected for your data export. You can, of course, perform any number of other evaluations using your export data. 

 

Can't find what you're looking for?

We are happy to help you! Just write us a message with your questions and we will get back to you as soon as possible.

Submit a request

Comments

0 comments

Article is closed for comments.