Customer Segmentation

Gender · Preferred channel · Loyalty · PLCC · State. Current-state snapshot of 1,200 customers.

Data governance: Current-state snapshot from V_CURRENT_CUSTOMER (1,200 rows). This is a static cross-sectional snapshot — no time dimension. LTV represents lifetime net amount captured at time of snapshot.

Segmentation KPIs

Customers by Gender

Preferred Channel Distribution

Which channel customers prefer: WEB / STORE / MOBILE / OMNI.

Avg LTV by Preferred Channel × Loyalty

Per-customer lifetime revenue. Loyalty members shown vs non-members.

Customers by State (Top 13)

PLCC × Loyalty Matrix

Customer count in each combination of loyalty membership and PLCC holding.

Segment Detail

Top segments by customer count. Filtered.

Gender	Channel	Loyalty	PLCC	Customers	Avg LTV	Avg Qty