Built a unified analytics dashboard

Built a unified analytics dashboard for an independent newsroom publishing across 9 channels (2 websites, 5 social platforms, newsletter, podcast). Designed a 21-table Airtable architecture with Make.com pulling and normalizing every platform's API on a schedule. Added an AI classification layer that auto-tags every article and post by format, topic, and section. Built automatic cross-platform content linking so a Facebook post is matched back to the article it promotes. Shipped as a native Airtable Interface Extension (React/TypeScript/Recharts) with a full bilingual (AR/EN) design system.