Tool · v6.0 · Active

CommunityXP Hub

Full creator program operations platform for Bullet Echo. Covers every stage of the creator lifecycle: discovery, applications, onboarding, analytics, payouts, Discord scheduling, and data health monitoring — replacing scattered spreadsheets with one system.

Stack: FastAPI · React 19 · PostgreSQL · Redis Integrations: YouTube · Twitch · TikTok · Nexus.gg · Amplitude · Google Sheets · SurveyMonkey · Discord
Reduced creator ops from 1.5–2 days/month to ~2 hours

Analytics & Reporting

  • Per-creator analytics with Shorts vs long-form breakdown, monthly averages, and growth %.
  • Churn risk scoring with green/yellow/red indicators and top performers vs needs-attention lists.
  • Period comparison mode: side-by-side metric deltas across any two date ranges.
  • Nexus/Amplitude integration for creator-level performance metrics beyond YouTube.
  • AI-powered analytics insights via OpenAI (optional).
  • Save and reload analysis history. Export to CSV.

Creator Management

  • Creator profiles with avatars, editable metadata, tags, country, in-game ID, Discord ID, notes.
  • Multi-platform support: YouTube, Twitch (including live stream monitoring), TikTok.
  • Creator 360 detail page: profile, content timeline, payout history, pinned notes, event feed.
  • Tag system with categories (segment, content type, custom).
  • Expulsion management with reason tracking and reinstatement options.
  • Global search (Ctrl+K) across creators, reports, payouts, and applications.

Applications & Onboarding

  • Multi-source application imports: Google Sheets, Nexus.gg API, SurveyMonkey, CSV.
  • Status pipeline: New → Reviewing → Approved / Rejected.
  • Smart merge: match incoming applications to existing creator profiles.
  • Bulk approve/reject. Import error review log.

Payouts & Rewards

  • Monthly reward calculations by country and tier, based on view count thresholds.
  • Automatic tier assignment (Gacha codes, Star Pass).
  • Exception flagging: zero views, view spikes, missing in-game IDs.
  • Payout tracking per creator. CSV export for disbursement.

Discord Scheduled Posting

  • Full post lifecycle: Draft → In Review → Scheduled → Posted / Failed.
  • Webhook and bot-channel destinations with Fernet-encrypted secrets.
  • Embed builder: title, description, color, fields, image attachments.
  • APScheduler worker with retry/backoff and rate-limit handling.
  • Delivery attempt logging and full audit trail.

Discovery, Calendar & Events

  • Discovery: automated hashtag scanning for new creator candidates, ranked by subs and views.
  • Featuring tracker: log official collaborations with before/after growth metrics.
  • Tournaments & events: prize pools, winners, reward delivery status.
  • Calendar: monthly view with community publishing heatmap (day × hour).

Data Health & Quality

Dedicated data health dashboard tracks import freshness per source, YouTube API quota usage, field coverage (% of creators with in-game ID, Discord, country, etc.), and broken/private channel detection. Batch re-verification pushes corrections back to YouTube API. Import log shows every run with source, status, duration, and error details.

Exception tracking auto-flags data quality issues after each payday run: zero views, view spikes and drops, missing profile data. Each exception has a priority level (Critical → Low) and a resolve/ignore workflow.

Operational impact

Before this tool, creator ops ran on spreadsheets, manual YouTube lookups, and ad-hoc calculations — taking 1.5–2 days per monthly cycle. CommunityXP Hub reduced that to ~2 hours by automating data ingestion, tier calculation, reward generation, and reporting in one system.

The platform is in production at v6.0. v6 completed the migration to a full React SPA, added Discord scheduled posting with encryption and audit logging, Creator 360 detail pages, a data health dashboard, global search, and extended multi-platform support (Twitch, TikTok) alongside YouTube.