customer_features_lifetime

previewtablecustomerlifetime

Lifetime features per customer (slowly changing). Built from daily aggregates.

warehouse.analytics.customer_features_lifetime

Preview. This feature table is not yet considered production-ready.

Use this feature group

select
  customer_id,
  lifetime_order_count,
  lifetime_order_value_usd,
  first_order_date
from warehouse.analytics.customer_features_lifetime

SELECT *
FROM {{ ref('customer_features_lifetime') }}

Features in customer_features_lifetime
Name	Type	Column type	Null %	Distinct	Null behavior	Status	Declared ML consumers
`lifetime_order_count` All-time order count for this customer	numeric	`integer`	1.2%	1,482	zero	—	`ltv_model_v3`
`lifetime_order_value_usd` All-time order value in USD	numeric	`decimal`	1.2%	1,482	zero	—	`ltv_model_v3`
`first_order_date` Date of the customer's first order	timestamp	`date`	0.50%	1,811	propagate	—	—

None.

Declared manually via used_by on individual features.