Reading repair-order mix without drowning in columns

Most aftersales extracts dump every line into one grid. Advisors see volume; principals see a single revenue number. Neither view shows whether the month was won on warranty throughput, retail labour, or parts attached to routine maintenance.

Start by splitting ROs into three buckets that match how Thai dealership floors actually work: warranty and campaign, retail maintenance, and retail repair. Ignore OEM campaign codes for the first pass—fold them into warranty. What matters is whether the bay hours that week were claimed or paid by the customer.

Next, attach parts contribution to each bucket. A month that looks strong on labour can still hide a weak parts attach rate on retail maintenance. That pattern often shows up when advisors rush check-in and skip the walk-around questions that surface cabin filters, brake fluid, and wiper blades.

Keep the chart to twelve weeks, not twelve months, when you brief the floor. Advisors remember the last quarter; longer windows flatten the story into a polite slope that no one acts on. Print the mix beside last week’s CSI comments so the room can connect a dip in retail maintenance to rushed reception times.

Cortexmatrixbase uses this RO mix view in every Aftersales Performance Review. It is not a dashboard for its own sake—it is a shared picture for the service manager, parts lead, and dealer principal before anyone debates hiring or overtime.