🚨 Customer Escalations

What was checked, and what was deliberately not flagged. 100 chat alerts and 7 voicemails were reviewed; 18 people are flagged. Every voicemail was read in full, and every chat whose preview was cut off or hinted at a problem was expanded from its full message body before scoring — quotes above are verbatim, typos and all.

⚠ Timestamp convention — contradicted again, and the clock settles it. The runbook for this scan states that the digits in created_on on cockpit_chats_raw_last_30_days are already Central wall-clock and must not be shifted. They are not, and following that instruction would have put a wrong time on this page. Two independent orderings prove it. Bethany Turner's reply to John Dickerson carries the digits 18:21:29; the customer's "Liked" reaction to that exact message arrived in Outlook at 18:22:12 UTC, 43 seconds later. Read as Central, the reply would be 6:21 PM — after the reaction, and in the future at a scan that ran at 4:45 PM. Her reply to Tina McClinsh carries 17:39:32, and McClinsh Liked it at 19:28:15 UTC; read as Central that reply would not have been sent yet. Every reply time on this page is therefore Central = created_on digits − 5 hours (CDT, UTC−5 today). This dashboard's own parseChatTime() already does exactly that and carries a comment saying so. The runbook sentence is the error, not the guard against it, and should be corrected. By contrast servicetitan.telecom.calls.createdon and the UTC-stamped fields on cockpit_unreturned_calls_7_day_window genuinely are UTC and genuinely do need converting — which is almost certainly where the confusion began.

The call-duration finding, re-confirmed today. A "Responded" verdict does not mean anyone spoke. Of today's callbacks, Jeff White's lasted 2.29 seconds and Kristy McDaniel's lasted 4.26 seconds — neither is a conversation, and White's card above is written on that basis. Real conversations did happen elsewhere and are credited as such: Kristen Cole spoke to Jerry Wayne Blount (1m 02s), Victor McNerney (1m 07s), Carsen Glueck (1m 57s), Chad Fryman (52s) and John Dickerson (3m 30s), and Chase Crittenden to Fryman earlier (1m 09s). The drop-off rule on the live panels above is still unsafe for phone calls and should require a minimum duration.

Two data faults to keep in mind. (1) cockpit_unreturned_calls_7_day_window.last_outbound is populated from inbound rows: Kristy McDaniel's shows a last_outbound of 20:05:04 UTC, but the call at that exact timestamp in servicetitan.telecom.calls is Inbound — she called in a third time and finally got 6m 33s with Bethany Turner. Every claim on this page was therefore written from the raw call table, not that field. (2) A new call/customer fault, the mirror of the Smith, Brian & Christina case: Jackie Myers' only outbound is filed correctly under her record but was dialled to (314) 707-2327 instead of her registered (314) 707-2417. The Smith pattern was a real call landing on the wrong record; this is the right record holding a call to the wrong phone. Both make ServiceTitan show a customer as contacted when they have not been.

Four structural failures showed up across several customers. (1) Pool covers are not arriving, and customers are the ones who find out. Tom Snyder had a closing booked today and never received his cover or pump plugs; Matthew Wiseman lost his Oct 9 closing the same way; the Myers household had a crew arrive without the equipment; Fred Pickard and Tina McClinsh are waiting on covers with no date; Jeff White has a hole in one that was fitted and Joycelyn Thielemier has one left unfinished; Jason Fitzgerald cannot tell whether he was billed for a cover alteration; Jeff Followell is waiting on a quote for a new one. Nine of today's eighteen flags trace back to pool covers. The closing schedule should be filtered against cover stock rather than discovered crew-by-crew on the day. (2) Ethan Lawson being out stalled three customers in one day — Pickard and McClinsh were both told to wait for him, and Diemert spent her morning chasing him. With Aloha closed Sat, Sun and Mon, "back Monday" means Tuesday. One named person is a single point of failure for every cover and liner question. (3) Closing customers are given no arrival window, which generated much of today's inbound traffic on its own: Wreyford, Dickerson, Blount, Banks and Fryman all rang or chatted purely to ask what time someone is coming. (4) Nobody is picking up the phone at the busy hours. Robert Edwards held 6m 40s, Jackie Myers 6m 09s and Kristy McDaniel 5m 48s before giving up and leaving voicemail. Three customers spent eighteen minutes on hold between them this afternoon and not one reached a person.

Deliberately not flagged. Routine scheduling requests (Hood, Carlisle, Mcmackins, Winkler, Fields, Wright, Nichols, Flanery, Abbott, Riley, Moreland); price and product questions (Petronio, Lamastus, Doughty, McNerney — who was also called back for 1m 07s, and the 19'x37' pool enquiry on (870) 283-2343); card-on-file housekeeping genuinely handled (Glueck, Fryman, Broderick, Sherwood, (731) 446-2573); arrival-time questions that were answered within minutes (Banks, Ward, Baker, Dickerson, Blount); and courtesy closers and one-word confirmations — "Thank you", "Ty", "Okay", "C", "Aloha", 👍 and Liked reactions, which account for roughly a quarter of today's alerts. Praise deserves naming: Melba Wood wrote "They did great! 5-star!" at 12:37 PM. And one loss worth seeing rather than flagging: (618) 315-3399 (no customer name on file) told Bethany at 10:56 AM "No, we got it taken care of though by another company thanks" — polite, final, and gone to a competitor.