Jitsu Enterprise Reporting Dashboard

FastAPI dashboard for Jitsu enterprise metrics: fill rate, show rate, early-departure rate, post-shift Pro feedback (sentiment and trends), and per-location benchmarks against the Jitsu network.

All data is scoped to Jitsu company IDs only; no other partner data is queried or exposed.

Prerequisites

• Python 3.11+
• AWS credentials with Redshift Data API access (redshift-data:ExecuteStatement, DescribeStatement, GetStatementResult)
• Access to cluster instawork-dw, database instawork

Setup

cd jitsu_dashboard
cp .env.example .env
python -m venv .venv
source .venv/bin/activate
pip install -e .

Configure .env with AWS region/profile and Jitsu company IDs if needed.

Run

cd jitsu_dashboard
source .venv/bin/activate
uvicorn app.main:app --reload --host 0.0.0.0 --port 8770

Open http://127.0.0.1:8770/.

API

• GET /api/summary?start=&end=&location= — headline KPIs
• GET /api/trends?metric=&granularity=week&start=&end=&location= — time series
• GET /api/locations?start=&end= — per-location rates and benchmark deltas
• GET /api/feedback?start=&end=&location= — sentiment, themes, verbatims

Replit

Set environment variables in Replit Secrets (AWS_REGION, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, REDSHIFT_CLUSTER, REDSHIFT_DATABASE, JITSU_COMPANY_IDS). Run with uvicorn app.main:app --host 0.0.0.0 --port 8770.