Setup Guide
This is the target design for your Airtable base. Build each table below with the exact field schema shown. Once built, connect Make to the base using the Airtable API key and Base ID. The automation pipeline on the previous page will populate Signal Log automatically. Opportunity Tracker receives linked records when KDE average > 2.5.
Base OverviewTarget state — 4 tables
Table 1 — Signal LogAuto-populated by Make · Primary intake
Kallor Group
Signal Log
Signal Log
Opportunity Tracker
Pilots
Capital
| Signal |
Category |
KDE Avg |
Decision |
Status |
Date |
Tags |
| Cable estimation in construction done manually — no standardised system, consistent waste and error on every job |
Field Obs |
4.3 |
Test |
In Testing |
2026-01-14 |
cable · construction · estimation |
| Artist management decisions made emotionally — no structured evaluation framework at any level |
Industry |
3.7 |
Test |
Building |
2026-01-22 |
artist · management · judgment |
| Solar installation estimator shortage — quoting done off experience, no repeatability |
Industry |
3.1 |
Park |
Parked |
2025-11-08 |
solar · estimation · labour |
| AI content tools for SME social media — demand signal observed |
Research |
1.8 |
Kill |
Killed |
2025-09-03 |
ai · content · sme |
| + New record added automatically via Make... |
| | | | | |
Table 2 — Opportunity TrackerLinked from Signal Log · Full KDE detail
Kallor Group
Opportunity Tracker
Signal Log
Opportunity Tracker
Pilots
Capital
Cable estimation universally manual in construction and telecoms. No standardised system. Persistent waste and error on every job.
5Demand
4Timing
5Operator
4Capital
4Upside
4Kill
Field Obs
In Testing
Artist management space makes all significant decisions emotionally. No structured evaluation framework exists at any level.
4Demand
3Timing
3Operator
4Capital
4Upside
3Kill
Industry
Docs Unsigned
Proprietary algorithm with commercial application. Patent filing in progress. Commercial pathway TBD.
—Demand
—Timing
—Operator
—Capital
—Upside
—Kill
Partner
KDE Deferred
Field Schema — Signal LogBuild these fields exactly
Signal
Long Text
Primary field. Clean 1-3 sentence description of the structural observation. Auto-populated by OpenAI.
Summary
Single Line
One sentence. The friction or opportunity in plain language. Auto-populated.
Category
Single Select
Market / Labour / Tech / Partner / Research / Field Obs. Auto-populated.
Tags
Multi Select
2-4 domain/industry tags. Lowercase. Auto-populated.
KDE Average
Number
Mean of all 6 lens scores, 1 decimal. Auto-populated. Used for routing logic.
Initial Decision
Single Select
Kill / Park / Test / Allocate. Auto-populated by scoring logic.
Status
Single Select
Logged / In Testing / Building / Parked / Killed. Set by Make router, updated manually as it progresses.
Date Logged
Date
Auto-set to now() by Make on record creation.
Source
Single Select
Apple Notes / Manual / Cull Lab / Judgment Lab / YouTube. Auto-set to "Apple Notes" by pipeline.
Raw Note
Long Text
Original unedited note text. Stored for reference. Not displayed in main views.
Kill Condition
Long Text
What would make this a definitive kill. Auto-populated by OpenAI.
Linked Opportunity
Link to Table
Link to Opportunity Tracker record if routed above threshold.
Field Schema — Opportunity TrackerAdd these on top of Signal Log link
Opportunity Name
Single Line
Primary field. Short name for the opportunity. Set manually after auto-creation.
Signal (Link)
Link to Table
Linked back to Signal Log record. Auto-set by Make router.
L1 Structural Demand
Number (1–5)
Auto-populated from OpenAI output.
L2 Market Timing
Number (1–5)
Auto-populated from OpenAI output.
L3 Operator Capability
Number (1–5)
Auto-populated from OpenAI output.
L4 Capital Efficiency
Number (1–5)
Auto-populated from OpenAI output.
L5 Asymmetric Upside
Number (1–5)
Auto-populated from OpenAI output.
L6 Kill Trigger
Number (1–5)
Auto-populated. If ≤2: immediately move to Killed regardless of other scores.
KDE Average
Formula
= AVERAGE(L1, L2, L3, L4, L5, L6). Auto-calculated.
KDE Decision
Single Select
Kill / Park / Test / Allocate. Auto-set. Updated manually if KDE is re-run.
Stage
Single Select
New → Review Required / Under Evaluation / In Execution / Capital Review / Killed / Parked
Execution Environment
Single Select
Cull Lab / Judgment Lab / Operator Lab. Set manually when entering execution.
Linked Pilot
Link to Table
Link to Pilots table record when it enters Operator Lab.
Kill Reason
Long Text
Documented kill reason if closed. Required before marking status as Killed.
Score Notes
Long Text
One-line reasoning per lens. Auto-populated by OpenAI. Reviewable and editable.
Tables 3 & 4 — Pilots + CapitalBuild after Signal Log and Tracker are live
Pilots Table
—
Name · Linked Opportunity · Stage (Web Tool / Workflow / Platform / Expansion) · Structure (Internal / Studio Build / Operator Intake / Funded Build) · KDE Decision · Priority Action · Blocker · Notes. One row per active pilot.
Capital Table
—
Opportunity name · Capital type (Minority Equity / Partnership / JV / Internal) · Amount deployed · Equity % · Date · Linked Opportunity · Status (Deployed / Committed / Returned / Active). One row per capital event.