Nineteen leads. Nineteen quotes. Twelve hundred seventeen jobs.
Those three numbers, sitting at the top of the Command Center dashboard, tell you everything you need to know about a lawn care business in one glance. The pipeline is mature. The lead-to-quote conversion is 50% — half the people who express interest get a real quote. The quote-to-job conversion is 98% — almost everyone who sees a price says yes. The bottleneck isn't closing. It's opening.
The Pipeline widget renders this as a funnel: three color-coded columns (blue for leads, amber for quotes, green for jobs), proportional bars that show volume at each stage, conversion rate percentages in the connectors between them. Below each count, the three most recently updated records with customer names — not just numbers, but people. Click a stage and you're on that stage's list page.
Two database queries power it. One aggregate COUNT per stage, excluding deleted and imported records. One JOIN per stage fetching the three most recent records with customer names attached. The endpoint lives behind the existing dashboard middleware stack — auth, tenant scoping, read permissions on orders.
The conversion rates are the point. A count tells you how much. A rate tells you where to look. If lead-to-quote drops, your quoting process is slow or your leads are unqualified. If quote-to-job drops, your pricing is off or your follow-up is weak. The numbers move in different directions for different reasons, and a dashboard that shows them side by side lets a business owner ask the right question instead of just checking a total.