Dashboard & Tools

I am unable to replicate the Active Subscriptions number from the dashboard chart.From the transactions data obtained through the ETL exports, I have tried the SQL example found here, as well as variations of it, but the result always differs from what’s in the chart.What are the calculation details for Active Subscriptions?

Hello,We are currently testing RevenueCat.On iOS, we are setting the user email with:Purchases.shared.setEmail(email)It works as intended:[Purchases] - DEBUG: 😻 Subscriber attributes synced successfully for App User ID: ZDOuNi1VLxWfXSJtdrO6eMbYe3H2On the customer profile we can see that the email attribute has been set correctly:https://app.revenuecat.com/customers/...But searching the user by email on the web console does not work (we checked several times for typos).Searching by user id works as intended.Thank you for your help. 

Is there a way in revenue cat to see how long (days, weeks, months) an users are premium paid subscribers before they voluntarily churn? Ideally this would be a cohort chart. I see there is a cohort chart, but I am trying to see this in days. On average how many days before someone churns. Is there already a way to see that that I am missing?

We currently have an AB test running, but the results seem confusing. The tests shows the following numbers: Variant A has an annual price of $49.99 and Variant B $59.99. From this, it seems more intuitive to me that Variant A is outperforming because the price of B is only 20% higher than A’s, but there are more than double the amount of active subscriptions in Variant A. Yet, the results section suggests:“Based on our most recent run of the model, at 1 years, there is a 67% chance that Variant B has a higher LTV.”Can you explain to me where this result comes from? Maybe there’s just a lack of additional data in the dashboard that would show the real reason, but with the data available, it seems very off for us. Thanks

I want to calculate the trial conversion rate with data in the new UI. In the old UI, I took the ratio of total trial conversions to Eligible Trial conversion. I cannot seem to find their analogs. Where should I be looking?

Is there any chart that shows the number of renewed subscriptions per month? I know that I can see the renewal revenue and the total number of active subscriptions, but I am trying to find a way to also find out about the number of renewals.Thanks!

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

I think it’d would be nice to have a chart about intro price period conversion to the full price subscription, just like free trial conversion to paid subscription. Is there a way to get this data from the platform? Thanks.

I’m trying to export transaction data on a per transaction basis, rather than per user. I’m using a Customer List to do this.For example, I’d like each row to be a transaction by date (user ID, purchase date, amount paid, product name, etc.), whereas the current export shows each row as a single customer. 

Hello,I can see active users on the front dashboard  during my sandbox testing. I filled up all the details. We are testing using SWIFTUI and iOS 15.1 on a physical device. However, when I look into details I am not able to see the details. Please elaborate on this. 

We just created a Customer List Export. But after decompressing the file all time stamps and other numbers were converted into E+12 numbers. Unfortunately this help article (Viewing Customer Lists Exports | RevenueCat Community) does not help . It seems that the time stamps are already converted to E+12 before extracting the file.I am using Windows & Excel.How can this issue be solved?

Hello - I’m trying to track down an inconsistency and hopefully someone here can help. I’ve noticed in the past week that when I look at the Conversions data, it shows that all trial conversions are zero: there are trials started, but all are labeled as Pending, even though the trial period has ended. When I look at individual days and users, I can indeed see users that converted from trial to subscriptions, but the charts that are supposed to aggregate this data don’t seem to reflect the data that I see by looking at individual users. Any help is appreciated!

We’re getting a sudden influx of cancellation webhook calls after we introduce a new pricing model.It has 7-days free trial period and then monthly subscription.What events should be triggered given this user story:User starts a free trial Free trial ends after a week User chooses not to go on with the planI think events trigger like the following: `INITIAL_PURCHASE` → `CANCELLATION`. Is it correct? If FTE does not trigger `CANCELLATION` event, we can’t explain cancellation increase. Additional Question:Also in revenue cat charts, do active subscription contains trial users? Or active subscription chart and active trial chart are not related to each other? 

Hi,I am integrating webhooks in out AWS backend application. I am wondering if webhooks can use HTTP? Seems that webhooks seem to work only with SSL certificate.Is there a best practices section for webhook implementation? I haven't found it and it could be a great resource for us. Thanks for any help.

