Calculation of the reaction time between each flow state

Procedure for calculating the reaction time

The data for this calculation can be found in the menu Selections | Reprots link

The procedure is as follows:

  • select the "timeline" tab from the report selection
  • we define the time period for which we want to get the report
  • generate an excel document and open it

💡The "timeline" workbook contains a record of events that have taken place in the system during the given period. It gives you the data needed for calculations such as: how many interviews took place, how many candidates were accepted, how many notes were created, etc.


Filtrace záložky Timeline

Working with excel document

1. In the column "ActionName"(action that was executed) filter the following:

    • "answer_add" - adding a candidate to the position (candidate has applied)
    • "answer_copy" - a copy of the answer (the recruiter copied the candidate to another position)
    • "answer_move" - moving the answer (the recruiter has moved the candidate to another position)
    • "answer_reject" - zamítnutí
    • "flow_change" - state change in flow

Once these positions have been filtered, only the data that relates to the candidate's emergence into the position, the shift between recruitment phases and rejection will be available. The calculation will not include the times of sending an email, adding a note, etc.

💡In order for the formulas to work correctly and the report to contain only this data, it is necessary to copy the result of the filtering into a new workbook so that there are no "gaps" in the data caused by not displaying the unfiltered values, which would cause the formula below to not work.




Filtrace záložky ActionName

2.  Sort the listing by "AnswerID" (candidate identifier)

    • the chronological data will be sorted, grouped by each candidate's position (if a candidate has applied for multiple positions, there will be multiple "groups" of data
    • insert a new column into the table, which will be used to calculate the duration between states, in our case we will call it e.g. "days"

💡All actions with one candidate will be chronologically ordered from the origin of the answer to the last move. This way it will be possible to count how long each action took line by line.

AnswerID, ascending order
Column for calculating the unknown - "Days"

3. Formula for calculating the value

The formula is used to calculate the value between adjacent rows (i.e. actions. For our calculation it is necessary that the actions belong to one candidate (satisfied condition), otherwise "X" will be shown (unsatisfied condition).


in the English version of MS Excel it is then: =IF(B2=B3;H3-H2;"X")

You set the formula on the second row to calculate the values for the first and second rows and then just copy to the entire range of rows in the workbook.

💡During the reporting period, there are likely to be events with candidates who have emerged in the past. It should be taken into account that the calculation may not cover all actions for all candidates (typically, for some candidates you will have, for example, only one action in the filtered period, e.g. rejection, and then it is not possible to calculate the duration of this state

💡It is therefore important to have the right range of data for the report, i.e. both the origin of the response and the shift between actions.


The figure below shows a sample result of such a calculation:


Achieving the formula for calculating the value
ATS Recruitis features Bulk tagging LinkedIn plugin Linking new responses from StartupJobs Integration with Integration with CzechCrunch Jobs Custom answer forms Talent database Facebook as a publishing channel Filtering in the overview of positions according to filter items Competency model Distribution of positions in the Recruitis system Creation of a new position Agency portal as a publication channel Google Chrome Plug-in Category of tags Reasons for rejection of candidates Measuring candidate satisfaction Record of communication with the candidate Interview planning Working with the hiring managers Questions for the interview Setting up and monitoring feedback Filtering the candidates in the database by source Hot candidates The gender variable in e-mail templates Online interviews directly from Recruitis Fast interview planning Introduction video with an overview of ATS Recruitis settings GDPR changes in the system Introductory video introducing ATS Recruitis Comparison of candidates Notification of all notes on your positions Variable stages of the recruitment process External sharing of the candidate cards Filling in the candidate's personal data directly from the CV New applicant notification even for manually entered ones Two-phase authentication Option to turn off adding a smart email to the copy of messages to candidates Automated candidate sharing and tagging Option to choose NPS sender The Google Chrome plugin now also loads candidates from StartupJobs Enforce response form language Notification of emails sent only to the system email Webhooks for the Nelisa portal End of support for Internet Explorer 11 Integration Impersonation Talent database and its possibilities Account line manager vs. account with limited rights Kanban Manage profile photos Processing the candidate list in the database (alternative to exporting candidate contacts) Copying and moving a candidate Principles of functioning of the candidate card Recruitment flow and connection with email templates Upload a response from a LinkedIn ad Clearing the image cache when sharing a position on LinkedIn Adjusted dialogs for copying and moving a candidate Scheduling a candidate interview right in your calendar Ad response source vs. candidate resource Candidate Service Prioritization (SLA) Management of communication regarding the rejection of applicants New GDPR filters in the database Reports and statistics GDPR consents Recovering a deleted user account Referral User management Multi-brand in email communication with candidates Filters in position lists NPS metric Applicant import history Practical example: candidate deletion vs. removing the answer Foreign advertisements Offers to candidates (offer management) Attachments of the applicant Confidential job position Place of work Preferred location Webhooks for system events Renaming the candidate Tagging notes Option to cancel sending NPS Expedited position publication Application for opening a position ("requests") SMTP settings for sending emails Elimination of the applicant Who has access to the candidate card Automatic response Classified ads and ad templates Sending SMS from ATS Recruitis Recruitis Option to omit a candidate from the invitation saved in your calendar Bulk actions To cancel a delayed email send Position sharing opportunities through ATS Recruitis' internal career site Connection with the fajn-brigá portal Withdrawal of consent to the processing of personal data A reminder to take action with the candidate Send emails from Recruitis using your Outlook365 account The function to remove candidates from a position directly in the talent database

Related articles

10. 11. 2022

Bulk tagging

You don't have to tag candidates one at a time, but you can add or remove tags from an entire group of candidates.

10. 11. 2022

LinkedIn plugin

Keep an overview of contacted candidates on the LinkedIn professional network and use the option to easily download them directly to ATS Recruitis without the need for rewriting.

10. 11. 2022

Linking new responses from StartupJobs

Use the automated connection with and get notified about new answers.