KPI-Dashboard for Ads Campaign

Organizations running digital marketing campaigns across Google Ads, Facebook Ads, and LinkedIn Ads face a common challenge: performance insights are scattered across multiple platforms, forcing teams to rely on manual spreadsheets. This leads to delays, errors, and fragmented decision-making. Managers struggle to track ROI in real time, finance teams waste hours reconciling invoices and spends, and clients often lack transparent reporting.

Our proposed solution is a Centralized Real-Time KPI Dashboard that unifies campaign data into a single, reliable platform. Using Google Ads, Facebook, and LinkedIn APIs, data is automatically extracted, cleaned, and stored in a PostgreSQL database. A backend layer (built with Node.js/Express or Python/FastAPI) processes this data, runs SQL queries, and calculates key performance indicators (KPIs) such as CTR, CPC, CPM, Conversions, ROI, ROAS, Spend Tracking, and Commission Calculations. The processed results are then displayed on a sleek React.js web dashboard, styled with TailwindCSS/Material UI and visualized through Recharts.js or Chart.js.

This approach eliminates repetitive manual work and ensures role-based access:

• Managers → campaign health, ROI, budget utilization.

• Finance Teams → spend vs invoice reconciliation, commission calculations.

• Clients → transparent reports on campaign performance.

While feasible, the system must address risks: API refresh limits may cause slight delays, inconsistent metric definitions across platforms could confuse users, and dashboards overloaded with KPIs may reduce clarity. These risks can be mitigated by caching, standardizing KPIs, and providing customized role-based dashboards.

The impact is clear: faster decisions, stronger collaboration, and higher ROI. Teams save hours previously spent on reporting, enabling them to focus on strategy and creativity. Clients gain trust through transparent, real-time insights, while organizations achieve greater efficiency and profitability.

We used figma to develop our prototype.