30-60-90 Day Onboarding Tracker: Which New Hires Are Behind on Their Ramp Plan Right Now

Target Keyword: onboarding template Secondary Keywords: 30-60-90 day plan template, new hire onboarding tracker, employee onboarding template, onboarding checklist Vertical: HR & People Ops Word Count: ~1,000

The 30-60-90 day plan is one of HR's most popular frameworks and one of its least enforced. A manager creates a plan for a new hire, checks in during the first week, and then the plan lives in a shared doc that nobody opens again until the 90-day review — when everyone scrambles to reconstruct what happened.

The OpenSource AI Pro 30-60-90 Day Onboarding Tracker makes the plan enforceable by making it observable. A Behind_Schedule flag evaluates each phase of every new hire's ramp plan against today's date. If a new hire should have completed their 30-day milestones by now and has not, the flag fires. An event-triggered alert emails the hiring manager the moment a phase falls behind. A scheduled digest gives HR a weekly summary of every new hire currently off track. The plan stops being a document and starts being a system.

Key Features

• Behind_Schedule Flag per Phase — Each onboarding phase (30-day, 60-day, 90-day) has a formula flag: if(and(field('Phase_Due_Date') < today(), field('Phase_Status') != 'Complete'), true, false). The flag is live. Fall behind by one day and it surfaces — no waiting for a check-in meeting.

• Completion Rollup per New Hire — A rollup field on each employee's onboarding record calculates the percentage of total milestones completed across all three phases. At a glance, see whether a new hire is at 20% or 80% of their ramp plan.

• Hiring Manager Alerts — When any phase transitions to Behind_Schedule = true, an automation sends the hiring manager a single email with the new hire's name, the phase, and what is overdue. Fires once, re-arms automatically.

• HR Weekly Digest — A scheduled automation collects all new hires with at least one behind-schedule phase and sends a consolidated summary to the HR lead. One email replaces a dozen Slack messages.

• Milestone Checklists — Each phase contains individual milestone tasks (e.g., "Complete security training," "Ship first PR," "Meet with skip-level manager"). Mark each milestone complete as the new hire progresses. The phase status rolls up from milestone completion.

• Multi-Hire Tracking — Track 5 or 50 new hires simultaneously. Filter by start date cohort, department, or hiring manager to see onboarding health at any level of granularity.

How It Works

1. Create an onboarding plan. When a new hire starts, create an onboarding record linked to their employee profile. The template auto-generates three phase records (30-day, 60-day, 90-day) with due dates calculated from the start date.

2. Add milestones to each phase. Populate each phase with specific milestones — the tasks and deliverables the new hire should complete during that window. Use the included milestone templates or customize for your organization.

3. Formulas track progress live. As milestones are marked complete, the phase completion percentage updates. If the phase due date passes without all milestones complete, the Behind_Schedule flag flips. This requires zero manual effort — the formulas evaluate on every view load.

4. Alerts catch problems early. The event-triggered automation fires the moment a phase goes behind schedule, reaching the hiring manager while there is still time to intervene. The weekly digest gives HR a portfolio view of all new hire progress.

Who It's For

• HR Managers and People Ops teams onboarding more than a handful of new hires per quarter and needing a system that scales beyond manual check-ins.
• Hiring Managers who want to stay on top of their new hire's ramp without adding another recurring calendar event.
• Companies with structured onboarding programs (engineering bootcamps, sales ramp plans, compliance-heavy industries) where phase completion matters.
• Remote and hybrid organizations where the informal "walk by their desk" check is not available.

vs the Alternatives

| Feature | OpenSource AI Pro | Google Sheets / Notion | BambooHR / Sapling | |---|---|---|---| | Behind-schedule detection | Formula flag, live per phase | Manual status review | Built-in, per-seat pricing | | Manager email alerts | Event-triggered, auto re-arm | Not available | Included | | Pricing | Free, self-hosted, unlimited users | Free but no automation | $6-12/employee/month | | Milestone-level tracking | Granular per phase | Manual checklists | Varies by vendor |

A Google Sheets 30-60-90 template gives you a checklist. This template gives you a checklist that watches itself and tells you when something is wrong.

What's Included

• Tables: New Hires, Onboarding Plans, Phases, Milestones, Hiring Managers
• Key Fields: Behind_Schedule (formula flag per phase), Phase_Completion_% (rollup), Overall_Completion_% (rollup), Days_in_Phase (formula), Phase_Due_Date (formula from start date)
• Automations: (1) Event-triggered hiring manager alert on behind-schedule phase, (2) Scheduled weekly HR digest of all behind-schedule new hires
• Views: All New Hires, Behind Schedule, By Start Date Cohort, By Department, By Hiring Manager

Get Started Free

Download the 30-60-90 Day Onboarding Tracker and deploy it on your own Baserow instance. No seat fees. No row limits. Self-hosted and open source.

Download Free Template | View Live Demo | Self-Hosting Guide

Related Templates

• Performance Review Cycle Tracker — The natural next step after onboarding: tracking the first performance review cycle.
• Org Chart Builder — New hires appear in the org chart the moment they are linked to a manager.
• Employee & Work Schedule Tracker — Schedule new hires into shifts as they complete onboarding phases.