Skip to main content
Solved

Expected Revene Chart

  • November 18, 2021
  • 2 replies
  • 252 views

Forum|alt.badge.img+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

Hey @Uri 

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. 

View original
Did this post help you find an answer to your question?

2 replies

tina
RevenueCat Staff
Forum|alt.badge.img+10
  • RevenueCat Staff
  • 338 replies
  • Answer
  • November 19, 2021

Hey @Uri 

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. 


Forum|alt.badge.img+5
  • Author
  • 1 reply
  • November 21, 2021

Thanks, I’ll try it.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings