Built Online Podcast Command Center

Internal decision-support application for the Built Online Podcast. It imports local YouTube exports, validates the data, recalculates deterministic recommendations, and keeps missing operations or business-attribution data visible instead of filling gaps with guesses.

Install

pnpm install

Run Locally

pnpm dev

Open http://127.0.0.1:3000.

Direct AI Access

This repo also ships with an MCP server so AI tools can read the Command Center directly.

Local stdio transport:

pnpm mcp:stdio

Local HTTP transport:

pnpm mcp:http

Default MCP endpoint: http://127.0.0.1:4318/mcp

Test

pnpm lint
pnpm typecheck
pnpm test
pnpm e2e

Import Data

Phase 1 supports CSV and JSON imports. The app automatically reads the five normalized YouTube CSV files in References/youtube-analytics during the first refresh. Manual imports can be selected from the app through Import Data or placed in data/imports before pressing Refresh Command Center.

Supported initial sources:

• youtube_video_performance_lifetime.csv
• youtube_video_performance_365d.csv
• youtube_daily_channel_365d.csv
• youtube_traffic_sources_365d.csv
• youtube_new_returning_viewers_365d.csv
• Production tracker CSV or JSON using the template in Settings
• Packaging experiment CSV or JSON using the template in Settings

Public Repo Notes

This public repo includes the real local reference exports, the planning docs, and the source evidence that powers the current app state. Missing data remains explicit. No credentials are required for the included local-first workflows.

Replace Sample Or Source Data

The app does not ship fake analytics. Replace the YouTube exports by adding new supported files through Import Data or data/imports. Existing imports are deduplicated by file hash. Invalid rows are reported and are not silently discarded.

Back Up Data

Back up data/command-center.sqlite and any files in data/imports. Keep /References unchanged as source evidence.

Deploy

Phase 1 is local-first. For deployment, set the environment variables from .env.example, provide persistent storage for SQLite and imports, and run:

pnpm build
pnpm start

Manual Work Remaining

Operations, Release Radar ownership, business attribution, comments, Spotify, Apple Podcasts, and API refreshes remain manual or unconnected until their imports or credentials are supplied. Missing values are shown as explicit missing-data states.

Credentials

No API credentials are required for Phase 1. Future integrations should be added through environment variables and least-privilege credentials only.