How shivkhurana/adcampaigniq works
This repository is a small Flask advertising-campaign dashboard with SQLite-backed reporting scripts. Its demonstrated workflow is to generate mock campaign data, load a CSV into SQLite, and serve aggregated campaign metrics to a browser dashboard. Separate scripts provide campaign summaries and platform-relative underperformance analysis. The README describes a React/Node/PostgreSQL architecture and additional capabilities that are not reflected in the supplied tree or excerpts, so those are not represented. Relationships are limited to those visible in the excerpts; the template’s internal behavior was not sampled.
Main entry points: setup_db.py Schema and CSV Loader · app.py Metrics API · generate_data.py Mock Data Generator · analyze_data.py Campaign Summary
Components 11
Data Preparation
- Mock Data Generator
generate_data.py - Campaign CSV
- Schema and CSV Loader
setup_db.py - Campaigns SQLite DB
Dashboard Serving
- Flask Routes
app.py - Metrics API
app.py - Dashboard Template
templates/index.html
Campaign Analysis
- Campaign Summary
analyze_data.py - Platform Comparison
advanced_analysis.py
Other components
- Operator
- Browser User
Connections 14
- Operator → Mock Data Generator: runs
generate_data.py - Mock Data Generator → Campaign CSV: writes
generate_data.py - Operator → Schema and CSV Loader: runs
setup_db.py - Schema and CSV Loader → Campaign CSV: reads
setup_db.py - Schema and CSV Loader → Campaigns SQLite DB: creates and loads
setup_db.py - Browser User → Flask Routes: requests page
app.py - Flask Routes → Dashboard Template: renders
app.py - Browser User → Metrics API: requests metrics
app.py - Metrics API → Campaigns SQLite DB: queries
app.py - Metrics API → Browser User: returns JSON
app.py - Operator → Campaign Summary: runs
analyze_data.py - Campaign Summary → Campaigns SQLite DB: queries
analyze_data.py - Operator → Platform Comparison: runs
advanced_analysis.py - Platform Comparison → Campaigns SQLite DB: queries
advanced_analysis.py