🏃‍♀️
📦
🛵
💰
⚡
🎯
🧾
☕

Runner Hub 🏃

no runners were harmed in making this tool

🔐 Password time! This keeps out nosy colleagues, curious cats, and your manager who definitely won't read this.
Wrong! Did you try turning it off and on again? 🤷
💃

Runner Hub

because spreadsheets are so last decade
⚡ Ops Tool 🔒 Internal
Loading data…

Runner Lookup

Search any runner by ID and date

Payout Issues

Resolve Cash & MinG payout discrepancies

Click to upload or drag & drop your CSV here 👆

needs: id · expert_id · issue_type · issue_date (we won't bite, promise)

MTD Churn

Month-to-date churn breakdown by geography

Unsuspension

Extract & check runner IDs from WhatsApp chat

Dump Downloader

Generate filtered data exports

  Loading masterdata…
🏦
Missing Bank / UPI
Active runners with no bank or UPI on record
✓
⚠️
Pending Suspension
Active runners absent for more than 10 days
✓
🪪
Missing PAN
Active runners with PAN status marked as missing
✓

Fleet

Region · Cluster · Hood — suspended & unsuspended counts by date range

  Waiting for runner_status_change.csv…
📌 Logic: Compares each runner's status at start vs end of each month. Active→Suspended = Churn. Suspended→Active = Revival. Flip-flopped back to same state = No Net Change. Full history used even outside date range, so cross-month context is always correct.

Day-on-Day Suspension Analysis

Track suspension & revival counts per day, with bulk CSV download

  Waiting for runner_status_change.csv…
📌 Logic: Each event row = one day. Counts suspensions (Active→Suspended) and revivals (Suspended→Active) per calendar date. Use filters + date range, then download any combination as CSV.

Fleet Pulse

Day · Week · Month fleet changes broken down by Region · Cluster · Hood

  Waiting for runner_status_change.csv…
📌 Logic: Same as Fleet — boundary transitions per period. Active→Suspended = Churn. Suspended→Active = Revival. Flip-flopped back = No Net Change. Week = Mon–Sun. Month = calendar month.

Payout Letter

Generate printable payout letters for runners

  Loading payout_data.csv…

Expert Attendance

View attendance records by runner and date range

Attendance Calendar

Monthly heatmap of runner attendance

Attendance %
≥ 80%
65–79%
50–64%
35–49%
< 35%
No data
Sun
Mon
Tue
Wed
Thu
Fri
Sat