Share:

CMN stage audit

Every CMN lead Sun 6 Sep – Sat 19 Sep, checked against every 6AB, 5AB, N1N and R row that person still has anywhere back to Tue 10 Mar. Reaching a stage is meant to consume the one before it, so every row found here is one that should have disappeared and did not. Newest lead in the feed: 2026-09-18 18:50:39. 1 of 81 leftovers sat in a different city from their CMN.

Original code→ chase → R→ re-SMS, sends a picture → N1N→ free for a chat? → CMN  — each step is meant to CONSUME the one before it
CMN in the window
222
people · 222 rows
Shifted cleanly
163
73.4% — nothing left behind
Still carrying an old stage
59
26.6% · 81 rows that should have gone
The shift itself failed
1
old stage within 14 days of the CMN
Two different faults — do not add them together. 1 people (1 rows) carry a stage row from within 14 days of their CMN: that is the shift failing to consume the previous stage. 59 people (80 rows) carry one older than that — an earlier journey that died and was never cleaned up. Different causes, different fixes.

What is left behind

A person can be counted under more than one stage, so these do not sum to the total.

Stage still livePeopleOf all CMN Rows within 14dRows older
6AB33 14.9%222142
5AB10 4.5%222013
N1N14 6.3%222015
R10 4.5%222010

How long before the CMN was that row created?

A same-day leftover is unambiguous: the lead converted and the previous stage was simply never cleared.

Gap6AB5ABN1NR Rows
8–14 days10001 1.2%
15–30 days50207 8.6%
31+ days3713131073 90.1%

Which combination is left

Stages still live for that personPeople
6AB26 44.1%
5AB10 16.9%
N1N9 15.3%
R7 11.9%
6AB + N1N4 6.8%
6AB + R2 3.4%
6AB + N1N + R1 1.7%
Download the cleanup list — every leftover row (CSV)
R is the biggest single fault, and it is not subtle. Of the 0 leftover rows dated the SAME DAY as the CMN, 0 are R codes. The lead converts and its R row is simply never cleared — same person, same day, both rows still live.
R rows still live
0
within 14 days of the CMN
Of those, same day
0
— — no ambiguity at all
Distinct R codes affected
0
it is not one broken feed

The R codes not being cleared

Every one of these is {CITY}{SOURCE}R — the chase stage of a lead that has since converted.

R codeCityRows still live
Original code→ chase → R→ re-SMS, sends a picture → N1N→ free for a chat? → CMN  — each step is meant to CONSUME the one before it
Push gap: Sun 6 Sep, Sat 12 Sep, Sun 13 Sep carried almost no recycled leads at all against a median day of 372, while total lead flow held up. That is the recycled push stopping, not a quiet day.

Leads in, by stage, per day

Recycled counts every stage row plus CMN once each. The last day in range is always part-built.

DateAll leadsRecycled 6AB5ABN1NR CMN
Sun 6 Sep1,06217 1.6%62242
Mon 7 Sep1,254131 10.4%9455646
Tue 8 Sep1,413250 17.7%2155101549
Wed 9 Sep1,280290 22.7%2555718518
Thu 10 Sep1,712649 37.9%91461548214
Fri 11 Sep1,496372 24.9%83133208
Sat 12 Sep1,18435 3.0%743200
Sun 13 Sep1,17023 2.0%610151
Mon 14 Sep2,031944 46.5%4021821624365
Tue 15 Sep1,635405 24.8%18741767031
Wed 16 Sep1,483401 27.0%20250634937
Thu 17 Sep1,478446 30.2%22056728018
Fri 18 Sep1,477384 26.0%16657687913
Sat 19 Sep1560 0.0%00000
TOTAL18,8314,347 23.1%1,3504615401,765222

By city

CityCMN peopleStill carrying an old stage Shift failed (≤14d)
New York5817 29.3%0 0.0%
Houston3510 28.6%0 0.0%
Chicago326 18.8%1 3.1%
Florida308 26.7%0 0.0%
Boston195 26.3%0 0.0%
Nashville185 27.8%0 0.0%
Dallas175 29.4%0 0.0%
Orlando133 23.1%0 0.0%
Yes — and that is what makes the leftovers a fault rather than the design. A CRM pull shows a code as it stands now, so an in-place shift is invisible unless the same row was observed earlier. Across 3,516 rows with an earlier observation on file, 36 were caught mid-shift: the row's own code was rewritten to CMN and the old stage genuinely disappeared, exactly as intended. 0 ever moved the other way.
Rows observed twice
3,516
the only rows that CAN show a shift
Shifted in place to CMN
36
the mechanism working correctly
Unchanged
3,480
99.0%
Shifted OUT of CMN
0
CMN is an end state

Every shift caught in the act

WasBecameRows
NY6ABNYCMN13
CHI6ABCHICMN4
HOU6ABHOUCMN3
FL5ABFLCMN3
FL6ABFLCMN3
BOS6ABBOSCMN2
CHI5ABCHICMN2
HOU5ABHOUCMN2
NA6ABNACMN1
DAL6ABDALCMN1
ORL6ABORLCMN1
ORL5ABORLCMN1

What this count can and cannot see

A shift that happened before the row was ever observed is invisible and always will be — the ledger only started recording on 25 Aug 2026, seeded from /recycled-codes' chunk cache. So the shift count is a floor. It grows on its own as the ledger accumulates, which is why this report runs daily: a night not run is evidence that cannot be recovered later.