Retention & churn dashboard

Explorate freight forwarding · official Key definitions + cadence model · as of 2026-07-15
0
Enterprise at risk
15
Mid Market at risk
32
Small Infrequent at risk
$388,806
Annualised GP at Risk
3
Aged Out this week
$48,045 GP
5
Rebooked this week
$37,314 GP

Annualised GP at risk, week by week

$504,414$617,320$735,156$472,534$514,103$737,871$388,80602-1602-2403-1703-2704-1004-2407-15

This week's movement: aged out and rebooked

CustomerStatusCohortL365 GPLast bookingDays
AMIBLU PIPE SYSTEMS PTY LTDAged Out (Churn)Small Infrequent$24,8512026-04-1294
ELLAR BOUTIQUE PREMIUM GIFTS PTY LTDRebooked (Success)Mid Market$20,7122026-07-105
Webasto Thermo & Comfort Australia Pty LtdAged Out (Churn)Small Infrequent$17,2622026-04-0997
RUFUS & COCO PTY. LTD.Aged Out (Churn)Small Infrequent$5,9332026-04-0997
Xtreme Carpentry (Vic) Pty LtdRebooked (Success)Small Infrequent$5,5492026-07-132
ALCHEMY SODAS PTY. LTD.Rebooked (Success)Small Infrequent$4,1162026-07-141
TRADING STREET PTY LTDRebooked (Success)Small Infrequent$3,9592026-07-087
Stanwell CorporationRebooked (Success)Small Infrequent$2,9782026-07-132

At-risk accounts (official definition)

Enterprise and Mid Market pinned first. This is the weekly discussion list.
CustomerCohortKAML365 shipsL365 GPLast bookingDaysCadence modelPriority

Early warnings: active accounts overdue against their own cadence

Not yet flagged by the official 28-day rule, but overdue against their own booking rhythm.
CustomerCohortKAML365 shipsL365 GPLast bookingDaysCadence modelPriority

Watchlist: dormant 90 to 365 days

CustomerCohortKAML365 shipsL365 GPLast bookingDaysCadence modelPriority
Definitions (master-file Key, verbatim logic): At Risk = booked last quarter, nothing in the past 28 days (days since last booking 29 to 90). Aged Out (Churn) = crossed 90 days without rebooking, within the last 7 days. Rebooked (Success) = booked in the last 7 days after a 28+ day silence. Cohorts: Enterprise 50+, Mid Market 10 to 49, Small Infrequent under 10 shipments in the last 365 days. Single-shipment accounts are tracked as Prospects and excluded.
Cadence model: per-customer P90 booking-gap threshold (floor 30d, cap 270d) with tiered fallback (30/90/180d). It flags accounts overdue against their own rhythm before the flat 28-day rule fires.
Priority = L365 GP × cohort weight (Ent 2.0 / Mid 1.5 / Small 1.0) × depth into the silence window.
Scope: Explorate-managed shipments only (byo=false), no drafts/cancelled/deleted, internal accounts excluded, GP = SCE totalProfit ex-GST (sentinel-guarded), bookings anchored on shipment created date, cadence on actual departure date.