How ipanpanpan/ecommerce-lifecycle-analytics works
This repository is an e-commerce lifecycle analytics project, not a deployed application. Its documented workflow queries BigQuery to produce RFM customer segments, cohort-retention metrics, and smoothed daily-revenue data; the resulting CSVs are loaded into a notebook for visualization and business insights. The graph preserves those three distinct analytical stages and their documented outputs. Source excerpts were unavailable, so relationships are based on the README’s architecture diagram and descriptions; the revenue-query details are only partially shown.
Main entry points: visualization-for-ecommerce-rfm-and-customer-ret.ipynb Visualization Notebook · README.md Business Insights · 01_rfm_segmentation.sql RFM Segmentation · 02_cohort_retention.sql Cohort Retention
Components 12
SQL Analytics
- RFM Segmentation
sql/01_rfm_segmentation.sql - Cohort Retention
sql/02_cohort_retention.sql - Rolling Revenue
sql/03_rolling_revenue.sql
Exported Data
- RFM Results
data/01_rfm_segmentation.csv - Retention Results
data/02_cohort_retention.csv - Revenue Results
data/03_rolling_revenue.csv
Notebook Analysis
- Visualization Notebook
notebooks/visualization-for-ecommerce-rfm-and-customer-ret.ipynb - RFM Charts
notebooks/visualization-for-ecommerce-rfm-and-customer-ret.ipynb - Retention Heatmap
notebooks/visualization-for-ecommerce-rfm-and-customer-ret.ipynb - Revenue Overlay
notebooks/visualization-for-ecommerce-rfm-and-customer-ret.ipynb - Business Insights
README.md
Other components
- BigQuery Dataset
Connections 15
- BigQuery Dataset → RFM Segmentation: query source
README.md - BigQuery Dataset → Cohort Retention: query source
README.md - BigQuery Dataset → Rolling Revenue: query source
README.md - RFM Segmentation → RFM Results: exports
README.md - Cohort Retention → Retention Results: exports
README.md - Rolling Revenue → Revenue Results: exports
README.md - RFM Results → Visualization Notebook: loads data
README.md - Retention Results → Visualization Notebook: loads data
README.md - Revenue Results → Visualization Notebook: loads data
README.md - Visualization Notebook → RFM Charts: renders
README.md - Visualization Notebook → Retention Heatmap: renders
README.md - Visualization Notebook → Revenue Overlay: renders
README.md - RFM Charts → Business Insights: informs
README.md - Retention Heatmap → Business Insights: informs
README.md - Revenue Overlay → Business Insights: informs
README.md