COUNT(*) counts rows (views). COUNT(DISTINCT viewer_id) counts people (viewers). "Active viewers" computed with COUNT(*) is inflated by anyone who refreshes. Bucket weeks with strftime('%Y-%W', viewed_at); aggregate to the grain you report.