The Business Value of roi_decisions Archive — Reinforcement Decisions as Organizational Memory
Pro soccer clubs' greatest weakness: 'organizational memory disappears with each reinforcement-staff generation change.' New staff don't know the reasoning behind past decisions and repeat the same mistakes. Footnote's roi_decisions table persists who, when, what, and why for every reinforcement decision. Outcome_value_yen recorded 6 months later enables 'human judgment vs algorithm proposal' precision comparison and feeds G9 ML calibration. This article covers structure, usage patterns, and organizational learning effects.
Why Decision Archive Generates Business Value
Reinforcement staff average 3-5 year tenure. Over 10 years, 2-3 generation changes. Knowledge lost without databases.
J League club GM/SD average tenure is 3-5 years. Within a decade, 2-3 staff generations turn over. New staff inherit operations without knowing predecessors' reasoning — 'sold player X 3 years ago, was wrong, should have HOLD' learning is lost in oral tradition.
Excel limitations
Many clubs use Excel for decision tracking, but (1) file scatter, (2) non-uniform format, (3) zero search, (4) manual outcome verification — none yield organizational learning. Footnote's relational design links roi_decisions to player_profiles / roi_snapshots, enabling SQL queries like 'past 3 years of SELL decisions for CBs with outcomes' in one line.
roi_decisions Structure
7 decision fields at insertion + 3 outcome fields added later. Who, when, what, why decided — and how it turned out, all preserved.
Decision-time fields
- player_id: target
- club_id: own club (RLS-isolated)
- decided_by_user_id: decider's Footnote user ID
- decided_at: timestamp
- decision: SELL / EXTEND / LOAN_OUT / HOLD / PROMOTE_TO_YOUTH etc.
- target_window: '2026 summer', 'next season', etc.
- rationale: free text, ≤2000 chars
Outcome fields (added later)
- outcome_recorded_at: when outcome was logged
- outcome_text: e.g., 'next season contract extended, starter role'
- outcome_value_yen: actual transaction value (optional but recommended)
Outcome Recording — The Verification Cycle
Recording outcomes 3-6 months after the decision is what fuels organizational learning. The 'Pending Outcomes' banner in Squad ROI keeps the cycle going.
Squad ROI dashboard displays 'Pending Outcomes: N' banner (3+ months old + outcome empty). /club/squad-roi/pending-outcomes lists + bulk-enters. Monthly 30-minute habit sustains organizational learning.
Writing better outcomes
- 1-2 sentences on what happened: e.g., 'External offer accepted, sold for ¥60M'
- Variance from prediction: 'Predicted ¥50M → actual ¥60M, +20% above'
- Lessons learned: 'Contract-residual-1yr players: early sale economically rational'
- Enter outcome_value_yen: required for G9 ML learning sample
Three Organizational Learning Patterns
Accumulated decisions yield value in quarterly reviews, new-staff onboarding, and ML calibration.
- Quarterly precision review: aggregate past 6-12 months' outcome-confirmed decisions for absolute-error metrics, decision-type accuracy, per-decider variance
- New-staff onboarding: 3 years of roi_decisions becomes the philosophy reference for incoming reinforcement staff
- G9 ML calibration: outcome_value_yen feeds club_roi_calibration EMA update, club-specific bias becomes learned, FMV optimizes
Anti-patterns to Avoid
Records alone don't create learning. Four traps that turn archive into dead data.
- Empty rationale or 'decided': future utility = zero — write 2-3 lines minimum, specifying data viewed + judgment process
- No outcome recording: ML calibration starved, accuracy never improves — habituate monthly outcome backlog check
- Post-hoc rationalization: editing rationale after results destroys learning — keep decision-time rationale immutable, separate 'lessons' field
- Single-person record-keeping: GM-only logging vanishes on departure — multiple owner/admin records + monthly review meetings
References
- [1] Argote L., Miron-Spektor E. (2011). “Organizational learning: From experience to knowledge” Organization Science.
- [2] Kahneman D., Lovallo D., Sibony O. (2011). “Before You Make That Big Decision” Harvard Business Review.
Related Articles
Squad ROI Explained — Football Manager-style Decision Support for J Club Reinforcement
3 min read
Fair Market Value Logic — Statistical + Comparative + Club Calibration
2 min read
Improving PVS — 30 Concrete Monthly Actions Across 4 Axes
3 min read
Verbalizing Club Philosophy — A 3-Question Framework
2 min read
fit_score Explained — Club Philosophy × Player Evaluation Vector Inner Product
2 min read
Track Your Growth with Footnote
Just record your matches — AI analyzes every 5 games. Visualize growth with PVS Score. All features free during beta.
30-second signup · No credit card required
Last updated: 2026-05-18 ・ Footnote Editorial