Home About Experience Projects Case studies Resources Articles Briefs Playbook Tools FAQ How we start Security Get in touch

Case study 08

Three in four client calls produced nothing

Confidential engagement, described by its shape. Every image and file on this page is rebuilt with invented data.

All case studies · 08 of 15

An automation that turned recorded calls into tasks showed every run as complete. A count from the source showed about three in four client calls producing nothing. One rule explained the gap, hand cover closed it the same day, and filing moved from whenever someone noticed to same day.

The team recorded its calls, and an automation was meant to file each recording and turn it into tasks on the right client board. It had been live for weeks and its runs completed without errors, so it was trusted. Missed calls surfaced one at a time, each was fixed on its own, and the pattern stayed hidden. Recordings had also stopped reaching the file store, and nobody owned that.

I audited it from the outside, without reading its code.

Count from the source. I listed every recording in a fixed window from the recorder itself, not from the automation's log. A log only shows what the automation tried. The source shows what it should have done.

One row per recording, one column per stage. Recorded, filed, indexed, tasks created, and whether each task was made automatically or by hand. Every cell is yes, no or not applicable, with a link to the evidence. A call that needs no follow-up is marked "none needed", so the judgment is visible and never read as a miss.

Gap rate per type. Each call was tagged client, prospect, internal or new account. The overall rate blurred the problem. By type it was plain: about three in four client calls produced no tasks, and prospect and internal calls produced none at all.

Pipeline Audit Tracker, Tracker tab (one row per recording, client and prospect calls plus one internal)

MeetingFiledNotesTasksGap status
Weekly sync, CedarlineYesYes2 autoNo gap
Hiring syncYesn/anone neededNo gap
Kickoff, Kaolin (new)blankNo0Open
Monthly review, GarnetYesYes5 manualCovered by hand
Pricing call, Thistle RowYesNo0Open
Discovery call, Redfern SupplyYesYes0Open
Break stage =IF(D6="No","Recorded",IF(E6="","Filed",IF(F6="No","Notes attached",IF(OR(G6="",AND(ISNUMBER(G6),G6=0)),"Tasks",IF(H6="manual","Tasks","None")))))

Pipeline Audit Tracker, Summary tab (gap rate by type)

TypeMeetingsGapsRateBreakTrust
client16425%FiledNot yet
prospect10660%TasksNot yet
internal1400%NoneTrusted
new clients (subset)4375%FiledNot yet
All meetings401025%TasksNot yet
Gaps =COUNTIFS(Tracker!$C$6:$C$45,$A12,Tracker!$L$6:$L$45,"<>No gap")  Trust =IF(D12>0.1,"Not trusted yet","Trusted")

The demo file is invented and set to a milder gap of about 1 in 4 client calls. The real audit found about 3 in 4, with whole call types producing nothing.

The rule behind the gaps. One sentence explained every gap: the automation only acts where a board already exists. New clients, prospects and informal calls fell through without an error. I tested the rule against two gaps and one success, then sent its owner the rule, the evidence rows and the fixes I was asking for: who owns the follow-up, a due date, and a status on creation.

Hand cover, with an end condition. Until the fix shipped, I ran one batch at the end of every shift. Each new recording was filed in the required format, indexed and read for action items. Tasks were created only where someone was asked to do something. Before creating anything, I looked for the automation's own item by its tag, not by keyword, so nothing was made twice. The cover ends when the fix holds on a fresh window, and a dated re-audit task keeps that honest.

Pipeline Audit Tracker, Tracker tab: one row per meeting with type, recorded, filed location, notes attached, tasks and who created them
Tracker tab: one row per recording, one column per stage
Pipeline Audit Tracker Summary tab: gap rate by type and by stage, plus the open gaps still missing a stage
Summary tab: gap rate by type and stage, open gaps listed
Pipeline Gap Auditor tool: gap rate by type with a trust verdict, the open gaps with their first failed stage, and a draft rule per flagged type
The Pipeline Gap Auditor runs the same method in a browser

Click any image to see it full size. Every file here is rebuilt with invented data.

The results, in bands. The gap was found and covered the same day. A few dozen missed tasks were backfilled by hand. The first audit covered about 100 recordings at roughly 98% filed correctly, and filing moved to same day. The owner got a short spec instead of a stream of complaints.

What went wrong
  1. The automation's own view showed every run completing, and that was taken as proof it worked. I now count outputs against inputs from the source, never from the tool's log.
  2. Early misses were handled one call at a time, so nobody saw the rule. A fix request now needs a rule statement and evidence rows first.
  3. My own filing step saved transcripts in the wrong document format. I re-exported and refiled them in the required format, then changed the step.

Case study 08

Three in four client calls produced nothing

WhereA small professional-services team running a few dozen client accounts; details changed
RoleRemote operations and project management; audit, daily cover and the fix request
ScaleAbout 100 recordings in the first audit; client, prospect, internal and new-account calls
StackSpreadsheets, scripts, a shared task tracker, email