Randy Peck: This stat might not be available natively in the app yet, but I think you can do what you are looking for with the orders API and/or webhooks (https://developers.myclickfunnels.com/).

Rich Steinmetz (ClickFunnels Engineering) that would be a viable solution, but it's almost completely unsupported for non-developers. I can't even figure out how to obtain my workspace ID. Also, Zapier's existing webhooks for "invoices" doesn't include stats like "last payment" "rebill number" or other data needed for this stat, so I'm not sure if there is a webhook for those events. It is all viewable in the app, just not sortable or easily copyable, otherwise I could just easily do it all in a spreadsheet.

Hye Randy Peck, thanks for sharing your experience! I agree that this should be native functionality and see that integrating with the API for that might be overkill at the moment. But just in case now or in future you would like to get your hands on the API, there is a Getting Started guide that explains how to get your workspace_id step-by-step (https://developers.myclickfunnels.com/docs/getting-started#make-your-first-requests).

Speaking of Zapier, another way of doing this would be setting up some webhook endpoints to point to Zapier hooks and listen for events like , , , , and other events to fill up your spreadsheet.

rebill_number is available in the Orders::Transaction/transaction.created payloads. Orders and invoices have info about cancelation. I think "last payment" could be the last successful transaction or paid invoice of an order.

Let me know if you need more support with any of that while the feature request here is still cooking.