Track Churn % of subscriptions | Voters

Track Churn % of subscriptions

Best Music Coach

Kelan Kline

We need this feature added so bad.

Randy Peck

I just made another post, but I'll comment here because this is similar.

I'd like to be able to export "last payment" information on order. This is for cancelled/churned subscription orders so I can sort by dates of purchase the date of their last payment. This will help track churn, an extremely important metric for subscriptions. The date of cancellation would be helpful too, but since we can already display "last payment" I'd like it to be exportable.

Rich Steinmetz (ClickFunnels Engineering)

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/).

Randy Peck

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.

Rich Steinmetz (ClickFunnels Engineering)

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 subscription.activated
, subscription.canceled
, subscription.churned
, subscription.invoice.paid
, transaction.created
 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.

Randy Peck

Rich Steinmetz (ClickFunnels Engineering) Hi Rich. I appreciate this reply. I'm using some workarounds for now. The webhooks concept is interesting, but probably over my head as a non-programmer. I'd be willing to learn, but not sure where to turn for instruction. There is documentation for developers, but for a non-dev user it's still over my head. Simple things for developers, like making requests and understanding requests, and working in a shell or terminal - not something users have much if any experience with.