# shivkhurana/adcampaigniq architecture

> Architecture diagram of the GitHub repository shivkhurana/adcampaigniq, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/shivkhurana/adcampaigniq
- Repository: https://github.com/shivkhurana/adcampaigniq

## Overview

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`](https://github.com/shivkhurana/adcampaigniq/blob/main/setup_db.py) (Schema and CSV Loader), [`app.py`](https://github.com/shivkhurana/adcampaigniq/blob/main/app.py) (Metrics API), [`generate_data.py`](https://github.com/shivkhurana/adcampaigniq/blob/main/generate_data.py) (Mock Data Generator), [`analyze_data.py`](https://github.com/shivkhurana/adcampaigniq/blob/main/analyze_data.py) (Campaign Summary)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data_prep["Data Preparation"]
  node_generator["Mock Data Generator<br/>[generate_data.py]"]
  node_csv["Campaign CSV"]
  node_loader["Schema and CSV Loader<br/>[setup_db.py]"]
  node_db[("Campaigns SQLite DB")]
end

subgraph group_serving["Dashboard Serving"]
  node_app["Flask Routes<br/>[app.py]"]
  node_metrics["Metrics API<br/>[app.py]"]
  node_template["Dashboard Template<br/>[index.html]"]
end

subgraph group_analysis["Campaign Analysis"]
  node_basic_analysis["Campaign Summary<br/>[analyze_data.py]"]
  node_advanced_analysis["Platform Comparison"]
end

node_operator(("Operator"))
node_browser(("Browser User"))

node_operator -->|"runs"| node_generator
node_generator -->|"writes"| node_csv
node_operator -->|"runs"| node_loader
node_loader -->|"reads"| node_csv
node_loader -->|"creates and loads"| node_db
node_browser -->|"requests page"| node_app
node_app -->|"renders"| node_template
node_browser -->|"requests metrics"| node_metrics
node_metrics -->|"queries"| node_db
node_metrics -->|"returns JSON"| node_browser
node_operator -->|"runs"| node_basic_analysis
node_basic_analysis -->|"queries"| node_db
node_operator -->|"runs"| node_advanced_analysis
node_advanced_analysis -->|"queries"| node_db

click node_generator "https://github.com/shivkhurana/adcampaigniq/blob/main/generate_data.py"
click node_loader "https://github.com/shivkhurana/adcampaigniq/blob/main/setup_db.py"
click node_app "https://github.com/shivkhurana/adcampaigniq/blob/main/app.py"
click node_metrics "https://github.com/shivkhurana/adcampaigniq/blob/main/app.py"
click node_template "https://github.com/shivkhurana/adcampaigniq/blob/main/templates/index.html"
click node_basic_analysis "https://github.com/shivkhurana/adcampaigniq/blob/main/analyze_data.py"
click node_advanced_analysis "https://github.com/shivkhurana/adcampaigniq/blob/main/advanced_analysis.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_generator,node_csv,node_loader,node_db,node_browser toneBlue
class node_app,node_metrics,node_template toneAmber
class node_basic_analysis,node_advanced_analysis toneMint
class node_operator toneIndigo
```

## Components

### Data Preparation

- [Mock Data Generator](https://github.com/shivkhurana/adcampaigniq/blob/main/generate_data.py): `generate_data.py`
- **Campaign CSV**
- [Schema and CSV Loader](https://github.com/shivkhurana/adcampaigniq/blob/main/setup_db.py): `setup_db.py`
- **Campaigns SQLite DB**

### Dashboard Serving

- [Flask Routes](https://github.com/shivkhurana/adcampaigniq/blob/main/app.py): `app.py`
- [Metrics API](https://github.com/shivkhurana/adcampaigniq/blob/main/app.py): `app.py`
- [Dashboard Template](https://github.com/shivkhurana/adcampaigniq/blob/main/templates/index.html): `templates/index.html`

### Campaign Analysis

- [Campaign Summary](https://github.com/shivkhurana/adcampaigniq/blob/main/analyze_data.py): `analyze_data.py`
- [Platform Comparison](https://github.com/shivkhurana/adcampaigniq/blob/main/advanced_analysis.py): `advanced_analysis.py`

### Other components

- **Operator**
- **Browser User**

## Connections

- Operator → Mock Data Generator: runs (evidence: `generate_data.py`)
- Mock Data Generator → Campaign CSV: writes (evidence: `generate_data.py`)
- Operator → Schema and CSV Loader: runs (evidence: `setup_db.py`)
- Schema and CSV Loader → Campaign CSV: reads (evidence: `setup_db.py`)
- Schema and CSV Loader → Campaigns SQLite DB: creates and loads (evidence: `setup_db.py`)
- Browser User → Flask Routes: requests page (evidence: `app.py`)
- Flask Routes → Dashboard Template: renders (evidence: `app.py`)
- Browser User → Metrics API: requests metrics (evidence: `app.py`)
- Metrics API → Campaigns SQLite DB: queries (evidence: `app.py`)
- Metrics API → Browser User: returns JSON (evidence: `app.py`)
- Operator → Campaign Summary: runs (evidence: `analyze_data.py`)
- Campaign Summary → Campaigns SQLite DB: queries (evidence: `analyze_data.py`)
- Operator → Platform Comparison: runs (evidence: `advanced_analysis.py`)
- Platform Comparison → Campaigns SQLite DB: queries (evidence: `advanced_analysis.py`)
