01Run it
Straight from the command's own help.
p202 ltv customers --search acme --segment repeatp202 ltv customers --cf plan=pro --cf score.min=50 --allp202 ltv customers 4202What you get
Captured from the real binary, run against a demo store with 30 days of traffic. Switch tabs to see the same run as JSON, the shape scripts and agents parse.
$ p202 ltv customers status active_subscription_count city company country customer_id email first_click_id first_name first_seen_time last_activity_time last_name mrr order_count primary_ref refunded_amount region total_revenue ------ ------------------------- ---- ------- ------- ----------- ----------------------------- -------------- ---------- --------------- ------------------ --------- -------- ----------- ----------- --------------- ------ ------------- active 0 111 [email protected] 2800 Diego 1789733060 1789733060 Vance 0 1 cust-1111 0 636 active 0 18 [email protected] 548 Lena 1791356492 1791356492 Grant 0 1 cust-1018 0 607 active 1 115 [email protected] 2871 Mason 1791243739 1791243739 Morgan 49 1 cust-1115 0 588 active 1 83 [email protected] 1996 Mateo 1790547397 1790547397 Morgan 49 1 cust-1083 0 588 active 1 67 [email protected] 1597 Zoe 1790184516 1790184516 Okafor 49 1 cust-1067 0 588 active 1 10 [email protected] 295 Felix 1790777698 1790777698 Jensen 49 1 cust-1010 0 588 active 0 78 [email protected] 1869 Lena 1790480065 1790480065 Quinn 0 1 cust-1078 0 577 active 0 20 [email protected] 600 Grace 1789064541 1789064541 Foster 0 1 cust-1020 0 548 active 0 68 [email protected] 1611 Lena 1790276733 1790276733 Bennett 0 1 cust-1068 0 518 active 0 1 [email protected] 3 Kenji 1790595724 1790854924 Vance 0 1 cust-1001 59 518 active 1 89 [email protected] 2149 Rhys 1789500439 1789500439 Carter 29 1 cust-1089 0 348 active 1 55 [email protected] 1294 Zoe 1790423437 1790423437 Patel 29 1 cust-1055 0 348 active 1 46 [email protected] 1101 Grace 1791539206 1791539206 Foster 29 1 cust-1046 0 348 active 1 22 [email protected] 677 Elias 1789416983 1789416983 Lindqvist 29 1 cust-1022 0 348 active 1 11 [email protected] 364 Lena 1790768967 1790768967 Reyes 29 1 cust-1011 0 348 active 1 4 [email protected] 85 Elias 1791303994 1791303994 Diaz 29 1 cust-1004 0 348 active 0 31 [email protected] 801 Clara 1790089761 1790841089 Foster 0 2 cust-1031 0 286 active 0 21 [email protected] 627 Ivy 1789902011 1790100430 Hayes 0 2 cust-1021 0 276 active 0 2 [email protected] 15 Grace 1790626426 1790921878 Quinn 0 2 cust-1002 0 252 active 0 79 [email protected] 1887 Kenji 1791065921 1791065921 Bennett 0 1 cust-1079 0 242 active 0 13 [email protected] 421 Ethan 1789767743 1790353372 Grant 0 2 cust-1013 0 242 active 0 44 [email protected] 1042 Isla 1790174263 1790174263 Quinn 0 1 cust-1044 0 232 active 0 7 [email protected] 176 Silas 1790715099 1790715099 Walsh 0 1 cust-1007 0 225 active 0 19 [email protected] 569 Nora 1791231148 1791231148 Walsh 0 1 cust-1019 0 214 active 0 66 [email protected] 1544 Mateo 1790674883 1790674883 Jensen 0 1 cust-1066 0 198 active 0 72 [email protected] 1673 Grace 1791357768 1791539176 Moreau 0 2 cust-1072 0 180 active 0 65 [email protected] 1470 Arlo 1789770031 1789770031 Moreau 0 1 cust-1065 0 175 active 0 49 [email protected] 1145 Mateo 1790432452 1790432452 Tanaka 0 1 cust-1049 0 175 active 0 24 [email protected] 705 Hugo 1791296228 1791539176 Kowalski 0 2 cust-1024 0 175 active 0 36 [email protected] 895 Diego 1789159933 1789159933 Quinn 0 1 cust-1036 0 174 active 0 98 [email protected] 2522 Rhys 1789044827 1789268422 Zhang 0 2 cust-1098 0 171 active 0 86 [email protected] 2107 Miles 1789575919 1789575919 Jensen 0 1 cust-1086 0 164 active 0 35 [email protected] 862 Diego 1791377586 1791539176 Underwood 0 2 cust-1035 0 164 active 0 96 [email protected] 2336 Omar 1791219616 1791219616 Morgan 0 1 cust-1096 0 156 active 0 110 [email protected] 2756 Arlo 1790097838 1790776628 Reyes 0 2 cust-1110 0 150 active 0 82 [email protected] 1951 Lucas 1791149199 1791539176 Grant 0 2 cust-1082 0 150 active 0 76 [email protected] 1782 Hazel 1789130506 1789130506 Bennett 0 1 cust-1076 0 150 active 0 43 [email protected] 1041 Hazel 1791022077 1791022077 Morgan 0 1 cust-1043 0 150 active 0 39 [email protected] 962 Lena 1788952578 1789644838 Moreau 0 2 cust-1039 0 150 active 0 73 [email protected] 1726 June 1789051454 1789051454 Hayes 0 1 cust-1073 0 146 active 0 61 [email protected] 1397 Hazel 1789330864 1789330864 Vance 0 1 cust-1061 0 146 active 0 109 [email protected] 2711 June 1789215886 1789215886 Reyes 0 1 cust-1109 0 141 active 0 74 [email protected] 1748 Chloe 1790639259 1790639259 Haddad 0 1 cust-1074 0 130 active 0 62 [email protected] 1446 Ruby 1789466643 1789466643 Vance 0 1 cust-1062 0 130 active 0 29 [email protected] 747 Felix 1790726688 1791539176 Diaz 0 2 cust-1029 0 126 active 0 99 [email protected] 2528 Leo 1790716612 1790716612 Haddad 0 1 cust-1099 0 125 active 0 52 [email protected] 1187 Arlo 1790809126 1790809126 Grant 0 1 cust-1052 0 125 active 0 51 [email protected] 1182 Isla 1789418375 1789418375 Foster 0 1 cust-1051 0 125 active 0 71 [email protected] 1651 Ava 1790817267 1791314745 Morgan 0 2 cust-1071 0 120 active 0 92 [email protected] 2169 Elias 1791143047 1791539176 Keller 0 2 cust-1092 0 102 Total: 115 | Limit: 50 | Offset: 0 Warning: Showing 50 of 115 results. Use --all to fetch all.
$ p202 ltv customers --json { "data": [ { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 111, "email": "[email protected]", "first_click_id": 2800, "first_name": "Diego", "first_seen_time": 1789733060, "last_activity_time": 1789733060, "last_name": "Vance", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1111", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "636.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 18, "email": "[email protected]", "first_click_id": 548, "first_name": "Lena", "first_seen_time": 1791356492, "last_activity_time": 1791356492, "last_name": "Grant", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1018", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "607.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 115, "email": "[email protected]", "first_click_id": 2871, "first_name": "Mason", "first_seen_time": 1791243739, "last_activity_time": 1791243739, "last_name": "Morgan", "mrr": "49.00000", "order_count": 1, "primary_ref": "cust-1115", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "588.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 83, "email": "[email protected]", "first_click_id": 1996, "first_name": "Mateo", "first_seen_time": 1790547397, "last_activity_time": 1790547397, "last_name": "Morgan", "mrr": "49.00000", "order_count": 1, "primary_ref": "cust-1083", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "588.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 67, "email": "[email protected]", "first_click_id": 1597, "first_name": "Zoe", "first_seen_time": 1790184516, "last_activity_time": 1790184516, "last_name": "Okafor", "mrr": "49.00000", "order_count": 1, "primary_ref": "cust-1067", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "588.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 10, "email": "[email protected]", "first_click_id": 295, "first_name": "Felix", "first_seen_time": 1790777698, "last_activity_time": 1790777698, "last_name": "Jensen", "mrr": "49.00000", "order_count": 1, "primary_ref": "cust-1010", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "588.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 78, "email": "[email protected]", "first_click_id": 1869, "first_name": "Lena", "first_seen_time": 1790480065, "last_activity_time": 1790480065, "last_name": "Quinn", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1078", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "577.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 20, "email": "[email protected]", "first_click_id": 600, "first_name": "Grace", "first_seen_time": 1789064541, "last_activity_time": 1789064541, "last_name": "Foster", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1020", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "548.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 68, "email": "[email protected]", "first_click_id": 1611, "first_name": "Lena", "first_seen_time": 1790276733, "last_activity_time": 1790276733, "last_name": "Bennett", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1068", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "518.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 1, "email": "[email protected]", "first_click_id": 3, "first_name": "Kenji", "first_seen_time": 1790595724, "last_activity_time": 1790854924, "last_name": "Vance", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1001", "refunded_amount": "59.00000", "region": null, "status": "active", "total_revenue": "518.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 89, "email": "[email protected]", "first_click_id": 2149, "first_name": "Rhys", "first_seen_time": 1789500439, "last_activity_time": 1789500439, "last_name": "Carter", "mrr": "29.00000", "order_count": 1, "primary_ref": "cust-1089", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "348.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 55, "email": "[email protected]", "first_click_id": 1294, "first_name": "Zoe", "first_seen_time": 1790423437, "last_activity_time": 1790423437, "last_name": "Patel", "mrr": "29.00000", "order_count": 1, "primary_ref": "cust-1055", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "348.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 46, "email": "[email protected]", "first_click_id": 1101, "first_name": "Grace", "first_seen_time": 1791539206, "last_activity_time": 1791539206, "last_name": "Foster", "mrr": "29.00000", "order_count": 1, "primary_ref": "cust-1046", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "348.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 22, "email": "[email protected]", "first_click_id": 677, "first_name": "Elias", "first_seen_time": 1789416983, "last_activity_time": 1789416983, "last_name": "Lindqvist", "mrr": "29.00000", "order_count": 1, "primary_ref": "cust-1022", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "348.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 11, "email": "[email protected]", "first_click_id": 364, "first_name": "Lena", "first_seen_time": 1790768967, "last_activity_time": 1790768967, "last_name": "Reyes", "mrr": "29.00000", "order_count": 1, "primary_ref": "cust-1011", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "348.00000" }, { "active_subscription_count": 1, "city": null, "company": null, "country": null, "customer_id": 4, "email": "[email protected]", "first_click_id": 85, "first_name": "Elias", "first_seen_time": 1791303994, "last_activity_time": 1791303994, "last_name": "Diaz", "mrr": "29.00000", "order_count": 1, "primary_ref": "cust-1004", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "348.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 31, "email": "[email protected]", "first_click_id": 801, "first_name": "Clara", "first_seen_time": 1790089761, "last_activity_time": 1790841089, "last_name": "Foster", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1031", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "286.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 21, "email": "[email protected]", "first_click_id": 627, "first_name": "Ivy", "first_seen_time": 1789902011, "last_activity_time": 1790100430, "last_name": "Hayes", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1021", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "276.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 2, "email": "[email protected]", "first_click_id": 15, "first_name": "Grace", "first_seen_time": 1790626426, "last_activity_time": 1790921878, "last_name": "Quinn", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1002", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "252.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 79, "email": "[email protected]", "first_click_id": 1887, "first_name": "Kenji", "first_seen_time": 1791065921, "last_activity_time": 1791065921, "last_name": "Bennett", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1079", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "242.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 13, "email": "[email protected]", "first_click_id": 421, "first_name": "Ethan", "first_seen_time": 1789767743, "last_activity_time": 1790353372, "last_name": "Grant", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1013", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "242.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 44, "email": "[email protected]", "first_click_id": 1042, "first_name": "Isla", "first_seen_time": 1790174263, "last_activity_time": 1790174263, "last_name": "Quinn", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1044", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "232.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 7, "email": "[email protected]", "first_click_id": 176, "first_name": "Silas", "first_seen_time": 1790715099, "last_activity_time": 1790715099, "last_name": "Walsh", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1007", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "225.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 19, "email": "[email protected]", "first_click_id": 569, "first_name": "Nora", "first_seen_time": 1791231148, "last_activity_time": 1791231148, "last_name": "Walsh", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1019", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "214.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 66, "email": "[email protected]", "first_click_id": 1544, "first_name": "Mateo", "first_seen_time": 1790674883, "last_activity_time": 1790674883, "last_name": "Jensen", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1066", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "198.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 72, "email": "[email protected]", "first_click_id": 1673, "first_name": "Grace", "first_seen_time": 1791357768, "last_activity_time": 1791539176, "last_name": "Moreau", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1072", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "180.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 65, "email": "[email protected]", "first_click_id": 1470, "first_name": "Arlo", "first_seen_time": 1789770031, "last_activity_time": 1789770031, "last_name": "Moreau", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1065", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "175.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 49, "email": "[email protected]", "first_click_id": 1145, "first_name": "Mateo", "first_seen_time": 1790432452, "last_activity_time": 1790432452, "last_name": "Tanaka", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1049", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "175.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 24, "email": "[email protected]", "first_click_id": 705, "first_name": "Hugo", "first_seen_time": 1791296228, "last_activity_time": 1791539176, "last_name": "Kowalski", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1024", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "175.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 36, "email": "[email protected]", "first_click_id": 895, "first_name": "Diego", "first_seen_time": 1789159933, "last_activity_time": 1789159933, "last_name": "Quinn", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1036", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "174.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 98, "email": "[email protected]", "first_click_id": 2522, "first_name": "Rhys", "first_seen_time": 1789044827, "last_activity_time": 1789268422, "last_name": "Zhang", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1098", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "171.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 86, "email": "[email protected]", "first_click_id": 2107, "first_name": "Miles", "first_seen_time": 1789575919, "last_activity_time": 1789575919, "last_name": "Jensen", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1086", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "164.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 35, "email": "[email protected]", "first_click_id": 862, "first_name": "Diego", "first_seen_time": 1791377586, "last_activity_time": 1791539176, "last_name": "Underwood", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1035", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "164.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 96, "email": "[email protected]", "first_click_id": 2336, "first_name": "Omar", "first_seen_time": 1791219616, "last_activity_time": 1791219616, "last_name": "Morgan", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1096", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "156.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 110, "email": "[email protected]", "first_click_id": 2756, "first_name": "Arlo", "first_seen_time": 1790097838, "last_activity_time": 1790776628, "last_name": "Reyes", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1110", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "150.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 82, "email": "[email protected]", "first_click_id": 1951, "first_name": "Lucas", "first_seen_time": 1791149199, "last_activity_time": 1791539176, "last_name": "Grant", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1082", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "150.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 76, "email": "[email protected]", "first_click_id": 1782, "first_name": "Hazel", "first_seen_time": 1789130506, "last_activity_time": 1789130506, "last_name": "Bennett", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1076", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "150.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 43, "email": "[email protected]", "first_click_id": 1041, "first_name": "Hazel", "first_seen_time": 1791022077, "last_activity_time": 1791022077, "last_name": "Morgan", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1043", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "150.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 39, "email": "[email protected]", "first_click_id": 962, "first_name": "Lena", "first_seen_time": 1788952578, "last_activity_time": 1789644838, "last_name": "Moreau", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1039", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "150.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 73, "email": "[email protected]", "first_click_id": 1726, "first_name": "June", "first_seen_time": 1789051454, "last_activity_time": 1789051454, "last_name": "Hayes", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1073", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "146.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 61, "email": "[email protected]", "first_click_id": 1397, "first_name": "Hazel", "first_seen_time": 1789330864, "last_activity_time": 1789330864, "last_name": "Vance", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1061", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "146.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 109, "email": "[email protected]", "first_click_id": 2711, "first_name": "June", "first_seen_time": 1789215886, "last_activity_time": 1789215886, "last_name": "Reyes", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1109", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "141.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 74, "email": "[email protected]", "first_click_id": 1748, "first_name": "Chloe", "first_seen_time": 1790639259, "last_activity_time": 1790639259, "last_name": "Haddad", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1074", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "130.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 62, "email": "[email protected]", "first_click_id": 1446, "first_name": "Ruby", "first_seen_time": 1789466643, "last_activity_time": 1789466643, "last_name": "Vance", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1062", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "130.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 29, "email": "[email protected]", "first_click_id": 747, "first_name": "Felix", "first_seen_time": 1790726688, "last_activity_time": 1791539176, "last_name": "Diaz", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1029", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "126.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 99, "email": "[email protected]", "first_click_id": 2528, "first_name": "Leo", "first_seen_time": 1790716612, "last_activity_time": 1790716612, "last_name": "Haddad", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1099", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "125.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 52, "email": "[email protected]", "first_click_id": 1187, "first_name": "Arlo", "first_seen_time": 1790809126, "last_activity_time": 1790809126, "last_name": "Grant", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1052", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "125.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 51, "email": "[email protected]", "first_click_id": 1182, "first_name": "Isla", "first_seen_time": 1789418375, "last_activity_time": 1789418375, "last_name": "Foster", "mrr": "0.00000", "order_count": 1, "primary_ref": "cust-1051", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "125.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 71, "email": "[email protected]", "first_click_id": 1651, "first_name": "Ava", "first_seen_time": 1790817267, "last_activity_time": 1791314745, "last_name": "Morgan", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1071", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "120.00000" }, { "active_subscription_count": 0, "city": null, "company": null, "country": null, "customer_id": 92, "email": "[email protected]", "first_click_id": 2169, "first_name": "Elias", "first_seen_time": 1791143047, "last_activity_time": 1791539176, "last_name": "Keller", "mrr": "0.00000", "order_count": 2, "primary_ref": "cust-1092", "refunded_amount": "0.00000", "region": null, "status": "active", "total_revenue": "102.00000" } ], "pagination": { "limit": 50, "offset": 0, "total": 115 } }
03Build your command
Pick values and the command line writes itself, quoted and ready to paste.
p202 ltv customersSet flags below; the command updates as you type.
04Flags
11 flags, plus the global flags every command takes.
| Flag | What it does |
|---|---|
| --allbool | Fetch every page (500 rows a request) |
| --cfstringArray | Only customers whose custom field matches: key=value, or key.min=value / key.max=value for a number or date field (repeatable, at most 3; p202 ltv fields list shows the keys) |
| --dirstring | Sort direction: ASC, DESCASCDESC |
| --limit, -lstring | Rows per page (max 500) |
| --offset, -ostring | Pagination offset |
| --period, -pstring | Period: today, yesterday, last7, last14, last30, last90, thismonth, lastmonth, thisyear, lastyear, alltimetodayyesterdaylast7last14last30last90thismonthlastmonththisyearlastyearalltime |
| --searchstring | Only customers whose reference, email, company or name contains this text (the API's q) |
| --segmentstring | Only this segment (repeat: 2+ orders; subscribers: an active subscription; at_risk: a past_due subscription): repeat, subscribers, at_riskrepeatsubscribersat_risk |
| --sort, -sstring | Sort: total_revenue, order_count, last_activity_time, first_seen_time, mrrtotal_revenueorder_countlast_activity_timefirst_seen_timemrr |
| --time-fromstring | Acquisition window start: unix seconds, a date (2026-10-01, from its first second in the account's timezone) or a time with its offset (2026-10-01T09:30:00Z) |
| --time-tostring | Acquisition window end, inclusive: unix seconds, a date (2026-10-01, through its last second in the account's timezone) or a time with its offset |
05How it works
List customers with their LTV rollups, newest-valued first, or show one in full.
p202 ltv customers --search acme --segment repeat p202 ltv customers --cf plan=pro --cf score.min=50 --all p202 ltv customers 42
--search matches the customer reference, email, company or name. --cf filters by custom
field: key=value, or key.min/key.max for number and date fields (at most 3). Writes are
p202 ltv customer (upsert, update, merge, erase, alias).
06For agents
Running this from an agent
- Read the same facts as JSON:
p202 commands ltv customers --json. - With
AI_AGENT,CLAUDECODEor another agent variable set, output is compact JSON and errors arrive on stderr as a JSON envelope with ahint. - Exit codes: 0 ok, 1 bad input, 2 auth, 3 network, 4 server error, 5 partial failure.
{
"path": "p202 ltv customers",
"use": "customers [id]",
"short": "List customers with LTV rollups, or show one customer in full (CRM, aliases, custom fields, recent revenue)",
"long": "List customers with their LTV rollups, newest-valued first, or show one in full.\n\n p202 ltv customers --search acme --segment repeat\n p202 ltv customers --cf plan=pro --cf score.min=50 --all\n p202 ltv customers 42\n\n--search matches the customer reference, email, company or name. --cf filters by custom\nfield: key=value, or key.min/key.max for number and date fields (at most 3). Writes are\n`p202 ltv customer` (upsert, update, merge, erase, alias).",
"runnable": true,
"flags": [
{
"name": "all",
"type": "bool",
"default": "false",
"usage": "Fetch every page (500 rows a request)",
"required": false
},
{
"name": "cf",
"type": "stringArray",
"default": "[]",
"usage": "Only customers whose custom field matches: key=value, or key.min=value / key.max=value for a number or date field (repeatable, at most 3; `p202 ltv fields list` shows the keys)",
"required": false
},
{
"name": "dir",
"type": "string",
"default": "",
"usage": "Sort direction: ASC, DESC",
"allowed_values": [
"ASC",
"DESC"
],
"required": false
},
{
"name": "limit",
"shorthand": "l",
"type": "string",
"default": "",
"usage": "Rows per page (max 500)",
"required": false
},
{
"name": "offset",
"shorthand": "o",
"type": "string",
"default": "",
"usage": "Pagination offset",
"required": false
},
{
"name": "period",
"shorthand": "p",
"type": "string",
"default": "",
"usage": "Period: today, yesterday, last7, last14, last30, last90, thismonth, lastmonth, thisyear, lastyear, alltime",
"allowed_values": [
"today",
"yesterday",
"last7",
"last14",
"last30",
"last90",
"thismonth",
"lastmonth",
"thisyear",
"lastyear",
"alltime"
],
"required": false
},
{
"name": "search",
"type": "string",
"default": "",
"usage": "Only customers whose reference, email, company or name contains this text (the API's q)",
"required": false
},
{
"name": "segment",
"type": "string",
"default": "",
"usage": "Only this segment (repeat: 2+ orders; subscribers: an active subscription; at_risk: a past_due subscription): repeat, subscribers, at_risk",
"allowed_values": [
"repeat",
"subscribers",
"at_risk"
],
"required": false
},
{
"name": "sort",
"shorthand": "s",
"type": "string",
"default": "",
"usage": "Sort: total_revenue, order_count, last_activity_time, first_seen_time, mrr",
"allowed_values": [
"total_revenue",
"order_count",
"last_activity_time",
"first_seen_time",
"mrr"
],
"required": false
},
{
"name": "time-from",
"type": "string",
"default": "",
"usage": "Acquisition window start: unix seconds, a date (2026-10-01, from its first second in the account's timezone) or a time with its offset (2026-10-01T09:30:00Z)",
"required": false
},
{
"name": "time-to",
"type": "string",
"default": "",
"usage": "Acquisition window end, inclusive: unix seconds, a date (2026-10-01, through its last second in the account's timezone) or a time with its offset",
"required": false
}
]
}