An AI-powered reporting platform that consolidates Google Ads and Meta campaign data, generates professional client reports with OpenAI insights, and streamlines manager approval workflows—reducing report turnaround from days to hours.
Project Details
AI Ads Reporting Dashboard is a full-stack SaaS platform built for a digital marketing consultancy managing dozens of client ad accounts across Google Ads and Meta Ads. The platform replaces a fragmented workflow of spreadsheets, manual screenshots, and ad-hoc email updates with a centralized system that pulls live campaign data, generates AI-written performance insights, and delivers polished PDF reports to clients on schedule.
At its core, the dashboard features a template engine that lets consultants configure reporting parameters per client—selecting specific campaigns or entire accounts, choosing from 7 distinct PDF layouts (short summary, long-form, e-commerce, lead generation, and Meta-specific variants), and customizing AI prompts for each client's industry context. Reports flow through a multi-stage pipeline: data ingestion from ad platform APIs, AI analysis via OpenAI GPT-4o-mini, rich-text editing in a Lexical editor, manager review and approval, and finally automated email delivery via Nodemailer.
Project Research
The research phase began by shadowing the agency's reporting workflow end-to-end. Consultants were spending 6–8 hours per client per month manually exporting data from Google Ads and Meta Business Suite, copying metrics into slide decks, writing performance narratives, and emailing PDFs. We identified that 70% of this work was repetitive—pulling the same metrics, writing similar analysis patterns, and formatting identical layouts.
We evaluated API capabilities across Google Ads API v17 and Meta Marketing API, mapped data models for cross-platform metric normalization, and tested multiple AI approaches for generating actionable campaign insights. The architecture was designed around N8N workflow automation for scheduled report triggers and Zep memory integration so the AI could retain context across reporting periods—referencing last month's performance when writing this month's analysis.
Project Results
After an 8-week build and phased rollout, the Ads Reporting Dashboard transformed the agency's operations. Monthly report generation time dropped from 6–8 hours per client to under 45 minutes—a 90% reduction. The manager approval workflow caught quality issues before client delivery, with an average review-to-approval cycle of just 2 hours. AI-generated insights achieved a 91% acceptance rate from managers, requiring only minor edits in most cases.
The platform consolidated reporting across 40+ client accounts spanning both Google Ads and Meta campaigns into a single interface. Automated scheduling eliminated missed report deadlines entirely, and client satisfaction scores for reporting quality increased by 24 points. The agency estimated annual savings of $48K in consultant hours while simultaneously improving report consistency and delivery reliability across their entire portfolio.
