# Unified Projects System State — 2026-05-04 (S83-H182-A)

**Filed:** 2026-05-04 by CC. **Source:** Holdings `appPEio7ynglgyA5X` / table `tbliHBSunTSyrQUu4`. **Verdict:** System is healthier than expected — schema coverage strong, no stale rows, 5 documented blockers.

## Executive verdict

The Unified Projects system is functioning well. 115 total rows, clean status distribution, 98% schema coverage on the Active tier. Earlier preliminary audit estimates suggested major schema gaps (e.g., "9% have Expected_Revenue_30d") — those numbers were wrong. **Actual coverage on Active rows is 44/45 (98%).** The single Active row missing key fields is a known automation/internal item, not a customer-facing project.

**No urgent UP system hygiene work is required.** The 5 blocked rows are the real work surface — unblocking them is higher-leverage than any field-cleanup pass.

## Status distribution (115 rows)

| Status | Count | % |
|---|---|---|
| Active | 45 | 39% |
| Planning | 32 | 28% |
| Production | 22 | 19% |
| Archived | 13 | 11% |
| Paused | 2 | 2% |
| Idea | 1 | 1% |

## Brand distribution

| Brand | Count | % |
|---|---|---|
| CrossBrand | 29 | 25% |
| RoseCourt | 21 | 18% |
| Holdings | 20 | 17% |
| MirrorMirror | 17 | 15% |
| LongHouse | 10 | 9% |
| GroveHouse | 9 | 8% |
| WitchHavenGrove | 7 | 6% |
| SmallStage | 2 | 2% |

(AstroGarden rows are tracked under RoseCourt parent; CC:Universe under CrossBrand; Brady Hugins under Holdings.)

## Schema coverage (115 total rows, all statuses)

| Field | Populated | % | Quality |
|---|---|---|---|
| Expected_Revenue_30d | 73/115 | 63% | ✅ Active rows 44/45 (98%) |
| Confidence | 73/115 | 63% | ✅ Active rows 44/45 (98%) |
| Effort_Hours | 73/115 | 63% | ✅ Active rows 44/45 (98%) |
| Weekly Priority | 74/115 | 64% | ✅ healthy |
| ROI Signal | 33/115 | 29% | ⚠️ many rows lack qualitative signal |
| Work Mode | 32/115 | 28% | ⚠️ execution style unrecorded |
| Weekly Weight | 32/115 | 28% | ⚠️ |
| Weekly Move | 30/115 | 26% | ⚠️ |
| Analytics Signal | 24/115 | 21% | low priority |
| Linked Base | 14/115 | 12% | low priority |
| Blocked By | 5/115 | 4% | ✅ correct — only blocked rows should populate |
| Engagement Track | 2/115 | 2% | likely deprecated |

**Pattern:** Active tier (45 rows) is almost-complete on the data we'd want for ROI math. The 42 rows missing revenue/effort/confidence are mostly Archived (13) + Paused (2) + Idea (1) + Planning items deferred to later cycles. **No urgent backfill needed.**

## Top 10 ROI-scored open items (Revenue × Confidence)

| # | Project | Brand | Pri | Score |
|---|---|---|---|---|
| 1 | Fuega Dance May 15 + June 26 execution | RoseCourt | P0 | $400 × Medium = **200** |
| 2 | MirrorMirror Systems Contracts | MirrorMirror | P0 | $800 × Low = **160** |
| 3 | DS Webinar + $297 Course | MirrorMirror | P0 | $297 × Medium = **148.5** |
| 4 | GroveHouse Land Intelligence Snapshot | GroveHouse | P1 | $300 × Low = **60** |
| 5 | GH-LS-001 photo upload + email announce send | GroveHouse | P0 | $300 × Low = **60** |
| 6 | Downside Up May 28 event execution | RoseCourt | P2 | $200 × Low = **40** |
| 7 | Priority Q&A ($20) activation | MirrorMirror | P1 | $40 × Low = **8** |
| 8 | MM membership retention + win-back | MirrorMirror | P1 | $33 × Low = **6.6** |
| 9 | Venus Lead Gen Funnel | RoseCourt | P1 | $25 × Low = **5** |
| 10 | SYS Send Confirmation Email | MirrorMirror | P1 | $0 × High = **0** |

**Pattern:** Top-3 dominate the funnel — Fuega May 15 + DS Webinar + MM Contracts = $508.5 of expected 30-day revenue. All three fire in May.

## Stale rows (>14 days no touch)

**0 rows.** Every Active/Planning/Production row has Last Touch within the last 14 days. The audit hygiene cadence is healthy.

## Blocked rows (5 — these are the real work surface)

| Project | Status | Blocked By (record id) |
|---|---|---|
| Apr 10 webinar splice + R2 upload | Planning | recI0DbTYHMKm3tge |
| Extend invoice pipeline to 6 non-GH brands | Active | recI0DbTYHMKm3tge |
| Community Financing pilot (LH first real use case) | Planning | recZVISEKlPDtoDOY |
| GH Scout/Walk conversion funnel verification | Active | recUbldeyBeDDRGhK |
| MM-DS-002 replay surface decision | Production | recI0DbTYHMKm3tge |

**Note:** 3 of 5 blocked rows reference the same blocker record (`recI0DbTYHMKm3tge`). That blocker should be inspected — fixing it unblocks half the queue. The blocking record is likely a Brady-action item.

## "Job Search broadening" P0 row — confirmed real

Per Brady direction (S83-H182 AskUserQuestion): **the row "Job search broadening: n8n-adjacent ecosystem companies" stays active P0**. It represents Brady's parallel-path exploration of partner/role opportunities adjacent to the ecosystem. Not stale, not orphaned. No action this session.

## What's NOT in this audit

- Active revenue field backfill (Brady-action — only 1 Active row needs it)
- Schema migration (Engagement Track / Primary Cycle Focus deprecation — defer to next session if at all)
- Weekly cadence field cleanup (Weekly Weight / Weekly Move at 28%/26% — low ROI to backfill historical rows)

## Recommended next moves (post-audit)

1. **Inspect the recurring blocker `recI0DbTYHMKm3tge`** — fixing it unblocks 3 rows (Apr 10 webinar splice, Extend invoice pipeline, MM-DS-002 replay)
2. **Backfill the 1 Active row missing revenue/effort/confidence** — "Extend invoice pipeline to 6 non-GH brands" (P1, MirrorMirror) — Brady knows the numbers, should be quick
3. **Don't touch the 42 rows missing Expected_Revenue_30d** — they're mostly Archived/Paused/deferred and the math doesn't matter

---

_Filed S83-H182-A (2026-05-04 by CC). UP system is in good shape; preliminary audit estimates were inflated. Real work is the 5 blocked rows + the recurring blocker record `recI0DbTYHMKm3tge`. No active hygiene pass needed this session._