Jobs data export - How to generate an export for reporting purposes?

The Jobs module provides a way to generate data from the jobs that are posted in your Career Center. The export functionality enables you to analyse and to process data, according to your own reporting needs. This article describes how you can use the export functionality, available as of August 2022. 

How to generate an export?

Capture_d_e_cran_2022-08-09_a__17.17.11.png

As a first step, make sure that your filters are set in the right desired way. Your filters will be taken into account when generating an export. 
As a next step, click on the "Export (beta)" button to request an export. 

Capture_d_e_cran_2022-08-09_a__17.17.58.png

As demonstrated above, several options are available to you:

  • Start and end date: choose the creation dates of the jobs that you wish to export.
  • Include jobs from all tabs: opt-in the checkbox to export all 4 tabs (Pending, Rejected, Published, Archived) or opt-out if you prefer to export only 1 selected tab.
  • Email address: fill in the recipient to which the download link of the export must be send.
    Confirm your request.

The download link of the export will be send within 2 hours on average to the email address of the recipient. In case of high demand, please note that generating the export can take up to 48 hours.
The download link is valid for 72 hours, after receiving the data export.

The content of the export is translated as much as possible into the language of your Career Center interface. If you wish to receive it in another language, please change the language of your user interface.

What data is included?

The export contains the following:

Column Type Example Description
Job Ad Id UUID 720413172041317204131 Identification number of the job ad
Title Text Marketing & Events Intern  
Job URL URL   URL from the job ad to share 
Contract Type Enum Internship  
Contract Duration Minimum Integer 6 months  
Contract Duration Maximum Integer    
Job Category Text Marketing & Webmarketing  
Language Text EN  
Start as soon as possible Boolean  True  
Start Date Enum 2021-01-07 Field is empty if « Start as soon as possible » is true.
Years of experience Enum Student / recent graduate   
Apply URL Text   Application route: either an email address from the recruiter or an URL that redirects to a corporate website 
Company Name Text Name Name from employer on the job ad
Company Group Permalink Text    
Company Business Type Enum Start-up  
Company Legal Id Text    
Company Sector List Retail;Fashion  
Company Partnership Enum   Partnership label as allocated in the Companies module
Recruiter First Name Text Apolline Field is empty when job ad is multi-posted via the whole JobTeaser network
Recruiter Last Name Text Martin Field is empty when job ad is multi-posted via the whole JobTeaser network
Recruiter Email Text martin@example.com Field is empty when job ad is multi-posted via the whole JobTeaser network
Recruiter Email Domain Text example.com Field is empty when job ad is multi-posted via the whole JobTeaser network
Recruiter Job Role Text Brand & Market Manager Field is empty when job ad is multi-posted via the whole JobTeaser network
Recruiter Phone Text +852 5400 0000 Field is empty when job ad is multi-posted via the whole JobTeaser network
Posted by an alumni Boolean TRUE  
City List Lyon;Madrid  
Country List France;Espagne  
Creation Date Date 2021-04-30  
Published Date Date 2019-05-07  
Archiving Date Date 2019-05-08  
Views Number 1900-01-02 Number of views on the job ad
Applications Number 1 Number of clicks on the "apply" button
Rejection Message Text Could be a long text Last rejection message
Origin Enum [university name], Jobteaser network, [Parent Faculty name] Differentiate between exclusive job ads (only visible for students / alumni from your Career Center) and public job ads (shared content, multi-posted in the whole JobTeaser network, visible in all Career Centers) 
Source Enum External Robot, Manual, Recruiter Who posted the job on your Career Center: uni admin (your team), a recruiter or a company 
Assigned to Text   First name & last name
Courses List A;B;C Targeted course(s) to restrict which user population could see and apply to the job ad. Students / alumni who are not part of the targeted course(s) could not see or apply to the job ad 
Tags List Urgent; Career Fair 2022; Thesis possibility Tag(s) that you allocated to the job ad as an extra label 

 

How to use this export ?

The export can contain many lines, not all software are adapted to analyse this type of file. We recommend that you use Microsoft Power Bi, Microsoft Excel or Apache OpenOffice. The file will be send in XLSX format.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.