Reports

Live gap analysis across all data sources — TikTok posts, users, comments, keywords, and WhatsApp links. Shows raw vs final row counts, load rates, and data quality status per source.

Technical design document for migrating from three isolated local pipelines to a single automated cloud-based workflow using GitHub Actions, Neon PostgreSQL, and GitHub Pages. Includes cost breakdown, migration roadmap, and glossary.

Static code analysis of the web report serving layer — network isolation, authentication, JavaScript audit, database isolation, and known limitations.