@brichis This is a masterclass in forensic on-chain reconstruction. Your conclusion that “extra weeks bought decay, not liquidity” provides the exact mathematical proof the Token House needed to realize that blunt-force incentives are actively bleeding the treasury.
However, as @MconnectDAO correctly points out, gross TVL delta is a highly manipulable metric. Identifying “unique and retained users” and tracking strict 30/60/90-day retained TVL requires deep-level wallet indexing.
A sovereign DAO cannot rely on former council members running manual Python scripts post-mortem to audit its ecosystem growth. This requires permanent, automated, trustless infrastructure.
This is precisely why I architected the S10 Capital Efficiency Oracle. It takes the exact forensic rigor you applied manually here, and automates it—introducing Sybil-filtering, 30/60/90-day wallet stickiness mapping, and Capital Bleed circuit breakers into a live dashboard for active delegates.
I invite you to review the operational mandate and cryptographic safeguards for that architecture here:
[[RFC] Operational Mandate: S9 Impact Autopsy & S10 Capital Efficiency Oracle]
The manual audits have conclusively proven the disease. It is time to fund and deploy the automated cure.