Post

Replies

Boosts

Views

Activity

Reply to How to calculate 'Active paid subscriptions' using subscription event data
Curious if you received an answer here or had any insight! I'm attempting to do the same exercise using similar logic. End of period active paid subscriptions = start of period active paid subscriptions + new paid subscriptions - churned paid subscriptions where new paid subscriptions = trial conversions to paid + direct purchases (standard price or a paid introductory offer) + reactivations into standard price churned paid subscriptions = cancellations, refunds, entries into billing retry, entries into billing grace period. My variance against actuals is anywhere from 1 - 10% with this logic, and I am having trouble isolating what part(s) of my equation might be incorrect. Any guidance here is appreciated!
Jun ’23