Customer Analytics

Demo

Click to play with sound.

---
name: Customer Analytics
description: Cohort analysis, LTV modeling, and churn prediction from transactions.
---

# Customer Analytics

Turn transactional data into cohort, lifetime value, and churn insights.

## Build cohorts

Group customers by acquisition period and track behavior across subsequent periods.

```sql
with first_order as (
  select customer_id,
         date_trunc('month', min(order_date)) as cohort_month
  from orders group by 1
),
activity as (
  select o.customer_id,
         f.cohort_month,
         date_trunc('month', o.order_date) as active_month
  from orders o join first_order f using (customer_id)
)… install to load the full skill