All projects

Case study
KYPI
8h → 15m
reporting time
35%
ROI lift
99.9%
uptime
Overview
Campaign performance tracking dashboard replacing manual marketing data workflows.
Problem
The client managed multiple marketing campaigns with fully manual workflows: collecting data from platforms, spreadsheet reporting, no real-time performance view, slow detection of underperforming campaigns, weak historical analysis, and no way to correlate metrics across channels.
Solution
I built KYPI as a campaign performance dashboard that centralizes marketing analytics: company creation, Google Sheets import, Chart.js visualizations, real-time KPIs, scheduled reporting, and APIs so teams move from 8-hour weekly reporting to automated generation.
Architecture & delivery
- React dashboard with Chart.js and WebSocket-style live updates
- Node.js and Express APIs with scheduled collection jobs
- MongoDB for campaign metrics and historical records
- Google Sheets / ads-platform API ingestion