# 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

```bash
pnpm install
```

## Run Locally

```bash
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:

```bash
pnpm mcp:stdio
```

Local HTTP transport:

```bash
pnpm mcp:http
```

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

## Test

```bash
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:

```bash
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.