Hi
I am trying to work out if a subscription has recovered during a period.
I have three tables, date, subscription and customers.
If a subscription churns (does not renew) at the end of the subscription period however within a 12 month period returns (from the end date of the subscription), to have a measure that is able to look back over the last 12 months to see if the customer had a subscription. If this is the case, then to be able to calculate what the difference between the old subscription to the new subscription.
For example, have a customer who had a subscription for the period 1 July 2016 to 30 June 2017 for $1,000. At 30 June 2017 the subscription does not renew and therefore churned. However, on the 15 December 2017 that customer returns with a new subscription value of $2,000.
So, need a measure to be able to do the calculation to say for the month of June 2017 you have churn of -$1,000 and December 2017 churn of $1,000 and upsell of $1,000. Therefore, the half year (Jul-Dec) churn $0 and upsell $1,000.
Or if the new subscription value is $500 to be downgrade of $500 but the churn numbers to be the same from above.
Or if the new subscription value is $1000 to only show the churn number from above.
Thanks
Jon
I am trying to work out if a subscription has recovered during a period.
I have three tables, date, subscription and customers.
If a subscription churns (does not renew) at the end of the subscription period however within a 12 month period returns (from the end date of the subscription), to have a measure that is able to look back over the last 12 months to see if the customer had a subscription. If this is the case, then to be able to calculate what the difference between the old subscription to the new subscription.
For example, have a customer who had a subscription for the period 1 July 2016 to 30 June 2017 for $1,000. At 30 June 2017 the subscription does not renew and therefore churned. However, on the 15 December 2017 that customer returns with a new subscription value of $2,000.
So, need a measure to be able to do the calculation to say for the month of June 2017 you have churn of -$1,000 and December 2017 churn of $1,000 and upsell of $1,000. Therefore, the half year (Jul-Dec) churn $0 and upsell $1,000.
Or if the new subscription value is $500 to be downgrade of $500 but the churn numbers to be the same from above.
Or if the new subscription value is $1000 to only show the churn number from above.
Thanks
Jon
