Stage Changes source fields and definitions

Follow

List of all the funnel stages a consideration entered and exited.

Field Type Field Name Data Type Definition
Dimension applicationId Text Unique id of the application the record belongs to
Dimension archivedDate Datetime Date when a consideration's pipeline stage was changed to Archive
Dimension candidateName Text Name of the consideration applying for the posting
Dimension candidateSignedDate   Date candidated signed an offer
Dimension considerationArchiveReason Text Reason why this consideration was archived
Dimension considerationCreatedDate Datetime Date when this consideration was created
Dimension Conversion Date Datetime If there is no stageEndedDate, use the Stage Started Date. (Helper dimension for more complex calculations)
Dimension currentFunnelStage Text Pipeline segment of the stage which this consideration is currently set to
Dimension currentStageName Text Name of the current stage of the consideration
Dimension currentFunnelStageExclArchived Text Higher-level funnel stage name of the stage which this consideration is currently set to. If the consideration has been archived, will be set to Archived (compared to currentFunnelStage, which will be set to the last stage before Archived if the candidate was Archived).
Dimension firstSource Text First of the sources entered for consideration source
Dimension funnelStage Text A higher-level funnel stage name the candidate was in, at some point during this timespan
Dimension stageName   Name of a stage which this consideration was in, at some point during this timespan
Dimension Hires & Pipeline Date Set Boolean If Hires & Pipeline Dates is between Start and End date selected on the dashboard, then True. Else, False. (Helper dimension for more complex calculations)
Dimension Hires & Pipeline Dates Datetime If candidate was hired, use the candidateSignedDate (manualOfferUploadDate, if the candidate has not signed yet). If candidate was not hired, use stageEndedDate (Stage Started Date, if the candidate has not exited the stage yet. Helper dimension for more complex calculations)
Dimension Historical Candidates in Stage Text Unique profile ids of candidates that were in a funnel stage at a previous point in time. Works in conjunction with Start and End date filters on dashboards.
Dimension isHired Boolean True if the candidate was hired for this consideration, else False
Dimension manualOfferUploadDate   Date when a manual offer was uploaded to the consideration, null if an offer was sent through a partner intergration
Dimension postingDepartment Text Department of the posting associated with this consideration
Dimension postingHiringManager Text Hiring manager of the posting associated with this consideration
Dimension postingId Text Unique id of the posting associated with this consideration
Dimension postingLastClosed Date   Date the posting was most recently closed, if a posting has been closed at least once
Dimension postingLocation Text Location of the posting associated with this consideration
Dimension postingOwnerName Text Owner of the posting associated with this consideration
Dimension postingStatus Text Status of the posting associated with this consideration
Dimension postingTeam Text Team of the posting associated with this consideration
Dimension postingTitle Text Job title of the posting associated with this considertaion
Dimension prevFunnelStage Text The name of the higher-level funnel stage the candidate was in before this stage
Dimension profileCreatedDate Datetime Date when this profile was created
Dimension profileId Text Unique id of the profile for the candidate this record belongs to
Dimension profileLinks Text Comma-separated list of links associated with this candidate
Dimension profileOwnerName Text Name of the owner of this candidate's profile
Dimension reqId Text Unique id of the requisition associated with the posting that this consideration applied to
Dimension Requisition Code Text Requisition code for the job posting that this consideration applied to
Dimension Requisition Department Text Department of the requisition associated with the posting that this consideration applied to
Dimension Requisition Hiring Manager Text Hiring manager of the requisition associated with the posting that this consideration applied to
Dimension Requisition Location Text Location of the requisition associated with the posting that this consideration applied to
Dimension Requisition Name Text Name of the requisition associated with the posting that this consideration applied to
Dimension Requisition Owner Name Text Owner of the requisition associated with the posting that this consideration applied to
Dimension Requisition Team Text Team of the requisition associated with the posting that this consideration applied to
Dimension State Started Date Datetime The date the consideration entered stageName (note: stageName may not be the same stage as currentStageName, because this table captures every stage a candidate was in during the recruitment process)
Dimension stageEndedDate Datetime The date the consideration left stageName (note: stageName may not be the same stage as currentStageName, because this table captures every stage a candidate was in during the recruitment process)
Dimension stageIndex Numeric Order of all the stages the candidate passed through during the recruitment process
Dimension stageIsCurrent Boolean If the candidate is still in this stageName, then True. Else, False.
Dimension wasOnsite Boolean True if the consideration reached the Onsite pipeline segment or further
Dimension wasScreen Boolean True if the consideration reached the Screen pipeline segment or further
Measure active candidates in progress Numeric Count of unique candidates in Onsite, Screen, or Offer stage relative to the selected time period (i.e relative to the start and end date selected on dashboard)
Measure active candidates/ managers Numeric Average number of candidates in an "active" stage (screen, onsite or offer) per hiring manager during the time period selected.
Measure active candidates/owner Numeric Average number of candidates in an "active" stage (screen, onsite or offer) per profile owner during the time period selected.
Measure daysInStage Numeric Amount of time consideration was in this stage, defined as "stage ended date" - "stage started date". Only applies to considerations who left a stage.
Measure Is hired/Total Numeric Count of profileIds where candidate was hired, divided by total count of profileIds
Measure Screen to Onsite Numeric Count of candidates who were in Screen and made it to Onsite during the selected time period, divided by all candidates who made it to Screen during the selected time period.
Measure stageSortRank Numeric Ranking of stageName by their order in Lever. Used to sort pipeline / funnel charts in order of occurence, instead of alphabetically.
Measure Swap Measure Numeric Helper measure to toggle between candidates and days in stage on Pipeline dashboards. DO NOT USE.
Measure TotalAppIdCount Numeric Count of unique profileIds
Measure Total Leads Numeric Unique count of opportunities who were / or currently are in the lead pipeline during the time period selected
Measure Total Onsites Numeric Unique count of opportunities who were / or currently are in an "onsite" stage during the time period selected
Measure Total Screens Numeric Unique count of opportunities who were / or currently are in a "screening" stage during the time period selected
Was this article helpful?
0 out of 0 found this helpful