Hi,Is there any way to define how RevenueCat reports developer proceeds for the Webhook/Segement integration to account for local taxes?Currently you can choose the ‘report proceeds’ option within the Segment Integration settings, but the calculation doesn’t reflect ‘Developer Proceeds’ as defined by Apple. The calculation by Apple removes local taxes from the ‘customer price’ prior to applying the take home percentage. (GROSS_REVENUE - TAX) * TAKEHOME_PC.For the Segment integration, the calculation for revenue seems to apply the `takehome_percentage` property to the `price` property (which is only actually shown in the web hook output and not shown on the Segment event)  – it doesn’t account for taxes at all. CUSTOMER_PRICE * TAKEHOME_PC.For the web hook, we’re only given the customer price converted to USD – no option for developer proceeds at all. I’m sure the local currency complicates it, but it would be good if we could get the price in local curren

I would like to propose that the  is_trial_conversion field be added to all webhook calls. From what I see this is the only field that does not appear in every call. Having well known fields across all event types would save on server side logic to handle missing fields.  While I understand that it may seem irrelevant to have this data in a Cancellation for example, the same can be said about takehome_percentage, is_family_share, and several other fields - yet those do appear.

Hi,I’m noticing a difference in the trial started numbers between the Trial Conversion page and the Active Trials Movement page but not sure why it’s happening. This is happening on the new Chart version and here’s the steps we did to reproduce it:Go to the Trial Conversion page Set the Date Range to last 90 days and Show to ‘Days’ Note down the number from the Trials column for a specific day Go to the Active Trials Movement page Set the Date Range to last 90 days and Show to ‘Days’ The ‘New Trials’ number doesn’t seem to match the number of trials from step 3 for that specific day

Hi,Is there a way to see a sum up of the purchase history of a customer? Like how many renewal until now, when was the initial purchase, and details like that?I know there’s a list of the history, but then it’s hard to tell how many renewal until now, and when was the initial purchase that generated all those renewals and revenue, and so on. Thanks

Hi,I don't quite understand how to read the data in the new chart Subscription Retention. I can’t even compare Subscription Retention with Auto Renew Status (original charts) since the new chart comes with a ‘Product duration’ filter that can’t be removed. I tried several combinations of filters but the results I got were totally different from the old chart. Why can’t I use the new chart without that filter? Also what should I pick for a product that is a yearly subscription and has an introductory price for 6 months? I tried both filters for the Product duration and both results are different from the Auto Renew Status with a simple filter by the product. Thanks.

Hello,we are just integrated revenue in our staging environment to test with sandbox users (iOS) and we are experiencing some delay in the dashboard. It takes several hours til our users are visible in the customers list of the dashboard. Is this normal? Does it have something to do with the missing forwarding of the apple push notification as described here? We were actually going to do this at a later step, but if it means the data arrives faster..Best regards,Patrick W.

I really like this chart!In particular, as someone with a very new app, I’m enjoying breaking it down by daily cohort, and looking at my conversion rates with a 15-day delay to the current day, to see how each successive cohort did as 14 day trials expire.I had a quick question, how does the pending column work? I noticed that many users will remain in pending past the length of the trial, is this related to my billing grace period, or maybe something to do with payment processing delays? Or are their other factors at play? Just curious, :)

Hello, We are experiencing delays on Dashboard data that we have not been having before. For example the “installs”-metric has been quite reqctive to small changes and seems quite real time. Now however it changes on steps of 10 installs and only like once in an hour.  We see from other analytics-solutions that there is constantly installs. Maybe the yesterdays Major outtake is still effecting the reporting?

Hey guys, In the main screen I see the revenue for the last 28 days. If a user make a refund will this money automatically excluded from the total revenue? 

The list of promo durations in the rest API is slightly different from the website UI - but I think these should match!  I attached two screenshots to show the difference. 

Hello,We noticed that one of our players was supposed to covert from a trial to a paid monthly subscription, but it shows that a billing error was encountered, so the subscription was cancelled. However, RevCat still shows that the player was given another full month and that it will renew again next month. We were expecting the subscription date to be rolled back, since there was a billing error. And we’ve also not allowed any grace periods through the Google/Apple dashboards.Is there a way to confirm a billing error was in fact encountered? It looks like their total spent at the top says $10, which would include the failed conversion from a trial, so I’m not sure if their purchase did actually go through, but then a different error happened afterwards? If the charge didn’t actually go through, is there a way we can roll back the