MDW LTV Table Spec: ltv_channel_summary
ltv_channel_summary
Why is it important? Retention, maturity based on conversion_type and channel.
Term | Definition | Datatype |
channel | Channel data based on source and campaign. This data will be joined from measured tag batch event and lookup rules. | varchar(3000) |
conversion_type | Conversion type defined for the client | varchar(2500) |
starting_month | First purchase month | date |
order_month | Transaction data order month | date |
customer_age_in_months | Month between first purchase month and today | float8 |
converters | Total users | int8 |
conversions | Total conversions | int8 |
revenue | Total revenue | float8 |
maturity | The months between first purchase month and order month | float8 |
retention | The number of users who have more than 1 order | int8 |
customers_at_maturity_zero | Total users when maturity is 0 | int8 |
cum_conversions | Cumulative conversions based on conversion type, transaction funnel, maturity | int8 |
cum_revenue | Cumulative revenue calculated along with cum_conversions | float8 |
ltv | Lifetime value for brand | float8 |
brand_id | Brand ID | int4 |
transaction | Transaction funnel, same as in other places | varchar(3000) |
