| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !select_module_ltv_normal -- |
| 100 |
| |
| -- !select_module_ltv_null -- |
| \N |
| |
| -- !select_module_ltv_zero -- |
| 100 |
| |
| -- !select_customer_analytics -- |
| 1001 Premium 5 50 10000 100 |
| 1002 Regular 30 10 2000 67.19368581839511 |
| 1003 Inactive 60 5 500 20.37527840768416 |
| 1004 VIP 2 100 25000 100 |
| 1005 Regular 15 25 5000 100 |
| 1006 Regular \N 30 6000 \N |
| 1007 Regular 10 \N 3000 \N |
| 1008 Inactive 45 8 \N \N |
| 1009 VIP 0 200 50000 100 |
| 1010 Churned 90 2 100 6.295836866004329 |
| |
| -- !select_segment_analysis -- |
| Churned 1 100 6.295836866004329 |
| Inactive 2 500 20.37527840768416 |
| Premium 1 10000 100 |
| Regular 4 4000 83.59684290919756 |
| VIP 2 37500 100 |
| |
| -- !select_high_value_customers -- |
| |
| -- !select_sorted_by_ltv -- |
| 1009 VIP 100 |
| 1005 Regular 100 |
| 1004 VIP 100 |
| 1001 Premium 100 |
| 1002 Regular 67.19368581839511 |
| |
| -- !select_complex_query -- |
| 1001 Premium 5 50 10000 100 Low Value |
| 1004 VIP 2 100 25000 100 Low Value |
| 1005 Regular 15 25 5000 100 Low Value |
| 1009 VIP 0 200 50000 100 Low Value |
| 1002 Regular 30 10 2000 67.19368581839511 Low Value |
| 1003 Inactive 60 5 500 20.37527840768416 Low Value |
| 1010 Churned 90 2 100 6.295836866004329 Low Value |
| 1007 Regular 10 \N 3000 \N Unknown |
| 1008 Inactive 45 8 \N \N Unknown |
| 1006 Regular \N 30 6000 \N Unknown |
| |
| -- !select_join_with_module_udf -- |
| 1001 Alice Johnson Premium 10000 100 |
| 1004 Diana Prince VIP 25000 100 |
| 1005 Eve Wilson Regular 5000 100 |
| 1002 Bob Smith Regular 2000 67.19368581839511 |
| 1003 Charlie Brown Inactive 500 20.37527840768416 |
| |
