How d-rehoune/ecommerce-analytics-platform works
This dbt project transforms e-commerce sales, Google Sheets mapping, and GA4 event data into reporting models. The documented workflow is raw sources → staging → intermediate models → mart; the main result is a daily order report by customer state and account manager. The graph preserves the documented staging and intermediate model families. Source excerpts were unavailable, so model-to-model dependencies are shown only at the documented layer level, not guessed individually.
Main entry points: intermediate Intermediate Layer · staging Staging Layer · sales_database Sales Staging · stg_google_sheets__account_manager_region_mapping.sql Account Mapping
Components 14
Data Sources
- Sales Database
- Google Sheets
- GA4 Events
Staging Models
- Sales Staging
models/staging/sales_database - Account Mapping
models/staging/google_sheets/stg_google_sheets__account_manager_region_mapping.sql - Flattened Events
models/staging/google_analytics/stg_google_analytics__event_flattened.sql - Staging Layer
models/staging
Intermediate Models
- Enriched Orders
models/intermediate/sales_database/int_sales_database__order.sql - Order Items
models/intermediate/sales_database/int_sales_database__order_item.sql - User Aggregates
models/intermediate/sales_database/int_sales_database__user.sql - Favorite Products
models/intermediate/sales_database/int_sales_database__user_favorite_product.sql - GA Sessions
models/intermediate/google_analytics/int_google_analytics__session.sql - Intermediate Layer
models/intermediate
Reporting Mart
- Daily Order Report
models/mart/mrt_order_daily_report.sql
Connections 13
- Sales Database → Sales Staging: stages tables
README.md - Google Sheets → Account Mapping: stages mapping
README.md - GA4 Events → Flattened Events: flattens events
README.md - Sales Staging → Staging Layer: joins layer
README.md - Account Mapping → Staging Layer: joins layer
README.md - Flattened Events → Staging Layer: joins layer
README.md - Staging Layer → Intermediate Layer: feeds layer
README.md - Intermediate Layer → Enriched Orders: builds models
README.md - Intermediate Layer → Order Items: builds models
README.md - Intermediate Layer → User Aggregates: builds models
README.md - Intermediate Layer → Favorite Products: builds models
README.md - Intermediate Layer → GA Sessions: builds models
README.md - Intermediate Layer → Daily Order Report: feeds mart
README.md