MDW LTV Table Spec: ltv_segment_maturity
ltv_segment_maturity
Why is it important? Converters, conversions, revenue based on first conversions split on week, month, quarter and year.
Term | Definition | Datatype |
quarter | quarter from order moneth | int4 |
year | year from order month | int4 |
granularity | granularity based on first purchase | varchar(300) |
induction_window | If granularity is week, then window will be calculated on week basis from order month | date |
order_window | order month | date |
converters | converters based on granularity, conversion type, transaction funnel and brand | float8 |
conversions | conversions based on granularity, conversion type, transaction funnel and brand | float8 |
revenue | conversions based on granularity, conversion type, transaction funnel and brand | float8 |
transaction_funnel | transaction funnel mentioned in crm_user_rollup_v2 | varchar(300) |
