Behind the One-Line Email: A Field Account of the 'Quick' Data Request That Ate a Quarter
Photo: business analyst working late at desk with multiple monitors and spreadsheets, via img.freepik.com
The request arrived at 4:47 p.m. on a Tuesday, and it was, genuinely, one line: 'Can you pull revenue per customer by region for the board deck?' To the sender, it was a fifteen-minute errand. To the analytics team that received it, it was the beginning of an eleven-week odyssey.
This column reconstructs that journey—not to mock the executive who asked, but because the gap between 'quick question' and 'quarter-long project' is one of the most expensive misunderstandings in corporate America, and it persists largely because nobody on either side can see the whole picture.
Week One: The Definition Problem
The first week was spent not on data, but on semantics. Revenue per customer: booked or recognized? Net of returns? Did 'customer' include the dormant accounts the sales team keeps on life support? Three departments offered three confident answers, all different. The analyst scheduled a alignment meeting. The meeting spawned a follow-up meeting.
Weeks Three Through Six: The Archaeology
The regional field in the CRM turned out to be populated inconsistently—sales reps in the Southeast had been free-typing territory names since 2019. The billing system stored customer IDs in a format incompatible with the CRM's. A contractor who built the original mapping had left the company; his documentation was a Confluence page last edited during a different presidential administration.
Weeks Seven Through Ten: Validation and Rework
When the first draft arrived, finance flagged a 6% discrepancy against their own numbers. Both were 'right,' computed on different fiscal calendars. Reconciliation began. Somewhere in week nine, the executive who made the request mentioned, almost casually, that the board actually wanted it 'by channel, not region.'
Why the Timeline Stays Invisible
The executive never saw any of this, and that is the design flaw. From the corner office, a data request is a black box: it goes in, and either a number comes out or silence does. There is no ticket status, no ETA, no visibility into whether the delay is laziness, complexity, or a data quality problem that predates the request by a decade.
The fix is borrowed, unglamorously, from IT operations. When a server goes down at any competent technology organization, nobody wonders what's happening. There is a ticket, a severity level, a published SLA, and a status page. Data functions should operate the same way:
- Intake with triage. Every request gets logged, sized (S/M/L), and assigned an expected turnaround published in advance.
- Status transparency. A shared queue visible to requesters, showing where their request sits and what is blocking it.
- Escalation language. 'This request requires redefining how the company calculates X' is a legitimate, communicable blocker—not an excuse to be mumbled.
- A demand ledger. Leadership should see total request volume against capacity. Most 'slow analytics teams' are simply over-subscribed teams whose backlog no one above them can see.
Five Minutes in the Boardroom
The final slide took the executive five minutes to present. The organization spent eleven weeks and roughly three salaries' worth of hours producing it. That ratio is not an argument against asking—it is an argument for seeing. When the true cost of a 'quick' request becomes visible, executives ask better questions, data teams prioritize honestly, and the black box finally gets a window.