Prepared by

Built from playback heartbeats, pause, seek, and QoE signals after Flink sessionization, deduplication, and late-event correction merges.

Table meaning

Why is completion_pct based on unique content coverage instead of total watch seconds?

Official watch-time, completion, binge, QoE, and recommendation features.

Row object shape

class FactWatchSessionRow {
  watch_session_id: string;
  user_id: number;
  profile_id: number;
  content_id: number;
  device_id_hash: string;
  session_start_ts: string;
  static fromEventStream(events: CanonicalEvent[]): FactRow { ... }
  attachDimensionKeys(lookups: DimensionLookups): void { ... }
  validateRequiredKeys(): boolean { ... }
  emitWarehouseRow(): Record<string, unknown> { ... }
}