# aryakadam1010/website-analytics-report architecture

> Architecture diagram of the GitHub repository aryakadam1010/website-analytics-report, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-29). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/aryakadam1010/website-analytics-report
- Repository: https://github.com/aryakadam1010/website-analytics-report

## Overview

This is a website analytics case study for a wellness clinic, turning session data into acquisition, engagement, and appointment-conversion findings. The principal workflow is CSV ingestion and validation, KPI and segment analysis, then CSV/Excel reporting for business insights and recommendations. The Python entry point and its calls are sampled; SQL query purposes and the broader workflow are documented in the README, but SQL execution wiring is not shown.

Main entry points: [`python/generate_and_analyse.py`](https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py) (Python Pipeline), [`README.md`](https://github.com/aryakadam1010/website-analytics-report/blob/main/README.md) (Business Insights), [`data/website_sessions.csv`](https://github.com/aryakadam1010/website-analytics-report/blob/main/data/website_sessions.csv) (Website Sessions), [`data/traffic_source_analysis.csv`](https://github.com/aryakadam1010/website-analytics-report/blob/main/data/traffic_source_analysis.csv) (Channel CSV)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Session Data"]
  node_sessions["Website Sessions"]
end

subgraph group_analysis["Analysis"]
  node_pipeline["Python Pipeline"]
  node_validation["Data Validation"]
  node_kpis["Overall KPIs"]
  node_channels["Channel Analysis"]
  node_devices["Device Analysis"]
  node_monthly["Monthly Trends"]
  node_sql_kpis["Overall KPI Query"]
  node_sql_channels["Channel Query"]
  node_sql_devices["Device Query"]
  node_sql_monthly["Monthly Query"]
end

subgraph group_reporting["Reporting"]
  node_traffic_report["Channel CSV"]
  node_device_report["Device CSV"]
  node_monthly_report["Monthly CSV"]
  node_excel_report["Executive Summary"]
end

subgraph group_business["Business Findings"]
  node_insights["Business Insights<br/>[README.md]"]
  node_recommendations["Recommendations<br/>[README.md]"]
end

node_stakeholder(("Clinic Management"))

node_pipeline -->|"reads"| node_sessions
node_pipeline -->|"calls"| node_validation
node_pipeline -->|"calls"| node_kpis
node_pipeline -->|"calls"| node_channels
node_pipeline -->|"calls"| node_devices
node_pipeline -->|"calls"| node_monthly
node_channels -->|"writes"| node_traffic_report
node_devices -->|"writes"| node_device_report
node_monthly -->|"writes"| node_monthly_report
node_pipeline -->|"exports"| node_excel_report
node_sql_kpis -.->|"analyzes"| node_sessions
node_sql_channels -.->|"analyzes"| node_sessions
node_sql_devices -.->|"analyzes"| node_sessions
node_sql_monthly -.->|"analyzes"| node_sessions
node_traffic_report -->|"informs"| node_insights
node_device_report -->|"informs"| node_insights
node_monthly_report -->|"informs"| node_insights
node_excel_report -->|"summarizes"| node_insights
node_insights -->|"guides"| node_recommendations
node_recommendations -->|"inform"| node_stakeholder

click node_sessions "https://github.com/aryakadam1010/website-analytics-report/blob/main/data/website_sessions.csv"
click node_pipeline "https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py"
click node_validation "https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py"
click node_kpis "https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py"
click node_channels "https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py"
click node_devices "https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py"
click node_monthly "https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py"
click node_sql_kpis "https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/01_overall_kpis.sql"
click node_sql_channels "https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/02_channel_performance.sql"
click node_sql_devices "https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/03_device_analysis.sql"
click node_sql_monthly "https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/04_monthly_trends.sql"
click node_traffic_report "https://github.com/aryakadam1010/website-analytics-report/blob/main/data/traffic_source_analysis.csv"
click node_device_report "https://github.com/aryakadam1010/website-analytics-report/blob/main/data/device_breakdown.csv"
click node_monthly_report "https://github.com/aryakadam1010/website-analytics-report/blob/main/data/monthly_performance.csv"
click node_excel_report "https://github.com/aryakadam1010/website-analytics-report/blob/main/data/executive_summary.xlsx"
click node_insights "https://github.com/aryakadam1010/website-analytics-report/blob/main/README.md"
click node_recommendations "https://github.com/aryakadam1010/website-analytics-report/blob/main/README.md"

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_sessions toneBlue
class node_pipeline,node_validation,node_kpis,node_channels,node_devices,node_monthly,node_sql_kpis,node_sql_channels,node_sql_devices,node_sql_monthly toneAmber
class node_traffic_report,node_device_report,node_monthly_report,node_excel_report toneMint
class node_insights,node_recommendations toneRose
class node_stakeholder toneIndigo
```

## Components

### Session Data

- [Website Sessions](https://github.com/aryakadam1010/website-analytics-report/blob/main/data/website_sessions.csv): `data/website_sessions.csv`

### Analysis

- [Python Pipeline](https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py): `python/generate_and_analyse.py`
- [Data Validation](https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py): `python/generate_and_analyse.py`
- [Overall KPIs](https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py): `python/generate_and_analyse.py`
- [Channel Analysis](https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py): `python/generate_and_analyse.py`
- [Device Analysis](https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py): `python/generate_and_analyse.py`
- [Monthly Trends](https://github.com/aryakadam1010/website-analytics-report/blob/main/python/generate_and_analyse.py): `python/generate_and_analyse.py`
- [Overall KPI Query](https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/01_overall_kpis.sql): `sql/01_overall_kpis.sql`
- [Channel Query](https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/02_channel_performance.sql): `sql/02_channel_performance.sql`
- [Device Query](https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/03_device_analysis.sql): `sql/03_device_analysis.sql`
- [Monthly Query](https://github.com/aryakadam1010/website-analytics-report/blob/main/sql/04_monthly_trends.sql): `sql/04_monthly_trends.sql`

### Reporting

- [Channel CSV](https://github.com/aryakadam1010/website-analytics-report/blob/main/data/traffic_source_analysis.csv): `data/traffic_source_analysis.csv`
- [Device CSV](https://github.com/aryakadam1010/website-analytics-report/blob/main/data/device_breakdown.csv): `data/device_breakdown.csv`
- [Monthly CSV](https://github.com/aryakadam1010/website-analytics-report/blob/main/data/monthly_performance.csv): `data/monthly_performance.csv`
- [Executive Summary](https://github.com/aryakadam1010/website-analytics-report/blob/main/data/executive_summary.xlsx): `data/executive_summary.xlsx`

### Business Findings

- [Business Insights](https://github.com/aryakadam1010/website-analytics-report/blob/main/README.md): `README.md`
- [Recommendations](https://github.com/aryakadam1010/website-analytics-report/blob/main/README.md): `README.md`

### Other components

- **Clinic Management**

## Connections

- Python Pipeline → Website Sessions: reads
- Python Pipeline → Data Validation: calls
- Python Pipeline → Overall KPIs: calls
- Python Pipeline → Channel Analysis: calls
- Python Pipeline → Device Analysis: calls
- Python Pipeline → Monthly Trends: calls
- Channel Analysis → Channel CSV: writes
- Device Analysis → Device CSV: writes
- Monthly Trends → Monthly CSV: writes
- Python Pipeline → Executive Summary: exports
- Overall KPI Query → Website Sessions: analyzes
- Channel Query → Website Sessions: analyzes
- Device Query → Website Sessions: analyzes
- Monthly Query → Website Sessions: analyzes
- Channel CSV → Business Insights: informs
- Device CSV → Business Insights: informs
- Monthly CSV → Business Insights: informs
- Executive Summary → Business Insights: summarizes
- Business Insights → Recommendations: guides
- Recommendations → Clinic Management: inform