AdInsights AI by Hamna HameedAdInsights AI by Hamna Hameed

AdInsights AI

Hamna Hameed

Hamna Hameed

.

AdInsights AI

Vertical AI SaaS platform for marketing agencies that automates monthly client reporting by transforming raw campaign data into client-ready reports, executive briefings, and strategic recommendations.

Tech Stack

Frontend
Next.js (App Router)
React
Tailwind CSS
shadcn/ui
Recharts
Backend
Python
FastAPI
Pandas
AI & Automation
OpenAI GPT-4
CrewAI
Multi-Agent Orchestration
Database & Authentication
PostgreSQL (Supabase)
Supabase Auth
Row-Level Security (RLS)
Data Ingestion
Google Sheets (CSV Export)
CSV/XLSX Parsing

Key Features

AI-Generated Client Reports

A multi-agent AI workflow converts marketing performance data into structured, client-ready reports.
Data Analyst Agent
Identifies the most significant trends and performance changes
Insights Writer Agent
Generates executive summaries and plain-language performance narratives
Strategist Agent
Creates data-backed recommendations for the next reporting period
QA Editor Agent
Verifies figures and ensures consistency with agency brand voice
Structured Output
CrewAI returns validated Pydantic JSON schemas for reliable report generation

Visual Analytics Dashboard

Automatically generates dashboards directly from verified campaign data.
KPI cards with period-over-period comparisons
Trend analysis charts
Channel and campaign performance breakdowns
Traffic, spend, and conversion visualizations
Conversion funnel analysis
Single Source of Truth
Both dashboard visualizations and AI-generated narratives are powered by the same metrics dataset, ensuring complete consistency between charts and written insights.

Verified Metrics Engine

A deterministic analytics layer designed to ensure report accuracy.
Pandas computes all metrics before AI processing
Calculates CTR, CPC, CPA, ROAS, conversion rates, and performance deltas
AI generates insights only from verified data
Automated validation confirms all figures referenced in the report exist in the source dataset

Multi-Tenant Architecture

Built for agencies managing multiple clients securely.
Isolated client workspaces using Supabase Row-Level Security
In-memory file processing with no raw upload retention
Only structured report data is stored

Technical Highlights

Anti-Hallucination Architecture: Separated metric computation from AI generation, preventing fabricated statistics in client-facing reports
Multi-Agent Workflow: Sequential CrewAI pipeline with specialized Analyst, Writer, Strategist, and QA agents
Data-Narrative Synchronization: A unified metrics layer powers both visualizations and written insights
Flexible Data Ingestion: Supports Google Sheets, CSV, and XLSX uploads with automatic column mapping
Privacy-First Design: Raw files are processed transiently and never permanently stored

Results

Reduced monthly reporting time from 1–2 days per client to a few minutes
Automated generation of dashboards, executive summaries, and strategic recommendations
Produced white-labeled, client-ready PDF reports with zero manual analysis required
Improved reporting consistency and accuracy through automated data verification
Like this project

Posted Jun 1, 2026

AdInsights AI transforms marketing data into automated client reports with dashboards, insights, and recommendations in minutes.