Funnel, reports and export to Excel
The funnel in Crutor is the set of stages your team moves candidates through: New, Shortlist, Interview, Hired and Rejected. The numbers are in /stats in the bot, on a job's “Report” tab, and on the “AI costs” page in the app. All of a job's applications can be exported to Excel with /export, or from the app to Excel or CSV. There are four steps below: move candidates, check the overview, check a job's report, and export.
Application status and candidate stage
Every application carries two separate marks:
- The status is set by Crutor: “in progress” means the candidate is still answering; “sent” means they confirmed the summary of their answers; “withdrawn” means they withdrew the application.
- The stage is set by your team: 🆕 new → 💎 shortlist → 🗓 interview → 🏆 hired, or ⛔ rejected. A new application always starts at “new”. The stage changes on its own in only one case: when the candidate books an interview, the application moves to “interview” if it was at “new” or “shortlist”.
Candidates aren't told about stages: changing a stage sends them nothing. You can write to them separately, for example when you reject them (see step 1).
Test applications (the ones you go through yourself with the test link) are left out of the numbers and the export.
Steps
- Move candidates through the stages. You can do it in three places:
- In the candidate's topic in the job's group, with the buttons on the application card: 💎 Shortlist, 🗓 Interview, 🏆 Hire, ⛔ Reject. The current stage is marked with a dot; tapping it again moves the candidate back to “new”. Or use
/status shortlist | interview | hire | reject | new. When you reject, the bot asks “⛔ … is rejected. Send them a message about it?”: ✉️ Write a rejection has the AI draft a polite message with no reasons and no promises, which you check before it goes; 🤫 Don't message skips it. - On the candidate board in the app: open the job, “Candidates” tab. At the top there are stage filters with counts and a name search; click a column header to sort. Select several candidates to move them all at once; for a bulk rejection you can write one message, and each candidate gets it as written (Reject and send). On a computer you can use the keys: j/k up/down, Enter to open, x to select, s to shortlist, r to reject (the candidate isn't messaged), / to search.
- On the candidate's page in the app: stage buttons with a confirmation.
A stage button on the application card moves the candidate, and the topic shows who did it.
- In the candidate's topic in the job's group, with the buttons on the application card: 💎 Shortlist, 🗓 Interview, 🏆 Hire, ⛔ Reject. The current stage is marked with a dot; tapping it again moves the candidate back to “new”. Or use
- Check the hiring overview. Send
/statsto the bot (“Hiring overview” in the menu). The bot shows “📊 Last 30 days”: the total started, completed, hired and AI cost, and for each job the number started, completed, shortlisted, at interview, hired and the average score. It counts applications started in those 30 days. For a single job, 📊 Stats on the pinned card in the group shows the same. In the app, the overview is on the “AI costs” page, in the “Hiring overview” table: there you can pick 7, 30 or 90 days, and it has a “Rejected” column as well. - Open a job's report. In the app, the “Report” tab on a job's page shows, for all time: “Started an application”, “Completed it” (with the share as a percentage), “Withdrew”, “Average score”, plus the AI cost per application over the last year. Below is “Answers by question”: how many people answered, the minimum, average and maximum for number questions, and the most common answers for questions with options.
- Export the applications.
- In the bot: send
/export(“Export applications to Excel”) and, at “Export applications for which job?”, tap the job. The bot sends an.xlsxfile captioned “N applications. Test applications are left out.” - In the app: job → “Candidates” → the “Sorting and export” menu → Export to Excel or Export to CSV. The “Show test applications” switch in the same menu also includes test applications in the export.
/stats shows the last 30 days; /export sends all of a job's applications as an Excel file.
- In the bot: send
What's in the export file
- One row per application: every application of the job, whatever its status (in progress, sent, withdrawn), newest first. The board's filters, search and sorting don't affect the export.
- Columns: Candidate (the name), Telegram (@username), Status, Stage, Score, Applied (date applied), Completed (date completed), then one column per job question and one per document. The fixed column headers and the status and stage values are in English (for example
complete,shortlisted); the question columns are named after the questions themselves. - Number answers are stored as numbers, several options are separated by commas, and yes and no appear as ✓ and ✗. Document columns hold the file names; the files themselves and the conversation aren't included.
- Dates are YYYY-MM-DD in UTC. The file is named
<job>-applications-<date>.xlsx(or.csv). - Excel: one sheet named after the job, with the first row frozen. CSV: UTF-8, comma-separated; Cyrillic and other non-Latin text opens correctly in Excel.
Try it on your own job
Five minutes to describe it, and the link for candidates is ready.
Try it on your job