Source of truth

AfroStream tracking methodology

AfroStream separates live discovery from daily creator analytics. Live status can update many times per day; follower, view, score, valuation, and cadence signals are recorded as daily snapshots so profile arrows reflect real movement instead of simulated motion.

How AfroScore Works Open Rankings
2 hoursCreator sync cadence
30 minLive stream checks
DailySnapshot baseline
400+Tracked creators now

What the arrows mean

  • Up arrow: the latest snapshot is higher than the previous daily snapshot, or a clearly marked estimate is positive before two snapshots exist.
  • Down arrow: the latest snapshot is lower than the previous daily snapshot. This can happen when a platform revises public counts or a stale source is corrected.
  • Flat arrow: AfroStream is tracking the metric, but there is no previous daily value yet, no movement, or the field is currently a reviewed estimate rather than a direct platform counter.

Daily tracking pipeline

Collect

Platform and stream data

Scheduled functions read creator URLs, live stream feeds, available platform APIs, RSS feeds, and manually verified profile records.

Normalize

One creator record

Followers, views, platform counts, stream activity, and profile fields are normalized into `as_creators` and related AfroStream tables.

Snapshot

One row per creator per day

`as_creator_snapshots` stores the daily baseline used for profile arrows, period rankings, and score movement.

Source tables and functions

  • Creator profile truth: `public.as_creators` stores canonical names, slugs, platform links, total followers, total views, AfroScore, tier, and public profile metadata.
  • Daily movement truth: `public.as_creator_snapshots` stores one dated baseline per creator, including total followers, platform follower counts, total views, AfroScore, valuation value, cadence text, and 30-day stream count.
  • Stream truth: `public.as_streams` stores live and scheduled stream records, stream URLs, platforms, dates, viewer counts, and publication state.
  • Mention truth: `public.as_news`, `public.as_news_sources`, and `public.as_news_creator_mentions` support RSS-style mention tracking and public creator news references.
  • Automation: `afrostream-sync` updates creator metrics and snapshots every two hours, `afrostream-livecheck` checks live status every 30 minutes, and `afrostream-news-monitor` checks RSS mentions daily.