Centralized Real-Time KPI Dashboard with Automated Excel Reporting
Link to open source: https://github.com/riyamote1205/Apex-Hackathon
Link to Live Project: https://github.com/riyamote1205/Apex-Hackathon
Proposed Solution: Centralized Real-Time KPI Dashboard with Automated Excel Reporting
1. Data Integration
* Use the Google Ads API to fetch campaign data automatically (impressions, clicks, CTR, conversions, spend, CPC, CPA, ROAS).
* Normalize and store data in a structured database (e.g., PostgreSQL or Firebase).
2. Real-Time Dashboard
* Build a React + Tailwind + Recharts dashboard.
* Show key KPIs in real time with charts (CTR trends, spend vs conversions, funnel view).
* Provide filtering options (campaign, date range, region).
* Auto-refresh every 30–60 seconds for live monitoring.
3. Automated Excel Reporting
* Use Python (pandas + openpyxl) to generate Excel reports with:
* Summary sheet (high-level KPIs).
* Detailed performance sheet (per campaign/ad group).
* Visuals (charts for trends).
* Enable one-click “Download Excel” from the dashboard.
* Schedule daily/weekly auto-generation of reports, with email/Google Drive delivery.
4. Outcome
* Efficiency: Save several analyst hours per week by removing manual workflows.
* Accuracy: Eliminate human errors in reporting and reconciliation.
* Transparency: Clients gain both real-time visibility (dashboard) and standardized periodic reports (Excel).
* Scalability: The same system can be extended to other ad platforms (Facebook Ads, LinkedIn Ads).
This build was uploaded as a hackathon project
