Advertising Analytics Dashboard
A unified web platform designed to resolve the fragmentation of digital advertising analytics across major platforms such as Google, Meta, and Microsoft.
Project Overview
The Advertising Analytics Dashboard is a unified web platform designed to resolve the fragmentation of digital advertising analytics across major platforms such as Google, Meta, and Microsoft. Developed as an Honors Thesis project for Vloe, a Quebec-based advertising agency, the dashboard enables businesses and agencies to retrieve, analyze, and report on advertising and tracking data from multiple accounts and platforms in a single, user-friendly interface.
Key features include detection of embedded tracking tags, OAuth-based account connections, query saving, PDF report generation, and dynamic localization in English and Canadian French. Usability testing with 14 participants demonstrated the dashboard's intuitiveness, accuracy, and value for marketing professionals.
Key Features
- Tracking Data Service: Detect embedded analytics and advertising tags from any URL.
- Centralized advertising data: Aggregate campaign metrics from Google Analytics, Google Ads, Meta Ads, and Microsoft Ads.
- Secure OAuth login: Support Google, Meta, and Microsoft OAuth for seamless account connections.
- Query management: Allow users to save, view, and rerun analysis queries.
- PDF report generation: Enable export of results as localized, formatted PDF reports.
- Bilingual localization: Support English and Canadian French.
System Architecture
The Advertising Analytics Dashboard utilizes a modern tech stack with Next.js 15 for the frontend and backend, integrating with OAuth providers for secure authentication and API access. The platform connects to multiple advertising service APIs including Google Analytics, Google Ads, Meta Ads, and Microsoft Ads.
The application employs PostgreSQL via Neon for database storage, Prisma ORM for database management, and next-intl for localization in English and Canadian French. The system is deployed on Vercel with Cloudflare for CDN and security services.
Architecture Highlights
- Frontend & Backend: Next.js 15 App Router for server components and API routes
- Authentication: Auth.js with OAuth providers for Google, Meta, and Microsoft
- Database: PostgreSQL hosted on Neon with Prisma ORM
- API Integration: Connection to multiple advertising APIs for analytics data
- Localization: Bilingual support with next-intl for English and Canadian French
Service Screenshots
