Context
Production-style analytics system: Next.js dashboard → FastAPI → Supabase, with automated ingestion via Apify scrapers orchestrated by n8n. Includes time-series charts, searchable tables, sentiment summaries, and AI-written weekly-style reports grounded in the user’s data.
What I built
- 1Three-pillar UX: owned performance analytics, hashtag discovery/competitive analysis, and sentiment intelligence in one navigation model.
- 2Chart endpoints optimized for visualization (time-series aggregations, top-media ranking, hashtag performance summaries).
- 3AI insights designed to cite concrete evidence (top posts, trend deltas, sentiment shifts, and example comments) instead of generic advice.
Results
- →Unified three analytics pillars (my content performance, hashtag competitive intel, and comment sentiment) into one consistent dashboard experience.
- →Automated recurring data collection with n8n + Apify, turning manual tracking into a repeatable pipeline (snapshots, dedupe, incremental updates).
- →Designed a secure multi-tenant backend using Supabase Auth + Row-Level Security so each user only accesses their own analytics and tracked assets.
Problem
Creators and small teams can see raw Instagram metrics, but struggle to answer strategy questions (what content actually drives engagement, how sentiment changes, which hashtags matter, what competitors are doing) without manually aggregating data across posts and time windows.
Approach
Built a data model for account snapshots, media metrics history, comments with sentiment, mentions, and external hashtag posts. Ingestion runs via n8n workflows (scheduling, retries, dedupe, incremental syncing) calling Apify actors/scrapers, then writes into Supabase. The FastAPI layer exposes typed endpoints for dashboards and charts, while AI endpoints generate evidence-linked insights from aggregated KPIs, sentiment trends, and top-performing content.
What I learned
Delivered a dashboard that supports account switching and date-window filtering, shows engagement/follower trends, surfaces top posts, tracks hashtag performance, and summarizes audience sentiment with drill-down into example comments/posts.
Links