CSV import

Concerned products

🔳 Attract 🔳 Engage 🔳 Convert ✅ Predict

Introduction

Adway's system relies on importing historical ATS data sets in CSV format to measure the advertising impact and predict future impact.

The data in each set are limited and contain no personal data, the data sets needed are;

• Jobs

• Applicants

• Hires

Preferrably we want the data sets to contain all historical records.

Data exchange

The CSV data sets should be made available to Adway through a SSL protected URL (HTTPS) per data set.

Security

Adway recommends to protect the CSV data sets with authenticiation , and support the following authenticiation methods;

• Anonymous

• Basic authentication

• Bearer token (JWT)

Data specification

Attached are examples of how to structure each of the 3 data-files, with some clarifications;

• Dates should be in the format YYYY-MM-DD and UTC timezone.

jobs.csv

Should contain all job posts.

• Fields "title", "role", "language", "channels" are optional for jobs, but give deeper insights.

  • Employer is the name of the hiring company

  • Channels is a comma-separated string with external publishing channels activated from the ATS (e.g. "indeed, glassdoor")

applicants.csv

Should contain all applicants.

• One row for each application, e.g. if a job recieved 3 applications, there should be 3 rows with the same atsJobId.

• Fields "rating", "gender", "source" are optional for applications & hires, but give deeper insights.

  • Rating is a numer (int)

  • Gender is a string (valid values: "m" or "f")

  • Source is a string, and represents the referring site the candidate applied from (e.g. "indeed")

hires.csv

Should contain all hires.

• One row for each hire, e.g. if a job had 3 hires, there should be 3 rows with the same atsJobId.

• Fields "rating", "gender", "source" are optional for applications & hires, but give deeper insights.

  • Rating is a numer (int)

  • Gender is a string (valid values: "m" or "f")

  • Source is a string, and represents the referring site the candidate applied from (e.g. "indeed")

Example CSV data sets

jobs.csv

atsJobId,employer,title,category,role,country,city,language,channels,createdDate

applicants.csv

atsJobId,rating,gender,source,appliedDate

hires.csv

atsJobId,rating,gender,source,hiredDate