Customer metrics
Segmentation, lifecycle, and value metrics
total_customers by loyalty_tier
—
active_customers by age_band
—
avg_recency_days by loyalty_tier
—
Revenue metrics
Revenue, order value, and customer value
total_revenue by loyalty_tier
—
revenue_last_30d by age_band
—
avg_order_value by loyalty_tier
—
revenue_last_90d
—
revenue_per_active_customer
—
avg_customer_value_score
—
Risk & fraud metrics
Churn risk, fraud signals, and transaction health
churn_rate by acquisition_channel
—
medium+ risk customers
—
avg_churn_risk_score by loyalty_tier
—
avg_failed_txn_rate
—
avg_chargeback_rate
—
avg_cart_abandon_rate
—
Engagement metrics
Email, personalization, and campaign performance
avg_email_open_rate by loyalty_tier
—
avg_email_click_rate by loyalty_tier
—
avg_personalization_score by age_band
—
Pipeline status
Production jobs, CI/CD, and environment health
Daily Pipeline Refresh — Production
CI/CD — Pull Request Validation
MetricFlow Semantic Layer
Self-healing Agent
Data lineage
Raw sources through to ML pipelines and BI tools
raw
→
raw_customers, raw_orders, raw_transactions, raw_events, raw_campaigns, raw_products
staging
→
stg_customers, stg_orders, stg_order_items, stg_transactions, stg_events, stg_campaigns, stg_products
intermediate
→
int_customer_orders, int_customer_transactions, int_customer_fraud_signals, int_session_features, int_product_affinity
marts
→
dim_customers, fct_orders, fct_transactions, fct_campaigns, fct_customer_value
features
→
feat_fraud_behavior, feat_customer_segmentation, feat_personalization
ML / BI
→
Snowpark KMeans, Isolation Forest, Sigma dashboards, MetricFlow, Power BI
Tech stack
Full technology breakdown
transformation
dbt Cloud
Snowflake
MetricFlow semantic layer
dbt_utils, dbt_expectations
orchestration
dbt Cloud Jobs (6 AM UTC)
GitHub Actions CI/CD
Snowpipe streaming
ML & AI
Snowpark Python
Isolation Forest (fraud)
KMeans segmentation
Claude API (agent)
data quality
290 dbt tests
Custom assert macros
Source freshness SLAs
visualization
Sigma BI
Power BI
dbt Docs lineage DAG
infrastructure
CUSTOMER_PLATFORM (Snowflake)
Dev + Prod environments
GitHub (version control)