+5
Is there a way to define a report (list) or a chart that shows the expected revenue in some time period?
For example, I can get a report of all the current active customers with a positive auto renew intent, which are expected to renew next month. However I’d like to calculate also the expected revenue of those customers, based on the current status of auto-renew. Is that possible?
Thanks
Best answer by tina
View original
+10
Hey
You could hack something together using the Subscription Retention chart. This chart takes into account the auto-renewing preference of the subscriptions. You can filter by the product identifier and if you have the price information handy, you will be able to calculate the expected revenue for those customers.
Alternatively, you can export your apps’ transaction data through ETL exports and write a query to calculate this. If the unsubscribe_registered_at is null, that means the subscriber is set to renew.
+5
Thanks, I’ll try it.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.