Job Application Stage Progression

This dataset provides a granular, stage-by-stage view of candidate progression through the hiring pipeline, including timing, outcomes, recruiter involvement, and decision points. It enables organizations to analyze recruitment efficiency, identify process bottlenecks, and optimize candidate experience across multiple job openings and departments.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing recruitment funnel conversion rates and stage drop-offs

Sample rows

preview · 8 of 110 rows · all 20 columns
application_idstringstage_namestringstage_duration_hoursfloatdepartmentstringcandidate_idstringcandidate_first_namestringcandidate_last_namestringcandidate_emailstringjob_idstringjob_titlestringstage_orderintegerstage_statusstringstage_start_datetimedatetimestage_end_datetimedatetimedecisionstringdecision_reasonstringrecruiter_idstringrecruiter_namestringnotesstringlast_updated_datetimedatetime
APP000101Applied0.03ProductCAND101OlgaKowalskiolga.kowalski+apply@gmail.comJOB12UX Designer1Completed2023-03-07T10:18:00Z2023-03-07T10:20:00ZMove ForwardMeets portfolio requirementsblankblankStrong digital portfolio attached.2023-03-07T10:21:00Z
APP000101Assessment48ProductCAND101OlgaKowalskiolga.kowalski+apply@gmail.comJOB12UX Designer2Completed2023-03-07T12:00:00Z2023-03-09T12:00:00ZMove ForwardCompleted design challengeREC201Liam ChenSubmitted timely, creative approach.2023-03-09T12:10:00Z
APP000101InterviewblankProductCAND101OlgaKowalskiolga.kowalski+apply@gmail.comJOB12UX Designer3In Progress2023-03-11T09:00:00ZblankPendingblankREC201Liam Chenblank2023-03-11T09:05:00Z
APP000102Applied0.18EngineeringCAND102AkiraSatoakira.sato@tokyo-mail.co.jpJOB02Software Engineer1Completed2023-06-14T08:50:00Z2023-06-14T09:01:00ZMove ForwardRelevant experience in JavablankblankWell formatted CV, relevant skills.2023-06-14T09:01:30Z
APP000102Phone Screen0.75EngineeringCAND102AkiraSatoakira.sato@tokyo-mail.co.jpJOB02Software Engineer2Completed2023-06-15T09:00:00Z2023-06-15T09:45:00ZMove ForwardGood communication, technical answersREC101Samantha NgFluent English, available for relocation.2023-06-15T09:50:00Z
APP000102Interview1.5EngineeringCAND102AkiraSatoakira.sato@tokyo-mail.co.jpJOB02Software Engineer3Failed2023-06-17T11:00:00Z2023-06-17T12:30:00ZRejectFailed technical interviewREC101Samantha NgStruggled with algorithm questions.2023-06-17T12:45:00Z
APP000103Applied0.08ProductCAND103Jean-PaulDuboisjp.dubois.fr@outlook.frJOB13Product Manager1Completed2023-04-21T13:20:00Z2023-04-21T13:25:00ZMove ForwardExperience aligns wellblankblankPM at major tech company.2023-04-21T13:26:00Z
APP000103Interview1ProductCAND103Jean-PaulDuboisjp.dubois.fr@outlook.frJOB13Product Manager2Completed2023-04-24T15:00:00Z2023-04-24T16:00:00ZMove ForwardStrong stakeholder managementREC102Renee O'NeillExcellent cross-functional experience.2023-04-24T16:05:00Z

What the 110 rows show

from the 110-row sample

Assessment (stage name) stands out: mean stage_duration_hours is 22.6, against 0.46 for the rest.

  • 0.34median stage_duration_hours
  • 4stage statuses
  • 9decisions
  • 18job titles
  • 19jobs
  • 2median stage_order
Mean stage_duration_hours by stage_name98 rows
020400.10Applied51 rows0.63Phone …13 rows22.6Assess…12 rows1.3Interv…17 rows0.82Offer5 rows
stage_duration_hours98 rows, in bands of 5
045909010030000402550stage_duration_hours →

Median 0.34, from 0.01 to 48.0.

department108 rows with a value · 2 left blank
  1. Product31
  2. Engineering27
  3. Customer Support15
  4. Data Science13
  5. Human Resources12
  6. Marketing7
  7. Finance1
  8. Operations1
  9. Business1
20 columns by typefrom the column list below
  • string 15
  • integer 1
  • float 1
  • datetime 3

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 15 columns
application_idstringUnique identifier for each job application recorduniqueAPP000101
candidate_idstringUnique identifier for the candidateCAND101
candidate_first_namestringFirst name of the candidateOlga
candidate_last_namestringLast name of the candidateKowalski
candidate_emailstringEmail address of the candidatejp.dubois.fr@outlook.fr
job_idstringUnique identifier for the job openingJOB12
job_titlestringTitle of the job openingUX Designer
departmentstringDepartment or team associated with the job opening9 departments · optionalProduct
stage_namestringName of the hiring stage (e.g., Applied, Phone Screen, Interview, Offer, Hired, Rejected)11 valuesApplied
stage_statusstringStatus of the candidate at this stage (e.g., In Progress, Completed, Failed, Skipped)In Progress · Completed · Failed · SkippedCompleted
decisionstringOutcome or decision at this stage (e.g., Move Forward, Reject, Offer Extended, Offer Accepted, Offer Declined, Withdrawn)8 values · optionalMove Forward
decision_reasonstringShort reason or note for the decision at this stageoptionalExperience aligns well
recruiter_idstringUnique identifier for the recruiter managing this application stageoptionalREC201
recruiter_namestringName of the recruiter managing this application stageoptionalLiam Chen
notesstringAdditional notes or comments about the candidate's progression at this stageoptionalRecommended for offer.
Numbers 2 columns
stage_orderintegerOrder of the stage in the hiring process (lower number = earlier stage)1 or more1
stage_duration_hoursfloatDuration in hours spent by the candidate in this stage0 or more · optional0.03
Dates and times 3 columns
stage_start_datetimedatetimeTimestamp when the candidate entered this stage2023-03-07T10:18:00Z
stage_end_datetimedatetimeTimestamp when the candidate exited this stageoptional2023-03-07T10:20:00Z
last_updated_datetimedatetimeTimestamp when this record was last updated2023-03-07T10:21:00Z

Use it for

  • median stage d…0.3498 rowsmean stage duration h…0.10Appl…0.63Phon…22.6Asse…1.3Inte…

    A human resources dashboard

    Stage_duration_hours by stage_name and a breakdown of department. Excel, Power BI or Tableau.

  • Why do the 12 Assessment rows have a mean stage_duration_hours of 22.6?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable applications with candidate_id, candidate_first_name and candidate_last_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset110 rows20 columns
Yours1,000 rows20 columns

blueprint · job-application-stage-progression

Behind this dataset

Same schema. As many rows as you need.

These 110 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Track each applicant by unique ID
  • Log timestamps for each stage
  • Indicate final outcome per applicant
  • Flag candidates inactive for 14+ days
  • Differentiate internal vs external applicants
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
job-application-stage-progression

More in Human Resources

Browse all
Also in Human ResourcesGreen Recruiting Process MetricsEmployee Attrition PredictionEnterprise Employee Attrition EventsAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.