I built this AI marketing dashboard to explore how campaign data can move from collection to analysis through an automated workflow. The project connects live campaign submissions with performance reporting, automatically calculating key marketing metrics such as spend, impressions, clicks, conversions, CTR, CPC, conversion rate, and CPA. The goal is to create an interactive dashboard that not only visualizes campaign performance, but also uses AI to identify trends, surface meaningful insights, and turn marketing data into actionable recommendations.
Interactive Marketing Performance Dashboard
Marketing Performance Dashboard
Campaign performance data collected through a live form, modeled automatically and displayed in near real time.
Performance by Channel
Conversions by Channel
Relative contribution to total conversions
Cost per Acquisition
Lower CPA indicates greater cost efficiency
Channel Performance
Detailed performance across marketing channels
| Channel | Spend | Impressions | Clicks | Conversions | CTR | CPC | Conv. Rate | CPA |
|---|
AI Performance Insights
This section will analyze the live campaign dataset to identify performance patterns, efficiency opportunities and actionable recommendations.
Submit your own form and watch the tracker update in real-time
How the AI Marketing Dashboard Works
This project demonstrates an end-to-end marketing analytics workflow. Campaign data is collected through a structured submission process and stored in Google Sheets. Automated calculations transform the raw campaign data into standardized marketing performance metrics.
Google Apps Script then provides the processed data through an API that connects the dataset to this live WordPress dashboard. The result is an interactive reporting experience where new campaign data can flow from submission to visualization with minimal manual work.
Campaign Data Collection
Campaign information including channel, spend, impressions, clicks and conversions is collected using standardized fields.
Automated Data Processing
The dataset automatically calculates CTR, CPC, conversion rate and CPA to create consistent performance measurements.
Live Performance Visualization
Processed campaign data is delivered to this dashboard through an API, allowing KPI cards, channel comparisons and performance tables to update from the underlying dataset.
AI-Powered Analysis
AI analysis will evaluate the structured performance data to identify patterns, highlight opportunities and generate actionable marketing recommendations.
Technology Used
Google Forms · Google Sheets · Google Apps Script · REST/JSON · JavaScript · HTML/CSS · WordPress · OpenAI API