Henry Media Dashboard
Client-facing analytics platform with AI-assisted reporting on top of BigQuery.
Overview
A multi-tenant analytics dashboard platform that turns raw marketing and campaign data into client-ready reporting. Next.js 16 on the front, Drizzle ORM over PostgreSQL for application data, BigQuery for the warehouse, and a background worker for scheduled syncs. An integrated AI layer built on the Claude API and Model Context Protocol lets users interrogate their data conversationally, and dashboards export to shareable PDFs for client delivery.
Technology Stack
Key Highlights
- →Multi-source data pipeline syncing campaign data into BigQuery with a dedicated worker process
- →Conversational AI reporting built on the Claude API and Model Context Protocol
- →Interactive visualizations with Recharts and d3-geo, exportable to client-ready PDFs
- →Typed end to end with Drizzle ORM, Biome, and Vitest across the stack
Project Gallery
A walkthrough of Henry in action.
Every number live — blended spend, ROAS, and reach with week-over-week deltas.
Campaigns ranked live across channels, with scaling and fatigue signals.
Conversational reporting — ask the data a question, get an answer with the why.