Applicant ID
- Requirement
- Required
- Example
- ID-10042
- Purpose
- Needed for the core workflow
Upload applicant data to visualize recruitment stages, source performance, recruiter workload, role pipelines, offer acceptance, and hiring outcomes.
Supports structured .csv and .xlsx files. Public examples use synthetic data. Review VizMint's current privacy and retention policy before uploading sensitive information.
Use the fixed preview below to switch between the source spreadsheet and a dashboard sample. Open the full demo in a new tab for every KPI and chart used in the recruitment funnel workflow.
Recruitment Funnel Dashboard
Interactive preview from the sample recruitment dataset
Switch preview
Total Records
48
rows in sample
Total Total Time to Hire Days
14,992
sum of Total Time to Hire Days
Total Applicants
5,581
sum of Applicants
Grouped by Date
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe sample tracks 4 sources across 12 months, with 5,581 applicants and 535 hires cumulatively.
Sample results: App→Screen 61.6%, Interview→Offer 41.9%, Offer→Hire 71.7%, overall 9.6% conversion (535/5,581).
See where candidates drop out and how time-to-stage varies by role, source, and recruiter.
Workforce reporting depends on consistent definitions for headcount, exits, transfers, contractors, and reporting dates. Public examples use privacy-safe synthetic records.
The sample covers 4 sources and 4 recruiters across 12 months. Overall conversion is 9.6% with an average 28-day time to hire per candidate.
The workflow is designed around consistent workforce definitions, privacy-safe proof, and auditable counts.
Recruitment reporting depends on a consistent applicant-stage model. This workflow separates current-stage reporting from stage-history analysis because time in stage and stage-to-stage velocity cannot be reconstructed reliably from a simple current-stage export.
The result brings the most important metrics, trends, and exceptions into one view, while keeping the supporting records available for review.
Use the downloadable sample to follow the source rows, field mapping, validation, and final output as one reproducible workflow.
The source preview highlights the exact columns and representative rows used by the workflow.
| Date | Quarter | Source | Recruiter | Total Time to Hire Days |
|---|---|---|---|---|
| 2025-07-01 | Q3 2025 | Maya Chen | 319 | |
| 2025-07-01 | Q3 2025 | Referral | Noah Smith | 336 |
| 2025-07-01 | Q3 2025 | Careers Page | Priya Das | 217 |
| 2025-07-01 | Q3 2025 | Job Board | Jordan Lee | 136 |
| 2025-08-01 | Q3 2025 | Maya Chen | 402.4 |
The finished output includes the KPI cards, charts, tables, and report views described below.
Grouped by Date
VizMint works best when every column has one clear heading and each row represents one consistent record. Fields that are not available should not be invented; dependent outputs should be hidden or clearly marked as unavailable.
| Column | Requirement | Example | Purpose |
|---|---|---|---|
| Applicant ID | Required | ID-10042 | Needed for the core workflow |
| Application Date | Required | 2026-06-01 | Needed for the core workflow |
| Current or Final Stage | Required | Qualified | Needed for the core workflow |
| Source | Recommended | Adds an important comparison or breakdown | |
| Recruiter | Recommended | Jordan Lee | Adds an important comparison or breakdown |
| Role | Recommended | Product Manager | Adds an important comparison or breakdown |
| Stage Date | Recommended | 2026-06-01 | Adds an important comparison or breakdown |
| Department | Optional | Sales | Adds detail when present |
| Location | Optional | North | Adds detail when present |
| Offer Date | Optional | 2026-06-01 | Adds detail when present |
| Hire Date | Optional | 2026-06-01 | Adds detail when present |
| Final Outcome | Optional | Hired | Adds detail when present |
5,581 applicants across 48 source-month records in the sample scope.
Screen: 3,437, Interview: 1,779, Offer: 746, Hired: 535.
App→Screen 61.6%, Screen→Interview 51.8%, Interview→Offer 41.9%.
746 offers extended across the sample scope.
535 hires with an overall 9.6% applicant-to-hire conversion.
4,835 rejections recorded across all source-month records.
71.7% of offers resulted in hires (535 of 746).
Breakdown by source when the source field is present: 4 sources in the sample.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Recruitment Funnel | Stage counts, applicants | Shows recruitment funnel for the selected records and reporting scope. |
| Applications Over Time | Application date, applicant counts | Shows applications over time for the selected records and reporting scope. |
| Source Performance | Source, applicant counts, hired counts | Shows source performance for the selected records and reporting scope. |
| Role Pipeline | Role, stage counts | Shows role pipeline for the selected records and reporting scope. |
| Recruiter Workload | Recruiter, applicant counts, stage counts | Shows recruiter workload for the selected records and reporting scope. |
| Stage Conversion | Stage names, stage counts | Shows stage conversion for the selected records and reporting scope. |
| Offer Acceptance | Offers, hires, withdrawn | Shows offer acceptance for the selected records and reporting scope. |
Upload the workflow-specific sample or a user file with clear headers and one record per row.
Select the correct worksheet when the workbook contains multiple sheets.
Confirm the detected header row and field mapping before generation.
Review the data preview, exclusions, and validation warnings.
Generate the dashboard, chart, report, presentation, or answer.
Review KPI values, calculations, charts, and source traceability.
Save, share, or export using capabilities available on the active plan.
| Metric | Formula or Method | Required Fields | Important Rule |
|---|---|---|---|
| Stage Conversion | Applicants reaching next stage ÷ eligible applicants in previous stage × 100 | Stage counts or stage-history records | Accurate history requires stage dates or stage-history records. |
| Offer Acceptance | Accepted offers ÷ total valid offers × 100 | Offers, hires, withdrawn, rejected offers | Define cancelled and withdrawn offers. |
| Time to Hire | Hire date − application date | Hire date and application date | Requires both dates and a completed hire outcome. |
| Problem | Recommended Fix |
|---|---|
| Duplicate applicants | Use a stable identifier, review repeated rows, and remove or reconcile duplicates before calculation. |
| Inconsistent stage names | Standardize labels so the same entity or category uses one consistent value. |
| Missing stage dates | Add the missing field when available; otherwise hide dependent metrics and explain the limitation. |
| Unnormalized source values | Document the rule, standardize the source data, and validate the corrected result before generation. |
| Private candidate data | Use consistent date formats and align records to the same reporting period. |
Available sharing and export options depend on the live VizMint plan. Publish only capabilities confirmed in production, such as saving the analysis, downloading images or PDF files, exporting PowerPoint, creating private links, refreshing a saved report, or removing branding on eligible plans.
Do not hardcode plan limits, file-size limits, privacy promises, or export features until product and billing owners confirm them.
VizMint analyzes exports; it does not replace the accounting, CRM, help-desk, HR, warehouse, advertising, or project-management system that produced them.
Upload a structured CSV or Excel file to generate the supported metrics, charts, and comparisons for this workflow.