Skip to main content
DD-RET-004 Enterprise Retail Profitability and Inventory Optimisation Get the data →
DD-RET-004-Q043 Very Hard Time series

Acquisition cohort value

Group customers by first-purchase month. Which cohort has generated the most net sales in total, and what is its average spend per customer?
Expected
Cohort table; leading row · Cohort grid
Tables
FactSalesTransactions, DimDate, DimCustomer · columns
  • FactSalesTransactions
  • DimDate
  • DimCustomer
  • CustomerID
  • NetSalesSAR
  • TransactionDateKey

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.