AAryabhangy Tracksheet
Loaded Logged in:

Job Cards

Aluva • All time • Click any cell to edit
JC Date Reg Customer Phone Model Service RPT Booking Adviser Tech Final Insp Status VAS Bill # Labour (₹) Spares (₹) Pay Total (₹) Remarks
Loading job cards…

Dashboard

Independent filters — these don't change the Job Cards view • Trend always shows the last 14 days
Total JCs
in current view
Delivered
VAS canvassed
Unique customers
by phone

JCs per day — last 14 days

Advisers — JCs · VAS attach %

Service mix

PSF — customer satisfaction

CSI — 7-day avg
out of 5
Calls — 7 days
Open issues
Issue Raised, last 7 days

VAS performance

VAS today
VAS MTD
Avg per JC
items ÷ JCs, MTD

Bookings

CRE call bookings • Click Status or Remarks to edit
Booked forCustomerPhoneRegModel ServiceBranchCREStatusJCRemarks
Bookings load after migration — run baserow_migration_v2.py

PSF — Post-Service Follow-up

Next-day follow-up call (branch CRE) • the 3-day PSF-cell call is logged in HiRise
JCDeliveredCustomerPhoneModel BranchAdviserNext-day call3-day callActions
PSF activates after migration — run baserow_migration_v2.py

Booking Performance

Across all branches •
Bookings taken
Reported
Pending
Cancelled
Conversion
reported ÷ taken

By branch

CRE leaderboard

PSF Insights

Post-service follow-up •
Next-day coverage
CRE ÷ delivered
3-day coverage
cell ÷ delivered
Avg CSI
both calls, /5
Issues raised
either call

By branch

Live issues

Live Issues

Complaints raised during PSF • close the loop once the in-charge has spoken to the customer
JCDeliveredCustomerPhoneBranch AdviserCSIFeedbackIssue status
Live issues activate after PSF is set up — run baserow_migration_v2.py

Complaints Analysis

PSF complaints + repeat complaints •
Complaints
PSF issues raised
Repeat complaints
same vehicle ≤2 wks
Complaint rate
complaints ÷ delivered
Top category

By branch — most complaints

By complaint category

By technician — complaints & repeats

By adviser — complaints

Edit Requests

Requests from branch/adviser to correct closed JCs •
JCFieldCurrent → ProposedReasonRequested byStatusAction
No edit requests yet.