Intermediary onboarding cycle time

📘 definition working days elapsed from stage 1 (intake) complete to stage 4 (activation) complete on the intermediary onboarding checklist, per intermediary, reported as a monthly median and 90th percentile attribute value owner distribution operations manager source crm onboarding task timestamps reported monthly, on the distribution scorecard target median ≤ 10 working days tolerance median ≤ 15 amber; > 15 red; p90 tracked, no rag 🧮 formula cycle time = working days between(stage1 complete at, stage4 complete at) working days per the company calendar; the clock starts only when stage 1 is complete — time spent waiting for the applicant to supply missing intake documents is therefore excluded by design ℹ️ control note cycle time monitoring depends on checklist timestamps being completed contemporaneously within the onboarding workflow 🧾 inclusions and exclusions included every intermediary activated in the reporting month excluded declined applications (they never reach stage 4), reactivations of previously deactivated intermediaries clock pauses none compliance escalations and remediation count inside the cycle — slow escalation paths are precisely what the measure exists to expose 📊 why median, not mean one stuck application can move a mean by days; the median with a visible p90 shows both the typical experience and the tail without either masking the other 🧭 operational interpretation use this kpi to evaluate operational friction within onboarding and escalation handling median performance indicates the standard operating experience, while p90 exposes queue congestion, escalation delays, or incomplete intake controls 🛡️ data quality notes cycle time depends on checklist stages being completed in real time backfilled stage timestamps are detectable (stage complete before predecessor) and are reported as data quality exceptions on the scorecard rather than silently corrected