01Run it
Replace the <placeholders> with your own values, or use the builder below.
p202 ltv subscriptions02What 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 subscriptions status amount billing_interval billing_interval_count canceled_at company currency current_period_end customer_id customer_ltv email external_sub_id first_name last_name mrr plan_name started_at subscription_id -------- --------- ---------------- ---------------------- ----------- ------- -------- ------------------ ----------- ------------ ----------------------------- --------------- ---------- --------- -------- -------------- ---------- --------------- active 588 year 1 USD 1822779739 115 588 [email protected] sub_cust-1115 Mason Morgan 49 Team Annual 1791243739 52 active 32 month 1 USD 1793740340 113 32 [email protected] sub_cust-1113 Stella Carter 32 Monthly Coffee 1791061940 51 active 32 month 1 USD 1792939011 104 32 [email protected] sub_cust-1104 Isla Patel 32 Monthly Coffee 1790347011 50 active 32 month 1 USD 1791673022 103 32 [email protected] sub_cust-1103 Zoe Jensen 32 Monthly Coffee 1789081022 49 active 32 month 1 USD 1792493548 100 32 [email protected] sub_cust-1100 Lucas Quinn 32 Monthly Coffee 1789901548 48 canceled 32 month 1 1791539314 USD 1793639148 95 32 [email protected] sub_cust-1095 Mateo Lopez 32 Monthly Coffee 1790960748 47 active 32 month 1 USD 1794009141 94 32 [email protected] sub_cust-1094 Hazel Diaz 32 Monthly Coffee 1791330741 46 canceled 32 month 1 1791539314 USD 1792547671 93 32 [email protected] sub_cust-1093 June Walsh 32 Monthly Coffee 1789955671 45 active 32 month 1 USD 1791659321 91 32 [email protected] sub_cust-1091 Chloe Ellis 32 Monthly Coffee 1789067321 44 active 29 month 1 USD 1792326449 90 29 [email protected] sub_cust-1090 Clara Reyes 29 Team Monthly 1789734449 43 active 348 year 1 USD 1821036439 89 348 [email protected] sub_cust-1089 Rhys Carter 29 Pro Annual 1789500439 42 active 29 month 1 USD 1792972196 88 29 [email protected] sub_cust-1088 Silas Haddad 29 Team Monthly 1790380196 41 active 32 month 1 USD 1791708132 87 58 [email protected] sub_cust-1087 Sofia Carter 32 Monthly Coffee 1789116132 40 canceled 32 month 1 1791539314 USD 1792666262 85 32 [email protected] sub_cust-1085 Maya Tanaka 32 Monthly Coffee 1790074262 39 active 32 month 1 USD 1791893606 84 32 [email protected] sub_cust-1084 June Nguyen 32 Monthly Coffee 1789301606 38 active 588 year 1 USD 1822083397 83 588 [email protected] sub_cust-1083 Mateo Morgan 49 Team Annual 1790547397 37 active 29 month 1 USD 1792437396 80 29 [email protected] sub_cust-1080 Mason Zhang 29 Team Monthly 1789845396 36 active 32 month 1 USD 1792486300 77 32 [email protected] sub_cust-1077 Theo Grant 32 Monthly Coffee 1789894300 35 active 29 month 1 USD 1792922647 70 29 [email protected] sub_cust-1070 Miles Okafor 29 Team Monthly 1790330647 34 active 32 month 1 USD 1792496935 69 32 [email protected] sub_cust-1069 Leo Moreau 32 Monthly Coffee 1789904935 33 active 588 year 1 USD 1821720516 67 588 [email protected] sub_cust-1067 Zoe Okafor 49 Team Annual 1790184516 32 active 32 month 1 USD 1792378544 64 58 [email protected] sub_cust-1064 Aisha Morgan 32 Monthly Coffee 1789786544 31 active 32 month 1 USD 1794157942 60 32 [email protected] sub_cust-1060 Clara Morgan 32 Monthly Coffee 1791479542 30 active 29 month 1 USD 1791679614 59 29 [email protected] sub_cust-1059 Lucas Haddad 29 Team Monthly 1789087614 29 active 29 month 1 USD 1793805129 56 29 [email protected] sub_cust-1056 Amara Ellis 29 Team Monthly 1791126729 28 active 348 year 1 USD 1821959437 55 348 [email protected] sub_cust-1055 Zoe Patel 29 Pro Annual 1790423437 27 active 32 month 1 USD 1794217606 53 32 [email protected] sub_cust-1053 Amara Bennett 32 Monthly Coffee 1791539206 26 canceled 32 month 1 1791539313 USD 1792066066 50 58 [email protected] sub_cust-1050 Omar Moreau 32 Monthly Coffee 1789474066 25 active 32 month 1 USD 1792095149 48 32 [email protected] sub_cust-1048 Zoe Reyes 32 Monthly Coffee 1789503149 24 active 32 month 1 USD 1793899636 47 32 [email protected] sub_cust-1047 Ava Walsh 32 Monthly Coffee 1791221236 23 active 348 year 1 USD 1823075206 46 348 [email protected] sub_cust-1046 Grace Foster 29 Pro Annual 1791539206 22 active 32 month 1 USD 1793395974 45 58 [email protected] sub_cust-1045 Leo Moreau 32 Monthly Coffee 1790803974 21 active 32 month 1 USD 1791813361 41 58 [email protected] sub_cust-1041 Isla Reyes 32 Monthly Coffee 1789221361 20 active 29 month 1 USD 1794130996 40 29 [email protected] sub_cust-1040 Arlo Ellis 29 Team Monthly 1791452596 19 active 29 month 1 USD 1793556940 38 29 [email protected] sub_cust-1038 Priya Moreau 29 Team Monthly 1790878540 18 canceled 32 month 1 1791539313 USD 1792047141 37 32 [email protected] sub_cust-1037 Rhys Ortiz 32 Monthly Coffee 1789455141 17 canceled 32 month 1 1791539313 USD 1792789333 34 32 [email protected] sub_cust-1034 Grace Hayes 32 Monthly Coffee 1790197333 16 active 29 month 1 USD 1793816558 32 29 [email protected] sub_cust-1032 Isla Lindqvist 29 Team Monthly 1791138158 15 active 32 month 1 USD 1793037269 30 32 [email protected] sub_cust-1030 Ethan Haddad 32 Monthly Coffee 1790445269 14 active 29 month 1 USD 1791839524 28 29 [email protected] sub_cust-1028 Silas Tanaka 29 Team Monthly 1789247524 13 active 32 month 1 USD 1794137698 27 32 [email protected] sub_cust-1027 Arlo Diaz 32 Monthly Coffee 1791459298 12 active 32 month 1 USD 1791891234 26 32 [email protected] sub_cust-1026 Lena Tanaka 32 Monthly Coffee 1789299234 11 active 29 month 1 USD 1791736523 25 29 [email protected] sub_cust-1025 Rhys Walsh 29 Team Monthly 1789144523 10 active 32 month 1 USD 1791891297 23 58 [email protected] sub_cust-1023 Ava Haddad 32 Monthly Coffee 1789299297 9 active 348 year 1 USD 1820952983 22 348 [email protected] sub_cust-1022 Elias Lindqvist 29 Pro Annual 1789416983 8 active 32 month 1 USD 1792916759 14 32 [email protected] sub_cust-1014 Jonah Carter 32 Monthly Coffee 1790324759 7 active 348 year 1 USD 1822304967 11 348 [email protected] sub_cust-1011 Lena Reyes 29 Pro Annual 1790768967 6 active 588 year 1 USD 1822313698 10 588 [email protected] sub_cust-1010 Felix Jensen 49 Team Annual 1790777698 5 active 29 month 1 USD 1793376796 8 29 [email protected] sub_cust-1008 Lena Nguyen 29 Team Monthly 1790784796 4 active 32 month 1 USD 1793649968 6 32 [email protected] sub_cust-1006 Priya Lopez 32 Monthly Coffee 1790971568 3 Total: 52 | Limit: 50 | Offset: 0 Warning: Showing 50 of 52 results. Use --all to fetch all.
$ p202 ltv subscriptions --json { "data": [ { "amount": "588.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1822779739, "customer_id": 115, "customer_ltv": "588.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1115", "first_name": "Mason", "last_name": "Morgan", "mrr": "49.00000", "plan_name": "Team Annual", "started_at": 1791243739, "status": "active", "subscription_id": 52 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793740340, "customer_id": 113, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1113", "first_name": "Stella", "last_name": "Carter", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1791061940, "status": "active", "subscription_id": 51 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792939011, "customer_id": 104, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1104", "first_name": "Isla", "last_name": "Patel", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790347011, "status": "active", "subscription_id": 50 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791673022, "customer_id": 103, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1103", "first_name": "Zoe", "last_name": "Jensen", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789081022, "status": "active", "subscription_id": 49 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792493548, "customer_id": 100, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1100", "first_name": "Lucas", "last_name": "Quinn", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789901548, "status": "active", "subscription_id": 48 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": 1791539314, "company": null, "currency": "USD", "current_period_end": 1793639148, "customer_id": 95, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1095", "first_name": "Mateo", "last_name": "Lopez", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790960748, "status": "canceled", "subscription_id": 47 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1794009141, "customer_id": 94, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1094", "first_name": "Hazel", "last_name": "Diaz", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1791330741, "status": "active", "subscription_id": 46 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": 1791539314, "company": null, "currency": "USD", "current_period_end": 1792547671, "customer_id": 93, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1093", "first_name": "June", "last_name": "Walsh", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789955671, "status": "canceled", "subscription_id": 45 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791659321, "customer_id": 91, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1091", "first_name": "Chloe", "last_name": "Ellis", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789067321, "status": "active", "subscription_id": 44 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792326449, "customer_id": 90, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1090", "first_name": "Clara", "last_name": "Reyes", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1789734449, "status": "active", "subscription_id": 43 }, { "amount": "348.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1821036439, "customer_id": 89, "customer_ltv": "348.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1089", "first_name": "Rhys", "last_name": "Carter", "mrr": "29.00000", "plan_name": "Pro Annual", "started_at": 1789500439, "status": "active", "subscription_id": 42 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792972196, "customer_id": 88, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1088", "first_name": "Silas", "last_name": "Haddad", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1790380196, "status": "active", "subscription_id": 41 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791708132, "customer_id": 87, "customer_ltv": "58.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1087", "first_name": "Sofia", "last_name": "Carter", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789116132, "status": "active", "subscription_id": 40 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": 1791539314, "company": null, "currency": "USD", "current_period_end": 1792666262, "customer_id": 85, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1085", "first_name": "Maya", "last_name": "Tanaka", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790074262, "status": "canceled", "subscription_id": 39 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791893606, "customer_id": 84, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1084", "first_name": "June", "last_name": "Nguyen", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789301606, "status": "active", "subscription_id": 38 }, { "amount": "588.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1822083397, "customer_id": 83, "customer_ltv": "588.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1083", "first_name": "Mateo", "last_name": "Morgan", "mrr": "49.00000", "plan_name": "Team Annual", "started_at": 1790547397, "status": "active", "subscription_id": 37 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792437396, "customer_id": 80, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1080", "first_name": "Mason", "last_name": "Zhang", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1789845396, "status": "active", "subscription_id": 36 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792486300, "customer_id": 77, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1077", "first_name": "Theo", "last_name": "Grant", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789894300, "status": "active", "subscription_id": 35 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792922647, "customer_id": 70, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1070", "first_name": "Miles", "last_name": "Okafor", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1790330647, "status": "active", "subscription_id": 34 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792496935, "customer_id": 69, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1069", "first_name": "Leo", "last_name": "Moreau", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789904935, "status": "active", "subscription_id": 33 }, { "amount": "588.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1821720516, "customer_id": 67, "customer_ltv": "588.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1067", "first_name": "Zoe", "last_name": "Okafor", "mrr": "49.00000", "plan_name": "Team Annual", "started_at": 1790184516, "status": "active", "subscription_id": 32 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792378544, "customer_id": 64, "customer_ltv": "58.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1064", "first_name": "Aisha", "last_name": "Morgan", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789786544, "status": "active", "subscription_id": 31 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1794157942, "customer_id": 60, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1060", "first_name": "Clara", "last_name": "Morgan", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1791479542, "status": "active", "subscription_id": 30 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791679614, "customer_id": 59, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1059", "first_name": "Lucas", "last_name": "Haddad", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1789087614, "status": "active", "subscription_id": 29 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793805129, "customer_id": 56, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1056", "first_name": "Amara", "last_name": "Ellis", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1791126729, "status": "active", "subscription_id": 28 }, { "amount": "348.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1821959437, "customer_id": 55, "customer_ltv": "348.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1055", "first_name": "Zoe", "last_name": "Patel", "mrr": "29.00000", "plan_name": "Pro Annual", "started_at": 1790423437, "status": "active", "subscription_id": 27 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1794217606, "customer_id": 53, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1053", "first_name": "Amara", "last_name": "Bennett", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1791539206, "status": "active", "subscription_id": 26 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": 1791539313, "company": null, "currency": "USD", "current_period_end": 1792066066, "customer_id": 50, "customer_ltv": "58.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1050", "first_name": "Omar", "last_name": "Moreau", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789474066, "status": "canceled", "subscription_id": 25 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792095149, "customer_id": 48, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1048", "first_name": "Zoe", "last_name": "Reyes", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789503149, "status": "active", "subscription_id": 24 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793899636, "customer_id": 47, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1047", "first_name": "Ava", "last_name": "Walsh", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1791221236, "status": "active", "subscription_id": 23 }, { "amount": "348.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1823075206, "customer_id": 46, "customer_ltv": "348.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1046", "first_name": "Grace", "last_name": "Foster", "mrr": "29.00000", "plan_name": "Pro Annual", "started_at": 1791539206, "status": "active", "subscription_id": 22 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793395974, "customer_id": 45, "customer_ltv": "58.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1045", "first_name": "Leo", "last_name": "Moreau", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790803974, "status": "active", "subscription_id": 21 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791813361, "customer_id": 41, "customer_ltv": "58.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1041", "first_name": "Isla", "last_name": "Reyes", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789221361, "status": "active", "subscription_id": 20 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1794130996, "customer_id": 40, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1040", "first_name": "Arlo", "last_name": "Ellis", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1791452596, "status": "active", "subscription_id": 19 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793556940, "customer_id": 38, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1038", "first_name": "Priya", "last_name": "Moreau", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1790878540, "status": "active", "subscription_id": 18 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": 1791539313, "company": null, "currency": "USD", "current_period_end": 1792047141, "customer_id": 37, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1037", "first_name": "Rhys", "last_name": "Ortiz", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789455141, "status": "canceled", "subscription_id": 17 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": 1791539313, "company": null, "currency": "USD", "current_period_end": 1792789333, "customer_id": 34, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1034", "first_name": "Grace", "last_name": "Hayes", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790197333, "status": "canceled", "subscription_id": 16 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793816558, "customer_id": 32, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1032", "first_name": "Isla", "last_name": "Lindqvist", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1791138158, "status": "active", "subscription_id": 15 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793037269, "customer_id": 30, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1030", "first_name": "Ethan", "last_name": "Haddad", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790445269, "status": "active", "subscription_id": 14 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791839524, "customer_id": 28, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1028", "first_name": "Silas", "last_name": "Tanaka", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1789247524, "status": "active", "subscription_id": 13 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1794137698, "customer_id": 27, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1027", "first_name": "Arlo", "last_name": "Diaz", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1791459298, "status": "active", "subscription_id": 12 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791891234, "customer_id": 26, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1026", "first_name": "Lena", "last_name": "Tanaka", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789299234, "status": "active", "subscription_id": 11 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791736523, "customer_id": 25, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1025", "first_name": "Rhys", "last_name": "Walsh", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1789144523, "status": "active", "subscription_id": 10 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1791891297, "customer_id": 23, "customer_ltv": "58.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1023", "first_name": "Ava", "last_name": "Haddad", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1789299297, "status": "active", "subscription_id": 9 }, { "amount": "348.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1820952983, "customer_id": 22, "customer_ltv": "348.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1022", "first_name": "Elias", "last_name": "Lindqvist", "mrr": "29.00000", "plan_name": "Pro Annual", "started_at": 1789416983, "status": "active", "subscription_id": 8 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1792916759, "customer_id": 14, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1014", "first_name": "Jonah", "last_name": "Carter", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790324759, "status": "active", "subscription_id": 7 }, { "amount": "348.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1822304967, "customer_id": 11, "customer_ltv": "348.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1011", "first_name": "Lena", "last_name": "Reyes", "mrr": "29.00000", "plan_name": "Pro Annual", "started_at": 1790768967, "status": "active", "subscription_id": 6 }, { "amount": "588.00000", "billing_interval": "year", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1822313698, "customer_id": 10, "customer_ltv": "588.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1010", "first_name": "Felix", "last_name": "Jensen", "mrr": "49.00000", "plan_name": "Team Annual", "started_at": 1790777698, "status": "active", "subscription_id": 5 }, { "amount": "29.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793376796, "customer_id": 8, "customer_ltv": "29.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1008", "first_name": "Lena", "last_name": "Nguyen", "mrr": "29.00000", "plan_name": "Team Monthly", "started_at": 1790784796, "status": "active", "subscription_id": 4 }, { "amount": "32.00000", "billing_interval": "month", "billing_interval_count": 1, "canceled_at": null, "company": null, "currency": "USD", "current_period_end": 1793649968, "customer_id": 6, "customer_ltv": "32.00000", "email": "[email protected]", "external_sub_id": "sub_cust-1006", "first_name": "Priya", "last_name": "Lopez", "mrr": "32.00000", "plan_name": "Monthly Coffee", "started_at": 1790971568, "status": "active", "subscription_id": 3 } ], "pagination": { "limit": 50, "offset": 0, "total": 52 } }
03Build your command
Pick values and the command line writes itself, quoted and ready to paste.
p202 ltv subscriptionsSet flags below; the command updates as you type.
04Flags
3 flags, plus the global flags every command takes.
| Flag | What it does |
|---|---|
| --limit, -lstring | Rows per page (max 500) |
| --offset, -ostring | Pagination offset |
| --status, -sstring | Only this status: trialing, active, past_due, paused, canceledtrialingactivepast_duepausedcanceled |
05For agents
Running this from an agent
- Read the same facts as JSON:
p202 commands ltv subscriptions --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 subscriptions",
"use": "subscriptions",
"short": "Account-wide subscription list joined to customers, filterable by lifecycle status",
"runnable": true,
"flags": [
{
"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": "status",
"shorthand": "s",
"type": "string",
"default": "",
"usage": "Only this status: trialing, active, past_due, paused, canceled",
"allowed_values": [
"trialing",
"active",
"past_due",
"paused",
"canceled"
],
"required": false
}
]
}