How aryakadam1010/website-analytics-report works
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: generate_and_analyse.py Python Pipeline · README.md Business Insights · website_sessions.csv Website Sessions · traffic_source_analysis.csv Channel CSV
Components 18
Session Data
- Website Sessions
data/website_sessions.csv
Analysis
- Python Pipeline
python/generate_and_analyse.py - Data Validation
python/generate_and_analyse.py - Overall KPIs
python/generate_and_analyse.py - Channel Analysis
python/generate_and_analyse.py - Device Analysis
python/generate_and_analyse.py - Monthly Trends
python/generate_and_analyse.py - Overall KPI Query
sql/01_overall_kpis.sql - Channel Query
sql/02_channel_performance.sql - Device Query
sql/03_device_analysis.sql - Monthly Query
sql/04_monthly_trends.sql
Reporting
- Channel CSV
data/traffic_source_analysis.csv - Device CSV
data/device_breakdown.csv - Monthly CSV
data/monthly_performance.csv - Executive Summary
data/executive_summary.xlsx
Business Findings
- Business Insights
README.md - Recommendations
README.md
Other components
- Clinic Management
Connections 20
- 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