Campaign Manager — Full-Stack CRM Dashboard

Overview

A full-stack CRM dashboard prototype demonstrating contacts management, audience segmentation, and campaign workflows. The dashboard features real-time KPI cards, lifecycle stage analytics, and campaign performance charts — all rendered server-side for zero client-side data waterfalls.

Built with Next.js 16 App Router, Prisma v7 with a dual adapter pattern (SQLite for local dev, Turso LibSQL for production), and ShadCN UI components. Every API route is Zod-validated with input bounds and column whitelisting.

Key Features

• Dashboard with KPI cards and Recharts analytics (server component, no waterfalls)
• Contacts data table with server-side search, filtering, sorting, and pagination
• Visual segment rule builder with AND logic and live preview (debounced 300ms)
• 3-step campaign wizard: Select Audience → Compose Message → Review & Send
• Full CRUD operations via modal dialogs
• Send simulation with realistic open/click statistics

Architecture Highlights

• Prisma v7 dual adapter — better-sqlite3 locally, libsql for Turso in production
• Shared buildWhereClause function keeps segment filtering DRY across APIs
• Route group (app) pattern for shared sidebar layout without URL pollution
• Recharts loaded via next/dynamic with ssr: false to avoid hydration mismatches
• Zod validation on all API routes with whitelisted sort columns and capped page size
• Seed data: 55 contacts, 4 segments, 5 campaigns