Chrorn report

rotem cohen's Avatar

rotem cohen

06 Dec, 2015 10:35 AM

Hi,

How can I create a query.report that would show me all chorned users. meaning that were previously paid and are now on non-paying plan ?

  1. 1 Posted by Drew Songer on 07 Dec, 2015 06:01 PM

    Drew Songer's Avatar

    There isn't a good way to compile a list of churned users because there is not a Churn Event. We calculate the churn rate by essentially just tallying churns as they occur to get a number which is used to calculate the rate. I have submitted a ticket to have a Churn Event created, which would dramatically simplify this issue.

  2. 2 Posted by rotem cohen on 08 Dec, 2015 05:48 AM

    rotem cohen's Avatar

    Thank you drew. Can I maybe track users that have switched from plan A to plan B for example.

  3. 3 Posted by Drew Songer on 08 Dec, 2015 02:21 PM

    Drew Songer's Avatar

    You could use the Subscription Changed hook event to collect data on that event. You could probably even use Zapier to create a Google spread sheet of the data when that event happens.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac