MDW LTV Table Spec: ltv_segment_maturity_v2
ltv_segment_maturity_v2
Why is it important? Converters, conversions, revenue based on first conversions split on week, month, quarter and year on a conversion_type level.
Term | Definition | Datatype |
brand_id | brand ID | int4 |
conversion_type | conversion type | varchar(600) |
quarter | quarter from order month | 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 | converters based on granularity, conversion type, transaction funnel and brand | float8 |
revenue | converters based on granularity, conversion type, transaction funnel and brand | float8 |
transaction_funnel | transaction funnel mentioned in crm_user_rollup_v2 | varchar(300) |
