p202 ltv subscriptions

Account-wide subscription list joined to customers, filterable by lifecycle status

All commands

p202 CLI reference

Back to the docs

01Run it

Replace the <placeholders> with your own values, or use the builder below.

p202 ltv subscriptions

02What 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
$ 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    32         month             1                                             USD       1794695616          114          32            felix.turner114@example.com    sub_cust-1114    Felix       Turner     32        Monthly Coffee  1792017216  48
active    32         month             1                                             USD       1792800784          112          58            jonah.turner112@example.com    sub_cust-1112    Jonah       Turner     32        Monthly Coffee  1790208784  47
active    348        year              1                                             USD       1822134577          109          348           priya.nguyen109@example.com    sub_cust-1109    Priya       Nguyen     29        Pro Annual      1790598577  46
active    348        year              1                                             USD       1821653692          107          348           diego.bennett107@example.com   sub_cust-1107    Diego       Bennett    29        Pro Annual      1790117692  45
active    32         month             1                                             USD       1794860744          106          32            kenji.ortiz106@example.com     sub_cust-1106    Kenji       Ortiz      32        Monthly Coffee  1792182344  44
active    29         month             1                                             USD       1795209618          103          29            zoe.jensen103@example.com      sub_cust-1103    Zoe         Jensen     29        Team Monthly    1792531218  43
canceled  29         month             1                       1792622056            USD       1795216741          100          29            zoe.moreau100@example.com      sub_cust-1100    Zoe         Moreau     29        Team Monthly    1792538341  42
active    348        year              1                                             USD       1823898110          99           348           theo.nguyen99@example.com      sub_cust-1099    Theo        Nguyen     29        Pro Annual      1792362110  41
active    29         month             1                                             USD       1794659214          93           29            isla.young93@example.com       sub_cust-1093    Isla        Young      29        Team Monthly    1791980814  40
active    32         month             1                                             USD       1795159068          91           32            isla.walsh91@example.com       sub_cust-1091    Isla        Walsh      32        Monthly Coffee  1792480668  39
active    32         month             1                                             USD       1794082731          90           32            rhys.turner90@example.com      sub_cust-1090    Rhys        Turner     32        Monthly Coffee  1791404331  38
active    29         month             1                                             USD       1794999668          89           29            aisha.reyes89@example.com      sub_cust-1089    Aisha       Reyes      29        Team Monthly    1792321268  37
active    348        year              1                                             USD       1822866094          86           348           chloe.ellis86@example.com      sub_cust-1086    Chloe       Ellis      29        Pro Annual      1791330094  36
active    32         month             1                                             USD       1795289961          85           32            clara.hayes85@example.com      sub_cust-1085    Clara       Hayes      32        Monthly Coffee  1792611561  35
active    32         month             1                                             USD       1794053351          80           32            june.nguyen80@example.com      sub_cust-1080    June        Nguyen     32        Monthly Coffee  1791374951  34
active    32         month             1                                             USD       1793293125          79           58            theo.reyes79@example.com       sub_cust-1079    Theo        Reyes      32        Monthly Coffee  1790701125  33
canceled  32         month             1                       1792622056            USD       1792972381          77           58            rhys.lopez77@example.com       sub_cust-1077    Rhys        Lopez      32        Monthly Coffee  1790380381  32
canceled  32         month             1                       1792622056            USD       1793992167          76           32            liam.grant76@example.com       sub_cust-1076    Liam        Grant      32        Monthly Coffee  1791313767  31
canceled  32         month             1                       1792622056            USD       1793061544          71           32            chloe.nguyen71@example.com     sub_cust-1071    Chloe       Nguyen     32        Monthly Coffee  1790469544  30
active    29         month             1                                             USD       1793305330          67           29            miles.okafor67@example.com     sub_cust-1067    Miles       Okafor     29        Team Monthly    1790713330  29
active    348        year              1                                             USD       1822400794          66           348           hugo.foster66@example.com      sub_cust-1066    Hugo        Foster     29        Pro Annual      1790864794  28
active    588        year              1                                             USD       1823290494          64           588           zoe.okafor64@example.com       sub_cust-1064    Zoe         Okafor     49        Team Annual     1791754494  27
canceled  32         month             1                       1792622055            USD       1793875718          62           32            leo.shah62@example.com         sub_cust-1062    Leo         Shah       32        Monthly Coffee  1791197318  26
active    32         month             1                                             USD       1794977856          59           32            maya.bennett59@example.com     sub_cust-1059    Maya        Bennett    32        Monthly Coffee  1792299456  25
active    32         month             1                                             USD       1793932387          58           58            ava.lindqvist58@example.com    sub_cust-1058    Ava         Lindqvist  32        Monthly Coffee  1791253987  24
active    348        year              1                                             USD       1822164035          57           348           rhys.patel57@example.com       sub_cust-1057    Rhys        Patel      29        Pro Annual      1790628035  23
active    32         month             1                                             USD       1795267974          53           32            lucas.bennett53@example.com    sub_cust-1053    Lucas       Bennett    32        Monthly Coffee  1792589574  22
active    32         month             1                                             USD       1792880009          50           32            zoe.patel50@example.com        sub_cust-1050    Zoe         Patel      32        Monthly Coffee  1790288009  21
active    348        year              1                                             USD       1823741808          47           348           mason.patel47@example.com      sub_cust-1047    Mason       Patel      29        Pro Annual      1792205808  20
active    29         month             1                                             USD       1794680656          46           29            silas.foster46@example.com     sub_cust-1046    Silas       Foster     29        Team Monthly    1792002256  19
active    348        year              1                                             USD       1821996284          45           348           ruby.walsh45@example.com       sub_cust-1045    Ruby        Walsh      29        Pro Annual      1790460284  18
active    588        year              1                                             USD       1823257087          40           588           isla.reyes40@example.com       sub_cust-1040    Isla        Reyes      49        Team Annual     1791721087  17
active    32         month             1                                             USD       1795145656          39           32            arlo.ellis39@example.com       sub_cust-1039    Arlo        Ellis      32        Monthly Coffee  1792467256  16
canceled  32         month             1                       1792622055            USD       1792833958          34           32            leo.shah34@example.com         sub_cust-1034    Leo         Shah       32        Monthly Coffee  1790241958  15
active    32         month             1                                             USD       1794608749          33           32            leo.patel33@example.com        sub_cust-1033    Leo         Patel      32        Monthly Coffee  1791930349  14
active    32         month             1                                             USD       1793318585          28           58            mateo.zhang28@example.com      sub_cust-1028    Mateo       Zhang      32        Monthly Coffee  1790726585  13
active    588        year              1                                             USD       1821798839          27           588           hazel.underwood27@example.com  sub_cust-1027    Hazel       Underwood  49        Team Annual     1790262839  12
active    32         month             1                                             USD       1794603146          26           32            noah.haddad26@example.com      sub_cust-1026    Noah        Haddad     32        Monthly Coffee  1791924746  11
active    29         month             1                                             USD       1792844031          25           29            felix.kowalski25@example.com   sub_cust-1025    Felix       Kowalski   29        Team Monthly    1790252031  10
active    32         month             1                                             USD       1794912678          23           32            ivy.diaz23@example.com         sub_cust-1023    Ivy         Diaz       32        Monthly Coffee  1792234278  9
canceled  32         month             1                       1792622055            USD       1794594316          21           58            zoe.moreau21@example.com       sub_cust-1021    Zoe         Moreau     32        Monthly Coffee  1791915916  8
active    29         month             1                                             USD       1795026019          17           29            leo.bennett17@example.com      sub_cust-1017    Leo         Bennett    29        Team Monthly    1792347619  7
active    348        year              1                                             USD       1821885735          13           348           maya.grant13@example.com       sub_cust-1013    Maya        Grant      29        Pro Annual      1790349735  6
active    348        year              1                                             USD       1823866333          12           348           liam.lindqvist12@example.com   sub_cust-1012    Liam        Lindqvist  29        Pro Annual      1792330333  5
canceled  32         month             1                       1792622055            USD       1794896481          11           32            miles.shah11@example.com       sub_cust-1011    Miles       Shah       32        Monthly Coffee  1792218081  4
active    29         month             1                                             USD       1795274606          9            29            priya.lopez9@example.com       sub_cust-1009    Priya       Lopez      29        Team Monthly    1792596206  3
active    32         month             1                                             USD       1793396690          8            32            jonah.iverson8@example.com     sub_cust-1008    Jonah       Iverson    32        Monthly Coffee  1790804690  2
active    32         month             1                                             USD       1795297382          2            32            clara.diaz2@example.com        sub_cust-1002    Clara       Diaz       32        Monthly Coffee  1792618982  1
Total: 48 | Limit: 50 | Offset: 0
Real output · p202 1.9.78 · demo dataexit 0

03Build your command

Pick values and the command line writes itself, quoted and ready to paste.

p202 ltv subscriptions

Set flags below; the command updates as you type.

04Flags

3 flags, plus the global flags every command takes.

FlagWhat it does
--limit, -lstringRows per page (max 500)
--offset, -ostringPagination offset
--status, -sstringOnly this status: trialing, active, past_due, paused, canceled
trialingactivepast_duepausedcanceled

05For agents

Running this from an agent

  • Read the same facts as JSON: p202 commands ltv subscriptions --json.
  • With AI_AGENT, CLAUDECODE or another agent variable set, output is compact JSON and errors arrive on stderr as a JSON envelope with a hint.
  • Exit codes: 0 ok, 1 bad input, 2 auth, 3 network, 4 server error, 5 partial failure, 6 no Pro licence on the install.
p202 commands ltv subscriptions --json
{
  "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
    }
  ]
}